15EXT4: Excel Tables: Revolutionize How You Work With Excel
If you have questions about this event, please call us at 952-831-2707.
Tuesday, April 21, 2015
8:30am - 12:00pm Central Time
4 CPE (4 technical)
Minnesota Society of CPAs, Bloomington
Tables are one of the best Excel features that you probably aren't using. Much more than just a formatting tool, tables can serve as data sources that automatically and dynamically re-size to match the volume of data under analysis. They provide a simpler way to write formulas, contain advanced filtering and sorting capabilities, and streamline the process of working with large volumes of data. In short, tables will revolutionize how you work with data in Excel. Find out how to use them to increase your daily efficiency and productivity. Find out if this class is right for you. Take the online assessment.
"Great, very useful."
"As is usually the case, K2 guys are great!"
- 2014 attendees
Major subjects
-
How to create and use Excel tables
-
How to build structured reference formulas
-
Using formulas that refer to tables in other worksheets and workbooks
-
Using tables as data sources for other objects, including PivotTables and PivotCharts
-
How to sort and filter data in tables
-
Using external criteria to filter data within a table
-
Advanced table techniques
Learning objective(s)
-
Understand how to use Excel tables to improve how you work with and analyze data
Who should take this program?
CPAs, accountants and financial professionals in industry and public practice
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$229.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Standard Member Fee |
$199.00
|
Standard Nonmember Fee |
$229.00
|