|
|
|
|
|
|
Nebraska Society of CPAs
635 South 14th Street
Suite 330
Lincoln, Nebraska 68508
Phone: (402) 476-8482 (800) 642-6178
Fax: (402) 476-8731
Email: society@nescpa.org
|
|
 |
| <- Previous Page |
|
|
Advanced Excel
|
|
|
| Date |
August 13, 2010
|
|
| Location | Mahoney State Park, Ashland, NE |
|
|
| Course Time |
|
8:30 a.m. to 4:30 p.m. |
|
|
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. If you use Excel extensively, you need this course! Participants will have access to sample data files.
|
| Course Highlights & Objectives |
|
Create, manage and use defined names to simplify formulas. Create, manipulate and customize charts for analyzing and communicating information. Identify, filter or remove unique or duplicate records. Import or work with data stored in external databases, such as the General Ledger, using ODBC. Perform advanced data analysis with data tables, subtotals, filters, PivotTables and PivotCharts. Protect documents using password encryption or Information Rights Management. Remove hidden metadata from documents before distribution, digitally sign and restrict changes to Excel workbooks. Save documents as PDF or XPS files for distribtuion by email. Track changes in shared workbooks and merge data from multiple workbooks. Use advanced formula auditing and error checking techniques. Use advanced techniques, such as Text to Columns, Paste Special, and Go-To Special, to cleanup imported data. Use array formulas to round-off in totals and other useful tasks. Use conditional formatting to create dynamic dashboard displays of tabular data. Use dynamic tables to automatically format and analyze data. Use SmartArt to create professional quality business figures and illustrations. Use advanced functions to create complex formulas. …And much more!
|
|
| Who Should Attend |
|
| Accountants who work with Excel. |
| Course Level | Advanced |
| Prerequisites | Experienced Excel user. |
|
|
|
|
|
| Discussion Leader | Brian Tankersley, K2 Enterprises |
|
|
|
|
|
| Additional Information: |
Parking is available on site and lunch is provided. |
|
|
| Fee |
$230 - Society Member
$260 - Society Nonmember |
|
|
| <- Previous Page |
|
|
