My Spreadsheet Lab

The site is about Microsoft Excel.

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

Posts Tagged → offset

Excel Running Template

posted in T_Planning on December 21, 2018 by Kevin Lehrbass 1 Comment

My super fit cousin Joe Perry contacted me with a few questions about an Excel spreadsheet he uses to track his running.  Continue reading →

Allocating costs

posted in Tips on August 21, 2018 by Kevin Lehrbass 4 Comments

In this post I’ll show you how to allocate expenses (or any number) over a period of time. I will use years but it could also be months, weeks or days. Continue reading →

Formulas or VBA to create military code?

posted in Formula or VBA on February 24, 2016 by Kevin Lehrbass 2 Comments

How do you know whether you should use Excel Formulas or Excel VBA? Sometimes both work and sometimes only one works. This series will explore this question. Let’s start with an idea from Sumit Bansal at TrumpExcel. Continue reading →

Video 00073 Helping Dean Pelton with his menu in Excel

posted in Features on January 13, 2014 by Kevin Lehrbass 3 Comments

Dean Pelton has a problem.

His menu is alphabetical and has too many meatball recipes.

Watch as Bill Jelen (aka Mr Excel) helps Dean:  Mr Excel helps Dean Pelton

 

But how can I help Dean?

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