New
16ETD1: K2's Excel Tables and Data Models: Efficiently Manage, Analyze and Report Your Data
If you have questions about this event, please call us at 952-831-2707.
Friday, April 22, 2016
8:30am - 4:30pm Central Time
8 CPE (8 technical)
Minnesota Society of CPAs, Bloomington
It just got easier and quicker to analyze and report on your data. To do it, you need tables and data models, two of Excel's best features. Discover how to harness their power to process large volumes of data into dynamic reports and analyses easily, accurately and quickly. Tables are far more than just a formatting tool. They'll revolutionize how you work with data in Excel -- they dynamically re-size ranges of data, provide an easier way to write formulas, and facilitate quick and easy sorting of large volumes of data. Couple tables with data models -- a way to join two or more tables together -- and you have a recipe for improved efficiency when managing, analyzing and reporting with Excel, even if you're using other data sources.
Major subjects
-
How to build tables and data models in Excel
-
How to use Power Query to link data from external data sources
-
How to easily summarize large volumes of data with Power Pivot
-
How to construct dynamic reports and analyses from tables and data models
-
Formulas that refer to tables in other worksheets and workbooks
-
Tips for improving efficiency with structured references, slicers and other unique table features
-
How to build data analysis expressions in data models to extend their usefulness
-
How to use tables as automatic re-sizing data sources for other objects, including PivotTables and PivotCharts
-
Best practices for generating financial reports and data analyses
Learning objective(s)
-
Understand how to use Excel tables and data models to improve data management, analysis and reporting
Who should take this program?
Accounting and business professionals who use Excel 2013 and Excel 2016 and are seeking to manage, analyze, and report data more efficiently using Excel
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$349.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Standard Member Fee |
$299.00
|
Standard Nonmember Fee |
$349.00
|