There are no items in your cart
Add More
Add More
Item Details | Price |
---|
Excel MasterClass
7+ Hours Hands-on MS Excel Training, 5+ Comprehensive WorkPapers, 10+ Practical Use Cases, Basic to Advance Excel Functions, Application on Real Data
Become Industry Ready in MS Excel and Join Top Firms
For Just
Rs. 3000 /-
Rs 999 /-
Become Industry Ready and Join Top Firms
7+ Hours Hands-on MS Excel Training
5+ Comprehensive MS Excel WorkPapers
3+ Practical Use Cases
@ Just Rs. 999/-
TEACHERS
Archit is a Chartered Accountant, an alumnus of Deloitte with 10+ years of experience. He’s the founder of Thinking Bridge and has trained 40000+ Leaners across finance domains. He is partner at a leading firm of New Delhi and has handled auditing and consulting assignments of Listed Companies, Top Banks and PSU’s across diverse industries. He’s a specialist trainer and advocates the importance of practical knowledge and skills.
Master essential functions in MS Excel like Text to Column, Paste Special, and comprehensive data filtering techniques
Learn VLOOKUP, Pivot Tables, and Pareto Analysis to unveil insights from multi-dimensional data sets in MS Excel
Create impactful visualisations in MS Excel: Bar Graphs, Histogram Charts, Pie Charts, Line Diagrams.
Learn MS Excel logical functions, Absolute and Relative Referencing, and the transformative Transpose function.
Do complex MS Excel Data Manipulations using: CONCATENATE, SUBTOTAL, SUMIF, COUNTIF, and the power of INDEX & MATCH.
Learn Conditional Formatting, Nested IF, Slicers, Data Validation, HLOOKUP, and XLOOKUP.
Introduction to Power Query and Power Pivot. Take your MS Excel skills to new heights.
Macros, Goal Seek, and Scrollers, & learn how to perform Present Value calculations for financial forecasting.
Master the art of error detection and correction using MS Excel’s Tracing Dependents & Precedents feature.
S.No |
Excel MasterClass - 7+
Hours
|
|||||||||
1 | 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 |
|||||||||
2 | 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. |
|||||||||
3 | 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. |
|||||||||
EXAM |
A Certificate of Completion along with Mark-sheet based on the performance will be awarded to each candidate.
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
120 Days from the date of enrolment.
Follow Us on