Our biggest sale of the year is going on now! 30% off all accelerator and essentials courses and books (on top of 20% member discount). Exclusions apply
IREM.org
0

Automating Microsoft Excel Formulas and Tasks with the Table Feature

Member price:

$59.00

Your price:

$ 99.00

12/14/2022

11 am PT / 12 pm MT / 1 pm CT / 2 pm ET
*approximate length: 45 minutes to 1 hour

Presenter: David Ringstrom, CPA

In this comprehensive session, Excel expert David Ringstrom, CPA goes deep into the Table feature, which was first introduced in Excel 2007. The Table feature offers numerous opportunities to vastly improve the integrity of your spreadsheets as well as reduce the maintenance involved with your spreadsheets. In short, it's a hidden automation feature in Excel that can help you save time and avoid frustration.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

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

Who should attend:

  • Practitioners seeking to use Microsoft Excel more effectively by way of the Table feature, as well as anyone looking to improve the integrity of their spreadsheets

Topics covered:

  • Avoiding the need to write repetitive formulas using Excel’s Data Table feature
  • Determining whether formulas within tables use cell references or field names
  • Discovering two different ways to locate tables anywhere within a workbook
  • Eliminating the need to manually resize charts when data is added—automate this with tables instead
  • Future-proofing VLOOKUP by using Excel’s Table feature versus referencing static ranges
  • Improving the integrity of pivot tables by utilizing the Table feature in Excel
  • Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets
  • Managing cumbersome lists of data using the Table feature
  • Minimizing a data integrity risk within pivot tables by way of Excel’s Table feature
  • Removing the Table feature from a worksheet if it’s no longer needed
  • Simplifying formula writing by way of table and field names, which eliminates the need to activate other worksheets
  • Streamlining the filtering of lists in Excel 2013 and later by using the Slicer feature with tables

Learning objectives:

  • Identify common data integrity risks that the Table feature eliminates
  • Recall the nuances of the Table feature so you can use it effectively
  • Apply Excel’s Table feature to simplify data analysis

Level: Basic

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David’s 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.

Close
Our site uses cookies to improve your visiting experience. Please view our Cookie and Privacy Policy.
Got it