There are 10 helpful excel pivot table tips for quick and efficient data analysis.
Ctrl + Letters
Ctrl + A Displays formula palette is given a function name or selects the whole worksheet or current date
Ctrl + B Toggles bold on the current selection
Ctrl + C Copies the current selection to the clipboard
Ctrl + D Copies the first cell in the selection downwards
Ctrl + F Displays the Find dialog box
Ctrl + G Displays the GoTo dialog box
Ctrl + H Displays the Replace dialog box
Ctrl + I Toggles italics on the current selection
Ctrl + K Displays the Insert Hyperlink dialog box
Ctrl + L Displays the Create Table dialog box
Ctrl + N Creates a new workbook
Ctrl + O Displays the Open dialog box
Ctrl + P Displays the Print dialog box
Ctrl + R Copies the leftmost cell in the selection to the right
Ctrl + S Saves, Displays the Save As dialog box if a new workbook
Ctrl + U Toggles underlining on the current selection
Ctrl + V Pastes the entry from the clipboard
Ctrl + W Closes the active workbook or window
Ctrl + X Cuts the current selection to the clipboard
Ctrl + Y Repeats the last workbook action Ctrl + Z Undo the last workbook action
Ctrl + Shift + Letters
Ctrl + Shift + F Activates the Font Tab of the format cells
Ctrl + Shift + O Selects all the cells with comments
Ctrl + Shift + P Activates the Font Size tab of the format cells