Description
Accountants and other business professionals who work in Excel® extensively become very strong with many aspects of the ubiquitous spreadsheet application. They, however, often do not have knowledge of the numerous advanced features available in Excel. In this session we highlight many of the powerful tools found in Excel and provide details as to how they are beneficial and how they are used. Topics include data connectivity, advanced functions available for formula creation, Tables and PivotTables, and charting tools. Many proficient Excel users only utilize a limited percentage of the available functionality when they work with spreadsheets, which is like tying one’s hands behind his back. This session will help make participants “two-fisted” Excel users!
Event Level: Intermediate
Who Should Attend: Accounting and other business professionals who work extensively with Excel® and who want to become knowledgeable about the many powerful features it possesses
Required Knowledge: An understanding of Excel® conventions
Advanced Preparation: None
Vendor: Taymes, LLC
Speaker: Egnatoff, Karl
Objective
Once participants have completed this session, they should be able to * Recall how to work with the charting tools in Excel® and understand conditional formatting * Indicate the benefits of using the Data Toolpak and such tools as descriptive statistics and regression analysis * Identify ways to create complex powerful formulas using advanced functions available from the Excel Function Library * Recall four benefits of using Excel tables and understand ways that tables are helpful * Recognize ways to work with PivotTables to summarize and present information and understand some of the many PivotTable features
Credit Types
- Computer Software & Applications: 8
Registration Fees
| Registration | Type | Price |
|---|---|---|
| Rebroadcast - General (8 hours) | Members | $280.00 |
| Rebroadcast - General (8 hours) | Non Members | $390.00 |
The North Carolina Association of Certified Public Accountants is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org/.For information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call 800-469-1352.