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 in Excel
Paste Special in Excel
Some Special Features in Excel
Cell Referencing in Excel
Important Text Function in Excel
Basic Excel Formula & functions in Excel
Advanced Excel Formula & functions in Excel
Formula (Auditing) Checking in Excel
Data Protection in Excel
Merge multiple files in one click
Basic and advanced Pivot in Excel
Charts and Graphs in Excel
Slicer (advanced filter for presentation)
Shapes and Smart art in Excel
How to Prepare Dashboard in Excel
What if analysis in Excel
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 & MVP Microsoft, Excel having experience in Microsoft Excel for more than 16 years. I’m passionate about excel and providing training for over 9 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.