My Spreadsheet Lab

The site is about Microsoft Excel.

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

Posts Tagged → Bill Jelen

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 →

Mr Excel (Bill Jelen) Power Excel Seminars

posted in Reviews on September 28, 2015 by Kevin Lehrbass 5 Comments

Last week I attended one of Bill Jelen’s Power Excel Seminars.  The event was hosted by Excel4Apps at the SoHo Metropolitan Hotel in Toronto. Continue reading →

Video 00042 Why would I need an array formula?

posted in Formulas on April 11, 2013 by Kevin Lehrbass 0 Comments

Why would I need an array formula?

I have heard this question so many times over the years! If you have never ever used an array formula than this video is for you.

Don’t worry….No prior knowledge is required. I explain things slowly. Continue reading →

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