Once you’ve learned how to implement a variety of Excel features and techniques, you’ll find it easy to prepare and print your documents. 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. You will learn helpful tips to work faster and more efficiently in Excel.
You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based 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. You will also receive an Excel workbook that includes most of the examples used during the webcast.
Office 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.
You will learn how to:
- Create a full-page printout of a chart that resides on a worksheet.
- Address annoying changes to Print Preview in Word 2010 and later.
- Incorporate 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.
- Select any aspect of a worksheet you’d like to print.
- Print a spreadsheet on the fly via Windows Explorer instead of manually opening a workbook in Excel.
- Monitor how much your text is being reduced as you try to squeeze more on a page.
- Set a print range that includes multiple noncontiguous areas of a worksheet.
- Print a list of all cell comments on a worksheet or printing visible comments.
- Use Excel’s Custom Views feature to apply different print settings, including orientation and margins, to a single worksheet.
- Streamline the process of printing spreadsheets to .PDF format.
Upon course completion, you will be able to:
- Identify how the Custom Views feature can streamline repetitive print actions.
- Recall how to print a list of all cell comments on a worksheet.
- Describe how to create a full-page printout of a chart that’s located in a worksheet.
Who Should Attend: Practitioners who can benefit by utilizing multiple Excel features and functions to easily prepare and print documents.
Advance Preparation: None
Program Level: Beginner
Field of Study: Computer & Software Applications (2 hours)
Format: Live Webcast
Credit Type: Group Internet Based for the Live Program. [If you attend the program on-demand (after the live date), you will receive Self-Study credit. Please note that to receive Self-Study credit you will need to complete a final exam after viewing the webinar.]