Back To Busn 216 Class Content Home Page
Excel Class Content
Chapter 01:
Video/Class Project 19, Excel 2013 Basics
01:
Handout to download:
Video19-Excel2013Basics01-IntroProject01-Notes.docx
Start file for Video/Class Project to download: None
Finished file for Video/Class Project to download (example of how file looks
after video is over):
Video19-Excel2013Basics01-Gradebooks.xlsx
Video to watch:
Office 2013 Class #19:
Excel Basics 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup
(50:47 min)
Homework from textbook: None
Video/Class Project 20, Excel 2013 Basics 02:
Handout to download:
Video20-Excel2013Basics02-IntroProject02-Notes.docx
Start file for Video/Class Project to download: None
Finished file for Video/Class Project to download (example of how file looks
after video is over):
Video20-Excel2013Basics02-Net Income Projections.xlsx
Video to watch: Office
2013 Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts &
Excel's Golden Rule (31:16 min)
Homework from textbook: None
Video/Class Project 21, Excel 2013 Basics 03:
Handout to download:
Video21-Excel2013Basics03-IntroProject03-Notes.docx
Start file for Video/Class Project to download:
Video21-Excel2013Basics03-CountingAddingWithCriteria.xlsx
Video to watch:
Office 2013 Class #21:
Excel Basics 03: Count & Add: COUNT, COUNTA, SUM, COUNTIFS, SUMIFS functions (12:27
min)
Homework from textbook:
1) Excel Chapter 1 Project: pages EX 1-54
Homework in the Excel Workbook File named
"Video21-Excel2013Basics03-CountingAddingWithCriteria.xlsx"
2) Blue Sheets named "HW(1)" and HW(2) and
HW(3)" at the end of the workbook file. Instructions for homework in yellows
cells at top of sheet.
Handout after first three videos:
Key concepts through Excel Basic videos 01 to 03.docx
Video/Class Project 22, Excel 2013 Basics
04:
Handout to download:
Video22-Excel2013Basics04-IntroProject04-Notes.docx
Start file for Video/Class Project to download:
Video22-Excel2013Basics04-PivotTablesAreEasy.xlsx
Video to watch:
Office 2013 Class #22:
Excel Basics 04: PivotTables Are Easy! SUMIFS or PivotTable for Region Report
(13:28 min)
Homework in the Excel Workbook File named
"Video22-Excel2013Basics04-PivotTablesAreEasy.xlsx"
2) Blue Sheets named "HW(1)" and HW(2) and
HW(3) and HW(4)" at the end of the workbook file. Instructions for homework in
yellows cells at top of sheet.
Video/Class Project 23-27, Excel 2013
Basics 05-09
Handout to download:
Video23-27-Excel2013Basics05-09-Keyboards-Calculations-Data.docx
Start file for Video/Class Project to download:
Video23-27-Excel2013Basics05-09-Keyboards-Calculations-Data.xlsm
Video to watch:
Office
2013 Class #23: Excel Basics 05: Customize the Quick Access Toolbar and Ribbon
(5:47 min)
Office
2013 Class #24: Excel Basics 6: Excel Keyboard Shortcuts Are Fast! 10 Examples
(11:30 min)
Office
2013 Class #25: Excel Basics 07: What Excel Does: Calculations and Data Analysis
(6:22 min)
Office
2013 Class #26: Excel Basics 08: Default Alignment In Excel. Numbers stored As
Text Trouble (4:04 min)
Office
2013 Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel
Table (13:18 min)
Homework in the Excel Workbook File named
"Video23-27-Excel2013Basics05-09-Keyboards-Calculations-Data.xlsm"
1) Blue Sheets named "HW(1)" and HW(2) and
HW(3) and HW(4) and HW(5)" at the end of the workbook file. Instructions for homework in
yellows cells at top of sheet.
Video/Class Project 28-34, Excel 2013
Basics 10-16:
Handout to download:
Video28-34-Excel2013Basics10-16-FormattingAndFormulas.docx
Start file for Video/Class Project to download:
Video28-34-Excel2013Basics10-16-FormattingAndFormulas.xlsm
Video to watch:
Office
2013 Class #28: Excel Basics 10: Style Formatting: By Hand, Cell, Table &
Conditional Format (22:49 mins)
Office
2013 Class #29: Excel Basics 11: Number Formatting & Formulas Don't Get Tricked
By The Façade (28:31 mins)
Office
2013 Class #30: Excel Basics 12: ROUND function: When and How to use it in
Business (10:10 mins)
Office
2013 Class #31: Excel Basics 13: Examples of Excel Formulas & Formula Elements
(12:22 mins)
Office
2013 Class #32: Excel Basics 14: Math and Order of Operations in Excel Formulas
(2:40 mins)
Office
2013 Class #33: Excel Basics 15: Entering Cell References in Formulas & Edit
Mode Status Bar (3:38 min)
Office
2013 Class #34: Excel Basics 16: Flash Fill To Combine or Extract Text
(3:59 mins)
Homework in the Excel Workbook File named
"Video28-34-Excel2013Basics10-16-FormattingAndFormulas.xlsm"
1) Blue Sheets named "HW(1)" to HW(6)" at the end of the workbook file. Instructions for homework in
yellows cells at top of sheet.
Video/Class Project 35-40, Excel 2013
Basics 17-22:
Handout to download:
Video35-37-Excel2013Basics17-19-FunctionsAndDefinedNames.docx
Video38-39-Excel2013Basics20-21-CellReferences.docx
Video40-Excel2013Basics22-Excel'sGoldenRule.docx
Start file for Video/Class Project to download:
Video35-39-Excel2013Basics17-21-MoreFormulas&References.xlsm
Video40-Excel2013Basics22-Excel'sGoldenRule.xlsm
Video to watch:
Office
2013 Class #35: Excel Basics 17: Search for Excel Functions: PMT & MEDIAN
Functions (17:41 min)
Office
2013 Class #36: Excel Basics 18: Excel Defined Names & Built-in Functions (12:45
min)
Office
2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with
Criteria/Conditions (24:30 min)
Office
2013 Class #38: Excel Basics 20: Relative, Absolute and Mixed Cell References
(28:37 min)
Office
2013 Class #39: Excel Basics 21: Orientate Formula Inputs To Allow Mixed Cell
References (13:28 min)
Office
2013 Class #40: Excel Basics 22: Don't Violate Excel's Golden Rule (8:21
min)
Homework in the Excel Workbook File named
"Video35-39-Excel2013Basics17-21-MoreFormulas&References.xlsm"
1) Blue Sheets named "HW(1)" all the way to
HW(10)" at the end of the workbook file. Instructions for homework in yellows
cells at top of sheet.
Homework from textbook:
2) Excel Chapter 2 Project: pages EX 65-118
(Be sure to watch video 40 BEFORE attempting this problem).
Video/Class Project 41-42, Excel 2013
Basics 23-24:
Handout to download:
Video41-42-Excel2013Basics23-24-DataAnalysisSortFilterPivotTablesFormulas.docx
Start file for Video/Class Project to download:
Video41-42-Excel2013Basics23-24-DataAnalysisSortFilterPivotTablesFormulas.xlsm
Video to watch:
Office 2013 Class #41:
Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples) (25:54
min)
Office 2013 Class #42:
Excel Basics 24: PivotTables for Data Analysis (21 Examples)
(32:40 min)
Homework in the Excel Workbook File named
"Video41-42-Excel2013Basics23-24-DataAnalysis:SortFilterPivotTablesFormulas.xlsm"
1) Blue Sheets named "HW(1)" all the way to
HW(10)" at the end of the workbook file. Instructions for homework in yellows
cells at top of sheet.
Video/Class Project 43, Excel 2013 Basics
25:
Handout to download:
Video43-Excel2013Basics25-Charts.docx
Start file for Video/Class Project to download:
Video43-Excel2013Basics25-Charts.xlsm
Video to watch:
Office 2013 Class 43,
Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more
(43:38 min)
Homework in the Excel Workbook File named
"Video43-Excel2013Basics25-Charts.xlsm"
1) Blue Sheets named "HW(1)" all the way to
HW(6)" at the end of the workbook file. Instructions for homework in yellows
cells at top of sheet.
Video/Class Project 44-45, Excel 2013
Basics 26-27:
Handout to download:
Video44-45-Excel2013Basics26-27-IFandVLOOKUPFunctions.docx
Start file for Video/Class Project to download:
Video44-45-Excel2013Basics26-27-IFandVLOOKUPFunctions.xlsm
Video to watch:
Office 2013 Class #44,
Excel Basics 26: IF Function Made Easy 8 Examples (12:07 min)
Office
2013 Class #45: VLOOKUP Function Made Easy 24 Examples - How To Use VLOOKUP
(33:40 min)
Homework in the Excel Workbook File named
"Video44-45-Excel2013Basics26-27-IFandVLOOKUPFunctions.xlsm "
1) Blue Sheets named "HW(1)" all the way to
HW(4)" at the end of the workbook file. Instructions for homework in yellows
cells at top of sheet.
Feb 25, 2015 PivotTable Fun Workbook
Feb 24: Busn216-BudgetProblem.xlsx
March 9, 2016: 2015-2016SalesTransactions.xlsx
March 9, 2016: RegionalReportEmail.docx