My Spreadsheet Lab

The site is about Microsoft Excel.

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

Post Category → Articles

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 →

Discover Data Types templates

posted in Reviews, T_Education on February 7, 2021 by Kevin Lehrbass 1 Comment

I was working on a demo file about Excel’s new Data Types but I found an incredible set of templates created by Elisabetta Caldesi! Continue reading →

review of 2020 posts

posted in Reviews on January 23, 2021 by Kevin Lehrbass 0 Comments

Let’s forget 2020 but I will review my posts. Thanks Excel for helping me through the year. Continue reading →

Robert Gascon’s Shortest Formula Challenge

posted in Challenges, Formula or VBA on October 14, 2020 by Kevin Lehrbass 8 Comments

Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! Continue reading →

Awkward Data

posted in Formula or VBA on July 26, 2020 by Kevin Lehrbass 3 Comments

Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? Continue reading →

Add color to letters inside a cell

posted in vba on April 26, 2020 by Kevin Lehrbass 0 Comments

VBA can color certain characters within a cell. It was fun to practice vba and build this but it doesn’t work well with many rows of text. Continue reading →

Calculate Wind Chill in Excel

posted in Auditing on April 21, 2020 by Kevin Lehrbass 10 Comments

It’s April 21 and winter is supposed to be finished here in the Toronto area. However, I went for a walk and it’s still cold out! A combination of cold & wind. Let’s calculate the wind chill in Excel. Continue reading →

arithmetic progression

posted in PowerBI on March 31, 2020 by Kevin Lehrbass 0 Comments

Let’s take a look at something that’s SO easy to calculate today with a simple spreadsheet but was very challenging to calculate in the past. Continue reading →

← Older posts