Excel Assignment
Inventory Movie Guide
The numbers refer directly to the steps in the
instruction sheet.
Only the current version of windows excel and mac have videos. The
videos are recorded on Windows but Mac is very similar.
(Note: Some examples have 1
extra column, so your sheet may use F where the example uses G.
If the written instructions and movies do not match exactly, both
methods will be accepted. )
step# | function |
Current Mac and Windows Excel |
Open Office calc | Windows Excel 2007 | Windows Excel below 2007 | Mac
2011 |
Mac
2008 |
Inventory Sheet #1 | Written Instructions | Written Instructions | Written Instructions | Written Instructions | Written Instructions |
remember control plus click is same as right click And do
not use the menu bar - just the ribbon |
remember control plus click is same as right click |
1-6 | enter all items and format the heading | movie here |
|
||||
7-9 | Format cells and fill item numbers | movie here | |||||
10-15 | Sort, calculate, functions, if statement, concatenate |
|
|||||
16 | Absolute Reference (% of total) | movie here | |||||
17+ | page formatting and window freeze pane | movie here | |||||
Invt sheet 2&3 | Written Instructions: | written guide | written guide | written guide | written guide | written guide |
written guide |
Inventory sheet 2 |
|
||||||
Inventory sheet 3 | movie |
|
|||||
Inventory Sheet 4 | written instructions | written instructions | written instructions | written instructions | written instructions | written instructions | |
Extra Helps:
Open Office Tips just for Inventory Sheet
General Open Office Excel Tips