Functional Excel Skills

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.

• 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