My Spreadsheet Lab

The site is about Microsoft Excel.

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

Post Category → Gurus

Advanced Conditional Formatting

posted in Gurus on November 17, 2019 by Kevin Lehrbass 1 Comment

Let’s explore an advanced way to use Conditional Formatting in Excel. We’ll make a face move around the screen without any vba! Bonus: see how to interact with target cells! Continue reading →

Excel Sorting Challenge

posted in Gurus on November 28, 2018 by Kevin Lehrbass 5 Comments

In this guest post Alan Murray (computergaga) compares two solutions to a challenging data sorting issue. I know my preference, what about you?
Continue reading →

Ken Puls Power Query Challenge #2

posted in Gurus on August 14, 2018 by Kevin Lehrbass 0 Comments

In this post I’ll review my solution to Ken Puls’ Power Query challenge #2. Online challenges are fun and it’s a great way to learn from others. Continue reading →

Stack Groups of 3 Numbers in Excel

posted in Gurus on May 17, 2018 by Kevin Lehrbass 1 Comment

When faced with a challenge in Microsoft Excel it’s rare that two very different approaches can both be equally amazing! In this post I’ll review two completely different solutions from Oz du Soleil and David Hager.  Continue reading →

Mr Excel & excelisfun Trick 141: Lookup 3 Items in 3 tables

posted in Gurus on March 14, 2018 by Kevin Lehrbass 3 Comments

I enjoy the dueling Excel podcasts between Bill Jelen and Mike Girvin! The challenges, the energy, the solutions, the community involvement…everything! Let’s look at Excel duel 141 (the PI episode). The best solution depends on asking one question. Continue reading →

Video 00174 Ranking Values into Tiers in Excel

posted in Gurus, Solutions on January 29, 2018 by Kevin Lehrbass 0 Comments

Last year I started visiting some REDDIT Excel groups. A few weeks ago I saw an interesting Excel question and provided a simple two step solution. Continue reading →

Change Text to Sentence Case

posted in Auditing, Gurus on January 26, 2018 by Kevin Lehrbass 5 Comments

As Puneet Gogia mentions in his post, we can change text using UPPER, LOWER and PROPER functions but we don’t have a SENTENCE function to capitalize the first letter of each sentence. Puneet solves it with a very interesting formula. How exactly does it work? Let’s audit it! Continue reading →

Compare Text Fonts in Excel using VBA

posted in Gurus on November 16, 2017 by Kevin Lehrbass 3 Comments

Have you ever had the experience where one event causes you to remember something from years ago? This happened to me today while reading the New Yorker magazine. What does Lucas de Groot, a Dutch typeface designer, have to do with Excel’s VBA language? What is “Fontgate”? Well…read on and I’ll tell you! Continue reading →

Video 00164 Excel Magic Trick 1452 Max Monthly Customer

posted in Gurus on August 29, 2017 by Kevin Lehrbass 0 Comments

Customers can make multiple purchases per month. What is the maximum amount that a customer has spent in a single month? This was a video from the amazing Mike Girvin (Excelisfun). The question is clear, but how did Mike solve it? How would you solve it? Continue reading →

Video 00165 Show Column Header for Matrix Value

posted in Gurus on August 23, 2017 by Kevin Lehrbass 8 Comments

Last week I saw an interesting Excel puzzle from Leila Gharani on YouTube. Leila solved it using a sumproduct function. I made a video showing different solutions. Wasif Mustafa sent me his 3 helper column solution. Then Oz du Soleil created a video showing two solutions. So many ways to solve it! Continue reading →

← Older posts