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.
Logical Functions
Lookup & Reference
VLOOKUP with dynamic column reference
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
Financial Functions
Compound Interest on Savings Formula
Math & Trig
Excel SUMPRODUCT an alternative to SUMIFS
Statistical Functions
AVERAGE, AVERAGEIF and AVERAGEIFS Functions
COUNT, COUNTA and COUNTBLANK Functions
MIN, MAX, SMALL and LARGE functions
RANK, RANK.AVG and RANK.EQ functions
Text Functions
UPPER, LOWER and PROPER functions
TRIM, CHAR and SUBSTITUTE functions
MID, LEN, REPT and FIND Functions
Date and Time Functions
Information
Database Functions
Formula Basics
Excel Charts
Gantt Chart Template using Conditional Formatting
PivotTables
Add a Percentage of Total Column to a PivotTable
Compare Columns in a PivotTable
Other Tools and Tricks
Data Validation – Drop Down Lists
Conditonal Formatting with Formulas
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.



... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses



{ 4 comments… read them below or add one }
This is an excerpt of a letter that I sent to my friends and family. “I stumbled onto this site looking for a resolution to a problem on a complicated spreadsheet I was developing. I don’t usually have an ongoing need for that kind of skill set. So retaining that information isn’t something that I would normally do unless I happen to be using it repetitively. Long story short, this site as well as My Online Training Hub has restored my faith in a simple, readable explanation of Excel formulas not to mention all of the Microsoft office software. The information is free as is 150 hrs of free training. Additionally, they offer 100 Excel tips and tricks that is nothing less than functionally superb. If you have a need for this occasional skill set, or your children or grandchildren have that need, this is the place. If you have a more pressing or ongoing need, they offer training that is remarkably inexpensive.
My problem was repetitive enough on my developing spreadsheet that I was totally stumped regardless of the research that I had done up to stumbling onto this site. I emailed them and they sent me a possible solution ( in less than 8 hours), which didn’t seem to work. They also offered to take a look at the spreadsheet if there suggestion didn’t work. I sent my template late one evening and got the answer back in less than 4 hours. Wow – in todays world??
I can’t say enough about this site and encourage you to store this email of their website in a location that you can access, should you ever have the need for this type of info. The resolution to my problem was critical if I was going to move forward with a custom made budget projection workbook. This was going to be the crux of a business that is being formed. PROBLEM SOLVED. The info is a quick and easy read.
Wow. Tanks for your kind words, Paul.
It’s rewarding to know that what we do is both appreciated and really helping people.
Warm regards,
Mynda.
hi
i am yogender andhra pradesh, India
i know knowledge in excel
i am working as excel trainer so i have learn advanced tip& tricks
your website is very use full all learners
further i would like join in online excel dashboards
please send about dashboards
thanking you
yognder
Hi Yogender,
Thanks for your kind comments. I’m glad you like our Excel Formulas list
I’ll email you direct about the Excel dashboard course.
Kind regards,
Mynda.