Printing and Page Layout

Level: Basic

Available Durations:

• 50 minutes
• 60 minutes
• 75 minutes
• 90 minutes
• 100 minutes
• 120 minutes

Description:

It’s easy to prepare documents for printing once you learn how to implement a variety of Excel features and techniques. Step-by-step, Excel expert David Ringstrom, CPA, demonstrates how to enable a full-screen print preview, use Excel’s Custom Views feature to apply different print settings, pick and choose worksheets you want to print, and more. David’s tips will help you work faster and more efficiently when laying out and printing your Excel documents.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly known as Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Microsoft 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Topics/Areas Typically Covered:

• Learning how to deal with annoying changes to Print Preview in Word 2010 and later.
• Restoring “classic” Print Preview functionality in Excel 2010 and later.
• Exploring the nuances of page breaks within Excel worksheets.
• Streamlining repetitive printing tasks by adding Quick Print to the Quick Access Toolbar.
• Leveraging the header and footer tools to have better control over controlling what prints at the top and or bottom of each page of a document.
• Printing a list of all cell comments on a worksheet or printing visible comments.
• Keeping an eye on how much your text is being reduced as you try to squeeze more on a page.
• Streamlining the process of printing spreadsheets to .PDF format.
• Seeing how to print a spreadsheet on the fly via Windows Explorer instead of manually opening a workbook in Excel.
• Using Excel’s Custom Views feature to apply different print settings, including orientation and margins, to a single worksheet.
• Setting a print range that includes multiple noncontiguous areas of a worksheet.
• Discovering the array of form controls available within Excel.
• Incorporating a new feature that enables you to pick and choose the worksheets to print from any workbook—no programming knowledge or experience required.
• Choosing the proper file workbook format to preserve macros within Excel workbooks.

Learning Objectives/Why You Should Attend:

• Demonstrate the easiest way to print a single chart that resides on a worksheet.
• Recall the location of the Print Titles command within Excel’s menu.
• Identify the command you can add to the Quick Access Toolbar to streamline access to Print Preview on Excel’s File menu.

About the Instructor:

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).

Pricing and Format Options:

Click here to learn about the presentation format and view pricing information.

Click here to view other topics.