Advanced Excel Tutorials  Become an Excel Ninja
Learn Everything in Excel from building Excel Models to creating Dynamic Dashboards
Watch Promo
What’s covered in the Advanced Excel Tutorials course…
 Beginner Skills
✓ Data basics (Best usage of Shortcuts, Formatting tricks, cell referencing)
✓ Simple problem solving (Sort and Filter basics)
✓ Learn Essential Business Math (Formula Warmup, Pivot table overview
 Intermediate Skills
✓ Build simple models (Combo Formulas, 3dimensional lookups, Date formulas)
✓ Errorhandling to avoid humiliation (data validation, auditing, track variables)
✓ Learn Data Cleaning Techniques (GotoSpecial, Text formulas, Flashfill)
✓ Summarize your data with Pivot Tables (Slicers, Sparklines, Calcs, Differential Criteria Filters)
 Advanced Skills
✓ Modeling Uncertainty (Scenario, Sensitivity Analysis, Data Tables, Goal Seek)
✓ Slideready output (Charts and Graphs, Printing techniques)
✓ Dynamic Dashboards (Get Pivotdata, Learn Reverse lookups, conditional calculations)
✓ Managing Data Security (Passwords, sheet protection)
These Advanced Excel Tutorials are targeted to SAVE you YEARS! This Online Course will propel you from the current proficiency level to a level where you can train professional users and explore a very satisfying and rewarding career opportunity.
Check out the Course Syllabus to see exactly what's part of this course.
Your Instructor
 Trained 30K+ professionals through
 150K+ Online Students
Course Curriculum

Preview0101 Introduction (5:12)

Preview0102 How to learn the best shortcuts in this section? (1:17)

Start0103 What is faster than the regular Copy and Paste shortcuts? (3:23)

Start0104  What is the shortcut to automatically fill selected cells? (1:16)

Start0105  Impress your coworkers with these 6 [data selection and navigating] shortcuts (4:34)

Start0106  Impress your coworkers with these 6 [rows and column] shortcuts (3:07)

Start0107  Impress your coworkers with these 9 [formula writing & auditing] shortcuts (6:20)

Start0108  Impress your coworkers with these 7 [formatting] shortcuts (4:39)

Start0109  How to create your own custom shortcut key in 2 clicks? E.g. Paste Special Value (4:45)

Start0110  How to audit a Financial Model or a Budget Sheet? (4:51)

StartExcel Shortcut Quiz #1

StartAdvanced Excel Tutorials Feedback

Preview0201  2 ways MAX() function can help build Financial Models & Budget (2:44)

Preview0202 Which two formula you must know for calculating Bidding & Auction pricing? (2:38)

Start0203  Learn the basics of ROUND(), ROUNDUP() and ROUNDDOWN() (3:43)

Start0204  Learn the advanced level of ROUND(), ROUNDUP() and ROUNDDOWN() (6:38)

Start0205  Learn the 4 most important COUNT formula types (3:20)

Start0206  Why is SUMPRODUCT so important for calculating weighted average? (3:34)

Start0207  How do you perform compounding and discounting calculations in Excel? (2:39)

StartExcel Formula WarmUp Quiz #2

StartAdvanced Excel Tutorials Feedback
FAQs
You can enroll for this online training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
 Visa/Master Card credit card
You will have access to the online elearning and practice worksheets along with the training.
Yes. There are some small differences in the Mac and Win interface with respect to formulas, but in general there is very good overlap between the Mac and Windows versions. The videos were recorded in Windows.
Yes, we offer course completion certificate after you successfully complete the training program.
We watch a lot of learning videos ourselves on wide variety of topics and have realized that our attention span is limited. We think people learn quickly and effectively with a nononsense approach that is quick, clean, and to the point.