Excel Formulas

Excel Formulas

by on May 29, 2013

in Excel,Microsoft Office Training

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

IF Statement Explained

IFERROR

Nested IF’s

IF, OR and AND used together

Lookup & Reference

VLOOKUP Exact Match version

VLOOKUP Sorted List version

VLOOKUP with dynamic column reference

VLOOKUP Multiple Values

VLOOKUP Multiple Criteria

VLOOKUP Multiple Columns

VLOOKUP Multiple Sheets

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.

CHOOSE

OFFSET

OFFSET – Dynamic Reference Video

INDIRECT Function

HYPERLINK Function

Financial Functions

Compound Interest on Savings Formula

FV Function

NPER Function

Math & Trig

SUMIF & SUMIFS Explained

SUBTOTAL 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

Share This

Text Functions

T Function

UPPER, LOWER and PROPER functions

TRIM, CHAR and SUBSTITUTE functions

SUBSTITUTE function trick

CONCATENATE

SEARCH and FIND Functions

MID, LEN, REPT and FIND Functions

Date and Time Functions

TIME

EOMONTH

EDATE

DATEDIF

NETWORKDAYS

Rounding Time

Convert time to decimals

Information

N Function

Database Functions

DSUM, DAVERAGE, DCOUNT etc

Formula Basics

Absolute References Explained

Named Ranges

Time calculations

Space Operator

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

PivotTables Explained

PivotTable Tutorial [video]

Auto-refresh PivotTables

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

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

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

EVALUATE Function

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

Print Friendly and PDF

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

FREE PDF Download
100 Excel Tips & Tricks

Excel Tips & Tricks E-Book
Just enter your details below

Leave a Comment

{ 4 comments… read them below or add one }

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.

Reply

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,

Mynda.

Reply

yogenderp excel June 17, 2013 at 10:35 pm

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

Reply

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,

Mynda.

Reply

Previous post:

Next post: