On-Demand

2 CPE

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

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.

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.

Learning Objectives

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

Major Topics

  • 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

CPE Credits Available

2 CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Basic

Professional Area of Focus

  • Technology

Prerequisites

None

Advanced Preparation

None

Intended Audience

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

Provider

Surgent CPE

Purchase This Course

  • COCPA Member

    $ 109 109
    Join

  • COCPA Non-Member

    $ 142 142
    Your Price

Please login to register.