Excel Interview Preparation in 1.3 Hrs.

Excel Interview Questions you need to get Right

This Course includes:

  • 1.3 of Pre-recorded Hindi video
  • 14 HD Videos
  • Excel Mastery eBooks
  • Practice files
  • Certificate of completion
  • Get 6 Month Access
  • No Refund
Enroll Now
LEARN MORE

Who this course is for:

Every professional who:
  • This course is for students and professionals, who are expecting questions on Excel in an Interview. This will also allow you to add these topics under the Excel Skills section of your Resume.
  • This is also an excellent brush-up course for existing Excel users.

What will you learn?

  • Essential Formulas: VLOOKUP, SUMIF, COUNTIF, SUM, AVERAGE, COUNTA, SUBTOTAL, HLOOKUP & many more.
  • Data Analysis: Pivot Table, Filter, Conditional Formatting
  • Data Cleaning: FlashFill, Text to Columns, CONCATENATE, Go To Special
  • Bonus Tricks: Fuzzy Lookup, Using $ with F4

Course Narrator

Rishabh Pugalia

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

Course Curriculum

Excel Interview Questions you need to get Right

01
Best Excel Tricks
12 Lessons
Using AI for Data Cleaning with FlashFill (Excel 2013+)
Top 10 Excel Formulas & Techniques for Interview
Top 10 Pivot Table Tips & Tricks for Beginners
Course Feedback
Don't do this when applying Filter
Top calculation blunder made by Filter users
SUBTOTAL function - Biggest mystery solved
Cell Referencing - Simplified (A1 vs $A$1 vs A$1 vs $A1)
Fill Intermittent blank cells without copy - paste
Vlookup vs. Hlookup - Simplified
Fuzzy Lookup can do what VLOOKUP can't
Review Course feedback
02
Excel Interview Preparation
2 Lessons
How to clear Basic Excel Interview
How to clear Intermediate Excel Interview
03
Free Excel eBook
140+ Excel Super Shortcuts for Windows & Mac (20 pages)
Download Excel Shortcuts PDF

6-Month Access

₹ 99 6-Month Access
  • 1.3 of Pre-recorded Hindi video
  • 14 HD Videos
  • Excel Mastery eBooks
  • Practice files
  • Certificate of completion
  • No Refund
ENROLL NOW
Get started now!
"I am an accountant at CA Firm. And I was faced lot of problems daily in calculations and interpretations the data. Now I do my all excel work easily. When first time i was saw the YouTube video of you (Excel superstar), I realized that you are amazing teacher sir and no one is comparable with you. And your style and the way of teaching the concepts is very unique and pure. You don't have any illogical reasons but your all reasons are fully logical behind the every excel formula. I feel proud of myself that I have teacher like you and I am student of you sir."
Jitanshu Masih
Student