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

remember control plus click is same as right click

Written Instructions

remember control plus click is same as right click And do not use the menu bar - just the ribbon

1-6 enter all items and format the heading movie here movie here movie here movie here movie here

movie step 1 to 2
- remember control plus click is same as right click.

movie step 3 to 4

movie step 5-9


7-9 Format cells and fill item numbers movie here movie here movie here movie here movie here

movie step 5-9
10-15 Sort, calculate, functions, if statement, concatenate movie here

10 sort

11-12 calculate

13 functions

14 if statement

15 concatenate

10 sort

11-12 calculate

13 functions

14 if statement

15 concatenate

Use Excel below 2007 movie for 10, 14&15

11-12 calculate

13 functions

movie here

movie step 10 - 11

movie step 12

movie step 13

movie step 14

movie step 15

16 Absolute Reference (% of total) movie here movie here movie here Use Excel below 2007 movie movie here
movie step 16
17+ page formatting and window freeze pane movie here movie here movie here movie here movie here

movie step 17 - 21
movie step 22 - end
    continue to sheet 2 continue to sheet 2 continue to sheet 2 continue to sheet 2 continue to sheet 2
continue to sheet 2

Extra Helps:

Every step using Excel 2007 - one big video

Basic skill guide

Written Skill Guide

Open Office Tips just for Inventory Sheet

General Open Office Excel Tips

Excel 2007 tips

Tutorials

Macros

Every step using Excel 2007 - one big video