-
This class is for people who use Excel everyday. It is aimed towards users who want to learn a few more functional skills
We will cover:
- Keyboard shortcuts
- Absolute and Relative referencing, including when using Tables
- Some useful formulas including VLookup and the new XLookup
- Delimiters
- Data Validation
- Conditional Formatting
- Dealing with raw data
- Inserting Tables
- Inserting Slicers
- Nested IF Statements
- OR Statements
- AND Statements
Bonus Videos:
- Using Logic to fill in missing values
- Inserting rows beneath alternating rows
Viewer request:
- Pivot Tables
- Multi Column Comparison
New videos are uploaded occasionally, so please keep an eye out for updated content.
Please let me know if you have any requests about a particular feature of Excel you would like to know more about.
Download Resources Here.
Overview
Syllabus
-
- Intro
- Lesson 1 Keyboard Shortcuts
- Lesson 2 Before We Look At Formulas
- Lesson 3 Formulas
- Lesson 4 VLookup
- Lesson 5 Delimiters
- Lesson 6 Data Validation
- Lesson 7 Filling Down & Conditional Formatting
- Lesson 8 Source Sheet
- Lesson 9 Data Setup
- Lesson 10 VLookup Continued
- Lesson 11 Absolute Referencing In Tables
- Lesson 12 XLookup
- Lesson 13 Data Extraction with the Find Function
- Lesson 14 Nested IF Statements
- Lesson 15 The OR Function
- Lesson 16 The AND Function
- Lesson 17 Putting Our Logic Together
- Viewer Request 1 - Pivot Tables
- Viewer Request 2 - Multi Column Comparison
- Bonus Video - Filling in Missing Table Data
- Bonus Video - Inserting Rows Into a Data Set
