Course Description
This course encompasses both core and advanced skills in Microsoft Excel and will prepare students to take the Microsoft Office Specialist (MOS) test, if desired. MOS certification is the leading IT certification in the world. MOS enables students to become experts in the software by utilizing the full features and functionality of the Microsoft Office system. Many colleges are accepting the certification in lieu of taking a college level course.
Concepts Covered Include:
Module 1-Creating a Worksheet and a Chart
Module 2-Formulas, Functions, and Formatting
Module 3-Working with Large Worksheets, Charting, and What-If Analysis
Module 4-Financial Functions, Data Tables, and Amortization Schedules
Module 5-Working with Multiple Worksheets and Workbooks
Module 6-Creating, Sorting, and Querying a Table
Module 7-Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots
Module 8-Working with Trendlines, PivotTable Reports, PivotChart Reports, and Slicers
Module 9-Formula Auditing, Data Validation, and Complex Problem Solving
Module 10-Data Analysis with Power Tools and Creating Macros
Module 11-User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features