Excel Tutorials
A collection of written and video based Excel tutorials (Power BI coming soon)Don’t Rush to Use Excel’s New Functions!
A Word of warning regarding using the new Excel functions released in March 2022
Excel Gets 3 New Text Functions
Three new functions that will make text manipulation much easier
Create a Ratings Chart in Excel
Need to know how to create “star ratings charts” in Excel? This tutorial will show you how
Calculate the Difference Between 2 Dates
Learn how to calculate the difference between 2 dates in Microsoft Excel
Cartoon People – Making Excel Fun to Use
Add a little fun to your Excel files as well as making them more engaging
Wow Your Audience -Infographic-Style Bar Charts
Learn how to create an impressive, eye-catching and engaging infographic that will wow your audience
LAMBDA – The Latest Excel Craze
LAMBDA is a brand new feature in Excel. It’s a function that allows you to create another function. What?? Why would you ever need to do that??
Workbook Protected. Password Unknown
How to make changes to a password protected workbook when you don’t know the password
5 Reasons Why XLOOKUP Beats VLOOKUP
XLOOKUP is branded as a VLOOKUP Killer but what’s so good about it? Here I present 5 reasons why it’s time to switch