Formulas & Functions

Charts & Graphs

Data Analysis 
with PivotTables

Formulas & Functions

This course will give you a deep understanding of the formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to think like Excel.

$175

Regular Price

$40

Special Offer

Full Course Access Includes

http://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_clockwise.svg
Lifetime Access
http://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_elaboration_browser_download.svg
Downloadable resources and practice files
http://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_book_pencil.svg
Course quizzes and homework exercises
http://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/arrows_shrink_horizonal2.svg
1-on-1 instructor support
http://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/ecommerce_receipt_dollar.svg
30-day money-back guarantee

Choose A Section

Excel Formulas 101

Formula Library & Auditing Tools

DEMO: Evaluate Formula

Basic Formula Syntax

Fixed, Relative, & Mixed References

Common Errors & IFERROR

Function, CTRL & ALT Shortcuts

Shortcuts for Mac Users

Custom Data Validation Rules

Fixed vs. Volatile Functions

Logical Operators

Anatomy of the IF Statement

Nested IF Statements

AND/OR Operators

NOT vs. “<>”

Fixing Errors with IFERROR

Common IS Statements

Statistical Functions

Basic Stats Functions

SMALL / LARGE & RANK / PERCENTRANK

RAND() & RANDBETWEEN

The SUMPRODUCT Function

COUNTIFS / SUMIFS / AVERAGEIFS

DEMO: Building a Basic Dashboard

Lookup/Reference Functions

Working with Named Arrays

ROW / ROWS & COLUMN / COLUMNS

VLOOKUP / HLOOKUP

Joining Data with VLOOKUP

Combining IFERROR & VLOOKUP

VLOOKUP Reference Arrays

The INDEX Function

The MATCH Function

Combining INDEX & MATCH

Combining MATCH with VLOOKUP

The OFFSET Function

Combining OFFSET with COUNTA

DEMO: Building a Scrolling Chart

Text Functions

UPPER / LOWER / PROPER & TRIM

The CONCATENATE Function (&)

LEFT / MID / RIGHT & LEN

TEXT & VALUE

SEARCH & FIND

The IF(ISNUMBER(SEARCH)) Combo