fbpx

Excel Masterclass

Advanced Excel + Excel VBA + Excel Dashboard + Financial Modelling

  • Video Lessons = 357+ (30 Hrs)
  • Lifetime Access
  • Lifetime Support
  • 4.8/5 Rating

Excel Masterclass New Image

Excel Masterclass Skills

How will #ExcelMasterclass benefit me?

  • Writing VLOOKUP formula or making Pivot Table will NOT give you the #OfficeHero status.
    Don’t get me wrong. These topics are must-know. However, they solve basic problems and do not solve complex reporting and data analysis problems. Then, what does? Array formulas, Reverse Lookup, 3-D Lookup, Dynamic Dashboards, Automation using Macros… and more such tricks. #YodaLearning #ExcelMasterClass covers all of these.
  • Re-watching a video is a waste of time, and time is money.
    If a video can’t make you understand a topic in the first view, it’s the author’s fault. For most users, two of the most difficult topics to understand are VBA Macros & Array Formulas. #YodaLearning #ExcelMasterClass has videos which even an Excel beginner can pick up easily, right from the basics of VLOOKUP to 3-D Lookup, Array formulas and Excel VBA Macros.
  • Everyone loves easy-to-learn Excel tricks that has RoI.
    Did you know you can (1) remove the Excel Worksheet password using just a Notepad – no software download needed, (2) you can apply Machine Learning algorithm for data cleaning based on pattern recognition, and (3) you can Fuzzy Lookup to match entries with different spellings (James, R. Louis vs. Louis Jameson). Our #YodaLearning #ExcelMasterClass brings to you all these tricks and more under one umbrella.
  • Choosing the right Instructor is half-the learning done. 
    Our instructor Rishabh Pugalia is a Chartered Accountant. He has worked with KPMG (Auditor), G.H. Financials subsidiary (Interest Rates Futures Trader) and J.P. Morgan (Debt Capital Markets Analyst). He has taught 4000+ professionals at PwC & EY – two of the global Big Four firms. The experience itself is invaluable. He shares his experience on applying the learning in our #YodaLearning #ExcelMasterClass.
  • We don’t want your money. 
    We want you to grow fast. If you’re not satisfied with our learning material, please ask for a 100% refund within 30-days with just two mouse clicks. No questions asked.
All in One Excel Bundle to make you 4x Faster in Excel

Excel Masterclass Courses

Advanced Excel

🗸 Basics – Sort, Filter, Dates
🗸 Lookups (VLOOKUP, 2D, 3D)
🗸 Pivot Tables & Macros in-depth
🗸 Content Optimization

Read More

Excel VBA Macros

🗸 Excel forms and VBA code
🗸 Stages of Variable declaration in Excel
🗸 Automate tasks
🗸 Edit Files Using Excel

Read More

Excel Dashboard

🗸 Dashboard fundamentals
🗸 Sheet tracker – multiple sheets
🗸 Pivot table dashboard
🗸 Map chart dashboard

Read more

Financial Modeling

🗸 Timing Flags
🗸 Circularity Switch
🗸 Analysis or Corkscrew equation
🗸 Waterfall Structure

Read More

Course Preview Video

What do TOP Excel Bloggers think about my course…

Big Peoples Reviews

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

GET ACCESS TO THE
EXCEL MASTERCLASS COURSE

BUNDLE COURSE

ADVANCED EXCEL COURSE WITH 450 TECHNIQUES (48$ VALUE)

  • MODULE #1 NINJA SHORTCUTS (40 MINUTES)
  • MODULE #2 FORMULA WARM-UP (25 MINUTES)
  • MODULE #3 FORMATTING TRICKS (22 MINUTES)
  • MODULE #4 CELL REFERENCING ($) – RELATIVE & ABSOLUTE (7 MINUTES)
  • MODULE #5 GO TO – SPECIAL “MAGIC WAND” (17 MINUTES)
  • MODULE #6 SORT, FILTER & ADVANCED FILTER (45 MINUTES)
  • MODULE #7 WORKING WITH DATES (33 MINUTES)
  • MODULE #8 DATA (CELL INPUT) VALIDATION (16 MINUTES)
  • MODULE #9 SETTING UP WORK AREA VIEW (12 MINUTES)
  • MODULE #10 PIVOT TABLE (1 HOURS 13 MINUTES)
  • MODULE #11 LOOKUPS & CONDITIONAL CALCULATIONS (2 HOURS 18 MINUTES)
  • MODULE #12 DATA CLEANING / “SANITIZING” & TEXT FORMULAS (1 HOURS 14 MINUTES)
  • MODULE #13 LOGICAL FORMULAS – SINGLE & COMBO (19 MINUTES)
  • MODULE #14 CONDITIONAL FORMATTING (30 MINUTES)
  • MODULE #15 WHAT-IF ANALYSIS (51 MINUTES)
  • MODULE #16 SUBTOTAL & 3D DATA CONSOLIDATION (30 MINUTES)
  • MODULE #17 WORKBOOK & WORKSHEET SECURITY (18 MINUTES)
  • MODULE #18 PRINTING (13 MINUTES)
  • MODULE #19 MULTIPLE WINDOWS, COMMENTS, HYPERLINKING (15 MINUTES)
  • MODULE #20 EXCEL ARRAYS (ADDED ON 5TH JAN 2017) (48 MINUTES)

