Video 01: MS 365 Excel Basics #1 What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup  (1 hour and 5 minutes)

Excel File Download: ExcelBasics01.xlsx (1 practice problem at end of worksheets)

pdf notes: ExcelBasics01.pdf

Download Excel workbook test for video #1: YourNameBusn218Test01.xlsx  . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 1 in the Home Area of Canvas. 

 

Video 02:  MS 365 Excel Basics #2: Add & Count Formulas with COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS & IF  (52 minutes)

Excel File Download: ExcelBasics02.xlsx (Practice problems at end of worksheets)

pdf notes:   ExcelBasics02.pdf

Download Excel workbook test for video #2: YourNameBusn218Test02.xlsx  . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 2 in the Home Area of Canvas.

 

Video 03:  MS 365 Excel Basics #3: Number Formatting as Façade & when you MUST use ROUND Function   (21 minutes)

Excel File Download: ExcelBasics03.xlsx (Practice problems at end of worksheets)

pdf notes: ExcelBasics03.pdf

Download Excel workbook test for video #3: YourNameBusn218Test03.xlsx  . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 3 in the Home Area of Canvas.

 

 

Video 3.5: MS 365 Excel Basics #3.5: Spill a Rectangle Range of Weekly Commission Paid Amounts: Test 3, Problem #4 Hint

Excel File Download: ExcelShort34.xlsx

 

 

Video 04:  MS 365 Excel Basics #4: Date & Time Formulas, Functions & Formatting: Everything You Need to Know!!    (43 minutes)

Excel File Download: ExcelBasics04.xlsx (Practice problems at end of worksheets)

pdf notes: ExcelBasics04.pdf

Download Excel workbook test for video #4:  YourNameBusn218Test04.xlsx . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 4 in the Home Area of Canvas.

 

Video 05:  MS 365 Excel Basics #5: IF Function and Logical Tests. IFS, IFNA, OR, AND, ISNUMBER Functions & More!  (44 minutes)

Excel File Download: ExcelBasics05.xlsx (Practice problems at end of worksheets)

pdf notes: ExcelBasics05.pdf

Download Excel workbook test for video #5:  YourNameBusn218Test05.xlsx . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 5 in the Home Area of Canvas. 

 

Video 06:  MS 365 Excel Basics 06: XLOOKUP, FILTER, LOOKUP, SWITCH Functions to Master Any Lookup Task!  (49  minutes)

Excel File Download: ExcelBasics06.xlsx (Practice problems at end of worksheets)

pdf notes: ExcelBasics06.pdf

Download Excel workbook test for video #6:  YourNameBusn218Test06.xlsx . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 6 in the Home Area of Canvas. 

 

Video 07:  MS 365 Excel Basics 07   ( 1 hour 25 minutes)

Excel File Download: ExcelBasics07.xlsx (Practice problems at end of worksheets)

pdf notes: ExcelBasics07.pdf

Download Excel workbook test for video #7:  YourNameBusn218Test07.xlsx . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 7 in the Home Area of Canvas.

 

 

Video 08:  MS 365 Excel Basics 08   ( xx   minutes)

Excel File Download: ExcelBasics08.xlsx (Practice problems at end of worksheets)

pdf notes: ExcelBasics08.pdf

Download Excel workbook test for video #8:  YourNameBusn218Test08.xlsx . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 8 in the Home Area of Canvas.

 

 

 

Video 09:  MS 365 Excel Basics 09   ( xx   minutes)

Excel File Download: ExcelBasics09xlsx (Practice problems at end of worksheets)

pdf notes: ExcelBasics09.pdf

Download Excel workbook test for video #9:  YourNameBusn218Test09.xlsx . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 9 in the Home Area of Canvas.

 

 

 

Video 10:  MS 365 Excel Basics 10   ( xx   minutes)

Excel File Download: ExcelBasics10.xlsx (Practice problems at end of worksheets)

pdf notes: ExcelBasics10.pdf

Download Excel workbook test for video #10:  YourNameBusn218Test10.xlsx . When you complete the Excel file test, you can upload it to the Home area of our Canvas course. You can also take Quiz 10 in the Home Area of Canvas.