Certification Course MS-Excel MasterClass by CA Archit Agarwal

Session Plan

Dive into the world of built-in MS Excel functions.
Learn essential MS Excel skills including Importing text file to excel, text to column function, basic navigation & formatting, Paste Special commands,
Absolute referencing, relative referencing, logical functions, Filtering & use cases, Linking, Tracing Dependents & Precedents, Transpose function

Learn range of tools including Move and Copy, Duplicate Values, Concatenate, VLOOKUP, and Pivot Tables for multi-dimensional analysis, Pareto Analysis.
Create various charts such as bar graphs, histograms, pie charts, Line Diagrams, 2 Variable Charts etc.

Learn Advance MS Excel features like: PV calculation, Goal Seek, Scrollers, Macros,
Power Query, Power Pivot, Subtotal, Sum if, Count if, Index & Match function
Hlookup, Xlookup, Data validation, Conditional Formatting, Nested If, Slicers etc.

Create dynamic excel dashboard & learn visualisation
MIS Dashboard using Bar chart, Histogram, Line Diagram, Pie Chart
Use Slicers for dashboard automation

Converting Raw Data to Excel using Chat GPT and AI, Data Structuring and Cleaning using AI, Variance and Ratio Analysis using AI
Creating MIS Reports through AI, Understand Complex Formulas with AI
Combining Multiple Sheets using Power Query and AI, Using Power Bi to automate work and Pull Data from Web
Creating Macros and Custom Formulas through AI and Embedding them Permanently for Automation

MCQs Based Exam Online - Practical Exam based on Course Module

Meet Your Instructor

CA Archit Agarwal

Archit is a former Deloitte professional with 10+ years of experience, founder Thinking Bridge and who has trained over 60,000+ learners in finance domains like Statutory Audit. As a partner at a leading New Delhi firm, he has led audits and consulting for listed companies, top banks, and PSUs. A specialist trainer in Statutory Audit. As a partner at a leading New Delhi firm, he has led audits and consulting for listed companies, top banks, and PSUs. A specialist trainer in Statutory Audit.