Keyboard Trainer
Becoming a keyboard expert requires first knowing what shortcuts can do, which usually means searching and reading long lists with many key combinations. Then, most people can only memorize a few at a time; many will never know what they’re missing, leaving keyboard productivity as an underused opportunity.
Keyboard Trainer is an on-screen keyboard simulation flanked by Slicer banks of functions and keys. As Slicer buttons are clicked, the keyboard lights up to assist memorization. Slicers are by function group, function and key and include 193 shortcuts.
A second sheet is focused on Ribbon KeyTips. This sheet simulates the Ribbon tabs and groups with horizontal Slicers, and the KeyTip spelling with vertical, single-character Slicers.
Excel features: Advanced Formatting; Conditional Formatting; Name Manager named ranges and formulas; Column Groups; Tables; PivotTables; Slicers VBA: none
Contents
Keyboard Trainer.zip, with
- Keyboard Trainer.xlsx (Excel Workbook)
Usage
USAGE NOTES
The keyboard simulator is most effective with maximum screen space. Headings are hidden (Alt-W,V,H). Additional space can be gained by:
Ctrl+F1 to hide the ribbon
Shift+Ctrl+F1 to hide the ribbon, toolbar and status bar
Slicer navigation by keyboard:
1. Ctrl+Alt+5 to select the first Slicer. The Slicer bank will have an extra border indicating it is selected.
2. Tab twice to place the focus on the buttons.
3. Arrow around, Space or Enter to select a button.
When using multiple Slicers together such as Area→ Function or Area→ Key or Function→ Way, reset the lower Slicer by clicking the Clear Filter button before selecting another item in the higher Slicer. If the Slicer is selected (has extra border), Clear Filter can be done by Alt+C.
To view the pivot or table:
1. Click the Show Help checkbox
2. Select the heading P or T
3. Follow the tips to unprotect the sheet and open the group