Busn 218 - Microsoft 365 Excel: Spreadsheet Construction
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: . When you complete the Excel file test, you can upload it to the Home area of our Canvas course.
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 (1 practice problem at end of worksheets)
pdf notes: ExcelBasics02.pdf
Download Excel workbook test for video #2: . When you complete the Excel file test, you can upload it to the Home area of our Canvas course.
Video 02: MS 365 Excel Basics #3: Data Analysis: Sort, Filter, PivotTables, PIVOTBY, Power Query & Dashboards (52 minutes)
Excel File Download: ExcelBasics03.xlsx (1 practice problem at end of worksheets)
pdf notes: ExcelBasics03.pdf
Download Excel workbook test for video #3: . When you complete the Excel file test, you can upload it to the Home area of our Canvas course.
Last 218 Class: Old