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.

Named Ranges

Time calculations

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 Function

OFFSET – Dynamic Reference Video



Financial Functions

Excel Bank Reconciliation Formula

Compound Interest on Savings Formula

FV Function

NPER Function


Math & Trig

SUMIF & SUMIFS Explained

SUBTOTAL Explained


FLOOR and CEILING Functions


Excel SUMPRODUCT an alternative to SUMIFS

Statistical Functions




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


TEXT Function examples and a clever twist.

T Function

UPPER, LOWER and PROPER functions



Nested SUBSTITUTE formula trick

CLEAN formula


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






Rounding Time

Convert time to decimals

Convert dates formatted as text strings to numbers


N Function

Database Functions


Excel Charts

Excel Chart Axis Label Tricks

Excel Chart Secondary Axis

Excel Histogram Charts

In-cell Charts

Gantt Charts

Gantt Chart Template using Conditional Formatting


PivotTables Explained

PivotTable Tutorial [video]

Auto-refresh PivotTables

Extract sub-sets of data using a PivotTable Report,

Reverse PivotTable

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

Excel Tables

Data Validation – Drop Down Lists

Custom Cell Formats

Conditional Formatting

Conditonal Formatting with Formulas

How to Apply Filters

Advanced 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

Camera Tool

Shapes and SmartArt

Importing data into Excel

Array Formulas

Excel Wildcard

Excel Workspace

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.

Share This

Please share this or leave a comment and I'll make sure you get a personal reply.

Leave a Comment

Current day month ye@r *

{ 23 comments… read them below or add one }

Ashish Sharma July 18, 2014 at 9:23 pm

kindly please tell me how i convet number into words.

Rupee 1500 in to one thousand five hundred only


Catalin Bombea July 19, 2014 at 12:01 am

Hi Ashish,
There is a UDF posted by Phil here.
Change in code Dollars and cents to your local currency.


Tahir July 3, 2014 at 9:24 pm

You Are working exceptional by spreading the knowledge for Microsoft Excel. As far as me is concerned, I got Much More from your source of communication.


Mynda Treacy July 4, 2014 at 7:42 am

Thanks, Tahir. It’s great to know we are able to help you master Excel.



Mahesh Dhiman November 27, 2013 at 5:48 pm

I Want How To Use 2 Sheet Combined Column By Column And Match


Mynda Treacy November 27, 2013 at 8:10 pm

Hi Mahesh,

You haven’t given me much to go on but I suspect this tutorial might help you:

Kind regards,



Catalin Bombea November 12, 2013 at 12:09 am

Hi Emman, my opinion is that operation can only be done using VBA, you can try to use this code to select the used range from a worksheet, and paste it in another worksheet:
Sub SelectUsedRange()

Dim ws As Worksheet

Set ws1 = Worksheets("Sheet1")
Set ws2 = Worksheets("Sheet2")

ws1.UsedRange.AutoFilter field:=1, Criteria1:="<>"

ws2.Paste ws2.Range("A1")

ws1.AutoFilterMode = False
Application.CutCopyMode = False

End Sub
Cheers, Catalin


emman November 12, 2013 at 1:25 am

Hi Catalin,
Thanks a lot for taken time for me n given this suggestion. But i don’t think its a exact solution for the above question…actually its a interview question which i was attended last Saturday. The meaning of question is to select all non blanks (number or text or both) through macros it should be highlighted?


Catalin Bombea November 12, 2013 at 2:15 am

Hi Emman, the code will not select nonblanks, will just copy them to another sheet…
There is another way, i know it from Rick Rothstein , but it’s not so intuitive, but if you do it several times, you will see the functionality:
Here is the sequence of keys to use:
Shift+8 (basically just do a search for any value, using the asterisk “*” wildcard)
Ctrl+A (this will select all nonblanks actually)
Alt+F4 (to close the search window)
Cheers, Catalin


CL Lim October 29, 2013 at 5:32 pm

Hi! Mynda Treacy,

Thank you so much for your kindness in sharing such an informative tips and tricks to all Excel users. The formulas have been clearly explained and elaborated which can be easily understood by the readers. It really helps all of us and improve our knowledge in applying it in our job.

A very sincere gratitude to you for sharing the knowledge to all Excel users.

Thank you once again.

Sincere regards,
CL Lim


Mynda Treacy October 29, 2013 at 9:19 pm

Hi CL,

Thank you for your kind words. It’s rewarding to know our tutorials are helpful.

Kind regards,



Peter field October 9, 2013 at 8:27 pm

Thank you , this site is great and helps me a lot

Thank you


Mynda Treacy October 9, 2013 at 9:11 pm

Cheers, Peter :) Glad we can help.


Pete Soriano December 23, 2013 at 4:45 am

Mynda, I hope you can help me with this. I have a worksheet containing several columns. Column A has the dates from January 1 through December 31. Column B is the name of particulars in each row. Column C is the corresponding amount in each row. I like to tell excel to give me the total amount for January in D1 and Feb in E2 and so on. Please help me with the formula and send it by email to facilitate getting my work done.
Thank you.


Catalin Bombea December 24, 2013 at 2:18 am

Hi Pete,
the formula you should use is:


You can add more criterias, if you need to.


Amanda September 16, 2013 at 5:06 pm

Great list of formulas, thanks for sharing :)


Philip Treacy September 16, 2013 at 5:10 pm

Thanks Amanda. Glad you found it useful.


yogenderp excel June 17, 2013 at 10:35 pm

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


Mynda Treacy June 17, 2013 at 10:39 pm

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,



Gamaliel September 23, 2013 at 2:10 am

Hello Mynda,

Good day.
Hope you are well.
I am very interested about dashboard hope you can give me also.
I just read your message. I am just trying my luck if you can help me.
God bless to you.

Best regards,



Mynda Treacy September 23, 2013 at 10:25 am

Hi Gamaliel,

Thanks for your message. You can find out more about my Excel Dashboard course here.

Please let me know if you have any questions.

Kind regards,



Paul Durand June 6, 2013 at 2:58 am

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.


Mynda Treacy June 6, 2013 at 8:24 am

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,



Previous post:

Next post: