Nigel Tillery

EXCEL 2022

The Complete Illustrative Guide for Beginners to Learning any Fundamental, Formula, Function and Chart in Less than 5 Minutes with Simple and Real-Life Examples

EXCEL VIDEO COURSE

BEGINNER

- Beginner’s Introduction to Excel [19:44]
- Basic Formatting Techniques [08:06]
- Math & Statistical Functions (e.g. SUM, AVERAGE) [13:53]
- Date & Time Functions (e.g. TODAY, MONTH) [13:25]
- Text Functions (e.g. LEN, CONCATENATE) [14:34]

INTERMEDIATE

- Logical Functions (e.g. IF, AND) [14:56]
- Lookup & Reference Functions (e.g. VLOOKUP, MATCH) [14:04]
- Absolute and Relative Cell Referencing (i.e. the $ sign) [07:44]
- Naming Ranges and Cells [09:58]
- Data Validation with In-Cell Drop-Down List [08:54]
- Conditional Formatting [09:11]
- Introduction to Pivot Tables [06:57]
- Advanced Pivot Tables: Round 1 [08:18]
- Advanced Pivot Tables: Round 2 [11:19]
- Auto-Filter and Advanced Data Filtering [06:34]
- Creating and Designing Charts (including Sparklines) [14:48]
- Error Checking and Data Monitoring [16:52]

ADVANCED

- Information Functions (e.g. CELL, ISNUMBER) [09:44]
- Formula Auditing & Formula Evaluation [07:28]
- Advanced VLOOKUP Examples [14:36]
- Advanced INDEX & MATCH Lookup Examples [09:40]
- Five Powerful Excel Tips [15:19]
- Introduction to Macros & VBA programming [13:08]
- VBA Macro Walkthrough #1: Purchase Order Generator [17:28]
- VBA Macro Walkthrough #2: Message Encoder & Decoder [16:51]