Learn Basic to Advance Excel from Scratch - Master Course
What you'll learn
- Hands on all Basic to Advance shortcuts required in Ms Excel
- All Advance Functions like Lookup Functions, If related all functions, Time Value of Money Functions, Data Analysis Functions etc.
- All kind of Charts like Tree Chart, Columunar Chart, Sparkling Charts, Bar Chart, Bridge Chart etc.
- All functionalities related to Goal Seek, Ranking Sensitivity Analysis, Pivot Tables, Loan Schedule etc.
- All functionalities related to Errors, Text, Basic & Advance Formatting, Filtering, Sorting etc.
Requirements
- You need a Laptop with MS Excel, PDF Viewer and a Good Internet Connection
- Second and the foremost thing you need is : "YOUR WILL to practice along side the class"
Description
This is a 100 % practical course specially designed for Finance Professionals, Beginners, School Students, MBA Professionals, Graduate Students to master the art of MS Excel. In this course, almost all necessary tools, functions, commands are included which will make you a real professional. After learning this course students shall be able to work in excel at a lighting speed. This course will enhance your speed, office productivity and will add skill to your professional life.
This course includes the following functions: 1) Basics of Excel 2) Home Tab Function 3) Mathematical operators 4) Lookup Functions 5) Time Value of Money Functions 6) Date Functions 7) Text Functions 8) Logical Functions 9) Error Functions 10) Basic Formatting 11) Advance level formatting 12) Goal Seek Function 13) Ranking & Sensitivity Analysis etc.
This is a 100 % practica course specially designed for Finance Professionals, Beginners, School Students, MBA Professionals, Graduate Students to master the art of MS Excel. In this course, almost all necessary tools, functions, commands are included which will make you a real professional. After learning this course students shall be able to work in excel at a lighting speed. This course will enhance your speed, office productivity and will add skill to your professional life.
This course includes the following functions: 1) Basics of Excel 2) Home Tab Function 3) Mathematical operators 4) Lookup Functions 5) Time Value of Money Functions 6) Date Functions 7) Text Functions 8) Logical Functions 9) Error Functions 10) Basic Formatting 11) Advance level formatting 12) Goal Seek Function 13) Ranking & Sensitivity Analysis etc.
Who this course is for:
- For freshers who have started their career and earnings
- For Finance and Business Executives
- For MBA Finance Students
- For Graduate Students
- For Chartered Accountants, Company Secretaries etc.
- For School Students of Class 6 + to College Goers under their parent guidance
- Any individual who want to learn excel from scratch
Instructor
- 4.3 Instructor Rating
- 31 Reviews
- 150 Students
- 5 Courses
CA Pankaj Chhabra, being one of the youngest Chartered Accountants of India and graduated from Delhi University at the young age of 21 years, is Technical Analyst & Professional Trainer. He has Vast and Dynamic experience of more than 6 years in the field of Wealth Management, International Taxation, and Statutory Audit.
Currently, he is one of the Co-founders of the DFM Institute and acting as Professional Trainer. He has more than 10000 Training hours experience right from his school time, as teaching & guidance being his passion always. He has already trained more than 5000 Students & Professionals to date. He has more than 7000 Followers on LinkedIn as of now.
He has been Guest Speaker at various colleges of Delhi University like Shri Ram College of Commerce (SRCC), Hansraj College, Daulat Ram College, Maharaja Agrasen College, Bharti College, Jesus & Marry College, GLA University -Mathura, Chitkara University - Punjab, etc and successfully delivered his insights on Equity & Currency Derivatives, Basics of Stock Market, Mutual Funds Analysis, Fundamental Analysis of Stocks & Sectors, Identification of Multibaggers, etc.
He has successfully conducted many Mock Stock Trading Events in various colleges of Delhi University and DFM Institute as well where Students from various communities like Delhi University / CA / CFA / CS / CWA / ACCA do participate.
He is also acting as Senior Business Development Manager at Fincare Shares & Stock Broking Private Limited and Motilal Oswal Securities Limited, Kohan Enclave – Delhi Branch.
CA Pankaj Chhabra