fbpx

Advanced Excel Course with 150+ tricks

Course Instructor: Rishabh Pugalia (ex-KPMG, ex-J.P. Morgan) is a Chartered Accountant. He regularly teaches Advanced Excel Analytics at two of the Big Four firms  – PwC & EY. His aim is to make you an Excel Pro.
  • Video Lessons = 177+ (11 Hrs)
  • Lifetime Access
  • Lifetime Support
  • 4.8/5 Rating

Advanced Excel Course Skills

Intermediate Skills

Able to implement techniques in your office
  • 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)

Advanced Skills

Ninja-Level Skills
  • Slide-ready output (Charts and Graphs, Printing techniques)
  • Dynamic Dashboards (Get Pivotdata, Learn Reverse lookups, conditional calculations)
  • Managing Data Security (Passwords, sheet protection)

3 reasons how this course is different than the others?

#1 Course Instructor with experience of three of the Big Four firms

The course instructor is a Chartered Accountant. He has worked with KPMG & J.P. Morgan. He regularly teaches Advanced Excel Analytics at two of the Big Four firms  – PwC & EY. Your learning will be the sum of all his experience. Some of his students have become Excel instructors themselves.

#2 We have Pro-level tricks which are often ignored by others.

Few examples:
(a) Complex combo functions: HLOOKUP with MATCH; OFFSET with MATCH
(b) Difference between MATCH function with 0 vs. 1 vs. -1
(d) SUMIFS with date ranges and ID-based running total
(d) Using Data Tables for Sensitivity Analysis along with INDIRECT function
(e) New updates: Fuzzy Lookup, FlashFill, Slicers
… and the list goes on (check the Index below)

#3 Our Video avoid “death by boredom”

(a) All videos have zoom in / zoom out, annotations, markers
(b) The narration is not a script reading
(c) Real-life stories connected to the learning
(d) Picture based eBook so that you don’t have to watch the video again

Learner Testimonials

I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.

peter-kuluberg-excel
Peter Klugsberger
ex-McKinsey & Co. served various senior roles (CEO, COO) in various companies

Because I use spreadsheets daily, I’m often using the Shift+down arrow to highlight and then manipulate data. Of course, this takes FOREVER! As I am advancing in my role at work, it is very important for me to learn more advanced Excel skills. I chose this video b/c it was short and condensed. I could literally watch it on my breaks at work and then use it right away. I really like that. Well done!

barbara
Barbara Jones
Finance Professional

I’ve been using Pivot Tables for a couple of years, so was expecting most of this to be familiar. But this course proved me wrong. From simple tips and keyboard shortcuts, to whole features I never knew existed, I constantly found myself muttering things like “oh wow, I had no clue about that”. Things that I can actually put into practice in my job. It’s a great feeling. Kudos to the team on a great course

Placeholder
Peter Thomas
Accounting Professional

Testimonial for YodalearningWe have helped these CompaniesI have helped this company

What do TOP Excel Bloggers think about my course…

Big Peoples Reviews

Excel Course Preview Video

COURSE CURRICULUM

Beginner Mode
Intermediate Mode
Advanced Mode
Ultimate Mode
✅ AutoSum function in Excel ✅ Number filter in Excel
✅ Max function in Excel ✅ Remove Duplicates values in Excel
✅ Average function in Excel ✅ Create Drop-down in Excel in 30 seconds
✅ CountBlank function in Excel ✅ Remove Drop-down in Excel
✅ Count and Counta function in Excel ✅ Freeze Panes in Excel
✅ Master logical statements: True or False in Excel ✅ Format Painter in Excel
✅ Simple logical statement: True or False in Excel ✅ Table Formatting in Excel
✅ Status bar in Excel ✅ Hyperlinks in Excel
✅ Data Formatting in Excel ✅ UPPER, LOWER, PROPER to change text case in Excel
✅ Autofill dates in Excel ✅ Trim function in Excel
✅ Autofill numbers in Excel ✅ Round function in Excel
✅ Sort Data in Excel | Descending order ✅ MRound function in Excel
✅ Sort Data in Excel | Alphabetically ✅ How to store numbers as text in 1 minute in Excel
✅ Sort by Dates in Excel ✅ Value function in Excel
✅ Sort by Color in Excel ✅ Len function in Excel
✅ Filter Data and then Calculate Sum in Excel ✅ Left – Right – Mid function in Excel
✅ Filter in Excel ✅ Excel VBA (Macro Basic)
✅ Working with filtered Data in Excel ✅ Basics of Charts in Excel

 

