Class |
Topic |
Terms |
Projects / Files |
Day
1 |
1 - Spreadsheet Software |
- Excel, Google Sheets, Numbers (Mac),
OpenOffice/Calc
- Office 365 is subscription based versus
one-time purchase
- Online Office versus Installed Office
(2019)
|
|
2 - Opening and Saving |
|
|
3 - File Types |
- xlsx - default Excel file type (zipped folder)
- xls - old Excel file type (before 2007)
- xlsm - macro enabled file type
- csv - comma separated values data file
- jpg versus png
|
Getting Started with VBA
Example CSV file |
4 - Basic Terminology |
- workbook (file), worksheet (spreadsheet)
- ribbon (toolbar), tab,
cell, row, column, formula bar, name box
|
|
5 - Comments and Notes
Excel Training Video |
- Insert notes (old Excel style)
- Insert comments (threaded conversation)
|
|
6 - Cursor Movement and Selecting Cells
Excel Training Video |
- Move cursor with Ctrl +
Arrow Keys
- Select rows and columns with Shift + Ctrl + Arrow Keys
- Selecting nonadjacent cells with Ctrl +
left click
- Zoom with Ctrl + mouse wheel
- Freezing Rows and Columns
|
Practice with School Enrollment |
7 - Format Cells
Excel Training Video |
- fonts, text color, fill color, borders, merging
cells
- conditional format
|
Project 1:
School Enrollment
Data File:
school_enrollment.xlsx |
Day
2 |
8 - Format Cells (Number)
Excel Training Video |
- number, currency, date, time,
percentage, fraction,
custom
|
Project 2:
Donut
Orders
Data File:
donut_orders.xlsx |
9 - Basic Charts
Excel Training Video |
- column, bar, line, pie, area,
scatter, bubble
|
Project 3:
Coffee
Shop Gigs |
10 - Basic Formulas
Excel Training Video |
- order of operations
- SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF
- cell reference between sheets
- autofill
|
Project 4:
Megabites
Restaurant
Data File:
megabites.xlsx
Project 5: Converter |
Day
3 |
11 - Copy & Paste
Excel Training Video |
- relative versus absolute formulas
- transpose
- paste special
|
Project 6: toolsales.jpg
Data File: toolsales.xlsx |
12 - Filters
Excel Training Video |
- allows you to sort and filter a
table
- UNIQUE function
- SORT function
|
Data File: coffee.xlsx |
13 - Named Ranges
Excel Training Video |
- assign a name to a range of cells
- Name Manager under Formulas menu
|
|
14 - Additional Functions |
- SUMIF - sum cells based on a criteria
- IF - return a value based on a condition
|
|
15 - Vlookup
Excel Training Video |
- VLOOKUP - find things in a table by first
row
|
Project 7: coffee_summary.jpg |
Day
4 |
16 - Data Validation
Excel Training Video |
- help control the type of data
entered
- show a message when you click in a cell
|
|
17 - Sorting
Excel Training Video |
- change the order of your data
|
Project 8: lotto.jpg |
18 - Additional Functions |
- RAND(), RANDBETWEEN(), RANDARRAY()
- DATE(), NOW(), TODAY()
|
Capstone Project: Lotto
Home
Drawings
Frequency |
19 - Pivot Tables
Excel Training Video |
- a tool to summarize and analyze
data
|
Project 10: pivot.xlsx |