Wall Street Prep: Excel
Add/delete sheets - ANSWER-alt-i-w OR alt h-i-s Moving around task ribbon - ANSWER-Tab and shift (to select) Auto fit cell -
... [Show More] ANSWER-alt-h-o-i Custom fit columns - ANSWER-alt h-o-w Custom fit rows - ANSWER-alt h-o-h Select entire column/row - ANSWER-ctrl shift-arrow key Format cells - ANSWER-ctrl 1 Paste special - ANSWER-alt e-s Freeze panes - ANSWER-alt w-f-f Split panes - ANSWER-alt w-s Move between panes - ANSWER-F6 Get in cell AND navigate to others while inside - ANSWER-F2 Edit a cell from the outside - ANSWER-alt h-e Add comments - ANSWER-Shift F2 Right (and down) fill - ANSWER-Ctrl (d) r Insert/delete row - ANSWER-alt i-r/h-d-r Insert/delete column - ANSWER-alt i-c/h-d-c Date formatting - ANSWER-Ctrl shift # Currency formatting - ANSWER-Ctrl shift $ Percentage formatting - ANSWER-Ctrl shift % Number formatting - ANSWER-Ctrl shift ! Anchoring a cell - ANSWER-F4 Group columns - ANSWER-Ctrl space; shift alt right; hide: alt a-h && show: alt a-j Group rows - ANSWER-Shift space; shift alt right; hide: alt a-h && show: alt a-j Auditing Cell - ANSWER-Ctrl [ = highlights precedent cell Ctrl ] highlights dependent cell alt m-p highlights precedent cell alt m-d highlights dependent cell alt m-a-a erases arrows Center across selection - ANSWER-Better than merge; effectively does same thing Go to special - ANSWER-F5 alt s Conditional Formatting - ANSWER-Custom: alt o-d Native: alt h-l Page breaks - ANSWER-alt enter =SUM() - ANSWER-Sums values; alt = is shortcut =AND() - ANSWER-True if all arguments are true =OR() - ANSWER-True if one of more arguments are true =IF() - ANSWER-Condition, output for true, output for false =IFS() - ANSWER-Better than nested IF, last argument is TRUE =IFERROR() - ANSWER-If there is an error, then a certain output is given Concatenation - ANSWER-Making dynamic headers with & =EOMONTH() - ANSWER-Gives date at end of month from specific start date =EDATE() - ANSWER-Gives exact date from specific start date =ISNUMBER() and =ISTEXT() - ANSWER-Determines if cell has numbers or text in it; if yes, certain output is given, if not same thing; embedded in =IF() =YEARFRAC() - ANSWER-Percentage of year between two dates [Show Less]