In this course, you will learn about some of the more advanced features of Excel, including automating worksheet functions, auditing workbooks to avoid errors, sharing your data with other people, importing and exporting data, analyzing data, working with multiple workbooks, and using Excel data in other applications.
This course is intended for a delegate who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets.
This course prepares you for the Microsoft Office Specialist (MOS) Certification Exam.
Before starting this course, delegates are recommended to take the following PTR courses or have equivalent knowledge: Microsoft Office Excel 2013: Level 1 and Microsoft Office Excel 2013: Level 2.
Update Workbook Properties
Create and Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak