In Excel and MS Office
MS Excel: Zero to Hero Course (एमएस एक्सेल: शून्य से हीरो कोर्स)
Advanced- Hinglish
- 43 Learners
- Validity: 2 years
-Course Highlights
- 16 videos
- 15+ Hours of Content
- 14+ downloadable materials
Introduction
To master Microsoft Excel is an inevitable skill one needs especially if you're or want to work in the field of Accounting & Finance, not only in India but anywhere in the world.
Learn from a Chartered Accountant & Corporate Banker putting his decade of experience in this course to guide you step by step in Hinglish (English + Hindi) through the beginner to advanced level and beyond.
As you participate in this course you will not only master Excel tools but also build a solid foundation for financial modeling and valuation.
At the completion of this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace.
Enroll now and take the next step in mastering Excel and become the Excel champ at your workplace!
About the Trainer
0 Learners 0 reviews
Kuldeep is a Chartered Accountant by qualification. He is experienced in the field of project financing and financial analysis for over 8 years. He has been a Corporate Banker managing an asset portfolio of over INR 3 Billion to his credit. He also mentors on Financial Modelling & Valuation, Project Financing, Financial Statement Analysis, Corporate Finance and MS Excel.
What Will You Learn?
- Master Microsoft Excel from Beginner to Advanced
- Learn the most common Excel functions used in the Office
- Automate your day to day Excel tasks by mastering the power of Macros and VBA
- Wild Card Characters in Excel no one talks about
- Create dynamic report with Excel Pivot Tables
- Problem-solving using Solver & What-if Analysis
- Wow your Boss with Dynamic Charts
- Make data DISAPPEAR but still use it for Calculations (Pro Hack)
- Access to a Finance Professional with 10+ years of experience in Excel
Topics Covered
Below are just a few of the topics that you will master:
- Creating effective spreadsheets
- Managing large sets of data
- Formatting data like never before
- Make data DISAPPEAR but still use it for Calculations (Pro Hack)
- The Art of Printing excel sheets
- Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, SUBTOTAL, and many more...)
- Importing Data from various sources including the internet
- Create dynamic report with Excel Pivot Tables
- Getting over the dreadful Custom Cell formats
- Wild Card Characters in Excel no one talks about.
- Conducting What-if Analysis
- Problem-solving using Solver
- Automate your day to day Excel tasks by mastering the power of Macros and VBA
- Creating Dynamic Charts
Intended Participants
- Commerce graduates
- Chartered Accountants
- Company Secretary
- Cost Accountant
- MBA
- Anyone willing to make a career in Finance & Accounting
- This course is the stepping stone for you if you're willing to take up Financial Modelling & Valuation.
Get Certified
Enhance your career prospects with a Elearnmarkets certification!
No preview video is available at this moment
Procedure:
The student has to appear for an examination hosted on the website itself under “Test section >> Certification Test”
Note: The certification test can be appeared by the candidate only once.
In case of any further assistance, drop in an email to support@kredentacademy.com or call: 90516222555
Other Details:
Duration: 1 hour.
Pattern of questions: 35 multiple choice based question of 2 marks each.
Qualifying marks: 50%
