Excel Productivity Gains with Tables and Shortcuts (Currently Unavailable)

Author: Jeff Lenning

In this session, we'll discuss ways to improve personal productivity by using Excel more efficienctly.

Specifically, we'll discuss the five most important shortcuts that help us communicate faster with Excel, and, we'll cover the benefits of storing data in tables. Additionally, we'll discuss how to create friendly names and set up in-cell drop downs. Note: this course is designed for Microsoft Excel for Windows, and selected items may not be available in Excel for Mac.

Publication Date: June 2014

Designed For
Accounting professionals looking to learn more about Microsoft Excel for Windows.

Topics Covered

• Keyboard shortcuts
• Named References
• Tables
• Data Validation

Learning Objectives

• Recall five shortcuts to improve productivity
• Identify the special properties and benefits of storing data in tables
• Recognize the Excel feature that creates an in-cell dropdown

Level
Basic

Instructional Method
Self-Study

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
None

Advance Preparation
None