- Filter
- Sort
- Consolidate
- PivotTable
No category found.
- To find the maximum value in a range.
- To determine what input value is needed to achieve a desired output (goal).
- To highlight cells with specific values.
- To predict future trends.
- Moves one screen up in the current worksheet.
- Moves to the previous worksheet in the workbook.
- Moves to the previous workbook.
- Scrolls to the top of the current worksheet.
- Moves one screen down in the current worksheet.
- Moves to the next worksheet in the workbook.
- Moves to the next workbook.
- Scrolls to the bottom of the current worksheet.
- Alt + H, O, U, S
- Ctrl + H
- Ctrl + Shift + H
- Ctrl + W
- To create simple calculations.
- To summarize and analyze large datasets.
- To draw complex shapes.
- To check for spelling errors.
- Home
- Insert
- Review
- File (then Info)
- Ctrl + Home
- Ctrl + End
- End, Home
- Shift + End
- Alt + =
- Ctrl + =
- Shift + =
- F2
- Looks for a value in the leftmost column of a table, and returns a value in the same row from a column you specify.
- Looks for a value in the top row of a table, and returns a value in the same column from a row you specify.
- Adds values vertically.
- Validates data entry.
- #DIV/0!
- #NAME?
- #VALUE!
- #SUCCESS!
- Ctrl + + (plus)
- Ctrl + – (minus)
- Ctrl + Shift + + (plus)
- Ctrl + Shift + – (minus)
- Ctrl + + (plus)
- Ctrl + – (minus)
- Ctrl + Shift + + (plus)
- Ctrl + Shift + – (minus)
- SUM()
- JOIN()
- CONCATENATE()
- TEXT()
- Ctrl + PgDown
- Ctrl + PgUp
- Ctrl + Tab
- Shift + Tab
- Ctrl + PgUp
- Ctrl + PgDown
- Ctrl + Tab
- Shift + Tab
- Sort
- Filter
- Conditional Formatting
- Subtotal
