Excel for Staff Level 2 - Getting More Out of Excel Webinar

Sep 30
11:30 a.m. - 1:30 p.m.

Online

2-Other
CPE Credits

Excel can do so many things but what are some of the features that can really help accountants take their Excel skills to the next level? This course is designed to do just that. To learn ALL the capabilities of Excel would take hundreds of hours of training, so this two-hour course is designed to give you a jump start on the most important features that you can immediately begin implementing in your spreadsheets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Learning Objectives:

After attending this presentation, you will be able to...

Identify the best practices for setting up spreadsheets for data analysis
Apply the use of Consistent Column Calculations to improve the accuracy of your spreadsheets
Determine how to leverage array formulas

Highlights

The major topics that will be covered in this class include:

Overview of setting up spreadsheets for data analysis and how Excel Tables can help
Learning the importance of Consistent Column Calculations
How to use Conditional Formatting to highlight important information
How to leverage Excel Tables by analyzing them in PivotTables
Learning to leverage array formulas

Registration

PICPA Member: $89
Nonmember: $114

More Information

Course No. DPBS2ES2 Level: Intermediate

Prerequisites: Excel for Staff Level 1 or similar course

Notes
This webinar is hosted by PICPA's partner, CPA Crossings, LLC. After registering, you will receive an email from messenger@webex.com with the log-in information.