Printing spreadsheets in Excel 365
Excel Microsoft 365 (2021)
| Beginner
- 6 videos | 25m 15s
- Includes Assessment
- Earns a Badge
- CPE
Excel 365 offers an array of tools for making printouts of your spreadsheet data. In this course, you will learn how to add headers and footers to the pages in a spreadsheet if you would like to include additional information. And you will learn how to set your print area, adjust your print page layout, configure the print settings, and print your spreadsheets in Excel 365. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this Microsoft 365: Printing spreadsheets in Excel 365 course
insert headers and footers in Excel 365
set a print area in Excel 365 -
adjust the print page layout in Excel 365
configure print settings in Excel 365
print a spreadsheet in Excel 365
IN THIS COURSE
-
50sThis video outlines the key content covered in the Microsoft 365: Printing spreadsheets in Excel 365 course, including how to set the print area, adjust the print page layout, and how to configure the print settings. FREE ACCESS
-
4m 54sYou can use headers and footers in Excel 365 to insert additional information in your spreadsheets – such as its author, the date it was printed, or its total number of pages. Headers and footers appear at the top and bottom of each page in a worksheet and are managed independently of any cells. In this video, you will learn how to insert headers and footers in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.3.3 Customize headers and footers. FREE ACCESS
-
3. Setting a print area4m 13sBefore printing a spreadsheet, it is important to check how the pages are laid out to ensure they will fit within the print area. Excel 365 features a special view mode, Page Break Preview, which is very useful for visualizing the exact layout of a worksheet. In this video, you will explore how to set the print area for a cell range. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.5.1 Set a print area. FREE ACCESS
-
4. Adjusting the print page layout4m 6sBefore printing a spreadsheet in Excel 365, it is advisable to ensure it is properly laid out. In this video, you will explore how to choose the paper print format, select the margin size, and set the page orientation. You will also learn how to select additional formatting elements to be printed. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.3.1 Modify page setup. FREE ACCESS
-
5. Configuring print settings5m 35sIf an Excel 365 spreadsheet includes headers and footers or customizations such as extra narrow margins, you can configure how these and other settings will print. In this video, you will explore how to configure print settings using the Page Setup tool in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.5.3 Configure print settings. FREE ACCESS
-
6. Printing your spreadsheet5m 37sWhen it comes to printing a spreadsheet, Excel 365 gives you control over a large number of settings and variables. In this video, you will discover how to specify how many copies you want to print out, which pages to print, and how to set the paper format used by a printer. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
