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.
Absolute References Explained
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.
IF Statement Explained
Nested IF Formulas
IF, OR and AND used together
Lookup & Reference
VLOOKUP Exact Match version
VLOOKUP Sorted List version
VLOOKUP with dynamic column reference
VLOOKUP and Sum Multiple Columns
VLOOKUP Multiple Criteria
VLOOKUP Multiple Sheets
VLOOKUP Multiple Values in Multiple Columns
VLOOKUP with CHOOSE – a trick that allows you to look up columns to the left.
Lookup and Return Multiple Values
HLOOKUP Exact Match and Sorted List
INDEX and MATCH – a VLOOKUP alternative that solves some of its limitations.
OFFSET – Dynamic Reference Video
Excel Bank Reconciliation Formula
Compound Interest on Savings Formula
Math & Trig
SUMIF & SUMIFS Explained
ROUND, ROUNDUP, ROUNDDOWN
FLOOR and CEILING Functions
RAND and RANDBETWEEN
Excel SUMPRODUCT an alternative to SUMIFS
AVERAGE, AVERAGEIF and AVERAGEIFS Functions
COUNT, COUNTA and COUNTBLANK Functions
COUNTIF & COUNTIFS Explained
STDEV & STDEVP Explained
MIN, MAX, SMALL and LARGE functions
RANK, RANK.AVG and RANK.EQ functions
Between Formula using MEDIAN
TRIMMEAN IF formula – find the average if criteria is met, and excludes outliers.
ISTEXT, ISNUMBER and ISBLANK Functions.
TEXT Function examples and a clever twist.
UPPER, LOWER and PROPER functions
TRIM, CHAR and SUBSTITUTE formula
Nested SUBSTITUTE formula trick
SEARCH and FIND Functions
5 Step System for nesting MID functions to extract text strings.
MID, LEN, REPT and FIND Functions
Convert Numbers into Words
Date and Time Functions
Convert time to decimals
Convert dates formatted as text strings to numbers
DSUM, DAVERAGE, DCOUNT etc
Excel Chart Axis Label Tricks
Excel Chart Secondary Axis
Excel Histogram Charts
Gantt Chart Template using Conditional Formatting
PivotTable Tutorial [video]
Extract sub-sets of data using a PivotTable Report,
Add a Percentage of Total Column to a PivotTable
Group Data in a PivotTable
Compare Columns in a PivotTable
Other Tools and Tricks
Evaluate Formula Tool
Excel Array Formulas
Data Validation – Drop Down Lists
Custom Cell Formats
Conditonal Formatting with Formulas
How to Apply Filters
How to insert Subtotals
Dynamic Named Ranges
Fix date formats using Text to Columns
Extract text strings using Text to Columns
How to Join Text Together
How to insert Outlines
Shapes and SmartArt
Importing data into Excel
Excel Go To Special
Didn’t find what you were looking for?
Try the blog or use the Search at the top of the page.
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.
Please share this or leave a comment
and I'll make sure you get a personal reply.