From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Prepare for the exam
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Prepare for the exam
- [Instructor] Let's talk about how to prepare for the MOS exam. First, what to study. We've inserted into your chapter 1 file folder a list of objectives for the Excel 2016 MOS Exam. Let's go ahead and take a look at that document. Here is a list of the Excel 2016 objectives for the MOS exam. The numbers listed for each objective correspond to the numbers in this video series. So for example, starting with chapter two, Create and Manage Workbooks and Worksheets, you'll have a chance to view videos where you will practice importing data from a delimited file, adding worksheets and copying data between worksheets, navigating worksheets using named ranges and hyperlinks, formatting worksheets and workbooks by adjusting column width and row heights, changing worksheet tab colors, and changing the worksheet order. You'll also practice working with the options under Page Setup, inserting headers and footers, adding commands to the quick access toolbar, and preparing workbooks for…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.