How to Maximize Your Excel Experience for Maximum Productivity and Efficiency in No Time

BEGINNER

– Beginner’s Introduction to Excel

– Basic Formatting Techniques

– Math & Statistical Functions (e.g. SUM, AVERAGE)

– Date & Time Functions (e.g. TODAY, MONTH)

– Text Functions (e.g. LEN, CONCATENATE)

INTERMEDIATE

– Logical Functions (e.g. IF, AND)

– Lookup & Reference Functions (e.g. VLOOKUP, MATCH)

– Absolute and Relative Cell Referencing (i.e. the $ sign)

– Naming Ranges and Cells

– Data Validation with In-Cell Drop-Down List

– Conditional Formatting

– Introduction to Pivot Tables

– Advanced Pivot Tables: Round 1

– Advanced Pivot Tables: Round 2

– Auto-Filter and Advanced Data Filtering

– Creating and Designing Charts (including Sparklines)

– Error Checking and Data Monitoring

ADVANCED

– Information Functions (e.g. CELL, ISNUMBER)

– Formula Auditing & Formula Evaluation

– Advanced VLOOKUP Examples

– Advanced INDEX & MATCH Lookup Examples

– Five Powerful Excel Tips

– Introduction to Macros & VBA programming

– VBA Macro Walkthrough #1: Purchase Order Generator

– VBA Macro Walkthrough #2: Message Encoder & Decoder