Busn 218 - Microsoft 365 Excel: Spreadsheet Construction
Syllabus: Busn 218 Syllabus
Introductory Video:
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 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 Test. 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! (?? 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.
Last 218 Class: Old