My Spreadsheet Lab
  • Home
  • Templates
  • Excel Tips
  • Video Tutorials
  • Excel Blog
  • Excel Coach
  • Excel Training
  • Contact Kevin

Gurus

You are here: HomeArticlesArchive by Category "Gurus"

Gurus

My favorite Excel tips & solutions from the web

Advanced Conditional Formatting

  • November 17th ,2019
  • Kevin Lehrbass
  • Gurus
  • Conditional Formatting
  • 0
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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! (more…)

Excel Sorting Challenge

  • November 28th ,2018
  • Kevin Lehrbass
  • Gurus
  • 5
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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

Ken Puls Power Query Challenge #2

  • August 14th ,2018
  • Kevin Lehrbass
  • Gurus
  • Get & Transform, Oz du Soleil, Power Query
  • 0
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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. (more…)

Stack Groups of 3 Numbers in Excel

  • May 17th ,2018
  • Kevin Lehrbass
  • Gurus
  • Get & Transform, textjoin
  • 1
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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.  (more…)

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

  • March 14th ,2018
  • Kevin Lehrbass
  • Gurus
  • Bill Jelen, Mike Girvin
  • 3
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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. (more…)

Video 00174 Ranking Values into Tiers in Excel

  • January 29th ,2018
  • Kevin Lehrbass
  • Gurus, Solutions
  • Binning, match, Rank, Roundup
  • 0
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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. (more…)

Change Text to Sentence Case

  • January 26th ,2018
  • Kevin Lehrbass
  • Auditing, Gurus
  • String Manipulation
  • 5
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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! (more…)

Compare Text Fonts in Excel using VBA

  • November 16th ,2017
  • Kevin Lehrbass
  • Gurus
  • vba
  • 3
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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! (more…)

Video 00164 Excel Magic Trick 1452 Max Monthly Customer

  • August 29th ,2017
  • Kevin Lehrbass
  • Gurus
  • 0
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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? (more…)

Video 00165 Show Column Header for Matrix Value

  • August 23rd ,2017
  • Kevin Lehrbass
  • Gurus
  • Leila Gharani, Oz du Soleil
  • 8
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

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! (more…)

1 2 Next →

Share

Newsletter

Do You Excel?

Kevin_Col-275x300-small-2019.png
“Improving your Excel skills can change your career!. Visit my 'EXCEL TRAINING' section!”

- Kevin Lehrbass

Excel Made Easy

Learn Excel

Free Templates

Video How-To's

© 2014 My Spreadsheet Lab| Entries (RSS)
website design & development by Engine Communications