Excel Dexterity: Table Feature (video)

  • Credits: 2
  • Format: Self-Study Video
  • Field of Study: Computer Software and Apps
  • Author/Speaker: David Ringstrom
Course ID: Advanced Preparation: Experience Level:
DR-604.21 None Overview
Published Date: Program Prerequisites: Other Course Formats:
© June 2020 Basic Understanding of Technology N/A
COURSE DESCRIPTION

In this extensive presentation Excel expert David Ringstrom, CPA explores the Table feature. This feature offers a dazzling number of automation and data integrity opportunities. Start saving time immediately with pivot tables and formulas that automatically accommodate expanding lists of data. Sift through lists of data with ease, and eliminate the risk of forgetting to copy formulas both up and down a given column.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws to your attention any differences in Excel 2013, 2010, or 2007 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.

Topics include:
  • Simplifying formula writing by way of table and field names eliminates the need to activate other worksheets.
  • Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets.
  • Using the SUMIF function to summarize data based on a single criterion.
  • Managing cumbersome lists of data using the Table feature.
  • Creating an in-cell list by way of Excel’s Data Validation feature, and then automating the addition of new items with a table.
  • Minimizing a data integrity risk within pivot tables by way of Excel’s Table feature.
  • Improving the integrity of pivot tables by utilizing the Table feature in Excel.
  • Improving the integrity of spreadsheets with Excel’s VLOOKUP function.
  • Applying different filter settings with just a couple of mouse clicks using the Custom Views feature.
  • Applying different filter settings with just a couple of mouse clicks using the Custom Views feature.
  • Determining whether formulas within tables use cell references or field names.
  • Avoiding the need to write repetitive formulas using Excel’s Data Table feature.

Learning Objectives:

After reading the course material, you will be able to:

  • Recall the arguments used within Excel's VLOOKUP function.
  • Identify which versions of Excel permit using slicers with both tables and pivot tables.
  • Identify the feature that makes charts expand automatically as you add additional data to the source range.

Who Should Attend:
  • All Certified Public Accountants (CPAs)

Qualifies and Approved with all State Boards of Accountancy and the following sponsorship’s:
NASBA