Excel Shortcuts and Formulas for Wall Street Prep 2023-2024, Exams of Business Systems

Download Excel Shortcuts and Formulas for Wall Street Prep 2023-2024 and more Exams Business Systems in PDF only on Docsity! Wall Street Prep Excel With Complete Solution 2023 – 2024 Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside - alt h-e Add comments - Shift F2 Right (and down) fill - Ctrl (d) r Insert/delete row - alt i-r/h-d-r Insert/delete column - alt i-c/h-d-c Date formatting - Ctrl shift # Currency formatting - Ctrl shift $ Percentage formatting - Ctrl shift % Number formatting - Ctrl shift ! Anchoring a cell - F4 Group columns - Ctrl space; shift alt right; hide: alt a-h && show: alt a-j Group rows - Shift space; shift alt right; hide: alt a-h && show: alt a-j Auditing Cell - 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 - Better than merge; effectively does same thing Go to special - F5 alt s Conditional Formatting - Custom: alt o-d Native: alt h-l Page breaks - alt enter =SUM() - Sums values; alt = is shortcut =AND() - True if all arguments are true =OR() - True if one of more arguments are true =IF() - Condition, output for true, output for false =IFS() - Better than nested IF, last argument is TRUE =IFERROR() - If there is an error, then a certain output is given Concatenation - Making dynamic headers with & =EOMONTH() - Gives date at end of month from specific start date =EDATE() - Gives exact date from specific start date =ISNUMBER() and =ISTEXT() - Determines if cell has numbers or text in it; if yes, certain output is given, if not same thing; embedded in =IF() =YEARFRAC() - Percentage of year between two dates =DATE() - Put in specific numbers and spits out date w/o serial number