Overview
-
Demonstrate your advanced knowledge of Excel 2016 by becoming a Microsoft Office Specialist. This course helps you prepare for exam 77-727.
Syllabus
-
Introduction
- Welcome
- Who should take this course
- Using the exercise files
- Using the challenges
- Compare the different Microsoft Office Specialist certifications
- Prepare for the exam
- Exam format and registration process
- Create worksheets and workbooks
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Configure page setup and headers/footers
- Customize options and views for worksheets and workbooks
- Configure worksheets and workbooks for distribution
- Challenge: Create and manage workbooks and worksheets
- Solution: Create and manage workbooks and worksheets
- Insert data in cells and ranges
- Format cells and ranges
- Summarize data with conditional formatting
- Summarize and organize data
- Challenge: Manage data, cells, and ranges
- Solution: Manage data, cells, and ranges
- Create and manage tables
- Manage table styles and options
- Filter and sort a table
- Challenge: Create and manage tables
- Solution: Create and manage tables
- Summarize data by using functions
- Use conditional operation functions: IF and COUNTIF functions
- Use conditional operation functions: SUMIF and AVERAGEIF
- Format and modify text by using functions
- Combine text using functions and flash fill
- Challenge: Perform operations with formulas and functions
- Solution: Perform operations with formulas and functions
- Create charts
- Format charts
- Insert and format objects
- Challenge: Create charts and objects
- Solution: Create charts and objects
- Challenge: Full-length practice exam
- Solution: Full-length practice exam
- Next steps
