Mastering spreadsheet shortcuts in MS Excel Course

Goals

What will you learn in this course:

• 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

Prerequisites

What are the prerequisites for this course?

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