Excel
Jim Cammack

NOTE: video topics are listed in google document --need to add them here

Assignments

Payroll Assignment

Garage Sale Excel Assignment

Restaurant Menu

BMI Excel Assignment

Speedtest Excel Assignment

Dance Studio Excel Assignment

Real Estate

Trip Excel Assignment

Advanced Spreadsheet Assignments

Creating Filters (Google Sheets)

Using the Vlookup Function part 1 (part 1, no absolute cell referencing) (uses Google Sheets) (uses Google Sheets)
additional clarification for Constructing the Table for the Assignment

Creating Charts (Google Sheets)

Using Pivot Tables (Google Sheets)

Using Add-ins (Excel)

Using Logical Functions (Google Sheets)

IF Function Assrnment (Google Sheets)

Using Financial Functions - Loan Calculator (Google Sheets)

BMI Part 2 (Goal Seek)

Why You Should Learn Excel -- watch this Excel video by University of Texas professor Clint Tuttle. :)

Possible Assignment Solutions

College Tuition

Payroll

Video Instruction

Getting Started in Excel -The Very Basics (8:23)

Simple Spreadsheet Example (Garage Sale Items)

Excel: Math Operators and the Order of Operations (6:33)

Excel: formatting numbers (13:12)

Excel: functions, sum, avg, min, max, using autosum, formulas with multiple functions (25:56)

Excel formatting: merging cells, changing column and row widths, wrapping text, colors, fonts, aligning (10:29)

Cell Referencing Example (Understanding Absolute and Relative Cell Referencing)

Creating Filters Part 1 (uses Google Sheets)

Creating Filters Part 2 (uses Google Sheets)

Creating Charts in Google Sheets (Aderly Corp)

Using Pivot Tables