However, I saw it as an example of software usability. Software should not make it difficult to access its features. Here are the "power features" of Excel, from the article:
- Click the square between column "A" and row "1" to select everything.
- Select multiple files at once to open them all.
- Use Ctrl-Tab to switch between spreadsheet tabs.
- Customize the toolbar using the File→Options→Quick Access Toolbar menu.
- Create diagonal lines in cells using the Home→Font→Borders menu.
- Drag and select X rows (or columns) to insert X new rows (or columns) at once.
- Drag highlighted columns or rows to new locations.
- Show or hide blank cells using the Data→Filter menu.
- Use wildcards when searching with Ctrl-F. Use ? to represent one character and * to represent more than one character.
- Generate unique data using the Data→Advanced menu.
- Validate your input using the Data→Data Validation→Setting menu.
- Jump to the edge of the sheet using Ctrl + arrow keys.
- Transpose a table when copying and pasting, using the Home→Paste→Transpose menu.
- “The best and easiest way to hide data thoroughly is to use Home→Font→Open Format Cells→Number Tab→Custom→Type ;;; → Click Ok.” (The article really does describe this as "easy.")
- Combine text from multiple cells using &.
- Change text to uppercase and lowercase using the UPPER(), LOWER(), and PROPER() functions.
- Insert literal text into a cell using the single quote mark.
- Create your own shorthand using the File→Options→Proofing→AutoCorrect Options menu.
- Right click in the bottom right to get more stats on cells you've highlighted.
- Double-click a spreadsheet tab to rename it.
I knew most of these features already, having used OpenOffice, LibreOffice, and Microsoft Office for years. But I also admit that most of these features are opaque, hidden from the user.
Some of these "power" features are discoverable. I believe users will eventually uncover several of these features on their own. For reference, the "Click the square between column A and row 1 to select everything" functionality is the same on every modern spreadsheet I've used, as shown in this comparison between Microsoft Office and LibreOffice:
The method to select multiple files and switch between tabs is used in other application programs, including the web browser (Ctrl-Tab) and the file manager (select multiple files). Navigating to the edges of a spreadsheet using Ctrl + arrow keys is somewhat discoverable, although this may happen by accident until the user figures out how to reproduce the desired behavior. Other features are a matter of learning the functions available in the program, such as changing text to uppercase and lowercase using the UPPER(), LOWER(), and PROPER() functions.
However, many of the "power" features are hidden deep within menus or available only when other seemingly-unrelated actions are engaged. For example, users must first highlight a group of cells, then access the Home→Paste→Transpose menu in order to "flip" or "transpose" the cell order. But perhaps the most egregious example of functionality that is difficult-to-reach is this: “The best and easiest way to hide data thoroughly is to use Home→Font→Open Format Cells→Number Tab→Custom→Type ;;; → Click Ok.” (The article really does describe this as "easy.")
Software must strike a balance between what is easy to use, what is discoverable, and "power" features for "advanced" users. Will most "general" or "average" spreadsheet users need to validate their input? Or create custom "shorthand" when entering in complicated, repeated text? Probably not. But perhaps many "general" or "average" users will want to "flip" a table using the "transpose" feature.
I'm not particularly critical of this spreadsheet example, as I know many "general" users use spreadsheet programs to do simple calculations or to create tables to organize basic data (such as an inventory of books on a bookshelf). But let this and any other "power features" article serve as reminders that software should be accessible by all, both "average" and "power" users.