Self Study: Excel Power User Module 1: Fundamental Features

Overview

This course is available until April 30, 2025.

The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly. In the first session, we’ll cover the fundamental features that help build a solid foundation. We’ll continue to integrate these features as we proceed throughout the series. This is part 1 of a 10-part series Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Highlights

• Selected shortcuts
• Named references tables
• Data validation
• Conditional formatting basics

Designed For

Accounting professionals who use Excel for Windows.

Objectives

• Recall at least three shortcuts to improve your speed.
• Recognize which feature allows you to control what a user can type into a cell.
• Identify the feature that enables you to name cells and ranges.

Notice

Online Self-Study