Ep 5. Printing Workbooks

In episode 5 of Microsoft Excel 2016 Training, viewers will learn all about printing workbooks. The episode starts off by discussing the various printing options available in Excel 2016, such as printing the entire workbook, a specific worksheet, or a selection of cells.

The episode then goes into detail about how to customize printing settings, such as page orientation, paper size, and margins. Viewers will also learn how to preview and adjust the print layout before actually printing the workbook.

Next, the episode covers how to add headers and footers to printed pages. This can be useful for including page numbers, dates, and other information on every printed page. Viewers will also learn how to customize headers and footers to include specific information and formatting.

Another important topic covered in this episode is printing multiple copies of a workbook. Viewers will learn how to specify the number of copies to print and also how to print specific pages or ranges of pages. They will also learn how to collate multiple copies of a workbook or print them all at once.

The episode then moves on to discussing how to print specific parts of a workbook, such as a selected range of cells or a specific chart. Viewers will learn how to use the print area feature to specify which parts of the workbook to print. The episode also covers how to adjust the print order of pages and how to print multiple worksheets on a single page.

Towards the end of the episode, viewers will learn how to save custom print settings as presets for future use. This can save a lot of time and hassle when printing similar workbooks in the future.

Finally, the episode concludes with some troubleshooting tips for common printing issues. For example, viewers will learn how to fix printing errors and how to deal with inconsistent page breaks.

Overall, episode 5 of Microsoft Excel 2016 Training offers a comprehensive guide to printing workbooks in Excel 2016. Viewers will learn a lot of useful tips and tricks, from customizing print settings to troubleshooting printing issues. This episode is a must-watch for anyone looking to become an Excel power user.