Summary
Highlights
Course Introduction and Payroll Project00:00:00
Introduction to the course, overview of the six projects, and the first lesson on creating a business payroll spreadsheet using basic formulas, formatting, and functions like MAX, MIN, AVERAGE, and SUM.
Advanced Payroll Features and Overtime00:16:44
Extending the payroll project by adding overtime calculations, using the IF formula for logic-based pay, and managing multi-week payroll tracking with absolute and relative cell referencing.
Gradebook and Conditional Formatting00:39:39
Building a gradebook to track employee performance on various tests, implementing conditional formatting with icon sets to visualize performance, and creating charts for data representation.
Decision Maker Spreadsheet00:57:21
Designing a career decision-making tool that weighs different factors such as pay, job market, and enjoyment using importance weighting to provide a calculated career recommendation.
Sales Reporting and Database Functions1:04:44
Analyzing a large sales dataset using text-to-columns for data parsing, commission calculation with IF statements, SUMIF for filtered totals, and creating summary reports with pivot tables and charts.
Car Inventory Database1:23:17
Managing a large car inventory database through importing text files, utilizing advanced text functions like LEFT, MID, and RIGHT, performing VLOOKUP for data retrieval, and using scatter charts to analyze trends.
Problem Solving and Interest Loans1:57:30
Applying Excel skills to real-world problem-solving scenarios, including calculating simple interest loan payments and comparing different financial options with charts.
Practical Application Challenges2:04:31
A series of practical assignments including school shopping lists, pet ownership cost analysis, vacation budget planning, printer cost comparisons, and total cost of car ownership calculations.