Mastering spreadsheet shortcuts in MS Excel Course

Goals

• 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 the 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

Prerequisites

• No prior experience needed.
• The student will learn everything he/she needs to know during the course.