Advanced Excel Tutorials - Become an Excel Ninja
Online Advanced Excel Tutorials to make you a NINJA at work. Learn Everything in Excel from building Excel Models to creating Dynamic DashboardsEnroll in Course
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, 3-dimensional lookups, Date formulas)
✓ Error-handling to avoid humiliation (data validation, auditing, track variables)
✓ Learn Data Cleaning Techniques (Go-to-Special, 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)
✓ Slide-ready 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.
Rishabh Pugalia | 🔗 Linkedin Profile
⭐ 4.8 Average Rating | 💬 839 Reviews |
🎓 30,000+ Classroom Students |💡 160,000+ Students Online
ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12,000+ participants across PwC, EY and Deloitte over last the 10 years
I am a Chartered Accountant from India. I have worked with KPMG (Audit), J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time).
After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Flipkart, Uber, Tata Group etc. use these video courses to excel at work - Automation & Analytics.
Preview0101 How to use this section? (1:17)
Start0102 The "ONE" Universal shortcut & a faster Copy-Paste technique (3:23)
Start0103 AutoFill selected cell(s) with pre-defined formula/text/no. (1:16)
Start0104 Navigating across Worksheets; Data Table selection & manoeuvring (4:34)
Start0105 Adding/Deleting/Selecting Rows/Columns (3:07)
Start0106 For "Formula" One Speedstars (6:20)
Start0107 Formatting cells (4:39)
Start0108 Using Quick Access Toolbar (QAT) (4:45)
Start0109 Formula auditing magic (4:51)
StartExcel Shortcut Quiz #1
Preview0201 MAX() in Financial Modeling (2:44)
Preview0202 LARGE() & SMALL() - for bidding/auction pricing strategies (2:38)
Start0203 Advanced ROUND() Tricks with ROUNDUP() & ROUNDDOWN() - 1 of 2 (3:43)
Start0204 Advanced ROUND() Tricks with ROUNDUP() & ROUNDDOWN() - 2 of 2 (6:38)
Start0205 COUNT() vs. COUNTA() vs. COUNTBLANK() vs. COUNTIFS() (3:20)
Start0206 SUMPRODUCT() for weighted average computation (3:34)
Start0207 POWER() vs. Caret sign ( ^ ) (2:39)
StartExcel Formula Warm-Up Quiz #2
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 e-learning 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 no-nonsense approach that is quick, clean, and to the point.