Excel: Functions

Course 2: ~30 “Tier 1” functions will service more than 90% of your needs. Learning these removes complexity and equips you to apply any of Excel’s functions with ease. Solve problems efficiently by applying the right functions.

Buy $99.00

Course curriculum

1. Course interaction
2. Introduction
3. 01 - Before getting started
4. 02 - Orientation
1. Pre-course survey
1. Supplemental slides
2. Supplemental files
1. Chapter preview
2. 03 - Data types
3. 04 - Formula introduction
1. Chapter preview
2. 05 - Overview
3. 06 - XLOOKUP / VLOOKUP
4. 07 - XMATCH / MATCH
5. 08 - INDEX / MATCH
6. 09 - Compare
7. 10 - OFFSET
8. 11 - COLUMN(S) / ROW(S)
1. Chapter preview
2. 12 - Overview
3. 13 - FIND / SEARCH / LEN / LEFT / RIGHT / MID
4. 14 - Combine
5. 15 - & / TEXT
6. 16 - Exercise 1
1. Chapter preview
2. 17 - Overview
3. 18 - IF
4. 19 - IFERROR / ISERROR / IF(ISERROR…
5. 20 - SUMIF
6. 21 - SUMIFS
1. Chapter preview
2. 22 - SUM / SUBTOTAL
1. Chapter preview
2. 23 - Overview
3. 24 - DATE / DATEVALUE / EOMONTH
1. Chapter preview
2. 26 - Overview
3. 27 - COUNT / COUNTA
4. 28 - Exercise 2
1. Chapter preview
2. 29 - TRANSPOSE
1. Chapter preview
2. 30 - Overview
3. 31 - Basic functions
4. 32 - Intermediate functions (and VBA)
1. 33 - INDIRECT
2. 34 - LET and double unary operator
1. 35 - Wrap up
1. Post-course survey

About this course

49 lessons
2.5+ hours of high-quality video
Supplemental files and slides

Excel: Functions

Course curriculum

Introduction

Pre-course Survey

Materials

Data Types and Formulas

Lookup and Positioning

String Extraction and Manipulation

Logic

Summation

Date and Time

Statistics and Math

Spill

Tier 2

Optional

Wrap Up

Post-course Survey

About this course