Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Introduction

• Welcome
• Who should take this course
• Using the exercise files
• Using the challenges

1. Microsoft Office Specialist Exam Overview

• Compare the different Microsoft Office Specialist certifications
• Prepare for the exam
• Exam format and registration process

2. Create and Manage Workbooks and Worksheets

• 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

3. Manage Data Cells and Ranges

• 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

4. Create Tables

• Create and manage tables
• Manage table styles and options
• Filter and sort a table
• Challenge: Create and manage tables
• Solution: Create and manage tables

5. Perform Operations with Formulas and Functions

• 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

6. Create Charts and Objects

• Create charts
• Format charts
• Insert and format objects
• Challenge: Create charts and objects
• Solution: Create charts and objects

7. Final Practice Exam

• Challenge: Full-length practice exam
• Solution: Full-length practice exam

Conclusion

• Next steps