Excel Training Course
Link:  mypccourse.com/excel
Instructor:  David Kirk | Dallas College Eastfield Campus

Day 1
Topic Terms Projects / Files
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)
Video Course:
Microsoft Excel Training Course
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
    Getting Started with VBA
  • csv - comma separated values data file
  • jpg versus png
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
  • Format as Table
Data File: employees.xlsx
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
Topic Terms Projects / Files
8 - Data Types

Excel Training Video
  • stocks
  • geography
  • movies
 
9 - Format Cells (Number)

Excel Training Video

  • number, currency, date, time, percentage, fraction, custom
Project 2: Donut Orders

Data File: donut_orders.xlsx
10 - Basic Charts

Excel Training Video

  • column, bar, line, pie, area, scatter, bubble
Project 3: Coffee Shop Gigs
11 - Basic Functions

Excel Training Video

  • math and order of operations
  • SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
  • cell reference between sheets
  • autofill
Project 4: Megabites Restaurant

Data File: megabites.xlsx

Project 5: Converter

 

Day 3
Topic Terms Projects / Files
12 - Copy & Paste

Excel Training Video

  • relative versus absolute formulas
  • transpose
  • paste special
Project 6: toolsales.jpg

Data File: toolsales.xlsx
13 - Filters

Excel Training Video

  • allows you to sort and filter a table
  • UNIQUE function
  • SORT function
Data File: coffee.xlsx
14 - Named Ranges

Excel Training Video

  • assign a name to a range of cells
  • Name Manager under Formulas menu
 
15 - Additional Functions

Excel Training Video
  • COUNTIF - count cell based on a criteria
  • SUMIF - sum cells based on a criteria
  • IF - return a value based on a condition
  • AND, OR
  • VLOOKUP - find things in a table by first row
Project 7: Coffee Sales

 

Day 4
Topic Terms Projects / Files
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
Home  Drawings  Frequency
 
18 - Additional Functions
  • RAND, RANDBETWEEN, RANDARRAY
  • DATE, NOW, TODAY
Project 9: Roulette Wheel
19 - Pivot Tables

Excel Training Video

  • a tool to summarize and analyze data
Project 10: pivot.xlsx
20 - Evaluation

Click Here For Evaluation