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

WC936  |  Course  |  Intermediate  |  Scheduled

Description

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

Credits

Number of Credits Type of Credits
2.00 Computer Software & Applications

Designed For

Any Excel user that wants to their spreadsheets to the next level.

Prerequisites

Excel for Staff Level 1 or similar course

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

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

Preparation

None

Notes

Webinar Day - HELP and Assistance Instructions

  1. The session will open 30 minutes prior to the start time. At that time, you will receive a reminder email bringing you to your Attendee Dashboard and a link to join the webinar.
  2. We recommend you log in early to ensure you are ready to go when the presentation begins.
  3. IF YOU ARE HAVING TROUBLE LOGGING INTO THE WEBINAR, please call the CPA Crossings Customer Service Team at (877)-370-2220 Ext. #1.

Prices

Member (Early Bird)
$89.00
Non-Member (Early Bird)
$89.00
Member
$89.00
Non-Member
$89.00
Registration for this event has closed. If you have any question or concerns please give us a call at 615-377-3825 or send us an e-mail at registrar@tscpa.com
Return to Events