Project Based Excel Course + Practice Tests

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Excel Training

Lecture 1: RESOURCES (Excel Training)

Lecture 2: Excel Training – Introduction

Lecture 3: Excel Training – Basics

Lecture 4: Excel Training – VLOOKUP Part 1

Lecture 5: Excel Training – VLOOKUP Part 2 (INDEX MATCH)

Lecture 6: Excel Training – Pivot Table

Lecture 7: Excel Training – The Other Functions

Lecture 8: Excel Training – Standards and Tips

Chapter 3: Exercises

Lecture 1: RESOURCES (Excel Exercises)

Lecture 2: Exercise 1 Solution – Splitting a Check

Lecture 3: Exercise 2 Solution – Running Journal

Lecture 4: Exercise 3 Solution – Minimum Score to Pass

Lecture 5: Exercise 4 Solution – An Actual Professional Exercise

Chapter 4: Project 1 (Medium) – Cable Provider Tool

Lecture 1: Project Instructions and Materials – Cable Provider Tool

Lecture 2: Solution – Cable Provider Tool

Chapter 5: Project 2 (Hard) – Task List

Lecture 1: Project Instructions and Materials – Task List

Lecture 2: Solution – Task List

Chapter 6: Project 3 (Hard) – NBA Scores Data

Lecture 1: Project Instructions and Materials – NBA Scores Data

Lecture 2: Solution – NBA Scores Data

Chapter 7: Excel Test 1 – Car Sales

Lecture 1: Test Instructions and Materials – Car Sales

Lecture 2: Solution – Car Sales

Chapter 8: Excel Test 2 – NBA Steph Curry

Lecture 1: Test Instructions and Materials – NBA Steph Curry

Lecture 2: Solution – NBA Steph Curry

Chapter 9: Excel Practice Test – just questions

Chapter 10: Outro

Lecture 1: Outro

Chapter 11: SQL Preview