✅ Pivot Table in Excel ✅Calculate Year on Year percentage Growth
✅ Vlookup function in Excel | Part 1 ✅ Add serial numbers column before sorting in Excel
✅ Vlookup function in Excel | Part 2 ✅ 2 level sorting in Excel
✅ Vlookup function in Excel | Part 3 Subtotal function in Excel
✅ Vlookup function in Excel | Part 4 ✅ Format Painter Continuously in Excel
✅ Vlookup function in Excel | Part 5 ✅ Color multiple sheet tab in Excel
✅ Use Vlookup to find the Debtors Ageing analysis in Excel ✅ Color cells based on cell value in Excel
✅ I bet you wouldn’t know this Vlookup trick in Excel | Score Grading ✅ Color cells based on cell error or blanks in Excel
✅ I bet you wouldn’t know this Vlookup trick in Excel |Food Grading ✅ Adding leading Zeroes in cheque number in Excel
✅ Using Vlookup find Service tax in Excel ✅ Calculate Fixed Deposit in Excel | Part 1
Excel vlookup in Multiple sheets ✅ Calculate Fixed Deposit in Excel | Part 2
✅ Vlookup vs. Hlookup in Excel ✅ Formatting Tricks to write x3 in Excel
✅ Excel Logical function – AND, OR ✅ Pie Chart in Excel
✅ IF function and Nested IF function in Excel ✅ Chart Trick – Best way to present Charts in Excel
✅ Countif function in Excel | Cell Counting ✅ View bar in Excel
✅ Sumif function in Excel | Adding numbers ✅ Comments in Excel
✅ Avaergeif function in Excel ✅ Print Excel Sheets
Sumproduct function in Excel ✅ Dashboard
✅ Delete Error cells by using Go To Special in Excel Dashboard Trick – Create a scroll Bar in Excel
✅ Excel Shortcut: Ctrl + Enter Hyperlinked Shortcuts in Excel
✅ Fill Intermittent Blank cells in Excel Horizontal Sort in Excel
✅ Match function in Excel | Part 1 Add a blank row in Excel
✅ Match function in Excel | Part 2 ✅ Sort Data by Custom list in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 1 ✅ Thermometer Chart in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 2 ✅ Multi-axis Chart in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 3 ✅ Formula Security
✅ 2D Lookup | Vlookup and Match in Excel | Part 4 ✅ Formula Audit
Roundup and Rounddown function in Excel ✅ 3D Data Consolidation in Excel Part 1 & 2
Round function in Excel | Practical Applications ✅ Goalseek in Excel
Round Tricks in Excel ✅ Substitute and Replace function in Excel
Substitute function in Excel ✅ Joining data strings using CONCATENATE, &
✅ Activate Developer Tab in 2007-2016 in Excel ✅ Reverse 2-way Lookup – INDEX with MATCH Part 1
✅ Dashboard Trick – Create a spin Button in Excel ✅ Reverse 2-way Lookup – INDEX with MATCH Part 2
✅ Create Scenario in Excel ✅ Reverse 2-way Lookup – INDEX with MATCH Part 3

 

