Microsoft Excel Training – Beginner to Expert Level in Hindi
Description
This is an Excel training program with an effort to put live practicals experience in the form of videos. This course will taught you thoroughly on how to manage important tools in Excel and how to apply various functions with nested methodology. it is advisable that you must follow the structure pattern for better understanding.
What can be expected?
At the end of the course you will be able to handle data in excel, also will be able to apply text, logical, math, lookup & reference functions very easily. you will find it easy to manage organizing tools in Excel like charts, pivot table etc.
What Will I Learn?
- Managing data in Excel
- Good understanding of Excel at MIS level
- Expertise in Text Function
- Expertise in Logical Function
- Expertise in Lookup and Reference Function
- Expertise in Date and Time Function
- Mastery in Pivot Table and Chart Preparation
- Mastery in 'What if Analysis' tools
- Print Option in Excel
- Data Validation, Filter and Conditional Formatting
- Mastery in Data organising Tools in Excel
- Mastery in Data creation and Data Manipulation in Excel
- Managing data protection and data sharing in Excel
- Work with Macro Recording
Topics for this course
36 Lessons08h 37m 07s
Excel Fundamentals
Understanding Excel Structure00:17:41
Cell Properties, AutoFill and Cell Reference Types00:18:17
Handling Equation and Math Functions
Text Functions, Nesting Methodology and Tools
Logical Functions
Pivot Table
What if Analysis Tools
Print Option in Excel
Define Name and Hyperlink
Filter and Conditional Formatting
Excel Security and Sharing
Date and Time Management in Excel
Chart Preparation and Data Validation
Lookup and Reference Functions
About the instructor
6 Courses
3883 students