Printing spreadsheets in Excel 365

Excel    |    Beginner
  • 6 videos | 25m 15s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 1014 users Rating 4.6 of 1014 users (1014)
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 Course Contents pane or 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

  • 50s
    This 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 54s
    You 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
  • Locked
    3.  Setting a print area
    4m 13s
    Before 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
  • Locked
    4.  Adjusting the print page layout
    4m 6s
    Before 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
  • Locked
    5.  Configuring print settings
    5m 35s
    If 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
  • Locked
    6.  Printing your spreadsheet
    5m 37s
    When 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.

YOU MIGHT ALSO LIKE

Rating 4.1 of 14 users Rating 4.1 of 14 users (14)
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)
Rating 4.5 of 475 users Rating 4.5 of 475 users (475)
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)