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, Excel 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!
Once participants have completed this session, they should be able to * Work with the charting tools in Excel® and understand conditional formatting * Explain the benefits of using the Data ToolPak and such tools as descriptive statistics and regression analysis * Create complex powerful formulas using advance functions available from the Excel Function Library * List four benefits of using Excel tables and understand ways that tables are helpful * Work with PivotTables to summarize and present information and understand some of the many PivotTable features
* This session is taught using a Hands-On methodology * We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor for a greatly improved learning experience * The Excel® topics discussed in this session include * Using Excel for Graphical Output and Dashboard Reporting * Data Tools and the Data Analysis ToolPak * Advanced Functions and Complex Formulas * Working with Excel Tables and PivotTables * All practice and demonstration files are available for download for a period of 30 days after the session is taught
Who Should Attend
Accounting and other business professionals who work extensively with Excel® who want to become knowledgeable about the many powerful features it possesses
An understanding of Excel® conventions
An understanding of Excel® con
Additional Event Information
Contact NCACPA if you need assistance with your online program. For the quickest results, email the Online Learning Team at [email protected], and a team member will contact you shortly.
If you need assistance with internet access issues, browser capability, or when the NCACPA office is closed* please call Freestone Technical Support at 866-702-3278 or by email at [email protected] .
*NCACPA office hours are 9:00 am–5:00 pm ET. Online Learning Team members will be available via email 30 minutes prior to the start of a live online program.
Test Your System
You may test your system by clicking here. Please test your system to ensure you have the proper components installed.
Share This Event
For information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call 800-469-1352.