Webcast: K2's Excel Tables - Database Technology Comes to Spreadsheets (XKETD117)
Tell a Friend About This EventTell a Friend
 

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 refer

5/18/2017
When: 05/18/2017
9:00 AM until 11:00 AM
Where: Webcast
K2
United States
Presenter: Mac McClelland


Online registration is closed.
« Go to Upcoming Event List  

AcronymXKETD117
CPE2 hours
VendorK2 Enterprises
Category
Management
LevelIntermediate
PrerequisiteBasic Understanding of Excel
Adv PrepNone
Yellow Book?No
Designed forAccounting and financial professionals interested in increasing their proficiency and efficiency when working with Excel
Registration
Member$79
CPA Non-Member$104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course Description

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.

Objectives

Upon completing this course, you should be able to:

  • 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
  • Filter and sort data stored in Tables

Topics

  • Understanding the power of the Excel Tables
  • Summarizing data and making calculations on data stored in Tables
  • Using Tables as data sources for PivotTables and Charts