Excel Shortcuts
Work faster in Excel by mastering practical keyboard shortcuts. Learn to navigate large worksheets, enter and edit data, format financial reports, and manage workbooks efficiently. Then apply shortcuts to formulas, copying, searching, sorting, filtering, and working with dates and tables. Explore tools for comparing worksheet views and preparing reports for printing. Finally, combine useful commands into repeatable workflows that reduce mouse clicks and minimize interruptions.
Format
PDF Course
Course Lists
Duration
12 Hours
Course Information
Author: Steven Bragg
NASBA Category: Computer Software and Applications
NASBA Category: Computer Software and Applications
Course Number: SP1024
Not Acceptable For: Enrolled Agents
Not Acceptable For: Enrolled Agents
Learning Objectives
- Recognize the benefits, categories, platform differences, and effective learning strategies associated with Excel keyboard shortcuts.
- Specify the keyboard shortcuts used to navigate worksheets, move between worksheets, and select contiguous ranges of data.
- Recall the keyboard commands and procedures used to create and close workbooks, hide worksheets, and group adjacent worksheets.
- Specify the keyboard shortcuts used to edit cell contents, enter identical values into multiple cells, fill formulas, and reverse or restore worksheet changes.
- Recognize the keyboard shortcuts and formatting conventions used to modify cell formatting, apply borders, align information, and repeat formatting actions.
- Specify the keyboard shortcuts and procedures used to select columns, insert rows, delete columns, and restore hidden rows.
- Recall the keyboard shortcuts and commands used to insert functions, establish absolute cell references, copy formulas horizontally, and identify formula dependencies.
- Recognize the appropriate copying and Paste Special operations for transferring cell contents, values, formatting, and transposed data.
- Specify the keyboard shortcuts and procedures used to find and replace worksheet information, navigate to specific cells, and select visible cells.
- Recall the keyboard shortcuts and settings used to sort worksheet data, preserve column headings, access filter menus, and filter records by selected values.
- Specify the keyboard shortcuts and procedures used to select table data, extend selections across populated ranges, add table rows, and identify contiguous data regions.
- Recognize the functions, keyboard shortcuts, and procedures used to convert, edit, generate, and calculate with Excel dates and times.
- Specify the Excel commands and procedures used to freeze worksheet rows and columns, split worksheet views, open additional workbook windows, and arrange windows for comparison.
- Recall the keyboard shortcuts and procedures used to access Backstage view, close workbooks, adjust print areas, and check worksheet spelling.
- Recognize the strategies for prioritizing keyboard shortcuts, balancing keyboard and mouse use, understanding context-sensitive commands, and developing reliable shortcut proficiency through consistent practice.
Instructional Method: QAS Self-Study
Prerequisites: Basic knowledge of Excel
Program Knowledge Level: Intermediate
Program Knowledge Level: Intermediate
Advance Preparation: None
Latest Review Date: October 2026
Program Registration Requirements: Click on the Enroll button to pay for and access the course. You will then be able to download the course as a PDF file, then take an on-line examination, and then download a certificate of completion if you pass the examination.
Program Refund Policy: For more information regarding administrative policies concerning complaints, refunds, and other matters, see our policies page.