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, 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.


Your Instructor


Rishabh Pugalia
Rishabh Pugalia
Worked with KPMG, and became a Chartered Accountant Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

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 2021. 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.

  • Trained 30K+ professionals through
  • 150K+ Online Students

Course Curriculum


  Downloadable Files
Available in days
days after you enroll
  001 Ninja Shortcuts
Available in days
days after you enroll
  002 Business Math Calculations
Available in days
days after you enroll
  003 Formatting Tricks
Available in days
days after you enroll
  004 Formula Pre-Requisite
Available in days
days after you enroll
  005 Special Cell Selections
Available in days
days after you enroll
  006 Sort & Filter
Available in days
days after you enroll
  007 Working with Dates
Available in days
days after you enroll
  008 Data Input
Available in days
days after you enroll
  009 Organizing Data
Available in days
days after you enroll
  010 Pivot Table
Available in days
days after you enroll
  011 Lookup & Conditional Calculations
Available in days
days after you enroll
  012 Data Cleaning
Available in days
days after you enroll
  013 Logical Formulas
Available in days
days after you enroll
  014 Conditional Formatting
Available in days
days after you enroll
  015 What-If Analysis
Available in days
days after you enroll
  016 Subtotal and Consolidation
Available in days
days after you enroll
  017 Security & Password
Available in days
days after you enroll
  018 Printing & Comments - Part 1
Available in days
days after you enroll
  019 Printing & Comments - Part 2
Available in days
days after you enroll
  20 Charts
Available in days
days after you enroll
  21 Basics of VBA Macros
Available in days
days after you enroll

Get started now!



FAQs


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
Where and how can I access the e-learning content? Are there any limitations?
* Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website which can be accessed on Desktop, Laptops, Phones and Tablets. You'll receive an email immediately with a link to login, and when you do log in, you'll have full access to all videos and practice worksheets for the course(s) you purchased. * I am not able to access the online course. Whom should I contact for a solution? - Please send an email to hello@yodalearning.com. We promise to solve the issue within 24 hours
What if I’m unhappy with my course? Do I get a refund?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund. To know more please go through our Refund Policy.
How do I enroll for the online training?
<p> 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.<br> </p> <p> - Visa/Master Card credit card </p> <div> - Through PayPal </div> <div> - Debit card/Net Banking for INR (Indian Rupees) payment for lifetime courses </div>
What will I get along with this training?
<p> You will have access to the online e-learning and practice worksheets along with the training. </p>
Will the course work for both Windows and Mac?
<p> 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. </p>
Do you provide any course completion certificate?
<p> Yes, we offer course completion certificate after you successfully complete the training program. </p>
Why short videos?
<p> 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. </p>
What version of Excel do you teach?
We use Excel 2013 and we have added all new features up to Office 365.

FOR ENQUIRY ABOUT EXCEL NINJA COURSE? CONTACT US:

hello@yodalearning.com
US: +1 203-349-9909 / IN: +91-8080042523
Feel free to call us for any query related to the course. Our support team will resolve your issue.