✅ Microsoft Add-in Fuzzy lookup in Excel
Flash fill in Excel | Data Cleaning
Hide a sheet so that no one can easily Unhide in Excel
Confidential – Remove “Protect sheet” Password with Notepad
Confidential – Remove “Protect workbook” Password with Notepad
✅ Making a text magically invisible in Excel
✅ OFFSET function in Excel
✅ Indirect function in Excel
Text to Columns in Excel

Start Learning Today

No Frills

Free Course Lessons

$FREE
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
WATCH NOW
No Frills

Lifetime Access

177+ Course Lessons
$48
  • 177+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now
Office Training Bundle Package

All Courses

Unlimited Learning [All YL Courses]
$690
  • 177+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Looking for subscription plan? Get All Courses in $39/mo: Enroll Now

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

30 days money back gauarantee

Course Completion Certificate By Yodalearning

Unlock your completion certificate

  • Complete Advanced Excel premium course at Yoda Learning Solutions
  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

For Enquiry About Courses? Contact Us:
[email protected]
 +1- 203-349-9909

Feel free to call us for any query related to courses. Our support team will resolve your issue.

Advanced Excel Course is for you if...

  • You use ERP downloaded Excel files as a base to generate custom MIS reports
  • You want to reduce your TAT significantly (turnaround time)
  • You want to prepare Financial Models with combo-logical statements
  • You prepare Management Reporting dashboards
  • You are involved in Performing CAAT & Forensic Audit techniques
  • You are looking for basic excel course which make you advanced in excel course

Advanced Excel Course is not for you if...

  • You use Excel rarely like if you’re on sales field all the time or work as a salesman or cashier facing the consumer [I love you guys, but this model will not help you]
  • You have a personal assistant who is an Excel expert and can do all the number crunching for you [May be, this course will be helpful to your assistant]
  • Anyone who wants to instant results just because they have joined without taking any real action or practicing the working files

Frequently Ask Questions

What do you get in Excel course?

  • An accelerated, Practical approached Advanced Excel Tutorials to teach you Skill needed to compete in competitive work environment
  • All Advanced Excel tutorials case studies related to videos
  • A picture based PDF handbook on Excel Tips, Functions & Techniques
  • Access to all excel video tutorials 24 x 7 – learn excel online from anywhere
  • A 30-day money-back guarantee (we want you to be 100%)

How do I enroll for the Excel training online?

  •  Visa/Master Card credit card
  • Through PayPal

What will I be able to do after completing this Excel tutorials?

  • Create reports with sheets across 10+ excel files
  • Build interactive Pivot table with key business metrics like sales, monthly variations, top 10 customers
  • Transform messy data within minutes
  • Wow your boss and get noticed by the top management

What if I’m unhappy with my online excel course? Do I get a refund?

Customer happiness is our ultimate goal. These Excel videos are created after spending a lot of time in research and recording. We would never want you to be unsatisfied with your purchase and if you’re, then contact us in the first 30 days and we will give you a full refund. To know more, please read our Refund Policy.

How much time required to complete Excel Training?

This is a fast-paced, lean excel training program of about 11:30 hours with videos from basics to Advanced Excel Tutorials. Watch the preview of Excel videos to get a flavor of the program’s uniqueness and relevance. Online Excel course may not be your first preference but I promise that – after watching 3 videos, this course will give a tough fight to your usual classroom Excel Training.

How can you say that my speed will improve?

Well, I want to share something personal. My feedback from each and every client from Corporate gave me a rating between 4.8 to 5 out of 5. So, do not worry. I will empower you with all the excel tips and tricks based on the real issues faced by 1000s of students I teach. I created this advanced excel tutorials after so many years of research and hundreds of hours of excel training. You can also try the Outlook Tutorial to improve your speed further.

What do you get in the course?

In our program, we will train you with our advanced Excel skills which will help you to be the supreme ninja of excel in your field. Data Lookup & Calculations such as Vlookup and Hlookup, Pivot Table for multi-variable analysis, Logical Statements, MIS Reporting & Dashboard Techniques and the Application of Macros.