[Lynda.com / Jennifer McBee] Cert Prep: Excel 2016 Microsoft Office Specialist (77-727) [2016, ENG] + Sub (Eng)

Содержание

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

Скриншоты