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
(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

Written Instructions

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

10 sort

11-12 calculate

13 functions

14 if statement

15 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  

movie up to entering payments

entering payments

format chart







Inventory sheet 3   movie





Inventory Sheet 4   written instructions written instructions written instructions written instructions written instructions written instructions
               

 

 

 

 

 

Extra Helps:

 

Basic skill guide

Written Skill Guide

Open Office Tips just for Inventory Sheet

General Open Office Excel Tips

Macros