Webinar: Excel Tables - Database Technology Comes to Spreadsheets

WK263  |  Partner Virtual Events  |  Intermediate  |  Scheduled


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.


Number of Credits Type of Credits
2 Other


Basic Understanding of Excel


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


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




This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.


Member (Early Bird)
Non-Member (Early Bird)
Your Price: $79.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations. Early Bird rates will be applied to all registrations made prior to December 11, 2017.


Lawrence McClelland, MBA, JD

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Back to Facilitators