YoVDO

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

Offered By: LinkedIn Learning

Tags

Microsoft Certification Courses Microsoft Excel Courses Data Summarization Courses Data Management Courses

Course Description

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
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

Taught by

Jennifer McBee

Related Courses

Introduction to Statistics: Descriptive Statistics
University of California, Berkeley via edX
Statistical Reasoning for Public Health 1: Estimation, Inference, & Interpretation
Johns Hopkins University via Coursera
Excel Skills for Business: Intermediate I
Macquarie University via Coursera
Introduction to Statistics for Data Science
SAP Learning
Complex Retrieval Queries in MySQL Workbench
Coursera Project Network via Coursera