What you'll learn
- Intermediate to Advanced Excel skills that will help you
- - to ace your Excel skills,
- - to find state-of-the art Excel functions,
- - to make yourself the go-to-person in their office, or
- - to be well positioned for your next promotion!
Requirements
- Basic Excel
- Example: be able to open one Excel file and connect to external data files, etc.
Description
The course is presented in four parts.
First, the course reviews 5 basic skills in building a pivot table learned in “Excel Pivot Table: How to Tame the Excel Beast!”
Second, we demonstrate 12 intermediate maneuvers to tame the Pivot Table beast. They include:
o How to solve a formula error in a pivot table
o How to show a Running total
o How to show averages. What average?
o How to count unique items
Third, we demonstrate 5 advanced maneuvers to tame the Pivot Table beast. They include:
o How to update manual filtered list
o How to set up a customized sorting order
o How to cut down big file size
o How to generate pivot reports for all entities
Last, the course shows 10 keyboard shortcuts used in building a pivot table. They include:
o Ctrl + T to convert data list to data table
o Alt + N + V to create a pivot table
o Alt + F1 to insert a pivot chart
Who this course is for:
- Students (Secondary or post secondary), Office workers, Professionals, and Managers
Course content
- Preview00:58
- Preview00:48
- Preview01:12
- Preview01:26
- Preview00:38
Instructor
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. He also sat as an Examiner for the International English Language Testing System (or IELTS) in the 1990s. On top of these, he is an exam trainer for various high profile exams, such as GRE (or Graduate Record Examination), GMAT (or Graduate Management Admission Test), TOEFL (or Test of English as a Foreign Language), and math contests such as Euler, Gauss and Pascal. He has published books on test taking strategies.
Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada.
Lenny's motto at work is "Don’t work hard, work smart". Lenny has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
Lenny is a big proponent of OCR (One-click Reporting), and SSR (Self-service Reporting).