Course Content
Excel 2016 - Introduction and Basics
The Excel 2016 - Introduction & Basics course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to open workbooks, navigate directly to cells and between worksheets. You will also create new workbooks, use viewing tools, modify Excel options. Inspect Documents and check for Accessibility and Compatibility issues.
The estimated time to complete this course is 2 hours and 17 minutes.
Excel 2016 - Cells and Worksheets
The Excel 2016 - Cells and Worksheets course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn cell selection techniques, how to move and copy data, add and remove cells. You will also search and sort data, format cells and work with multiple worksheets.
The estimated time to complete this course is 2 hours and 16 minutes.
Excel 2016 - Views and Layout
The Excel 2016 - Views and Layout course covers topics included in the Microsoft Office Specialist (MOS) exam. You will learn how to use Excel views, and import and export files. You will also insert hyperlinks, add workbook properties, add headers, use Page Setup and the Print Place.
The estimated time to complete this course is 3 hours and 0 minutes.
Excel 2016 - Sharing and Validating Data
The Excel 2016 - Sharing and Validating Data course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to add comments and share workbooks. You will also sort data and apply filters, use custom and conditional formats as well as validate data.
The estimated time to complete this course is 2 hours and 7 minutes.
Excel 2016 - Formatting and Proofing
The Excel 2016 - Formatting and Proofing course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will use AutoFill and Paste options, modify and group worksheets, apply styles and format worksheets. You will also use proofing tools, Flash Fill and record macros.
The estimated time to complete this course is 3 hours and 14 minutes.
Excel 2016 - Formulas and Functions
The Excel 2016 - Formulas and Functions course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to use formulas and functions in Excel including Informational, Logical, Financial, Text functions, data tables and using named ranges.
The estimated time to complete this course is 3 hours and 12 minutes.
Excel 2016 - Presenting Data Visually
The Excel 2016 - Presenting Data Visually course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will create charts, move charts and add illustrations using Pictures, WordArt, SmartArt, and ClipArt. You will also learn how to add Alternative text, Shapes and Sparklines and use Outlining tools.
The estimated time to complete this course is 2 hours and 11 minutes.
