Here you’ll find a list of common Microsoft Excel formulas and Excel functions explained in plain English, and applied to real life examples.
You won’t find any of that techno babble you get in the Excel Function Wizard here.
The Excel Tutorials are grouped in line with the Function Library so they’re easy to find when you need them.
And when you’re ready to take your Excel skills to the next level check out our Excel training course.
Excel Formulas – The Basics
Excel Formulas Not Working? Get help here. In this video I share several tips that will help you understand any formula and why it’s not returning the correct result.
Tabular Data – the perfect data format and 5 other formats that will make your Excel life difficult.
Lookup & Reference
VLOOKUP with CHOOSE – a trick that allows you to look up columns to the left.
INDEX and MATCH – a VLOOKUP alternative that solves some of its limitations.
Math & Trig
Excel SUMPRODUCT an alternative to SUMIFS
TRIMMEAN IF formula – find the average if criteria is met, and excludes outliers.
Date and Time Functions
Excel Formulas in Charts
GetPivotData Function – most people hate this function when they first see it but don’t be put off, it is well worth mastering.
Other Tools and Tricks using Excel Formulas
Didn’t find what you were looking for?
Try our blog or use the Search box at the top of the page.
Failing that you could try Microsoft themselves, but they don’t always keep their site up to date
Excel Training Course
Are you ready to take your Excel skills to the next level? Check out our Excel training course.
Found This Useful?
If you found our explanations of Excel formulas and functions useful, please help us out by sharing this page through Facebook, Twitter, Google + and Linked In.