Overview
Microsoft Office Specialist (MOS) Excel 2010 Expert teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.
Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Excel 2010 Expert Exam #77-888.
Prerequisites
This course assumes that students have completed the Microsoft Excel 2010 Specialist 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
- Customizing Charts
- Using Sparklines
- Creating and Using Chart Templates
- Using Trendlines
- Using Custom Cell Formats
- Using Tables
- Using Dynamic Charts
- Lesson Summary
- Review Questions
- Working with Templates
- Using XML
- Workgroup Functions
- Protecting Your Workbook
- Lesson Summary
- Review Questions
- What are Functions?
- Using Math and Trigonometric Functions
- Using Statistical Functions
- Working with Financial Functions
- Using Logical Functions
- Using Date and Time Functions
- Using Text Functions
- Using Information Functions
- Converting Data Types
- Using Advanced Functions
- Auditing a Worksheet
- Lesson Summary
- Review Questions
- What-If Analysis
- Using the Goal Seek Tool
- Using the Solver
- Using a Data Table
- Working with Scenarios
- Analysis ToolPak
- Using Array Formulas
- Outlining
- Advanced Filtering
- Using PivotTables
- Using the Data Slicer with a PivotTable
- Using Slicers on External Data Connections
- Using Cube Functions
- Lesson Summary
- Review Questions
- Macros
- Adding Form Controls
- Data Validation
- Using Pick Lists
- Circling Invalid Data
- Removing Duplicate Rows
- Setting Advanced Excel Options
- Lesson Summary
- Review Questions
