5.00(4)

MS Excel Professional Training

  • Course level: All Levels

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

74 Lessons6h 57m 34s

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

5.00 (45 ratings)

6 Courses

3883 students

Student Feedback

5.0

Total 4 Ratings

5
4 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating

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.

1,299.00 119.00

Material Includes

  • 7 Hours of video Training
  • Q & A Quizes
  • Practice Files

Requirements

  • Computer with MS Office installed