K2's Excel Tables - Revolutionize How You Work with Excel
Earn 4 CPE Credits!
Exam price $154.
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

Microsoft introduced tables with the 2007 release of Excel and, in the course of doing so, likely forever changed how many Excel users should work with data in spreadsheets. Though not yet thoroughly understood by most, tables build upon the list functionality introduced in Excel 2003 and provide superior options for storing, sorting, filtering, querying, and managing volumes of data in Excel. In this chapter, you will learn about the fundamentals of working with tables – one of Excel’s best features.

  • List five advantages of working with tables in Excel;
  • Identify three approaches to creating tables and utilize each
  • Apply names to tables and rename tables when desired;
  • Use table styles to format tables and to create new table styles to meet specific formatting objectives
  • Convert table data back to an ordinary range of data in Excel.
  • None
  • Basic Understanding of Excel
  • Intermediate
  • 103648

No Reviews