EXCEL VBA COURSE WITH 315 TECHNIQUES (48$ VALUE)

  • MODULE #1 MACRO BASICS AND DEVELOPER TAB – 18 MINS
  • MODULE #2 RECORD AND RUN MACROS – 20 MINS
  • MODULE #3 GOOGLE YOUR VBA CODES – 19 MINS
  • MODULE #4 OBJECTS, PROPERTIES, METHODS – 4 MINS
  • MODULE #5 WORKSPACE INTERFACE – 13 MINS
  • MODULE #6 RANGE & CELLS OBJECT – 26 MINS
  • MODULE #7 ABSOLUTE VS RELATIVE REFERENCE – 5 MINS
  • MODULE #8 RANGE NAVIGATION – 15 MINS
  • MODULE #9 VARIABLE DECLARATION – 20 MINS
  • MODULE #10 LOOPS – 52 MINS
  • MODULE #11 OPTIMIZING CODE EFFECIENCY – 8 MINS
  • MODULE #12 EVENT TRACKING – 37 MINS
  • MODULE #13 INPUT BOX – 23 MINS
  • MODULE #14 MSG BOX – 16 MINS
  • MODULE #15 ACTIVEX CONTROLS – 8 MINS
  • MODULE #16 USER FORMS – 74 MINS
  • MODULE #17 USER DEFINED FUNCTIONS – 17 MINS
  • MODULE #18 MIS PROJECTS – 40 MINS
  • MODULE #19 REAL LIFE PROJECT – 91 MINS

EXCEL DASHBOARD COURSE WITH 200 TECHNIQUES (48$ VALUE)

  • MODULE #1 SINGLE SHEET TRACKER – 35 MINS
  • MODULE #2 DASHBOARD FUNDAMENTALS – 160 MINS
  • MODULE #3 PIVOT TABLE DASHBOARD – 58 MINS
  • MODULE #4 MAP CHART DASHBOARD USING ADVANCED EXCEL FUNCTIONS – 117 MINS
  • MODULE #5 DYNAMIC DASHBOARDS USING EXCEL MACROS – 52 MINS

FINANCIAL MODELING BASICS 50 TECHNIQUE (48$ VALUE)

  • MODULE #1 FLAGS – TIMING & OPERATION – 13 MINS
  • MODULE #2 WATERFALL STRUCTURE – FUNDING – 19 MINS
  • MODULE #3 ITERATION & CIRCULARITY SWITCH – 15 MINS

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

400+ Course Lessons
$149
  • 400+ 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
  • 400+ 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 any 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.

How does it work?

The process is really smooth. After enrolling for the Course, you’ll get a link. With the given link you can register for the course. Enjoy lifetime access and support with the course. Watch the video courses 24×7 as per your interest.

how-it-works

Frequently Asked Question

Is this for me?

Doesn’t it frustrate you that you end up spending a lot of time on Analysis or Presentation-related activity because you don’t know better and faster way to complete the same?

I've been there

There’s nothing more frustrating than – Spending time on creating appealing presentation slides while you could be working on perfecting your speech or delivery. – Performing manual actions like data cleaning or formatting on excel which could be easily solved with combo formulas or VBA macros.

And to make matters even worse, you think what you know is enough and what I don’t know is implicitly considered irrelevant and useless from my point of view.

The fact you’re watching this video, means you know what it’s like to feel because nothing seems to work out the way you planned.

How much time required to complete Excel masterclass?

This is a self-paced, learn Excel masterclass program with videos from basics to advanced tutorials. Watch the preview of videos tutorials to get a flavor the program’s uniqueness and relevance. Online courses may not be your first preference. But I promise this – After watching 3 videos, this courses will give a tough fight to your usual classroom training.

What if I'm Unhappy with Excel masterclass course ? Do i get refund ?

Excel Masterclass library access comes with Unconditional 30 days money back guarantee. This means you can try courses for yourself and if you don’t agree that it adds value to your knowledge, then just send us an email to [email protected] and we’ll refund the amount. No Questions asked, no hoops to jump through and no hard feelings… So go ahead and click on the Enroll in Course button. To know more please read our Refund Policy. If you just want to get to know the flavor of the course, you click on any one of the tutorials

What do you get in Excel Masterclass Course

– All Advanced tutorials case studies related to videos.
– A picture based Excel PDF handbook on Excel Tips, Functions & Techniques.
– Access to all video tutorials 24 x 7 – learn excel online from anywhere.
– A 30-day money-back guarantee (we want you to be 100% satisfied with our Office Training)
– You will also get support for doubt and assistance to implement your learning in real-life challenges.