Advanced Excel - Beginner to Ninja level (includes Charts)
Why take this course?
🌟 Master Excel Like a Ninja 🚀
Embark on an advanced learning journey with "Advanced Excel - Beginner to Ninja level (includes Charts)" – your ultimate guide to mastering Microsoft Excel for MIS Reporting, Data Cleaning, Data Analysis, and more! 📊✨
Course Headline: Unlock the full potential of Excel with our Advanced Excel Ninja online training program. This comprehensive course, spanning 12 sections and featuring over 90+ tutorial videos totaling an engaging 13 hours of content, leaves no stone unturned in your journey to becoming an Excel expert! 🎓
Course Overview 📚
Our course includes a variety of topics that are often overlooked in other advanced online programs. To truly appreciate the depth and breadth of this course, we invite you to watch our Demo Preview Lecture 89 and 90. You'll see firsthand what sets this program apart.
Key Topics Covered 🔍
- VLOOKUP() with MATCH()
- HLOOKUP() with MATCH()
- INDEX() with multiple arrays & MATCH()
- Using TRANSPOSE() formula
- Form Control Buttons for Dashboard creation
- Understanding the difference between SUMIF() vs. SUMIFS()
- Utilizing SUM() vs. SUBTOTAL() with Filter
- Hidden Text-to-Columns tricks
- Employing IFERROR() vs. IF() + ISERROR()
- Applications of INDIRECT() and OFFSET()
- Pivot Table techniques for advanced data analysis
- 3-Data Consolidation
- Mastering "GO TO - Special" with Ctrl+Enter
- Advanced "Find and Replace" with wildcard characters
- Combo techniques for efficient Data cleaning
- Formula-based Conditional formatting
- In-depth Charts including Thermometer, 2 axis, Trendline, Axis value settings, and more!
- Inserting Picture in Comments and much, much more...
Instructor's Profile 👨🏫
Rishabh Pugalia, the mastermind behind this course, is a qualified Chartered Accountant with rich experience at esteemed organizations like KPMG and J.P. Morgan. His dedication to teaching excellence is evident as he has already trained over 12,500 professionals in face-to-face training programs from April 2010 to June 2016.
Additionally, Rishabh has conducted over 200 workshops for one of the Big Four firms, engaging participants from various departments and domains. His extensive knowledge and real-world insights have been seamlessly woven into this online program to ensure you receive comprehensive, hands-on learning.
What You'll Get 🎁
As a participant of "Advanced Excel - Beginner to Ninja level," you will enjoy lifetime access to videos, which means you can revisit the content whenever you need a refresher or want to deepen your knowledge. You'll also receive downloadable Excel Case Studies and a picture-based HandBook (PDF) to supplement your learning experience.
Enroll now to transform your Excel skills and become an Advanced Excel Ninja! 🚀💻
Course Gallery
Loading charts...