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

Overview

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.

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

Prerequisites

None

Designed For

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

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

Preparation

None

Notice

On-Demand Webcast