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

Combining RIGHT, LEN, and SEARCH

The SUBSTITUTE Function

Date & Time Functions

The DATEVALUE Function

Date Formatting & Fill Series

TODAY() & NOW()

YEAR / MONTH / DAY & HOUR / MINUTE / SECOND

The EOMONTH Function

The YEARFRAC Function

WEEKDAY, WORKDAY & NETWORKDAYS

The DATEDIF Function

DEMO: Building a Budget Pacing Tool

Formula-Based Formatting

Managing Formula-Based Rules

Highlighting Rows with the MOD Function

Formatting Cells Based on Other Values

Formatting Cells Using Stats Functions

Formatting Cells Using Text & Logical Functions

Array Formulas

Rules of Array Functions

Pros & Cons of Array Functions

Types of Array Constants

Using Array Constants in Formulas

Named Array Constants

The Transpose Function

Linking Data: Array vs. Non-Array

Returning the “X” Largest Values

Counting Characters Across Cells

Creating a “MAX IF” Array Formula

“MAX IF” with Multiple Criteria

Using a Double Unary Operator (“–“)

Badass Bonus Functions

The INDIRECT Function

Dynamic Linking with HYPERLINK

Real-Time Data with WEBSERVICE & FILTERXML

Ready to Gain Full Access and Become an Excel Maven?

ACCESS FULL COURSE