Back To Busn 216 Class Content Home Page

Excel Class Content
 

Video/Class Project 13: Excel Basics 1:
Video to watch:  Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup    ( 01:02:54 min)
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): EB01-Gradebook-Finished.xlsx
Handout to download: Office2016Class13-ExcelBasics01-IntroductionToExcel01.pdf
Assigned Homework: None

Video/Class Project 14: Excel Basics 2:
Video to watch:  Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts    ( 37:49 min)
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): EB02-NetIncomeProjections.xlsx
Handout to download: Office2016Class14-ExcelBasics02-IntroductionToExcel02.pdf
Assigned Homework: None

Video/Class Project 15: Excel Basics 3:
Video to watch:  Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)     ( 21:06 min)
Start file for Video/Class Project to download:  EB03-CountingAddingWithCriteria.xlsx
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB03-CountingAddingWithCriteriaFinished.xlsx
Handout to download: Office2016Class15-ExcelBasics03-IntroductionToExcel03.pdf
Assigned Homework: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project 16: Excel Basics 4:
Video to watch:  Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)  ( 33:25 min)
Start & Finished file for Video/Class Project to download:  EB04-SUMIFSandPivotTables.xlsx
Handout to download: Office2016Class16-ExcelBasics04-IntroductionToExcel04.pdf
Assigned Homework: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project 17: Excel Basics 5:
Video to watch:  Excel Basics 5: Power of PivotTables to Create Reports with Various Calculations & Layouts  ( 20:19 min)
Start & Finished file for Video/Class Project to download: EB05-PivotTableCalculationsLayout.xlsx
Handout to download: Office2016Class17-ExcelBasics05PivotTableCalculationsLayout.pdf
Assigned Homework: HW # 1 - 3 at the end of the Excel workbook for this video.

Important Video 01 - 05 Concept Summary: Office2016Class17s-ExcelBasics01-05-KeyConcepts.pdf

Video/Class Project 18 - 20: Excel Basics 6 - 8:
** There are three videos here with one Excel file and one handout:
Video to watch:  Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs  ( 10:17 min)
Video to watch:  Excel Basics 7: Keyboard Shortcuts Are Fast!  ( 08:15 min)
Video to watch:  Excel Basics 8: Default Data Alignment In Excel & How it Can Help  ( 09:25 min)
Start & Finished file for Video/Class Project to download: EB06-08QATKeyboardsDefaultAlign.xlsx
Handout to download: Office2016Class18-20-ExcelBasics06-08QATKeyboardDefaultAlign.pdf
Assigned Homework: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project 21: Excel Basics 9:
Video to watch:  Excel Basics 9: Number Formatting as Façade & the ROUND Function   ( 28:49 min)
Start & Finished file for Video/Class Project to download: EB09-NumberFormattingAndROUND.xlsm
Handout to download: Office2016Class21-ExcelBasics09-NumberFormattingAndROUND.pdf
Assigned Homework: HW # 1 - 2 at the end of the Excel workbook for this video.

Video/Class Project 22: Excel Basics 10:
Video to watch:  Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations   ( 39:53 min)
Start & Finished file for Video/Class Project to download: EB10DateTimeNumberFormattingAndCalculations.xlsm
Handout to download: Office2016Class22-ExcelBasics10-DateTimeNumberFormatAndCalculations.pdf
Assigned Homework: HW # 1 - 4 at the end of the Excel workbook for this video.

Video/Class Project 23: Excel Basics 11:
Video to watch:   Excel Basics 11: Search for Excel Functions & get help with Function Arguments  ( 17:04 min)
Start & Finished file for Video/Class Project to download: EB11SearchForFunctions.xlsm
Handout to download: Office2016Class23-ExcelBasics11-SearchForFunctions.pdf
Assigned Homework: None.

Video/Class Project 24: Excel Basics 12:
Video to watch:   Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples   ( 42:25 min)
Start & Finished file for Video/Class Project to download: EB12-FormulaElements.xlsm
Handout to download: Office2016Class24-ExcelBasics12-FormulaElements.pdf
Assigned Homework: HW # 1 - 5 at the end of the Excel workbook for this video.

Video/Class Project 25: Excel Basics 13:
Video to watch:   Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!    ( 54:07 min)
Start & Finished file for Video/Class Project to download:  EB13-IF-FunctionAnd-IS-Functions.xlsm   
Handout to download: Office2016Class25-ExcelBasics13-IF-FunctionAndIs-Function.pdf
Assigned Homework: HW # 1 - 4 at the end of the Excel workbook for this video.

