Viewing & printing worksheets in Excel 365 (2023)

IN THIS COURSE

• 1.  Overview: Viewing & printing worksheets in Excel 365 (2023)
  1m
  This video outlines the key content covered in the Viewing & printing worksheets in Excel 365 course, including Viewing multiple windows, Freezing panes and Configuring your print job in Excel 365. FREE ACCESS
• 2.  Resizing rows & columns in Excel 365
  5m 14s
  Changing the row height and column width can enhance your column's aesthetics and readability. In this tutorial, you will see how to manually adjust row height and column width, as well as how to use the AutoFit feature. This video aligns with MO-210 Microsoft Excel Exam objective: Adjust row height and column width. FREE ACCESS
• 3.  Viewing multiple windows in Excel 365
  3m 55s
  When you are working with a large spreadsheet, it can be helpful to view the same workbook in multiple windows. In this tutorial, you will see how to create and work with multiple windows at the same time. This video aligns with MO-210 Microsoft Excel Exam objective: Change window views. FREE ACCESS
• 4.  Freezing panes & splitting worksheets in Excel 365
  4m 49s
  Scrolling through large worksheets can be tedious, but the Freeze Panes and Split tools can make it easier. In this video, you will see how to freeze panes to lock headers and other rows or columns in place as you scroll. You will also see how to split your worksheet into multiple scrollable areas. This video aligns with MO-210 Microsoft Excel Exam objectives: Freeze worksheet rows and columns, and Change window views. FREE ACCESS
• 5.  Changing the workbook view in Excel 365
  4m 51s
  In Excel, you can choose from multiple views to help you visualize and edit your data in the most efficient way possible. In this video, you will see how to activate Full-Screen Mode to maximize your workspace. You will also see how to use Page Layout View and Page Break Preview to help you optimize your worksheet for printing as well as how to save a custom view. This video aligns with MO-210 Microsoft Excel Exam objective: Display and modify workbook content in different views. FREE ACCESS
• 6.  Adjusting the print page layout in Excel 365
  4m 36s
  Before printing a worksheet, you will want to make sure it is laid out according to your needs. In this video, you will explore how to adjust various aspects of page layout, including margins, orientation, and paper size. This video aligns with MO-210 Microsoft Excel Exam objective: Modify page setup. FREE ACCESS
• 7.  Setting a print area in Excel 365
  4m 30s
  When you work with large worksheets, you may only want to print a specific area. In Excel, you can easily set and adjust the print area. You can also use the Page Break View to visualize the print area. See how in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Set a print area. FREE ACCESS
• 8.  Configuring layout for multiple pages in Excel 365
  4m 4s
  In Excel, you can split a large spreadsheet across multiple pages. In this tutorial, you will find out how to split the print area across pages, insert and adjust page breaks, and set print titles. This video aligns with MO-210 Microsoft Excel Exam objective: Set a print area. FREE ACCESS
• 9.  Inserting headers & footers in Excel 365
  4m 47s
  You can use headers and footers to display the author, date, or other information in your printed spreadsheet. In this video, you will see how to add headers and footers using Excel's built-in formats. This video aligns with MO-210 Microsoft Excel Exam objective: Customize headers and footers. FREE ACCESS
• 10.  Customizing headers & footers in Excel 365
  3m 49s
  Excel provides a number of options for customizing headers and footers. You can group worksheets to apply headers or footers to multiple sheets at once. You can also use the Page Setup dialog box to access options for personalizing headers and footers, including formatting font and images. Find out more in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Customize headers and footers. FREE ACCESS
• 11.  Configuring your print job in Excel 365
  3m 51s
  Once you have set up the page layout to your liking, you are ready to print. In this tutorial, you will see how to configure print options and submit your print job. This video aligns with MO-210 Microsoft Excel Exam objective: Configure print settings. FREE ACCESS