30-days Money-Back Guarantee
Learn advanced filters, conditional formatting, Data Validation, CountIFs, SumIFs, Offset, Charts, Form Controls, and Arrays.
Updated on Sep, 2026
Office Productivity, Microsoft, Excel
Duration - 34.5 hours
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
After finishing this course, you will never look back. You will never need any trainer to learn more. I have created this course for you keeping fundamentals, interview preparation, and most importantly practical real-life scenarios.
Theory can help us in understanding the subject but practical's make you PRO. This course has a lot to give you in terms of real-life-based challenges.
You will be able to implement everything in your office work or personal work after finishing the course. Pls do not skip any lecture as each of the sessions and sections are in a sequence and they are my live classroom recordings so your doubts too will get answered here automatically.
You shall be able to mix the formulas and create any complex formula and should be able to create dashboards too.
You need to install Excel application( Excel 2010 or above) and no prior knowledge is required. It has started from zero level and gradually turning into advance level.
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.