From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Configure worksheets and workbooks for distribution
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Configure worksheets and workbooks for distribution
- [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…
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.
Contents
-
-
-
-
Create worksheets and workbooks7m 12s
-
(Locked)
Navigate in worksheets and workbooks6m 8s
-
(Locked)
Format worksheets and workbooks5m 46s
-
(Locked)
Configure page setup and headers/footers5m 23s
-
(Locked)
Customize options and views for worksheets and workbooks7m 3s
-
(Locked)
Configure worksheets and workbooks for distribution7m 10s
-
(Locked)
Challenge: Create and manage workbooks and worksheets1m 56s
-
(Locked)
Solution: Create and manage workbooks and worksheets8m 46s
-
-
-
-
-
-
-