Advanced Excel
Date/Time
8:30am – 4:00pm
Location
170 W Dewey St
Wichita, KS 67202
316-263-3167
| Member Fee | $280.00 |
| Non-Member Fee | $330.00 |
|
Late Fee on or after June 19, 2012 |
$30.00 |
| Your Price | $330.00 |
Description
Although many accountants consider themselves experts in using Excel, most accountants are self-taught and do not use Excel to its full potential. This course is designed to take experienced, self-taught users to the next level. It provides real world examples developed by accountants for accountants in the following six major topic 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 with subtotals, filters, and PivotTables; and using charts to analyze and communicate information. Its content is based on twenty years of experience in delivering Excel training to accountants and on feedback from thousands of accounting and financial professionals just like you. If you use Excel extensively, you need this course! Participants will have access to sample data files.
This course includes coverage of features found in Excel 2003, 2007, and 2010.
Highlights
Excel best features and functions
Objectives
- Describe best practices for securing and collaborating Excel workbooks, including Encryption, Digital Signatures, Sharing and Merging workbooks, and Publishing Excel workbooks to SharePoint
- Describe Tables and understand how to use Table names, Turn a Table into a Range and Analyze the Data using Filtering and Sorting, Structural Reference and Advanced Filters
- Explain how to import data from Text files, XML files, Access tables, and ODBC and MS Query and then use Data Cleanup Tools such as Text to Columns and Transposing Columns and Rows
- Use advanced functions- SUMPRODUCT, VLOOKUP, HLOOKUP, MATCH, INDEX, NETWORKDAYS, RAND, RANDBETWEEN, NPV, IRR, MIRR- to create and audit complex formulas
- Describe advanced data analysis techniques such as Data tables, Subtotals, Filters, PivotTables, and PivotCharts
- Describe techniques used to create, manipulate, and customize charts for analyzing and communicating information
