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 The Basics
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.
Space Operator Logical Functions
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
HYPERLINK Function Financial Functions
Excel Bank Reconciliation Formula
Compound Interest on Savings Formula
ACCRINT Formula Math & Trig
SUMIF & SUMIFS Explained
ROUND, ROUNDUP, ROUNDDOWN
FLOOR and CEILING Functions
RAND and RANDBETWEEN
Excel SUMPRODUCT an alternative to SUMIFS Statistical Functions
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. Text Functions
ISTEXT, ISNUMBER and ISBLANK Functions.
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 VBA Add-in by Yogesh Gupta Date and Time Functions
Convert time to decimals Information
N Function Database Functions
DSUM, DAVERAGE, DCOUNT etc Excel Charts
Excel Chart Axis Label Tricks
Excel Chart Secondary Axis
Excel Histogram Charts
Gantt Chart Template using Conditional Formatting PivotTables
PivotTable Tutorial [video]
Auto-refresh PivotTables 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
EVALUATE Function Didn’t find what you were looking for?
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.
FREE PDF Download 100 Excel Tips & Tricks
Just enter your details below
Please share this or
leave a comment
and I'll make sure you get a personal reply.