Excel
Jim Cammack
NOTE: video topics are listed in google document --need to add them here
Assignments
Baratheon College Schedule Excel AssignmentAdvanced Spreadsheet Assignments
Creating Filters (Google Sheets)
Using the Vlookup Function part 1 (part 1, no absolute cell referencing) (uses Google Sheets) (uses Google Sheets)
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)
Why You Should Learn Excel -- watch this Excel video by University of Texas professor Clint Tuttle. :)
Possible Assignment Solutions
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)
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)