Excel Inventory Exercises Index

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	Written Instructions 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