2016
3 hours
00 – Introduction
Welcome
Who should take this course
Using the exercise files
Using the challenges
01 – Microsoft Office Specialist Exam Ocerview
Compare the different Microsoft Office Specialist certifications
Prepare for the exam
Exam format and registration process
02 – 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
03 – 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
04 – 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
05 – 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
06 – Create Charts and Objects
Create charts
Format charts
Insert and format objects
Challenge: Create charts and objects
Solution: Create charts and objects
07 – Final Practice Exam
Challenge: Full-length practice exam
Solution: Full-length practice exam
08 – Conclusion
Next steps
Exercise Files