My Spreadsheet Lab

The site is about Microsoft Excel.

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

Author Archives → Kevin Lehrbass

aggregating text part 2

posted in Formulas, Get & Transform on April 8, 2021 by Kevin Lehrbass 2 Comments

Haven’t I done this before? It was almost identical except for two details. 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 →

whack-a-merged-cell

posted in Macros (vba) on November 23, 2020 by Kevin Lehrbass 0 Comments

Do merged cells irritate you? My latest lame game gives you points for whacking merged cells! 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 →

Aggregating Text

posted in Solutions on August 29, 2020 by Kevin Lehrbass 3 Comments

Is it ok to make one manual adjustment to an automation task to avoid the complexity of a fully automated task?

Continue reading →

awkward-data/power-query-solution

posted in Get & Transform on August 3, 2020 by Kevin Lehrbass 1 Comment

My last post was about an awkward dataset. Now I’ll review Daniel Choi’s Power Query solution that rearranges the data. 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 →

← Older posts
Newer 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