Excel Assignment
Inventory Sheet 1 Movie Guide
The numbers refer directly to the steps in the instruction sheet.
((Note: Some examples have 1 extra column, so your sheet may use F where the
example uses G.)
| step# | function | Excel below 2007 | Excel 2007 | Excel 2010 | Open Office calc | Mac 2008 |
Mac 2011 |
| Written Instructions | Written Instructions | Written Instructions | Written Instructions | Written Instructions | Written Instructions |
||
| 1-6 | enter all items and format the heading | movie here | movie here | movie here | Use Excel below 2007 movie | Use Excel below 2007
- remember control plus click is same as right click. Every step using Excel 2007 - one big video |
movie step 1
to 2
|
| 7-9 | Format cells and fill item numbers | movie here | movie here | movie here | Use Excel below 2007 movie | Use Excel below 2007
- remember control plus click is same as right click. Every step using Excel 2007 - one big video |
movie step 5-9 |
| 10-15 | Sort, calculate, functions, if statement, concatenate | movie here |
Use Excel below 2007 movie for 10, 14&15 |
Use Excel below 2007
- remember control plus click is same as right click. Every step using Excel 2007 - one big video |
|||
| 16 | Absolute Reference (% of total) | movie here | movie here | movie here | Use Excel below 2007 movie | Use Excel below 2007
- remember control plus click is same as right click. Every step using Excel 2007 - one big video |
movie step 16 |
| 17+ | page formatting and window freeze pane | movie here | movie here | movie here | movie here | Use Excel below 2007
- remember control plus click is same as right click. Every step using Excel 2007 - one big video |
movie step 17 - 21 movie step 22 - end |
Extra Helps:
Open Office Tips just for Inventory Sheet
General Open Office Excel Tips
Every step using Excel 2007 - one big video