Learn how to prepare worksheets and workbooks for distribution. Jen McBee reviews the print options including how to set print scaling, how to repeat rows and column on each printed page, and how to Inspect a workbook for hidden properties and personal i
- [Instructor] It's important to understand how to…configure worksheets and workbooks for distribution.…Before you share your workbook, there are four…things that I'd like for you to consider.…Do you need to save the file in an alternative format…such as an earlier version of Excel or as a PDF document?…Have you reviewed and configured all of the print options,…most importantly making sure that if you need to…repeat row or column headings on each printed page…that the settings have been set up correctly.…Have you inspected the workbook for hidden properties…such as personal information and meta data?…Have you inspected the workbook…for any accessibility issues?…Do you have users who may be vision impaired and…therefore we need to go through our document…and put alternative text in the properties for each…of our objects in the worksheet?…In this video I'll show you how to answer all of these…questions and we'll focus on the settings and options…you may encounter on the Excel 2016 MOS exam.…
I have the 0206 exercise file open so let's prepare…
Author
Jennifer McBee
Released
12/25/2016The course begins with an overview of the certification program and how to prepare for the exam. Next, Jennifer walks you through all the certification objectives. Throughout the course, she provides you with opportunities for hands-on practice with exercises and chapter challenges, and wraps up with a full-length practice test that emulates exam 77-727.
- Recall the steps taken to change the margins of a worksheet.
- Explain how to repeat row and column headings when printing a document.
- Recognize three available options when merging cells.
- Identify the most effective way to filter and sort data in a table.
- Recognize the order of operations used when calculating data.
- Explain why a user might want to switch the row and column data in a chart.
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m
-
-
1. Microsoft Office Specialist Exam Overview
-
Prepare for the exam2m 33s
-
2. Create and Manage Workbooks and Worksheets
-
3. Manage Data Cells and Ranges
-
Format cells and ranges7m 51s
-
4. Create Tables
-
Create and manage tables4m 22s
-
Filter and sort a table6m 41s
-
-
5. Perform Operations with Formulas and Functions
-
6. Create Charts and Objects
-
Create charts4m 47s
-
Format charts5m 50s
-
Insert and format objects5m 22s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps19s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Configure worksheets and workbooks for distribution