Fancy Formulas
This is the formula and the short cut for adding amounts together.
=sum()
alt =
Name the shortcuts for save, copy, cut, paste, undo, find, and flipping between windows on your computer.
Ctrl + S
Ctrl + C
Ctrl + X
Ctrl + V
Ctrl + Z
Ctrl + F
Alt + tab
This is the button you press to make text go from one line to multiple lines within one cell.
Wrap text
Click this to highlight the entire worksheet.
The triangle in the top left.
This is immediately the first thing you want to do with a data set to be able to organize and search it better.
Add filter
These are the formulas for finding the largest amount and the smallest amount in a data set.
=max()
=min()
You press these buttons to get to the end of a data set and you press this additional button to highlight to the end of the data set.
Ctrl + directional arrow. Add shift to highlight.
Click on this button to copy formatting from a group of cells onto another group of cells.
Format painter
You do this to expand a column to the width of its contents.
What is double clicking the vertical top boundary on the right side
What is the best graph for showing time based data: scatter, line, or pie?
Line
If the below phrase is in a formula, are you linking another Excel workbook, an Excel worksheet within the same workbook, or a table within the same worksheet titled "Table 1"?
'Table 1'!E22
An Excel worksheet within the same workbook
Give me the shortcuts to insert a row, insert a column, and insert a comment.
Row: Alt + IR
Column: Alt + IC
Comment: Shift + F2
This is the tool to format certain items in a data set based on a predefined rule.
Conditional formatting
Where do you click to continue a pattern down a column (i.e. if you have 1, 2, 3 in the first the cells, how do you continue counting into the cells below)?
Hover over the right bottom corner of cell to get the bold cross symbol, then click and drag (or double click if there is data in the column to the left).
This is helpful when you have a large data set and you need to summarize it (especially if you can group it in broader categories).
Pivot Table
Name the formula for counting amounts based on a condition.
=countif()
This is the symbol and the shortcut for locking a cell in a formula (i.e. when you want to multiply a lot of cells all by another singular cell).
$, F4 (ex: $A$1 * B1)
Instead of merging a cell, you can do this do align the text in the middle of the column.
Distribute horizontally
You can do this to easily see the sum, average, and count of section of a data set.
Highlight and look at the bottom right of the Excel window
This is the type of graph that can show two different series of data as two different types in the graph.
Combo
Give me the Index Match formula and the subpar formula that's similar, but can't do as much.
=index(range,match(),match())
=Vlookup()
This is the shortcut for switching between Excel worksheets within one workbook.
Ctrl + page up
Ctrl + page down
Give me the short cut to open the Format Cells box and the example format the custom numbers are in (only asking because this was on Linkedin)
Ctrl + 1
###.0
When dragging down the lower right corner of a cell that says 11/2/98, this is what will be put in the next three cells.
11/3/98
11/4/98
11/5/98
What is the tool called for switching the X and Y axis of a graph (i.e. you have dollars on the x-axis and months on the y-axis, but you want them switched)?
Switch row/column