I played around with two different S curve concepts using dynamic arrays.
Continue readingPost Category → Templates
Discover Data Types templates
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
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
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
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
See how my Microsoft Excel template can give you an big advantage in your hockey pool! Continue reading
Don’t break the chain
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
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?
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
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.