15AEXCEL: Advanced Excel
If you have questions about this event, please call us at 952-831-2707.
Wednesday, June 17, 2015
8:30am - 4:30pm Central Time
8 CPE (8 technical)
Minnesota Society of CPAs, Bloomington
You may consider yourself an Excel master, but if you're self-taught, you're not using it to its full potential. Take your knowledge to the next level so you can work more productively, efficiently and accurately with Excel. Explore real-world examples developed by accountants, for accountants, in six critical areas: collaboration and workbook security; using tables to analyze and report data; integrating and manipulating data from external sources; creating and auditing complex formulas; advanced data analysis; and using charts to analyze and communicate information. Plus, get access to sample data files that will help you put your new Excel knowledge into practice.
Major subjects
-
Workbook security and collaboration -- encryption, digital signatures, sharing and merging, and publishing to SharePoint
-
How to use tables for analysis and reporting, including filtering, sorting, structural reference and advanced filters
-
Data integration and manipulation -- how to import data from various file types and use data cleanup tools
-
How to create and audit complex formulas using advanced functions, including SUMPRODUCT, VLOOKUP, HLOOKUP, MATCH, INDEX and more
-
Advanced data analysis techniques -- data tables, subtotals, filters, PivotTables and PivotCharts
-
How to create, manipulate and customize charts to analyze and communicate information
Learning objective(s)
-
Understand advanced features and functions in Excel to improve workbook productivity and accuracy
Who should take this program?
CPAs, accountants and financial professionals who work extensively with 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
|