Who should attend
This class is for those who already use functions, formulas and cell references — but want to enhance their spreadsheets with responsive tables, advanced charts and pivot tables.
Mastery of Excel is developed in stages: first you learn basic formatting, functions and formulas, and build a few spreadsheets yourself. Easy enough. But moving to the next level of proficiency is hard! To create truly professional-looking spreadsheets, you'll need to know how to organize data into elegant, interactive tables that dynamically generate colorful charts and graphs. To bring you up to an intermediate-level usage of Excel, we'll train you in how to use these core features:
After Intermediate Excel, you'll be ready for advanced Excel training.
Module 3: List/Table Essentials & Charting
Learning Outcomes:
Topics:
Module 4: Pivot Tables, Protecting & Linking Data
Learning Outcomes:
Topics:
Skills covered
"I learned pivot tables, conditional formatting and just the little hints and tips that I never thought to use before."
"I got a clear understanding of tables, great worksheets were sent that can be used to practice later, and an excitement for pivot tables!"
"Learning a lot new tips. Looking forward to learn more Excel."
"So many great new tips. I learned quite a bit. Excellent class!"
"Mo's teaching style is focused, informative, attentive, and soothing. The information presented was concise, easy to follow, and valuable."