On-Demand

2 CPE

Surgent's Excel for Staff Level 2 – Getting More Out of Excel

On-Demand
2 CPE

This course is delivered as a recorded video. After completing all sessions, you must pass the final exam with a minimum score of 70% to receive credit.

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.

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

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

CPE Credits Available

2 CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Technology

Prerequisites

Excel for Staff Level 1 or similar

Advanced Preparation

None

Intended Audience

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

Provider

Surgent CPE

Purchase This Course

  • COCPA Member

    $ 109 109
    Join

  • COCPA Non-Member

    $ 142 142
    Your Price

Please login to register.