Taming Wild Excel Spreadsheets (OnDemand Webinar)

$219.00

SKU: 405143EAU

Description

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

Date: 2020-01-31 Start Time: End Time:

Learning Objectives

Discovering Four Different Ways to Remove Data From a Pivot Table Report

Using the SUMIFS Function to Sum Values Based on Multiple Criteria

Contrasting the Index and Match Combination to VLOOKUP or HLOOKUP

Exploring How the Indirect Worksheet Function Can Automate Pulling Values From a Group of Individual Worksheets

Using VLOOKUP to Perform Approximate Matches

Integrating Data on Web Pages Into Your Workbooks and Creating Automatic Links

Utilizing Excel’s® IFERROR Function to Display Alternate Values When VLOOKUP Returns an Error

Learning What Types of User Actions Can Trigger #Ref! Errors

Using the SUMIFS Function to Sum Values Based on Multiple Criteria

Utilizing Excel’s® IFERROR Function to Display Alternate Values When VLOOKUP Returns an Error

Performing Dual Lookups, Which Allow You to Look Across Columns and Down Rows to Cross-Reference the Data You Need

Using the SUMIFS Function to Sum Values Based on Multiple Criteria

ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

David H. Ringstrom, CPA-Accounting Advisors, Inc.