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

# Author Archives → Kevin Lehrbass

# review of 2020 posts

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

# whack-a-merged-cell

Do merged cells irritate you? My latest lame game gives you points for whacking merged cells! Continue reading

# Robert Gascon’s Shortest Formula Challenge

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

# Aggregating Text

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

# awkward-data/power-query-solution

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

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

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

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

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