Instructor - David Kirk
Video Resources:  Microsoft Excel Training Course

Topic Terminology Projects
1 - Spreadsheet Software Excel, Google Sheets, OpenOffice/Calc  
2 - Templates Microsoft templates to download  
3 - File Types xlsx - new Excel file type (zipped folder)
xls - old Excel file type (before 2007)
xlsm - macro enabled file type
csv - comma separated values data file
Password Protect Workbook
Make a sheet read-only with password		  
4 - Basic Terminology workbook, worksheet (spreadsheet), ribbon (toolbar), tab, cell, row, column, formula bar, name box  
5 - Selecting Cells
     video		 - moving cursor around with Ctrl + Arrow Keys
- selecting rows and columns with Shift + Ctrl + Arrow Keys
- selecting nonadjacent cells with ctrl + mouse		  
6 - Format Cells
      video		 fonts, text color, fill color, borders, merging cells Project 1: School Enrollment

Data File: school_enrollment.xlsx
7 - Format Cells (Number)
      video		 number, currency, date, time, percentage, fraction, custom Project 2: Donut Orders

Data File: donut_orders.xlsx
8 - Basic Charts
      video		 column, bar, line, pie, area, scatter, bubble Project 3: Coffee Shop Gigs
9 - Basic Formulas
      video		 order of operations, sum, average, min, max, count, countif Project 4: Megabites Restaurant

Project 5: Converter
10 - Copy & Paste
      video		 relative versus absolute formulas, paste special Project 6: toolsale.jpg
11 - Filters
      video		 - allows you to sort and filter a table
- use advanced filter to show unique values
- remove duplicates		 Data File: coffee.xlsx
12 - Named Ranges
       video		 - assign a name to a range of cells
- F3 to see a list of names to paste
- Name Manager under Formula menu		  
13 - Vlookup
       video		 - find things in a table by first row Project 7: coffee_summary.jpg
14 - Data Validation
       video		 - help control the type of data entered
- show a message when you click in a cell		  
15 - Sorting
       video		 change the order of your data Project 8: lotto.jpg
16 - Pivot Tables
       video		 a tool to summarize and analyze data Project 9: pivot.xlsx