“I love working with data in Microsoft Excel! Watch my videos and read my posts for interesting solutions and ideas!”

~ Kevin Lehrbass,
Your Excel Coach

NEWSLETTER

Excel How to Videos

Some of my favorite Spreadsheet Video Tutorials

"A properly designed spreadsheet can save thousands of hours of manual work."
~ Kevin Lehrbass

Icon Guy

I Love Excel!

Save

Posts From My Blog

  • Compare Text Fonts in Excel using VBA 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... (November 16, 2017)
  • Video 00167 Sliding Formula Ranges Data lands in Microsoft Excel in many different structures. Data Analysts like me will often tell you to normalize your data before starting your... (November 8, 2017)
  • Video 00166 Count Groups Above or Below Targets This Excel puzzle almost sounds like it could be solved with a quick COUNTIFS function but it's a bit more involved than that. Nevertheless, it... (November 7, 2017)
  • Video 00163 Creating a Weighted Random Dataset It's easy to create some random data using RANDBETWEEN and INDEX functions. But what if you want to create random data that favors or repeats some... (July 27, 2017)

GET EXCEL SPREAD SHEET TIPS!

Unlock the secrets and be more productive.

Click Here

VISIT MY BLOG AND LEARN MORE!

I share a variety of solutions and ideas!

Click Here