Course curriculum

  • 1

    CHAPTER 0 : INTRODUCTION

    • Intro to your instructor

    • 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

  • 12

    Chapter A: Project 4 Tips

    • Project 4 Intro

    • Workbook for session

    • Week 1 Power point

    • Copy of Parts of Excel (From Chapter 1)

    • Copy of Fixing Errors

    • Worksheet from Week 1 Session

    • Section 3 (descriptive statistics)

    • Histogram

    • Histogram using data analysis (starts at page 16, then 15, the 14....etc)

    • Class file used in session 5.11

    • Forecast function

    • QA- Standard Deviation

    • QA- General notes

    • QR: Mode

    • Descriptive Statistics Excel functions

    • 2023 Spring sessions (uneditted)

  • 13

    Chapter B: Basic Excel Additional Info

    • Basic Excel Course outline

    • Workbook for week 1

    • Workbook used in Week 2

    • Classroom Files

  • 14

    Chapter C: Statistics Extras

    • Statistics Course outline

    • Basic Probability using excel

    • Week 1 tutorial sheet aka workbook

    • Files used in live session. Week 2 May 5.29.22

  • 15

    Chapter D: Advanced Excel tips and tricks

    • Week 1 tutorial sheet aka workbook

    • Workbook used 5.29.22

    • Power Point

    • Data use 6.5

    • ADVANCED Excel Course Outline

    • Week 2 tutorial sheet aka workbook

    • Week 3 Tables Workbook

  • 16

    File used in class

    • Saturday 9.17 worksheet from class

    • File used 9.15

  • 17

    PROJECT 4 Step by Step Guides

    • Step 1

    • Step 2

    • Step 3

    • Step 4

    • Step 5

    • Step 6 (two parts)

    • Recoding of Weks 1 and 2 May 2023