MS Excel Professional Training
Description
Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel. Described as “fun” and “amazing” and “life changing,” This Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.
What Will I Learn?
- Good understanding of Excel at MIS level
- Expertise in Text Function
- Expertise in Logical Function
- Expertise in Math 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 organizing 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
Excel Fundamentals
Understanding Excel Structure00:08:15
Cell Properties00:02:46
Autofill Value and Text00:04:49
Autofill Date00:02:26
Autofill Custom Options00:04:40
Cell Reference Types00:04:29
Excel Quiz
Handling Equation and Math Functions
Text Functions and Tools
Excel Security and Sharing
Logical Functions
Pivot Table
What if Analysis Tools
Print Option in Excel
Chart Preparation in Excel
Conditional Formatting in Excel
Data Validation
Lookup and Reference Functions
Macro Recording
About the instructor
6 Courses
3883 students
Absolutely brilliant course as a starting point for procedures that can be used in Excel. So simple to understand the information being given, from the newcomer to Excel right up to the final sections.
Indeed the best.
This course explained Excel functions clearly and added to my ability to use Excel. It goes into great depth as well.
This is the most comprehensive course for MS Excel.