From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Configure page setup and headers/footers
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Configure page setup and headers/footers
- [Instructor] You'll probably see quite a few questions on the MOS exam regarding formatting and configuring your worksheets and workbooks. In this video we're going to review how to set up worksheet margins and take it a step further. We're going to learn how we can change the header and footer margins. We'll also look at worksheet orientation, changing it from portrait to landscape and vice versa, and also how to insert headers and footers. I have the 02_04 exercise file open, so let's get started. First let's look at what's available under the page layout tab for page setup. Here's our page setup group. Starting on the left-hand side we have margins: normal, wide, narrow, and then of course we can set up our own custom margins. On the exam you may have a task as simple as change the margins of a worksheet to wide, and this is all you need to do is come here and choose wide. Orientation we can change it from portrait to landscape, and the other item that we'll look at is on the…
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
-
-
-
-
-
-
-