My Spreadsheet Lab

The site is about Microsoft Excel.

  • Home
  • Templates
  • Excel Blog
  • About Me
  • Contact Kevin

Author Archives → Kevin Lehrbass

Word Game in Excel

posted in Formulas, Macros (vba) on April 24, 2022 by Kevin Lehrbass 6 Comments

It’s not exactly the same as Wordle but close enough 🙂

Continue reading →

3D Objects

posted in Macros (vba) on December 24, 2021 by Kevin Lehrbass 2 Comments

I heard about 3D Objects from MrExcel. I’ve had fun combing a 3D model with VBA (it moves inside your spreadsheet!)

Continue reading →

Rounding with a twist

posted in Formulas on December 13, 2021 by Kevin Lehrbass 0 Comments

Earlier this week I saw an interesting rounding question on the famous MrExcel Forum. And there was a twist!

Continue reading →

S curve

posted in T_Planning on November 25, 2021 by Kevin Lehrbass 0 Comments

I played around with two different S curve concepts using dynamic arrays.

Continue reading →

Zen Mode

posted in vba on October 17, 2021 by Kevin Lehrbass 3 Comments

https://lichess.org/ has a Zen mode. Can I create a Zen mode in Excel to celebrate Spreadsheet Day?

Continue reading →

DSUM gymnastics

posted in Formulas, Free Data on August 8, 2021 by Kevin Lehrbass 0 Comments

I explored ideas to make DSUM function’s criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. Continue reading →

CELL Function Adventure

posted in Formulas, Free Data on July 29, 2021 by Kevin Lehrbass 2 Comments

You may never need this…but I did recently and it’s just fun knowing that Excel can solve this! Continue reading →

Flirting with Volatility

posted in Formulas on July 4, 2021 by Kevin Lehrbass 0 Comments

I had some questions and improvement ideas for my formula pixel face. I learned a lot playing around with this. Continue reading →

Calculate Hours from Messy Text using Power Query

posted in Get & Transform on May 30, 2021 by Kevin Lehrbass 2 Comments

Daniel Choi solved it using Power Query! Let’s review his solutions. Continue reading →

Calculate Hours from Messy Text

posted in Formulas on May 29, 2021 by Kevin Lehrbass 2 Comments

I need to calculate hours given data like this in each cell: “9-10, 10-11, 10-11, 12-13, 12-15+, 14-17+“ Continue reading →

← Older posts

Sometimes I write a practical 'how to' post and other times I explore a crazy idea and build something unique. I love working with data in Microsoft Excel!

Kevin Lehrbass

Newsletter