My Spreadsheet Lab

The site is about Microsoft Excel.

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

Post Category → Templates

S curve

posted in T_Planning on November 25, 2021 by Kevin Lehrbass 1 Comment

I played around with two different S curve concepts using dynamic arrays.

Continue reading →

Discover Data Types templates

posted in Reviews, T_Education on February 7, 2021 by Kevin Lehrbass 1 Comment

I was working on a demo file about Excel’s new Data Types but I found an incredible set of templates created by Elisabetta Caldesi! Continue reading →

Chess FEN viewer

posted in Auditing, Other on August 23, 2019 by Kevin Lehrbass 4 Comments

FEN notation provides the necessary info to restart a chess game from a given position. See how I created a FEN viewer in Excel! Continue reading →

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 →

The Learning Curve in Excel

posted in EXCEL Path, T_Business on December 14, 2018 by Kevin Lehrbass 2 Comments

I’ve had this ‘Business Formulas’ book sitting around for years. I decided to explore the learning curve formula:  (a) create it in Excel and (b) think about the factors that go into learning Excel.
Continue reading →

Using Microsoft Excel for your hockey pool

posted in Sports, T_Planning on September 23, 2018 by Kevin Lehrbass 2 Comments

See how my Microsoft Excel template can give you an big advantage in your hockey pool! Continue reading →

Don’t break the chain

posted in T_Calendars on June 3, 2018 by Kevin Lehrbass 3 Comments

Years ago, Brad Isaac was working as a stand-up comedian. One night Brad saw Jerry Seinfeld at a comedy club and asked him if he had any advice for a young comic. Read Jerry’s advice and how this applies to learning Excel! Continue reading →

YouTube Video Transcript Template

posted in T_Education on March 6, 2018 by Kevin Lehrbass 5 Comments

Have you noticed there’s no way to create bookmarks within a YouTube video? I’ve always thought that it would be a great feature. Well, I have created an Excel template that can do this! Continue reading →

How Can I Improve My Excel Skills?

posted in EXCEL Path, T_Education on April 26, 2015 by Kevin Lehrbass 0 Comments

I have been asked this question many times so I thought I would write this post as a reference that I could share with anyone who wants to improve their Excel skills.

Download the Excel file from my OneDrive (file 00126) Continue reading →

Free Excel Template: Birthday and Anniversary Tracker

posted in T_Planning on January 6, 2015 by Kevin Lehrbass 10 Comments

This template allows you to keep track of events like birthdays and anniversaries. You can also create more events in the ‘Settings’ sheet.  In the ‘Input’ sheet you walk through the steps of selecting the event type, adding the individual’s name and date, etc.  

Continue reading →

← Older posts