Video/Class Project 26: Excel Basics 14:
Video to watch:  Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier!   ( 40:07 min)
Start & Finished file for Video/Class Project to download:  EB14-VLOOKUPFunction.xlsm   
Handout to download:  Office2016Class26-ExcelBasics14-VLOOKUPFunction.pdf 
Assigned Homework: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project 27: Excel Basics 15:
Video to watch:  Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more!    ( 36:46 min)
Start & Finished file for Video/Class Project to download:  EB15-ExcelTableFeature.xlsm   
Handout to download:  Office2016Class27-ExcelBasics15-VExcelTableFeature.pdf 
Assigned Homework: HW # 1 - 2 at the end of the Excel workbook for this video.

Video/Class Project 28: Excel Basics 16:
Video to watch:  Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!    ( 45:07 min)
Start & Finished file for Video/Class Project to download:  EB16MixedCellReferences.xlsm          Nov 12, 2019:   InClassPracticeNov12.xlsx
Handout to download:  Office2016Class28-ExcelBasics16-MixedCellReferences.pdf 
Assigned Homework: HW # 1 - 4 at the end of the Excel workbook for this video.

Video/Class Project 29: Excel Basics 17:
Video to watch:  Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting    ( 18:02 min)
Start & Finished file for Video/Class Project to download:  EB17StyleFormatting.xlsm   
Handout to download:  Office2016Class29-ExcelBasics17-StyleFormatting.pdf 
Assigned Homework: HW # 1 - 2 at the end of the Excel workbook for this video.

Video/Class Project 30: Excel Basics 18:
Video to watch:  Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To!   ( 10:44 min)
Start file for Video/Class Project to download:   EB18-DefinedNamesStartFile.xlsm  
Finished file for Video/Class Project to download (example of how file looks after video is over): EB18-DefinedNamesFinishedFile.xlsm 
Handout to download:  Office2016Class30-ExcelBasics18-DefinedNames.pdf 
Assigned Homework: None.

Video/Class Project 31: Excel Basics 19:
Video to watch:  Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria   ( 35:15 min)
Start & Finished file for Video/Class Project to download:  EB19-SUMIFSandSimilarFunctions.xlsm   
Handout to download:   Office2016Class31-ExcelBasics19-SUMIFSandSimilarFunctions.pdf
Assigned Homework: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project 32: Excel Basics 20:
Video to watch:   Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As   ( 39:49 min)
Start file for Video/Class Project to download:  EB20-PivotTablesStart.xlsm   
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB20-PivotTablesFinished.xlsm    
Handout to download:  Office2016Class32-ExcelBasics20PivotTables.pdf 
Assigned Homework: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project 33: Excel Basics 21:
Video to watch:  Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)   ( 21:34 min)
Start file for Video/Class Project to download:  EB21-PivotTablesRelationshipsStart.xlsm   
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB21-PivotTablesRelationshipsFinished.xlsm   and  EB21-PivotTablesVLOOKUPFinished.xlsm    
Handout to download:  Office2016Class33-ExcelBasics21PivotTablesRelationships.pdf 
Assigned Homework: HW # 1 at the end of the Excel workbook for this video.

Video/Class Project 34: Excel Basics 22:
Video to watch:  Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later   ( 04:25 min)
Start & Finished file for Video/Class Project to download:   EB22-DefaultPivotTableLayoutExcel2016.xlsx   
Handout to download:  Office2016Class34-ExcelBasics22DefaultPivotTableLayoutExcel2016.pdf 
Assigned Homework: None.

Video/Class Project 35 Excel Basics 23:
Video to watch:  Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data   ( 30:07 min)
Start file for Video/Class Project to download:   EB23-SortFilterFlashFillStart.xlsx   
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB23-SortFilterFlashFillFinished.xlsx 
Handout to download:  Office2016Class35-ExcelBasics23SortFilterFlashFill.pdf 
Assigned Homework: HW # 1 - 4 at the end of the Excel workbook for this video.

Video/Class Project 36 Excel Basics 24:
Video to watch:  Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!!    ( 34:33 min)
Start & Finished file for Video/Class Project to download:      EB24Charts.xlsm  
Handout to download:  Office2016Class36-ExcelBasics24Charts.pdf 
Assigned Homework: HW # 1 - 5 at the end of the Excel workbook for this video.

Video/Class Project 37 Excel Basics 25:
Video to watch:  Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set  ( 30:53 min)
Start file for Video/Class Project to download:  EB25GetAndTransformPowerQueryStart.xlsm   
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB25GetAndTransformPowerQueryFinished.xlsm    
Zipped Folder with Text Files used for importing into Excel:  EB25FileDownloads.zip 
Handout to download:  Office2016Class37-ExcelBasics25-PowerQueryGetAndTransform.pdf 
Assigned Homework: HW # 1 at the end of the Excel workbook for this video.

Important Video 01 - 25 Concept Summary: ExcelBasics01-25-KeyConcepts.pdf