The Intermediate Microsoft Excel 2013 training is a one-day class that is designed for students who have basic knowledge of Excel yet want to advance their skill set by learning the skill set of working with advanced formulas, lists, and illustrations. This intermediate course will make students work with charts and advanced formatting including styles. This course will prepare students to appear for the MOS: Microsoft Office Excel 2013 certification exam 420.
Completion of the course equips the participants with the following skill set:
Module 1: Advanced Formulas
In this module, participants learn how to work with advanced formulas in Excel.
Lessons
Module 2: Work with Lists
In this module, participants learn how to work with lists in Microsoft Excel 2013.
Lessons
Module 3: Work with Illustrations
In this module, participants learn how to add illustrations to Microsoft Excel worksheets to improve their look and feel, and also to illustrate your points.
Lessons
Module 4: Visualize Your Data
In this module, participants learn how to use techniques for visualizing your data.
Lessons
Module 5: Work with Tables
In this module participants learn how working with tables in Excel 2013 can help organize data.
Lessons
Module 6: Advanced Formatting
In this module, participants learn how to use advanced formatting techniques in Excel 2013.
Lessons
Module 7: Microsoft Excel 2013 New Features
In this module, participants learn about a number of new features in Excel 2013 to help make work with worksheets easier and more efficient.
Lessons
This course is beneficial for students who have little or no familiarity with Microsoft Excel 2013 or more experienced Excel users who are interested in learning intermediate level of skills covered in this course on the 2013 interface.
Before attending this course, a candidate must have/be:
Name | Code | Fee |
---|
OR