Advanced Excel® Topics for Spreadsheet Power Users

Accountants and other business professionals that 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 lie tying one’s hands behind their back. This session will help make participants “two-fisted” Excel® users!

Basic Course Information

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 advanced functions available from the Excel® Function Library;
• List four benefits of using Excel® tables and understand ways that tables are helpful; and
• 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
• 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.