BI 348 - Data Analysis with Microsoft Power Tools
Excel, Power Query, Spilled Arrays, PivotTables, Power Pivot, Power BI, Data Models, M Code, DAX and more!
BI 348 - Data Analysis with Microsoft Power Tools
Excel, Power Query, Spilled Arrays, PivotTables, Power Pivot, Power BI, Data Models, M Code, DAX and more!
Class Content (Videos, Excel Files, PDF Note Files, Test Files):
First Video: MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips! (36 mins)
Excel File Download: ExcelBasics08.xlsx (1 practice problem at end of worksheets)
pdf notes: ExcelBasics08.pdf
Download Excel workbook project for the first video: BI348Project01.xlsx . When you complete the Excel file project, you can upload it to the Home area of our Canvas course.
Second Video: PivotTables Can't, But PIVOTBY & GROUPBY Can ! 10 Mind-Blowing Examples! MS 365 Excel Basics #9 (51 mins)
Excel File Download: ExcelBasics09.xlsx (5 practice problem at end of worksheets)
pdf notes: ExcelBasics09.pdf
Download Excel workbook project for the second video: BI348Project02.xlsx . When you complete the Excel file project, you can upload it to the Home area of our Canvas course.
Third Video: (?? mins)
Excel File Download: ExcelBasics10.xlsx (?? practice problem at end of worksheets)
pdf notes: ExcelBasics10.pdf
Download Excel workbook project for the third video: BI348Project03.xlsx . When you complete the Excel file project, you can upload it to the Home area of our Canvas course.
Still in progress... More to come!
Link to Old BI 348 Class 2024
Link to Old BI 348 Class 2023
Link to Old BI 348 Class 2022:
Link to Old BI 348 Class 2020
Link to Old BI 348 Class 2019
Link to Old BI 348 Class 2015-2018
