Excel Notes

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