Excel for Staff Level 2 - Getting More Out of Excel
Monday, September 30, 2024
Webcast or Webinar, Online
11:30AM - 1:30 PM (opens at 11:00AM) EST
2Credits
Technical Business
Registration is Open
Members
$89.00 Regular Price
Non-Members
$119.00 Regular Price
CPE PowerPass Users
Click the "Apply PowerPass" button to use your PowerPass for the applicable course below.
$40.00 Members / $56.00 Non-Members
Don't have a CPE PowerPass? Click
here to find out more about the CPE PowerPass program.
Course Type: Webcast
Course Code: 24/CX44716
Level: Intermediate
Vendor: CPA Crossings, LLC
Field of Study: Computer Software and Applications
Overview:
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.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
Major Topics:
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
Major Topics:
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