K2's Excel Tables - Database Technology Comes to Spreadsheets
Earn 2 CPE Credits!
Exam price $89.
OR

All of our materials/exams are NASBA and the AICPA approved the revisions to the Statement on Standards for Continuing Professional Education (CPE) Programs (Standards).

Your Exam purchase includes

  • Course materials (video & PDF version)
  • Unlimited attempts to complete exam
  • Instant grading & certificate of completion
  • One year access to complete your CPE
  • Instructor discussion forum



Overview

Tables are new in Excel 2007 and newer versions. Think of them as two-dimensional Excel databases with special functionality to ease and enhance the way users sort, filter, format, and analyze information. Tables can be directly linked to external databases, such as the G/L, for easy update, and serve as dynamic data sources for PivotTables and charts. This webinar will cover the full breadth of functionality provided by tables, including auto expansion, formula replication, and structured referencing.

  • Create and format Tables to revolutionize how to work with data in Excel
  • Describe key features of Tables such as auto-expansion, formula replication, and structured referencing
  • Describe key features of Tables such as auto-expansion, formula replication, and structured referencing
  • Filter and sort data stored in Tables
  • None
  • Basic Understanding of Excel
  • Intermediate
  • 103648

No Reviews