Excel Formulas Explained
Excel Formula Cheat Sheet
Here you’ll find some of the most common 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.
Be sure to check back regularly as this list of Excel formulas will be added to continuously. Or go ahead and have one of these automated services let you know when we’ve added a new tutorial:
1) Sign up for our Excel Newsletter and get our bonus FREE 100 Excel Tips & Tricks e-Book.
2) Subscribe to our RSS feed and get notified in your email.
3) Sign up for our free training, and I will personally let you know when a new formula has been added.
4) Follow us on Twitter or Facebook for updates.
Logical Functions
Lookup & Reference
VLOOKUP with dynamic column reference
HLOOKUP Exact Match and Sorted List
INDEX and MATCH – a VLOOKUP alternative that solves some of its limitations.
VLOOKUP with CHOOSE – a trick that allows you to look up columns to the left.
OFFSET – Dynamic Reference Video
Financial Functions
Compound Interest on Savings Formula
Math & Trig
Excel SUMPRODUCT an alternative to SUMIFS
Statistical
AVERAGE, AVERAGEIF and AVERAGEIFS Functions
COUNT, COUNTA and COUNTBLANK Functions
MIN, MAX, SMALL and LARGE functions
Text
UPPER, LOWER and PROPER functions
TRIM, CHAR and SUBSTITUTE functions
Date and Time
Information
Database Functions
Formula Basics
Excel Charts
Other Tools and Tricks
Data Validation – Drop Down Lists
