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
-