Introduction
  • Introduction
Excel Training
  • RESOURCES (Excel Training)
  • Excel Training - Introduction
  • Excel Training - Basics
  • Excel Training - VLOOKUP Part 1
  • Excel Training - VLOOKUP Part 2 (INDEX MATCH)
  • Excel Training - Pivot Table
  • Excel Training - The Other Functions
  • Excel Training - Standards and Tips
Exercises
  • RESOURCES (Excel Exercises)
  • Exercise 1 Solution - Splitting a Check
  • Exercise 2 Solution - Running Journal
  • Exercise 3 Solution - Minimum Score to Pass
  • Exercise 4 Solution - An Actual Professional Exercise
Project 1 (Medium) - Cable Provider Tool
  • Project Instructions and Materials - Cable Provider Tool
  • Solution - Cable Provider Tool
Project 2 (Hard) - Task List
  • Project Instructions and Materials - Task List
  • Solution - Task List
Project 3 (Hard) - NBA Scores Data
  • Project Instructions and Materials - NBA Scores Data
  • Solution - NBA Scores Data
Excel Test 1 - Car Sales
  • Test Instructions and Materials - Car Sales
  • Solution - Car Sales
Excel Test 2 - NBA Steph Curry
  • Test Instructions and Materials - NBA Steph Curry
  • Solution - NBA Steph Curry
Excel Practice Test - just questions
  • Excel Trivia
Outro
  • Outro
SQL Preview
  • SQL Preview