Instructor - David Kirk
Video Resources: 
Microsoft Excel Training Course

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