Course curriculum

  • 1

    CHAPTER 0 : INTRODUCTION

    • Email me to set up time for live session

    • Copy of How to use this course

  • 2

    CHAPTER 1: INTRO TO EXCEL

    • What is Excel

    • Parts of Excel

    • Data entry for Excel

    • New document creation and saving

    • Special input in Excel

    • Excel Intro PIT STOP

    • EXCEL INTRO QUIZ

  • 3

    CHAPTER 2: EXCEL FORMATTING

    • CHAPTER 2 DOWNLOADS

    • Formatting 101

    • Formatting Tables

    • Conditional Formatting

    • Name Ranges

    • Worksheet Adjustments

    • Adding Borders

    • Real World Formatting

    • Cell Styles

    • CHAPTER 2: EXCEL FORMATTING QUIZ

  • 4

    CHAPTER 3: EXCEL TABLES

    • CHAPTER 3 DOWNLOADS

    • TABLES

    • Chapter 3 QUIZ: Excel Tables

  • 5

    CHAPTER 4: EXCEL FORMULAS

    • Formula Basics

    • Cell Reference 101

    • How to show the formula used in a sheet

    • Fixing Errors

    • Putting it all together: Excel Formulas 1

    • Putting it all together: Excel Formulas 2

    • Chapter 4 Downloads

    • Chapter 4 Quiz FORMULAS

  • 6

    CHAPTER 5: EXCEL FUNCTIONS

    • Functions 101

    • Functions 101 (part 2)

    • Functions 201

    • V LOOKUP (LONG)

    • V LOOKUP (SHORT)

    • YEARFRAC & COUNT

    • COUNTIF

    • HOW TO FIND OTHER FUNCTIONS

    • NESTED IF

    • ASSIGNMENT 5 FUNCTIONS

    • QUIZ 5: FUNCTIONS

  • 7

    CHAPTER 6: EXCEL ADD IN'S

    • EXCEL ADD INs DOWNLOADS

    • EXCEL ADD INs INTRO

    • INSTALLING ADD INs

    • DATA ANALYSIS

    • PHSTAT

    • QUIZ 6: EXCEL ADD INs

  • 8

    CHAPTER 7: GRAPHS, GRAPHICS, AND PRESENTATIONS

    • GENERATING GRAPHS

    • GRAPHS AND PRESENTATION

    • GRAPHS PIT STOP (PUTTING IT TOGETHER)

    • QUIZ 7: GRAPHS

  • 9

    CHAPTER 8: PRINTING, EXPORTING AND SHARING

    • PRINTING

    • QUIZ 8: PRINTING

  • 10

    CHAPTER 9: EXCEL SHORTCUTS

    • Short cut 1

    • Shortcut 2

    • CHAPTER 9 DOWNLOADS

    • QUIZ Chapter 9 Excel Shortcuts

  • 11

    CHAPTER 10: SPECIAL APPLICATIONS AND TEMPLATES

    • TI84 CALCULATOR

    • PHSTAT TEMPLATE

    • QUIZ Chapter 10 Templates

    • PIT STOP Geometric Mean formula

    • PIT STOP Standard Deviation formula

    • PIT STOP Quadratic Equation solution

    • PIT STOP Correlation