Microsoft Excel Printing and Page Layout Nuances

Why Should You Attend:

In this webinar, attendees will learn to use Excel more effectively and efficiently with regard to printing and page layouts. They will discover how to complete tasks that can be accomplished in a fraction of the time using a variety of Excel features or techniques.

The webinar instructor will constantly demonstrate techniques: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts that includes an Excel workbook with most of the examples illustrated during the webcast.

Learning Objectives:

• Identify how the Custom Views feature can streamline repetitive print actions.
• Determine how to restore the classic Print Preview screen from Excel 2007 and earlier.
• Identify printing nuances, such as printing all comments from a worksheet.
• Identify how to enable a full-screen print preview.
• Apply Excel’s Custom Views feature to store and apply different combinations of print areas/settings.
• Apply a new feature into Excel that makes it easy to pick and choose the worksheets you want to print.

Areas Covered in the Webinar:

• Creating a full-page printout of a chart that resides on a worksheet
• Learning how to deal with annoying changes to Print Preview in Word 2010 and later
• Incorporating a new feature that enables you to pick and choose the worksheets from any workbook you wish to print—with no programming knowledge or experience required
• Selecting any aspect of a worksheet you’d like to print
• Seeing how to print a spreadsheet on the fly via Windows Explorer instead of manually opening a workbook in Excel
• Keeping an eye on how much your text is being reduced as you try to squeeze more on a page
• Restoring classic Print Preview functionality in Excel 2007 and later
• Setting a print range that includes multiple noncontiguous areas of a worksheet
• Printing a list of all cell comments on a worksheet or print visible comments
• Using Excel’s Custom Views feature to apply different print settings, including orientation and margins, to a single worksheet
• Streamlining the process of printing spreadsheets to .PDF format

Who Will Benefit:

• Accountants
• CPAs
• CFOs
• Controllers
• Excel User
• Income Tax Preparers
• Enrolled Agents
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Government Personnel

David H Ringstrom
Owner, Accounting Advisors, Inc

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. His 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.

Follow us :