Advanced Excel Topics for Spreadsheet Power Users 2024

Thursday, December 26, 2024

Webcast or Webinar, Online

11:00AM - 6:30 PM (opens at 10:30AM) EST

8Credits

Registration is Open

Members

$299.00 Regular Price

Non-Members

$399.00 Regular Price

Please Login to Register

	Name	Email	Firm Office

CPE PowerPass Users

Click the "Apply PowerPass" button to use your PowerPass for the applicable course below.

$160.00 Members / $224.00 Non-Members

Please Login to Apply PowerPass

	Name	Email	Firm Office

Don't have a CPE PowerPass? Click here to find out more about the CPE PowerPass program.

Course Type: Webcast

Course Code: 24/4124658

Level: Basic

Vendor: California CPA Education Foundation

Field of Study: Computer Software and Applications

Overview:

Accountants and other business professionals who work in Excel extensively become very strong with many aspects of the ubiquitous spreadsheet application. In this course, we'll highlight many of the powerful tools found in Excel and provide details on how they are beneficial and 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!

Objectives:

• 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

Major Topics:

• 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

Major Topics:

• 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

Designed For:

CPAs, accountants and financial professionals.

Prerequisites:

An understanding of Excel conventions.