30-days Money-Back Guarantee
Learn advanced excel functions with video explanation and interview preparation
Updated on Sep, 2026
Office Productivity, Microsoft, Excel
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
This course has Solved Assignments on Basic plus advanced Excel topics. Mostly, it is advanced level questions solved on every topic.
If you are good in advanced Excel and want to gain more confidence and clear interviews or want to see how real situations confuse, you can join this course.
It will help you prepare for advanced Excel interviews.
Assignments are on Vlookup, Match, Index, SumIFs, CountIFs, Mid, Left, Right, substitute, Data validation, Indirect, Offset, conditional formatting, chart, and pivot level advance topics.
I conducted a surprise test for my live online students and giving you the same in this course. The lecture has a detailed discussion on how each student solved it and if correction is required, it is done and explained in the lecture for your benefit.
You should have a good knowledge of advanced Excel functions including basics.
Not meant for basic Excel users. It has difficult questions solved and one should know the basics and have a clear understanding of functions before taking this course.
Check out the detailed breakdown of what’s inside the course
I have been teaching online from 13 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.