Mastering spreadsheet shortcuts in MS Excel

Comprehensive Mastering Spreadsheet Shortcuts in MS Excel for Accounting Professionals

Created byBizfacility (Pty) Ltd

Last updated 9/2021

English

English [Auto],

What you'll learn

when and where to double-click or right-click with your mouse to uncover hidden functionality,
how to restore the classic print preview screen in Excel 2010 and later,
how to have Excel read numbers aloud to you
locking and unlocking worksheet cells, as well as alternatives that are more efficient
bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click
eliminate duplicates from a list with just a few mouse clicks
simplify repetitive tasks by creating your own keyboard shortcuts

Course content

6 sections • 23 lectures • 54m total length

Introduction1:35
Explore how to customize the Excel 2010+ file menu by pinning files and using the recent work list. Recover unsaved workbooks and remove items without deleting them.

Lecture 11:35
Explore how to manage the recent work menu in Excel 2010 and later, pin important files, recover unsaved workbooks, and remove items from the list.
Lecture 24:14
Learn how to adjust autosave recovery and save frequency, manage recent workbooks in Excel 2013 and 2016, and recover unsaved files to prevent data loss.
Lecture 33:29
Explore how to use the Excel open dialog efficiently, add favorites for quick access, and navigate with keyboard shortcuts like two periods to move back a level.
Lecture 41:14
Enable always create backup in Excel via the file menu's save as option, which saves a previous version as a backup before overwriting, providing a fallback for critical workbooks.

Lecture 53:53
Convert older workbooks from compatibility mode to modern Excel format using the convert command to restore features like spark lines, charts, and filters, and to enable copying worksheets between workbooks.
Lecture 61:18
Learn to customize Excel's quick access toolbar by adding the upgrade workbook command from the file tab, enable it, and export a workbook to the modern format with two keystrokes.
Lecture 72:11
Master Excel efficiency with keyboard shortcuts, borders, and the quick access toolbar to keep essential commands at the top and streamline page setup.
Lecture 80:44
Learn how to undo and redo actions in Excel, highlighting steps and using redo to reapply commands, enabling backward and forward navigation through a spreadsheet.

Lecture 90:55
Learn to center data in columns and speed formatting by adding commands to the Quick Access Toolbar, then use the alt key to trigger shortcuts tailored to how you work.
Lecture 102:46
Learn to freeze and unfreeze panes in Excel to keep headers visible while scrolling. Use quick access toolbar, alt key, number shortcuts, and G navigation tricks for faster pane control.
Lecture 111:17
Use print preview to see before printing, add a print preview button to the quick access toolbar via more commands and type q, then toggle zoom.
Lecture 122:19
Adjust Excel page layout and scaling to keep data on one page using automatic or manual page breaks, and check with print layout and print preview.

Lecture 131:55
Learn to use Excel's speak cells feature to read numbers and text aloud, add the shortcut to the quick access toolbar, and stop or compare data with paper.
Lecture 142:08
Navigate the quick access toolbar to use the form command and criteria features, filtering records with apples or Atlanta to review unique data efficiently.
Lecture 155:12
Master the filter workflow in Excel: apply filters, view only visible rows, copy visible data, and delete blanks, using current region and right-click filter by selected cells value.
Lecture 161:20
Master auto filter in Excel to filter by cell contents, toggle arrows, and clear filters to unwind all rows, using both the ribbon and the Alt+4 keyboard shortcut.

Lecture 171:17
Master practical spreadsheet shortcuts to quickly select, copy, and relocate data in Excel, using the quick access toolbar, alt shortcuts, and standard ctrl commands to isolate and share data.
Lecture 186:21
Convert your data into an Excel table, apply filters and a total row, and use auto-expanding formulas with structured references for easier data analysis.
Lecture 191:25
Copy data to the clipboard, paste into a column, and remove duplicates in Excel. Observe how headers affect the count and how duplicates across multiple columns yield different unique values.
Lecture 202:29
Navigate Excel workbooks quickly by using the Activate dialog and typing the first letter of a sheet (for example d for December or j for July). Use Ctrl+PageUp and Ctrl+PageDown to move between tabs, noting differences between Excel 2010 and 2013.
lecture 212:46
Master the format painter in Excel to apply bold, underline, currency format with F4, and colors or borders across cells, using double-click for multiple targets and escape key to finish.
Lecture 221:39
Manage multiple workbooks in Excel 2016 by switching windows and closing individual documents without exiting the app, and use the corner hot spot to double-click and close Excel.

Requirements

No experience needed
You will learn everything you need to know

Description

MASTERING SPREADSHEET SHORTCUTS IN MS EXCEL FOR ACCOUNTING PROFESSIONALS

Are you working Excel or is it working you? Many users end up working harder than necessary in Excel carrying out repetitive tasks in an inefficient manner. In online course focuses on helpful shortcuts that can be used in all versions of Excel. The online course also covers many Excel keyboard shortcuts and even shows you how to create your own custom keyboard shortcuts.

Course Content:

when and where to double-click or right-click with your mouse to uncover hidden functionality,
how to restore the classic print preview screen in Excel 2010 and later,
an alternative to the merged cells feature, and
how to have Excel read numbers aloud to you
locking and unlocking worksheet cells, as well as alternatives that are more efficient
materials cover Excel 2016, 2013, 2010, and 2007.
add the hidden Form Command back to Excel 2007 and later
converting Excel 2003 files to modern workbook formats with ease.
creating a keyboard shortcut for Excel Freeze Panes feature
saving workbooks as .XLS files by dispatching the Compatibility Checker
bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click
convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes
discover how to quickly access folders and workbooks, regardless of whether they are stored on your computer or on a network
discover techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheet
double-check manual inputs easily by having Excel read numbers aloud to you
eliminate duplicates from a list with just a few mouse clicks
keep an eye on how much your text is being reduced as you try to squeeze more on a page
learn how the Table feature allows you to transform filtering tasks
navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts
restore classic Print Preview functionality in Excel 2007 and later
simplify repetitive tasks by creating your own keyboard shortcuts
wrangle long lists of data by filtering instead of sorting

Who this course is for:

Anyone who wants to learn to importance of effectively communicating with their peers and superiors, trainee accountants and administrators
Practitioners will benefit from learning shortcuts that will enable them to use Microsoft Excel and Word more effectively and efficiently.

Mastering spreadsheet shortcuts in MS Excel

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Part 14 lectures • 11min

Part 24 lectures • 8min

Part 34 lectures • 7min

Part 44 lectures • 11min

Part 56 lectures • 16min

Requirements

Description

Who this course is for: