Advance Excel Assignments Solved With Videos Explanation

• This course is strictly for intermediate and advanced Excel users. We are providing solutions to complex scenarios in Excel which will help you with data handling and analysis very well.

• If you are not an expert or use Excel very often, this course is not for you, This course expects a good knowledge of Excel functions from you.
• The course covers all Excel functions one by one starting from basic to advanced. It has assignments and solutions too for your help.
• INDEX, MATCH, VLOOKUP. HLOOKUP, IF, NESTED IFs, CONDITIONAL FORMATTING Amazing challenges, Difficult INDIRECT questions, versatile ADDRESS function, simple yet useful ROW, COLUMN functions, SUMIF, COUNTIF, WILD CHARACTERS, use, ADVANCE FILTER, OFFSET, CHARTS, PIVOTS – all such amazing functions and topics are covered in the form of assignments with solutions.
• It is not just a function but how we can solve the questions by writing more than one function in a single formula is what you are going to learn.
• Solutions provided for the above functions are mainly on advanced-level complex situations to train your mind harder and make you ready to face real-world challenges.
• By finishing this course, you will never face any difficulties in solving any difficult situation. Your mind will be more creative, and innovative and you will have more than one solution for every situation. You shall be able to clear any written Excel test from the moment you finish the course.

Goals

• 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.

Prerequisites

• 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.