The shortcuts provided are of course, the shortest way to use these features without applying custom shortcuts or using a third party application. Enjoy the list and let me know if I missed anything.
Let me add a quick tip on the shortcuts in the table below.
A plus sign + means do the operations at the same time and a comma means this is the next command in sequence.
|Excel Shortcut or Quickest keystrokes
|Basic Lookup Functions
|Match a value bewteen two tables and return a corresponding value from the second table
|Equal sign, type vl, tab
|Pivot Table, Pivot Table Classic
|Flexible tool for quickly Organizing a data set into meaningful information groupings
|Alt + N, V
|AND, OR, XOR, NOT
|Use these functions to evaluate multiple conditions or compare more than one cell
|Equal sign, type an, tab (for AND)
|Quickly Organize data and filter out values outside of a specified range
|Ctrl + Shift + L
|IF, COUNTIF, SUMIF
|Limit data in view or calculations based on if specified criteria is met
|Equal sign, type I, tab (for IF)
|Index returns value at specified position, while match provides confirmation of matching value. Used together this is an advanced lookup function.
|Equal sign, type in, tab (for INDEX)
|Highlight Cells, Format by Trend
|Visualize Values in cells based on specified or common criteria
|Alt + O, D
|Find and Replace
|FIND, FIND ALL, REPLACE, REPLACE ALL
|Locate values on a page and/or replace them with another specified value
|CTRL + F (Find) ; CTRL + H (Replace)
|Column Charts, Pie Charts
|Provide a visual respresentation of data organized clearly for spreadsheet user
|Conduct multiple calculations on a range of cells or test multiple conditions against a range of cells. Ctrl + Shift + Enter is used instead of Enter
|F2, Enter Formula, CTRL + SHIFT + ENTER