Prerequisites
Course Overview
This course will teach you how to use formulas and advanced functions, create and
format tables, sort and filter and protect and finalize a workbook.
Instruction will be personalized by version (2016/2019/2021/365).
Goal
Learning How to read a function tip (like a musical note) to deal with anyone of the built-in functions.
Excel Intermediate Topics
1. What is a Formula?
2. Basic Formulas
3. Order of Operation
4. Moving Selection
5. Seven Methods to Add numbers
6. Relative & Absolute Reference
7. Basic & Intermediate Functions
8. Financial Functions
9. Text Functions
10.Date Functions
11.Logical Functions
12.Conditional Functions
13.Extraction Functions
14.Formula Auditing
15.Naming Cells & Ranges
16.Sort & Custom Lists
17.Filtering Data
18.Data Validation
19.Lists & Tables
20.Tips and Shortcuts
