High Impact Excel: Table Edition

View the Webinar

Follow this link to register or access the recording. After this seminar has passed, the recording will still be available.CPE CREDIT WILL BE AVAILABLE TO LIVE ATTENDEES ONLY.

Event Date: May 29, 2014, 2 pm ET
 
In this presentation Excel expert David Ringstrom, CPA brings you up to speed on the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well. Uncover power of this feature, but also get the low-down on the conflicts it can pose with other aspects of Excel.
 
Topics Covered:
  • Compare the similarly named Table and Data Table features.
  • Create self-expanding charts that automatically incorporate new data.
  • Use tables to filter multiple lists on a single worksheet.
  • Mitigate the side effects of converting a table back to a normal range of cells.
  • Discover the total row that you can toggle on or off within a table.
  • Determine whether formulas within tables use cell references or field names.
  • See how the Table feature can vastly improve the integrity of Pivot Tables in Excel.
  • Discover keyboard shortcuts that streamline creating tables and managing data within tables.
  • Understand how to use the Slicers feature in Excel 2013 to streamline analyzing data within tables.
  • Learn which features you can't use when one or more tables exist in a workbook, such as Custom Views.
Learning Objectives:
  • Master Excel's Table feature
  • Discover hidden side-effects of the Table feature, such as disabled features
  • Tailor the Table feature to your liking by uncovering hidden options

Download the slides and the materials for this webinar.

 
Presenter:
David Ringstrom
Owner
Accounting Advisors, Inc.
 
David H. Ringstrom, CPA  is the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. He teaches dozens of webinars each year and speaks at conferences on Excel, along with writing freelance articles about spreadsheets that appear internationally. Webinar attendees are often amazed by how much ground David can cover in a short period of time.
 
Program Levelintermediate
Prerequisitesnone
Advance Preparation Needednone
Delivery MethodGroup-Internet Based
Recommended CPE Credit1 credit per 50-minute session*
Registration Instructionsregister online
Costfree
Complaint Resolutionpublisher@accountingweb.com
Refund policy/Cancellation policyDue to this program being offered free of charge, there will be no refunds issued

 

Sift Media is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.


* To obtain CPE credit, the live session must be attended.  THE RECORDING DOES NOT QUALIFY FOR CPE CREDIT.