Excel Assignment

Inventory 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. If the written instructions and movies do not match exactly, both methods will be accepted. )

 step# function Current Mac and Windows Excel (2010, 2012 - 2020 and Office 365) 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 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 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 movie here 7-9 Format cells and fill item numbers movie here movie here movie here movie here movie step 5-9 movie here 10-15 Sort, calculate, functions, if statement, concatenate 10 sort 11-12 calculate 13 functions 14 if statement 15 concatenate Use this Excel movie for 10, 14&15, but see below for 11 - 13 11-12 calculate 13 functions 10 sort 11-12 calculate 13 functions 14 if statement 15 concatenate movie here movie step 10 - 11 movie step 12 movie step 13 movie step 14 movie step 15 movie here 16 Absolute Reference (% of total) movie here Use Excel below 2007 movie movie here movie here movie step 16 movie here 17+ page formatting and window freeze pane movie here movie here movie here movie here movie step 17 - 21 movie step 22 - end movie here Invt sheet 2&3 Written Instructions: written guide written guide written guide written guide written guide written guide Inventory sheet 2 movie up to entering payments entering payments format chart movie movie movie movie first part movie second part movie third part movie Inventory sheet 3 movie movie movie movie movie first part movie second part movie third part movie fourth part movie Inventory Sheet 4 written instructions written instructions written instructions written instructions written instructions written instructions

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