Overview
Microsoft Office Specialist (MOS) Excel 2013 teaches students how to use a variety of intermediate and advanced features to merge workbooks, perform data analysis, and audit formulas in spreadsheets. Students also use summary functions, create PivotTables and PivotCharts, and work with macros.
Students who complete this course will have reviewed all the exam objectives to prepare for: MOS Excel 2013 Expert Exams #77-427 and #77-428. Successful completion of the certification exam provides a competitive advantage by validating the knowledge and skill sets for individuals who may be seeking employment or further job opportunities in their careers.
Prerequisites
This course assumes that students have completed the Microsoft Excel 2013 Core course or have equivalent Excel knowledge and experience.
- Manage the worksheet environment
- Create cell data
- Format cells and worksheets
- Manage worksheets and workbooks
- Apply formulas and functions
- Present data visually
- Share worksheet data with other users
- Analyze and organize data
Course Outline
- Create Advanced Chart Elements
- Dual Axis Charts
- Using Chart Animation
- Custom Chart Templates
- Creating a Trendline
- Advanced Conditional Formatting
- Custom Conditional Formats
- Use Functions to Format Cells
- Manage Conditional Format Rules
- Checking for Formula Errors
- Using the Error Checking Tool
- Tracing Formula Errors
- Evaluate Formulas
- Manual Checking and Displaying Formulas
- Lesson Summary
- Review Questions
- Lookup Functions
- Transpose Function
- Date and Time Functions
- Create and Manage PivotTables
- Create New PivotTables
- Manipulate PivotTables
- Using a Data Slicer
- Group Data
- Calculated Fields
- Format Data
- Manage Relationships
- Using Power Pivot
- Lesson Summary
- Review Questions
- Advanced Filtering
- Advanced Filters
- Comparison Operators
- Workgroup Functions
- Create a Shared Workbook
- Resolving Shared Workbook Conflicts
- Tracking Changes
- Showing History of Changes
- Merging Workbooks
- Removing Shared Use of Workbooks
- Mark as Final
- Cell Comments
- Internationalization
- Modify Tab Order
- Display Data in International Formats
- Use International Symbols
- Accessibility
- Using Accessibility Tools
- Manage Multiple Options for Fonts
- Lesson Summary
- Review Questions
- Using Custom Cell Formats
- Custom Number Formats
- Custom Currency and Accounting Formats
- Custom Date and Time Formats
- Custom Scientific Formats
- Custom Text Formats
- Advanced Format Filling
- User Defined Styles
- Custom Color Formats
- Custom Cell Styles
- What-If Analysis
- Manual What-If
- Using the Goal Seek Tool
- Using the Solver
- Working with Scenarios
- Lesson Summary
- Review Questions
- Create and Manage Pivot Charts
- Create a PivotChart
- Manipulate PivotCharts
- Apply styles to PivotCharts
- Financial Functions
- AND/OR Functions
- Nesting Functions
- Conditional Summary Functions
- Consolidating Data
- Lesson Summary
- Review Questions
- Working with Templates
- Creating a Template
- Modifying Templates
- Copy Styles from Template to Template
- Deleting Templates Protecting Your Workbook
- Using Passwords
- Protecting the Worksheet
- Allow Ranges for Editing
- Protecting Worksheet Structure
- Protecting Workbook Files
- Linking External Data
- Copy Macros from Workbook to Workbook
- Removing Workbook Metadata
- Using Workspaces
- Setting Advanced Excel Options
- Lesson Summary
- Review Questions
