Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Excel for Staff Level 2 – Getting More Out of Excel (XL02)

  • Format Self-Study Webcasts
  • Credits 2.00
  • Level Intermediate
  • Field of Study Computer Software & Applications (2)

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 explore them. To learn ALL the capabilities of Excel would take hundreds of hours of training, so this 2-hour course is designed to give you a jump start on the most important features that you can immediately begin implementing in your spreadsheets.



Major Topics:

  • 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

Learning Objectives:

  • 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

Who should take this course:

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

Excel for Staff Level 1 or similar

None

No

No

No

QAS Approval Surgent
IRS Approval Surgent
CFP Approval Surgent
CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.