Excel Articles, Tutorials & Common Functions

Here is a list of the most commonly used functions
(Work In Progress)

Math Functions

Text Functions

Logical & Reference Functions

Date & Time Functions

Financial Functions

Information Functions

AVERAGE

CONCATENATE

AND

DAY

FV

COLUMN

INT

FIND

COUNTBLANK

HOUR

IPMT

ISBLANK

MOD

LEFT / RIGHT

COUNTIF

MINUTE

NPV

ISERROR

RAND

LEN

IF

MONTH

PMT

ISNUMBER

ROUND

LOWER

LARGE

NETWORKDAYS

PPMT

ISTEXT

SUM

MID

MAX

NOW

.

ROW

.

PROPER

MIN

SECOND

.

.

.

REPT

NOT

TODAY

.

.

.

SEARCH

OR

WEEKDAY

.

.

.

SUBSTITUTE

SMALL

YEAR

.

.

.

TRIM

SUMIF

.

.

.

.

UPPER

VLOOKUP

.

.

.

.

VALUE

.

.

.

.


Here are some of the Latest Articles and Tutorials Specific to Excel


To hear about the latest articles, tutorials, product and courses, and to get your
FREE Excel Functions List, with over 470 functions covered, sign up to our email list: