Using Excel May 2015 Open excel programme and choose file 1 Using Excel May 2015 The programme opens with a worksheet. You can type text and numbers into each cell The cells are pre-programmed with days, months etc 2 Using Excel May 2015 3 Using Excel May 2015 • • • • • • • • Create a table. Change the table formatting. Add and delete rows and columns. Filter the table. Create an auto fill formula in a row. Add a total column. Rename the worksheet Take a copy of the worksheet 4 Using Excel May 2015 5 Using Excel May 2015 • • • • • • • • Input figures into your table. Fill three Columns and 4 rows with data. Create a Pie Chart. Change it to a Column Chart. Pick totals up from one worksheet in another. Change the font colour of the text. Set the print area. Look at a print preview and save the file. Online Account Book 6 Using Excel May 2015 To do this Press To do this Press To do this Press New workbook CTRL+N Fill right CTRL+R Save CTRL+S Insert cells, rows, or columns CTRL+SHIFT+Plus sign Undo CTRL+Z Fill down CTRL+D Insert AutoSum ALT= Delete cells, rows, or columns CTRL+Minus sign Redo CTRL+Y Cut CTRL+X Fill current entry CTRL+ENTER Hide Rows Ctrl + 9 Print CTRL+P F2 Edit Formula Hide Columns Ctrl + zero Open files CTRL+O Expand Formula Bar CTRL+SHIFT+U Find text CTRL+F Select all CTRL+A View formulas CTRL ` Select row SHIFT+Spacebar Change reference type F4 Select column CTRL+Spacebar Insert new worksheet Ctrl + F11 Copy CTRL+C Paste all CTRL+V Paste special CTRL+ALT+V Cancel entry ESC Close CTRL+W Move to another cell Arrow keys Exit Excel ALT+F4 Move to next worksheet Ctrl+ page down Move one screen down Page down Move one screen up Page up 7
© Copyright 2024