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, sign up to our email list: