MS Excel MasterClass

🥳 30% Instant Off on All MasterClasses! No Code Needed!Register Now

Contact Us
Contact us

Excel MasterClass

7+ Hours Hands-on MS Excel Training, 5+ Comprehensive WorkPapers, 3+ Practical Use Cases.

Become Industry Ready and Join Top Firms

For Just Rs. 1200 /-  Rs 799 /-

Register Now

Excel MasterClass

Become Industry Ready and Join Top Firms

7+ Hours Hands-on MS Excel Training

5+ Comprehensive WorkPapers

3+ Practical Use Cases

@ Just Rs. 799/-

Register Now

Key Highlights


7+ Hours Video Lectures

5+ Comprehensive Workpapers

3+ Practical Case Studies

MCQ Based Evaluation


Revision Booklet For Interview

Placement Assistance

Learning Aspects

EFFICIENT DATA MANAGEMENT

Master essential functions like Text to Column, Paste Special, and comprehensive data filtering techniques

DYNAMIC DATA ANALYSIS

Learn VLOOKUP, Pivot Tables, and Pareto Analysis to unveil insights from multi-dimensional data sets

VISUAL DATA REPRESENTATION MASTERY

Create impactful visualisations: Bar Graphs, Histogram Charts, Pie Charts, Line Diagrams. 

ADVANCED FUNCTIONS

Learn logical functions, Absolute and Relative Referencing, and the transformative Transpose function.

EXCEL IMPORTANT FORMULAS

Do complex Data Manipulations using: CONCATENATE, SUBTOTAL, SUMIF, COUNTIF, and the power of INDEX & MATCH. 

DATA OPTIMIZATION TECHNIQUES

Learn Conditional Formatting, Nested IF, Slicers, Data Validation, HLOOKUP, and XLOOKUP.

POWER TOOLS INTEGRATION

Introduction to Power Query and Power Pivot. Take your excel skills to new heights..

AUTOMATION & FORECASTING

Macros, Goal Seek, and Scrollers, & learn how to perform Present Value calculations for financial forecasting.

ERROR TRACING & DATA LINKING

Master the art of error detection and correction using Excel’s Tracing Dependents & Precedents feature.

Session Plan

Session 1 2 Hours

Dive into the world of built-in functions. Learn essential 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

Session 2 2 Hours

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.

Session 3 2 Hours

Learn Advance 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.

Certificate of Completion

A Certificate of Completion along with Mark-sheet based on the performance will be awarded to each candidate.

Who Should Join:

Fresher Chartered Accountants

Commerce Graduates

CA Aspirants & Semi Qualified CAs

ACCA Aspirants & ACCA Professionals

CS & CMA Aspirants

Anyone who wants to make a career in Finance

BRANDS

Where do our Alumni Work?

What participants say?



Bonuses worth ₹15000

7 Free Technical Sessions

Worth Rs. 3000/-

Live Communication Skills Training

Worth Rs. 3000/-

Mentorship From Industry Experts

Worth Rs. 4000/-

Lifetime Free Placement Assistance

Worth Rs. 5000/-

500+

Placements

30+

Recruiters

500+

Vacancies

TEACHERS

Our Experienced Faculty

Mentor

CA Sanat Goyal

Sanat is a qualified Chartered Accountant. He has multiple years of experience in dealing with various facets of Indian and International Tax issues. He has worked on various Transfer Pricing assignments including compliance, documentation, planning and business model/price structuring. He also has transfer pricing litigation expertise and has represented various complex transfer pricing matters before the tax authorities.

VIDEOS

Demo Sessions

Validity of the course

120 Days from the date of enrolment.


Join Our WhatsApp Community for Placement Updates & Important Resources

Get Updates for: Latest Job opportunities in Big 4s & Top Firms, Important Resources for Interview Preparation, Updates from the Finance World

Download
Thinking Bridge App

Thinking Bridge - Your Gateway To Top Firms

Follow Us on

Chat with us

Call us