Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 405143
 
Credit & Course Provided by:

Taming Wild Excel Spreadsheets

Live Webinar
January 31, 2020
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$219Register Now
Can't Attend?   Audio & Reference Manual$219Add to Cart

Save time, improve the integrity of large workbooks, and avoid repetitive tasks.

Excel® expert David Ringstrom, CPA, coined the phrase, “Either you work Excel® or it works you.” When it comes to large spreadsheets, users often feel stressed in myriad ways. In this beneficial material, the speaker demonstrates a number of ways you can manage large spreadsheets with aplomb. His helpful tips enable you to save time, improve the integrity of large workbooks, avoid repetitive tasks, and much more. The speaker demonstrates every technique at least twice: first, on a PowerPoint® slide with numbered steps, and second, in the subscription-based Office 365 version of Excel®. He draws your attention to any differences in the older versions of Excel® (2019, 2016, 2013, and earlier) during the topic as well as in his detailed handouts. He also provides an Excel® workbook that includes most of the examples he uses 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.

Learning Objectives

• You will be able to describe four different ways to remove data from a pivot table report.

• You will be able to identify how to use custom views to manage the hidden or visible status of columns, rows, worksheets, print settings, and more.

• You will be able to explain the INDIRECT worksheet function to create simpler summary spreadsheets.

• You will be able to review the watch window feature to monitor and navigate key worksheet cells.

Registration

Live Webinar$219Register Now
Can't Attend?   Audio & Reference Manual$219Add to Cart