Excel 2013 Cheat Sheet, Lecture notes of Auditing

Download Excel 2013 Cheat Sheet and more Lecture notes Auditing in PDF only on Docsity! Excel 2013 Cheat Sheet Ed i t i n g Sho r t cu t s C tr l+X Cu t Ctr l+C Copy Ctr l+V Pas t e Ctr l+Z Und o Ctr l+Y Red o Ctr l+F Fin d Ctr l+A Se lect A l l N a v i gat i o n Sh or t cu t s Change Cell Tab Go Ri ght One Cel l Sh i f t+Tab Go Lef t One Cel l En t e r Down One Cel l S h i f t+Enter Up One Cel l C tr l+Home T o Cel l A 1 Ctr l+End T o Las t Data Cel l Prog ram Shor t cu ts Ctrl+O Open Ctr l+N Create New Ctr l+S Save Ctr l+P Pr in t C tr l+W C lose F 7 Spe l l Check F 1 Open He lp Format t in g Sho r t cu ts Ctrl+B Bo ld Ct r l+I I ta l i cs Ctr l+U Underl i ne Microsoft ® Keyboard Shortcuts Keys to Remember: Backspace: erases back one space Delete: erases forward one space Page Up: moves up one sheet Page Down: moves down one sheet F5: Open Go To Dial og Box Home: moves to the f irst cell in a row Num Lock: controls the 10-key pad Create New Workb o o k: C l i c k File Tab, select New, click Create Open a Workbook: Click File Tab, select open, choose workbook Save a Workbook: Click File Tab, select Save Save Workbook with a New Name: Click File Tab, select Save As, type in the title Print Preview: Click File Tab, click Print, Print Preview appears Print Workbook: Click File Tab, click Print, click Print button Program Basics Program Layout Co lum n s Microsof t Off i ce B ut to n: Hold s the o p t i o n s to s t a r t a new workb o ok, o p e n a sa v ed f i l e, s a v e, p r i n t, p r e pa re fo r d i s t r i b u t i o n, p u b l i sh t h e s p read s hee t, c l ose t h e pr og ram an d sh ow recen t l y v i ewed d o cumen ts Cus tom ize the Qu ick Access Too lbar to ho ld comm and s such as Save, Prin t, Undo, Red o, Co py and Paste. Ribbon Work sheet Tabs Ce ll Name Act i v e Ce l l Rows Max im ize Quick Access Toolbar Ti t le Bar M i n im i ze C lose Zoom S l id erV iews Status Bar Scro l l Bars Grou p Tab Dialog Box Launcher Add Worksheet Icon Workbook Tips Add Worksheet: Click Add Worksheet icon next to sheet tabs at the bottom of the program screen Delete Worksheet: Select the worksheet, click the delete button in the Cells group on the Home tab and select Delete Sheet Rename Worksheet: Double-click sheet tab, type in new name and press enter Add Illustrations to Worksheet: Click on the Insert tab and look in the Illustrations group Adjust Margins, Orientation, Size and Breaks: Click the Page Layout tab on the Ribbon and use the Page Setup group Page Setup Group I l l u s t r a t i o n s G r o u p Formulas & Functions Always start with an equals sign. Formu las Tab Funct i on L ibrary Formu la Aud i t i ng Ca lcu la t i on D e f i n e d N am e s Formu la BarCe l l Name Box Formul asTo Insert a Formula: Select the cell, press = and enter the formula Math Operators for Formulas: Addition + Multiplication * Subtraction - Division / If multiple operators, Excel will follow the order of operations. To Insert a Function: Select the cell, click the Insert Function button on the Formula Bar or on the Formulas Tab Inser t Funct i on But t on Inser t Funct i on But t on Symbols used in Functions: To indicate a range of cells use a colon : Always place parentheses around the cells Functio ns