Courses

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

Register

Member Price: $109.00 Non-Member Price: $139.00

Developer:: SURGENT MCCOY SELF-STUDY CPE, LLC
CPE Credits:: Computer Science: 2.00
Fields of Study:: Computer
Level:: Intermediate

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.

Objective

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

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

Designed For

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

Prerequisite

Excel for Staff Level 1 or similar

Advanced Preparation

None