Excel Printing and Page Layout (Video) (Course Id 2640)

• Who is this course for?
  This course is intended for anyone needing Continuing Professional Education (CPE), particularly CPAs and accounting professionals who use Excel in their work.

• What is this course about or what problem does this course solve?
  This course provides in-depth instruction on Excel’s printing and page layout features, helping users streamline and optimize their Excel printing processes.

• How can the knowledge from this course be used?
  The skills learned can be applied to manage and improve Excel print setups, including setting print ranges, handling page breaks, and using headers and footers effectively.

• Why is this course important to a CPA, Accountant, or IRS Enrolled Agent?
  Efficiently managing Excel print layouts can save time and reduce errors in financial reporting and document presentation, which are key tasks for CPAs and accountants.

• When is this course relevant or timely?
  This course is timely for professionals working with Excel 365 or older versions like Excel 2021, 2019, or 2016, especially those needing updated skills for current printing and layout features.

• How is a course like this consumed or used?
  The course is delivered via a video presentation in a QAS self-study format and includes visual demonstrations, detailed handouts, and an Excel workbook with examples.

In this presentation, author and Excel expert David H. Ringstrom, CPA, will walk you through a deep dive on printing and page layout techniques in Excel. Topics covered include setting or clearing print ranges, adding cells to the print area, utilizing page break preview and page breaks effectively, printing just a chart from a worksheet, and using Quick Print for efficient printing. Other topics include managing print titles, utilizing the Header and Footer Tools, and maximizing the print area with just three clicks. Participants will gain valuable insights and practical skills to optimize their printing experience in Excel.

David is the author of “Microsoft Excel 365 for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and has written or co-authored six other books. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365. David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations.

Excel for Microsoft 365 is a subscription-based product that receives periodic feature updates. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates.

Video - NASBA QAS - NASBA Registry - 2640

Course Learning Objectives

• State how many print areas Excel will include on a single piece of paper?
• Identify which Excel features are unavailable in specific worksheet views, such as Page Layout.
• Recognize which menu command in Excel displays Excel's Header and Footer tools.

Chapter 1 - Excel Printing and Page Layout

Chapter 1 Review Questions

Key Terms