What you'll learn
- This Microsoft Excel course will make you from beginner to master of Excel including macro.
Requirements
- Microsoft Excel 2007 - 2019 or Office 365 (Some features may not be available in older versions)
Description
This course will provide you everything you need to know about Microsoft Excel.
You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Chartered Accountant having 12+ year of experience, this course provides comprehensive coverage on Microsoft Excel. .
In only nine hours of videos, provided to you in 99 separate video lectures so that no one video is too long, you will learn all of the following about Microsoft Excel:
Basic Formatting & Editing
Paste Special
Some Special Features
Cell Referencing in Excel
Text Function
Basic Excel Formula & functions
Advanced Excel Formula & functions
Formula (Auditing) Checking in Excel
Data Protection in Excel
Merge multiple files in one click
Basic and advanced Pivot
Charts and Graphs in Excel
Slicer (advanced filter for presentation)
Shapes and Smart art
How to Prepare Dashboard
What if analysis
Important Shortcuts in Excel
Macro for Non Technical People
Macro - How to record
Macro - How to create button to run
Macro - Editing and Debugging
Macro - Relative reference
Apart from above, we will be learning lots of other features during this entire course.
Who this course is for:
- People who want to learn Excel in Hindi from Basic to Advanced including Macro without coding.
Instructor
I’m Chartered Accountant by Profession having experience in Microsoft Excel for more than 12 years. I’m passionate about excel and providing training for over 5 years. I have conducted lots of excel training from beginners to advanced levels including automation using macro in different corporations and in various professional forums. My primary area of work is automation in excel and I have created lots of automation tools solving various problems of different type of industries. My training language will be Hindi.