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
-