Courses

Surgent's Excel for Staff Level 1 - What You Never Learned

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:: Basic

Most staff accountants learned Excel in college and many others learned Excel on their own; however, most users never learned the important productivity tips that could help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness.

Objective

Identify all the ways you can select cells and ranges
Recall ways to leverage custom number formats
Recognize the importance of proper worksheet structure

Highlights

Navigating around worksheets
Selecting cells and ranges
How to use custom number formatting
How to leverage Views
How to build better formulas with referenced variables and defined names
How to quickly format cells with Cell Styles
Proper worksheet structure

Designed For

Any Excel user that wants to learn the "real" basics of Excel that will increase their productivity

Prerequisite

None

Advanced Preparation

None