Excel workbook file YouTube Downloads (100s of files, you may have to scroll down a lot to find your file). If you can't find file, try looking in "Other Excel Series" section at bottom (Ctrl + End)
|
Slaying Excel Dragons Book Download files: 1)
excelisfun-Start.xlsm (file to use for whole book) Get Slaying Excel Book at:
Ctrl+Shift+Enter: Mastering Excel Array Formulas Download zipped folders with files: Book and DVD files are DIFFERENT!!! (DVD is more visual, Book is more detailed) 1) Zipped Folder with files for BOOK: FilesForCtrlShiftEnterBook.zip (The files for the book are totally different than the files for the DVD/YouTube videos). 2) Zipped Folder with files for DVD or YouTube videos: ExcelFilesThatGoAlongWithDVD.zip (The files for the DVD/YouTube videos are totally different than the files for the book). Extra Workbooks From YouTube Videio Series: Appendix 3 Array Formula Examples Workbook:
Free Classes From Microsoft: http://www.microsoftvirtualacademy.com/?mtag=MVP4040052 Amazing array of free classes from Microsoft Virtual Academy
Excel Basics Series
Download files:
2010: Excel2010IsFun!START.xlsm StartFile Excel2010IsFun!FINISHED.xlsm FinishedFile Excel2010IsFun!.docx (Free Book) or Excel2010IsFun!.pdf (Free Book) 2007: ExcelBasics2007.xlsm Excel2007IsFun!.doc Book (Free Book!) 2003: ExcelBasics2003.xlsStartFile Excel 2003 Excel Is Fun!.doc Book (Free Book!)
|
Highline Excel 2016 Class Series:
Busn218-Week01.xlsm (Video01)
Highline Excel 2016 Class 01 Excel Fundamentals Efficiency, Data, Data Sets,
Formatting.pdf
Busn218-Video02.xlsm
Highline Excel 2016 Class 02 Excel Fundamentals Formulas, Formula Types, Formula
Elements, Functions & Excel's Golden Rule.pdf
Busn218-Video03-Start.xlsm and
Busn218-Video03-Finished.xlsm
and
Video03TextFilesForImport.zip
Highline Excel 2016 Class 03 Excel Fundamentals Data Analysis Sort, Filter,
PivotTables, Power Query, Power Pivot.pdf
Busn218-Video04Start.xlsm and
Busn218-Video04Finished.xlsm
and May Net Income.xlsx
Highline Excel 2016 Class 04 Cell References Defined Names Table Formula
Nomenclature.pdf
Busn218-Video05.xlsm
Highline Excel 2016 Class 06 Conditional Calculations with Excel Formulas AND &
OR Criteria.pdf
Busn218-Video07.xlsx
Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS Functions for
Conditional Calculations.pdf
Busn218-Video08.xlsx
Highline Excel 2016 Class 08 Text Functions.pdf
Busn218-Video09.xlsx
Highline Excel 2016 Class 09 Date Functions.pdf
Busn218-Video10.xlsx
Highline Excel 2016 Class 10 Data Validation.pdf
Busn218-Video11.xlsx
Highline Excel 2016 Class 11 Lookup Functions.pdf
Busn218-Video12-14Start.xlsx
Highline Excel 2016 Class 12 Two Lookup Values.pdf
Highline Excel 2016 Class 13 One Lookup Value Return Multiple Items.pdf
Highline Excel 2016 Class 14 VLOOKUP as Relationship and Vice Versa.pdf
Busn218-Video15.xlsm
Highline Excel 2016 Class 15 Excel Charts.pdf
Busn218-Charts.pptx
Busn218-Video16.xlsx
Highline Excel 2016 Class 16 Conditional Formatting to Visualize Data - Copy.pdf
Busn218-Video17Start.xlsx
Busn218-Video17Finished.xlsx
Video17ImportTextFiles-05.zip
Highline Excel 2016 Class 17 Dashboards.pdf
Busn218-Video18.xlsx
Highline Excel 2016 Class 18 Clean Transform Data Replace Flash Fill TTC
Formulas.pdf
Busn218-Video19Start.xlsx
Busn218-Video19Finished.xlsx
Highline Excel 2016 Class 19 Transform Data Sets Advanced Filter.pdf
Busn218-Video20Start.xlsx
Busn218-Video20Finished.xlsx
Video20-3ExcelFilesImport.zip
Highline Excel 2016 Class 20 Clean Transform & Import Excel Workbook Data with
Power Query.pdf
Busn218-Video21Start.xlsx
Busn218-Video21Finished.xlsx
Video21-3ExcelWorkbooks.zip
Highline Excel 2016 Class 21 PQ to Import Multiple Excel Workbooks with Multiple
Sheets.pdf
Busn218-Video22Start.xlsm
Busn218-Video22Finished.xlsm
Video22-ImportExcelFiles.zip
Highline Excel 2016 Class 22 Data Modling & DAX Formulas.pdf
Busn218-Video23.xlsm
Video22-Busn218-Finished.pbix
Video23-Import5ExcelFiles.zip
Highline Excel 2016 Class 23 Power BI Desktop.pdf
Busn218-Video24-OldFileName-Busn214-Week10.xlsm
Highline Excel 2016 Class 24 Finance Functions in Excel.pdf
Busn218-Video25-OldFileName-Busn214-Week03.xlsx
Busn218-Video26.xlsm
Highline Excel 2016 Class 26 Recorded Macros.pdf
Highline Excel 2013 Class Series:
Busn214-Week01.xlsm
Busn214-Week02.xlsx
Busn214-Week02-SecondWorkbookWithTableTricks.xlsx
Busn214-Week03.xlsx
Busn214-Week04.xlsx
Busn214-Week05.xlsm
Array Formula Notes.docx
Busn214-Week06.xlsm
Busn214-Week06-Second WorkbookSTART-FILE.xlsm
Busn214-Week06-Second WorkbookFINISHED-FILE.xlsm
Busn214-Week07StartFile.xlsm
Products.zip
LotsOfData.xlsx
Busn214-Week07FinishedFileWithCompletedExamplesAfterVideosDone.xlsm
Busn214-Week08StartFile.xlsm
Busn214-Week08FinishedFile.xlsm
Busn214-Week09.xlsm
Busn214-Week10.xlsm
Busn214-Week11StartFile.xlsm
Busn214-Week11FinishedFile.xlsm
Week1Busn214StartFile
Week1Busn214FinishedFile
Week2Busn214StartFile
Week2Busn214Workbook2StartFile
Week2Busn214FinishedFile
Week3Busn214StartFile
Week3Busn214FinishedFile
Week4Busn214StartFile
Week4Busn214StartZippedFolder
Week4Busn214FinishedFile
Week5Busn214StartFile
Week5Busn214FinishedFile
Week6Busn214StartFile&FinishedFile
(File name is:
Busn214SIBWMOE2007Chapter02andChartsfromMGirvin.xls)
Week7Busn214StartFile&FinishedFile
Week8Busn214StartFile
Week8Busn214Workbook2StartFile
Week8Busn214FinishedFile
Week9Busn214StartFile&FinishedFile
Week10Busn214StartFile
Week10Busn214FinishedFile
PowerPivot Excel 2013 Series
Video #1 Start File:
PowerPivot01Intro.xlsx
Video #1 Finished File:
YouTubeExcelIsFun/PowerPivot01IntroFinished.xlsx
Video #2 Start
File 1:
PowerPivot02-01-LotsOfNonNormalizedData.xlsx
Video #2 Start File2 :
PowerPivot02-02-ColumnarDatabase--NonNormalizedStart.xlsx
Video #2
Finished File 2:
PowerPivot02-02-ColumnarDatabase--NonNormalizedFinished.xlsx
Video #2
Start File 3:
PowerPivot02-03-LotsOfNormalizedData.xlsx
Video #2 Start File 4:
PowerPivot02-04-ColumnarDatabase--Normal.xlsx
Video #3 Start File
1:
PowerPivot03-01ReplaceVLOOKUPwExcel2013RelationshipsStart.xlsx
Video
#3 Finished File 1:
PowerPivot03-01ReplaceVLOOKUPwExcel2013RelationshipsFinished.xlsx
Video #3 Start File 2:
PowerPivot03-02ReplaceVLOOKUPwPowerPivotRelationshipsStart.xlsx
Video
#3 Finished File 2:
PowerPivot03-02ReplaceVLOOKUPwPowerPivotRelationshipsFinished.xlsx
Video #4 Start File:
PowerPivot04-ArrayFormulaOrPowerPivot-Start.xlsx
Video #4 Finished
File:
PowerPivot04-ArrayFormulaOrPowerPivot-Finished.xlsx
Video #5 Start File
1:
PowerPivot05-SourceTablesInExcelStart.xlsx
Video #5 Finished File 1:
PowerPivot05-SourceTablesInExcelFinished.xlsx
Video #5 Start File 2:
PowerPivot05-DataModelAndReportStart.xlsx
Video #5 Finished File 2:
PowerPivot05-DataModelAndReportFinished.xlsx
Video #6 Access Source Data File 1:
PowerPivot06-SourceData.accdb
Video #6 Text Source Data File 2:
PowerPivot06-SourceData.txt
Video #6 Start Excel Source Data File 3:
PowerPivot06-SourceData.xlsx
Video #6 Finished Excel Source Data File
3:
PowerPivot06-SourceDataFinished.xlsx
Video #6 Start File For Data
Model 4:
PowerPivot06ImportFromMultipledataSourcesStart.xlsx
Video #6 Finished
File For Data Model 4:
PowerPivot06ImportFromMultipledataSourcesFinished.xlsx
Video #7 Start File: PowerPivot07GroupingDatesCalendarTableStart.xlsx
Video #7 Finished File:
PowerPivot07GroupingDatesCalendarTableFinished.xlsx
Video #8 Start File: PowerPivot08EditExistingConnectionsImportNewDataStart.xlsx
Video #8
Finished File: PowerPivot08EditExistingConnectionsImportNewDataFinished.xlsx
Video #8 Access Source Data File 1:
PowerPivot08-SourceData.accdb
Video #8 Start Excel Source Data File
2:
PowerPivot08-SourceDataStart.xlsx
Video #8 Finished Excel Source Data File
2:
PowerPivot08-SourceDataFinished.xlsx
Video #9 Start File:
PowerPivot09-CalculatedFieldsStart.xlsx
Video #9 Finished File:
PowerPivot09-CalculatedFieldsFinished.xlsx
Video #10 Start File:
PowerPivot10-CALCULATE-Start.xlsx
Video #10 Finished File:
PowerPivot10-CALCULATE-Finished.xlsx
Video
#10 Source Data File 1:
PowerPivot10-SourceData.accdb (not neccessary to download, but if you
want live data source connections, you can download it)
Video #10 Source
Data File 2: PowerPivot10-SourceData.xlsx
(not neccessary to download, but if you want live data source connections,
you can download it)
Video renamed: Power Query Video #01
(file names still the same):
Video #11 Start File:
PowerPivot11-PowerQueryIntoPowerPivotAppendStart.xlsx
Video #11
Finished File:
PowerPivot11-PowerQueryIntoPowerPivotAppendFinished.xlsx
Video #11
Source Data File #1:
PowerPivot11-OaklandSalesSourceData.accdb
Video #11 Source Data File
#2:
PowerPivot11-TacomaSalesSourceData.xlsx
Video #11 Source Data File
#3:
PowerPivot11-SeattleSalesSourceData.txt
Video renamed:
Power Query Video #02 (file names still the same):
Video #12 Start File:
PowerPivot12-PowerQueryIntoPowerPivotTransformDataStart.xlsx
Video
#12 Finished File:
PowerPivot12-PowerQueryIntoPowerPivotTransformDataFinished.xlsx
Video
#12 Source Data File #1:
PowerPivot12-TransactionsSourceData.xlsx
Video #12 Source Data File
#2:
PowerPivot12-ProductTableSourceData.txt
Video renamed: PowerPivot #11 (file names still the same):
Video #13 Start File:
PowerPivot13-NoGroupingInPowerPivotStart.xlsx
Video #13 Finished
File:
PowerPivot13-NoGroupingInPowerPivotFinished.xlsx
Video renamed: PowerPivot #12 (file names still the same):
Video #14 Start File:
PowerPivot14-NoShowReportFilterPagesStart.xlsx
Video #14 Finished
File:
PowerPivot14-NoShowReportFilterPagesFinished.xlsx
Video renamed: PowerPivot #13 #01 (file names still the same):
Video #15 Start File:
PowerPivot15-BigDataThreeWayLookupStart.xlsx
Video #15 Finished File:
PowerPivot15-BigDataThreeWayLookup-Finished.xlsx
Video #15 Source File
1:
PowerPivot15-Source Table 1.xlsx (about 10 MB)
Video #15 Source File 2:
PowerPivot15-Source Table 2.xlsx (about 10 MB)
Video #15 Source File 3:
PowerPivot15-Source Table 3.xlsx (about 10 MB)
Video #15
Source File 4:
PowerPivot15-Source Categories.xlsx
Excel Power Query:
Video #01 Files:
Start File:
PowerPivot11-PowerQueryIntoPowerPivotAppendStart.xlsx
Finished File:
PowerPivot11-PowerQueryIntoPowerPivotAppendFinished.xlsx
Source Data File #1:
PowerPivot11-OaklandSalesSourceData.accdb
Source Data File
#2:
PowerPivot11-TacomaSalesSourceData.xlsx
Source Data File
#3:
PowerPivot11-SeattleSalesSourceData.txt
Video #02 Files:
Start File:
PowerPivot12-PowerQueryIntoPowerPivotTransformDataStart.xlsx
Finished File:
PowerPivot12-PowerQueryIntoPowerPivotTransformDataFinished.xlsx
Source Data File #1:
PowerPivot12-TransactionsSourceData.xlsx
Source Data File
#2:
PowerPivot12-ProductTableSourceData.txt
Video #03 Files:
Start File:
PowerQuery03-ImportMultipleTextFiles.xlsx
Finished File:
PowerQuery03-ImportMultipleTextFilesFinishedFile.xlsx
Source File #1:
PowerQuery03-GradesBefore1990.txt
Source File #2:
PowerQuery03-GradesBetween1990-2001.txt
Source File #3:
PowerQuery03-GradesAfter2001.txt
Video #04 Files:
Start File:
PowerQuery04-CSVMultipleFileImport.xlsx
Finished File:
PowerQuery04-CSVMultipleFileImportFinished.xlsx
Source File #1:
PowerQuery04-Oakland.csv
Source File #2:
PowerQuery04-Portland.csv
Source File #3:
PowerQuery04-SanFrancisco.csv
Source File #4:
PowerQuery04-Seattle.csv
Source File #5:
PowerQuery04-Tacoma.csv
Video #05 Files:
Start File:
PowerQuery05-ImportCSVCreateLookupDimensionTable.xlsx
Finished File:
PowerQuery05-ImportCSVCreateLookupDimensionTableFinished.xlsx
Source
Files: Use Source Files 1-5 From Video #04 (above)
Video #06 Files:
Start File:
PowerQuery-06-ImportMultipleExcelFiles.xlsx
Finished File:
PowerQuery-06-ImportMultipleExcelFilesFinished.xlsx
Source File #1:
PowerQuery-06-Oakland.xlsx
Source File #2:
PowerQuery-06-Portland.xlsx
Source File #3:
PowerQuery-06-Seattle.xlsx
Source File #4:
PowerQuery-06-SanFrancisco.xlsx
Source File #5:
PowerQuery-06-Tacoma.xlsx
Video #07: No Files
Video #08 Files:
Start File:
PowerQuery08-ImportMultipleExcelSheetsFromMultipleExcelWorkbooks.xlsx
Finished File:
PowerQuery08-ImportMultipleExcelSheetsFromMultipleExcelWorkbooksFinished.xlsx
Source File #1:
PowerQuery08-GrainvilleStore.xlsx
Source File #2:
PowerQuery08-KipsatStore.xlsx
Source File #3:
PowerQuery08-OthelloStore.xlsx
Source File #4:
PowerQuery08-ExtraFranTable.xlsx (This file has data you copy and paste
at the end of the video. It is not imported during the initial "From Folder"
import.)
Video #09 Files:
Start File:
PowerQuery09Start.xlsx
Finished File:
PowerQuery09Finished.xlsx
Video #10 Files:
Start File:
PowerQuery10-UnPivotStart.xlsx
Finished File:
PowerQuery10-UnPivotFinished.xlsx
Video #11:
Start File:
PowerQuery11Start.xlsx
Finished File:
PowerQuery11Finished.xlsx
Video #12:
Start File:
PowerQuery12Start.xlsx
Finished
File:
PowerQuery12Finished.xlsx
VLOOKUP "Shark" Week Downloadable Workbooks
Video #1 (VLOOKUP video):
VLOOKUP-SHARK-WEEK-DownloadableWorkbook01-Start.xlsx (use this one to
follow along and learn)
Video #1:
(VLOOKUP video):
VLOOKUP-SHARK-WEEK-DownloadableWorkbook01-FINISHED.xlsx (use this one
to see completed answers)
Video #1:
CTable.xlsx (use this to follow
along and do VLOOKUP with Workbook References)
Video #2: (LOOKUP video):
YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-video02-LOOKUPFunction-Start.xlsx (use this one to
follow along and learn)
Video #2: (LOOKUP video):
YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-video02-LOOKUPFunction-Finished.xlsx (use this one
to see completed answers)
Video #3: (INDEX and MATCH video): EMT778.xlsx Start and Finished (use this to follow along and to see the completed solutions).
Video #4: (Approximate V. Exact Match video): VLOOKUP-SHARK-WEEK-Video#4.xlsx Start and Finished (use this to follow along and to see the completed solutions).
Video #5: (CHOOSE Function video):
VLOOKUPWEEKVideo05-START.xlsx (use this one to
follow along and learn)
Video #5: (CHOOSE Function video):
VLOOKUPWEEKVideo05-Finished.xlsx (use this one to see completed answers)
Video #6: (Lookup Picture video):
VLOOKUPWEEKVideo06-Start.xlsx (use this one to
follow along and learn)
Video #6: (Lookup Picture video):
VLOOKUPWEEKVideo06-Finished.xlsx (use this one to see completed answers)
EMT 968-969.xlsx StartFile&FinishedFile.xlsx
EMT989-993Start&FinishFile.xlsm
(if downloads as ".zip" file, simply change extension to ".xlsm")
EMT994-996Start&FinishFile.xlsx
EMT997-999Start&FinishFile.xlsx
EMT1000-1002Start&FinishFile.xlsx
EMT1003-1006Start&FinishFile.xlsx
EMT1007Start&Finished.xlsx
EMT1008-1009Start&Finished.xlsx
EMT1010Start&Finished.xlsx
EMT1011-1012Start&Finished.xlsx
EMT1013-1016Start&Finish.xlsx
EMT1017-1020Start&Finish.xlsx
EMT1021Start&Finish.xlsx
EMT1022Start&Finish.xlsx
EMT1023.xlsx (Start and Finished
File)
EMT1024Start&Finish.xlsx
EMT1025-1027Start&Finish.xlsx
EMT1028Start&Finished.xlsx
EMT1029Start&Finished.xlsx
EMT1030Start&Finished.xlsx
EMT1031Start&Finished.xlsx
EMT1032Start&Finished.xlsx
EMT1033Start&Finished.xlsm (if
downloads as ".zip" file, simply change extension to ".xlsm")
EMT1034Start&Finished.xlsx
EMT1035Start&Finished.xlsx
EMT1036Start&Finished.xlsx
EMT1037Start&Finished.xlsx
EMT1038Start&Finished.xlsx
EMT139-1040Start&Finished.xlsx
EMT1041Start&Finished.xlsx
EMT1042Start&Finished.xlsx
EMT1043-1046Start&Finished.xlsm
(if downloads as ".zip" file, simply change extension to ".xlsm")
EMT1047Start&Finished.xlsx
EMT1048-1051Start&Finish.xlsx
EMT1052Start&Finish.xlsx
EMT1053Start&Finish.xlsx
EMT1054Start&Finish.xlsx
EMT1055Start&Finish.xlsx
EMT1056-1058Start&Finish.xlsx
EMT1059Start&Finished.xlsm (if
downloads as ".zip" file, simply change extension to ".xlsm")
EMT1060Start&Finish.xlsx
EMT1061-1062Start&Finish.xlsx
EMT1063Start.xlsx
EMT1063Finish.xlsx (Answer)
EMT1064-1065Start&Finish.xlsx
EMT1066Start&Finish.xlsx
EMT1067-1068Start&Finish.xlsx
EMT1069-1071Start&Finish.xlsx
EMT1072Start&Finish.xlsx
EMT1073.xlsxStart
EMT1073.xlsxFinish
EMT1074.xlsxFinish
EMT1075.xlsxFinish
EMT1076.xlsxFinish
EMT1077-1078.xlsxStart&Finished
EMT1079-1080.xlsxStart&Finished
No 1081
EMT1082-1083.xlsxStart&Finished
For 1084, download the workbook directly above: "EMT1082-1083"
EMT1085.xlsxStart&Finished
EMT1086-1088xlsxStart&Finished
EMT1089.xlsxStart&Finished
EMT1090.xlsxStart&Finished
EMT1091-1094.xlsxStart&Finished
EMT1095-1097.xlsmStart&Finished
(if downloads as ".zip" file, simply change extension to ".xlsm")
EMT1098-1100.xlsxStart&Finished
EMT1101-1102.xlsxStart&Finished
EMT1103.xlsxStart&Finished
EMT1104.xlsxStart&Finished
EMT1105-1106.xlsxStart&Finished
EMT1107.xlsxStart&Finished
EMT1108-1110.xlsxStart&Finished
EMT1111.xlsxStart&Finish
EMT1112.xlsxStart&Finish
EMT1113-1115.xlsxStart&Finished
EMT1116-1118.xlsxStart&Finished
EMT1119-1121.xlsxStart&Finished
EMT1122.xlsxStart&Finished
EMT1123-1126.xlsxStart&Finished
EMT1127.xlsmStart&Finished (if downloads as
".zip" file, simply change extension to ".xlsm")
EMT1128.xlsxWorkbook01Start
(file name: EMT1128-DataSourceStart.xlsx)
EMT1128.xlsxWorkbook02Start
(file name: EMT1128-AgingStart.xlsx)
EMT1128.xlsxWorkbook01Finished
(file name: EMT1128-DataSourceFinished.xlsx)
EMT1128.xlsxWorkbook02Finished
(file name: EMT1128-AgingFinished.xlsx)
EMT1129-1131.xlsxStart&Finished
EMT1133.xlsxStart&Finished
EMT1134.xlsbStart&Finished
EMT1135.xlsxStart&Finished
EMT1136.xlsxStart&Finished
EMT1137.xlsxStart&Finished
EMT1138-1140.xlsxStart&Finished
EMT1141.xlsxStart
EMT1141.xlsxFinished
EMT1141.accdbStart
EMT1141.accdbFinished
EMT1142.xlsxStart&Finished
EMT1143.xlsxStart&Finished
EMT1144-1145.xlsxStart&Finished
EMT1146.xlsxStart&Finished
EMT1147.xlsxStart&Finished
EMT1148.xlsxStart&Finished
EMT1149.xlsx Start
EMT1149.xlsx Finished
EMT1150.xlsx Start
EMT1150.xlsx Finished
EMT1151.xlsx Start
EMT1151.xlsx Finished
EMT1152.xlsx Start
EMT1152.xlsx Finished
EMT1153.xlsx Start
EMT1153.xlsx Finished
EMT1154.xlsx Start
EMT1154.xlsx Finished
EMT1155.xlsx Start&Finished
EMT1156.xlsx Start&Finished
EMT1157.xlsx Start&Finished
EMT1158.xlsx Start
EMT1158.xlsx Finished (22
MB file)
EMT1158.accdb
(HUGE file - about 84 MB)
EMT1159.xlsx
Start
EMT1159.xlsx
Finished
EMT1160-1161.xlsx Start
& Finished (20 MB File)
EMT1162.xlsx
Start & Finished
EMT1163-1165.xlsx Start & Finished
EMT1166-1168.xlsm Start &
Finished (if downloads as ".zip" file, simply change extension to ".xlsm")
EMT1169-1170.xlsx Start &
Finished
EMT1171 .xlsx Start &
Finished
EMT1172.xlsx Start &
Finished
EMT1173.xlsxStart &
Finished
EMT1174-1176.xlsx Start&Finish
EMT1177.xlsxStart&Finished
EMT1178.xlsxStart&Finished
EMT1179-1180.xlsxStart&Finished
EMT1181.xlsxStart&Finished
EMT1182-1183.xlsxStart&Finished
EMT1184-1185.xlsxStart&Finished
EMT1186-1187.xlsxStart&Finished
EMT1188-1189.xlsxStart&Finished
EMT1190.xlsxStart&Finished
EMT1191-1194.xlsxStart&Finished
EMT1195.xlsxStart&Finished
EMT1196.xlsxStart&Finished
EMT1197.xlsxStart&Finished
EMT1198-1203.xlsxStart&Finished
EMT1204.xlsxStart&Finished
EMT1205.xlsxStart&Finished
EMT1206-1209.xlsxStart&Finished
EMT1210-1214.xlsxStart&Finished
EMT1215.xlsxStart&Finished
EMT1216-1217.xlsxStart&Finished
EMT1218-1220.xlsxStart&Finished
EMT1221-1223.xlsxStart&Finished
EMT1224.xlsmStart&Finished
(if downloads as ".zip" file, simply change extension to ".xlsm")
EMT1225-StartFile-Customer Balances.xlsx
EMT1225-StartFile-LetterToCustomers.docx
EMT1225-FinishedFile-Customer Balances.xlsx
EMT1225-FinishedFile-LetterToCustomers.docx
EMT1226-1227.xlsxStart&Finished
EMT1228-1229.xlsxStart&Finished
EMT1230-1231.xlsxStart
EMT1230-1231.xlsxFinished
EMT1232-1234.xlsxStart&Finished
EMT1235-1238.xlsxStart&Finished
EMT1239-1240.xlsxStart&Finished
EMT1241.xlsxStart&Finished
EMT1242.xlsxStart&Finished
EMT1243.xlsxStart
EMT1243.xlsxFinished
EMT1244.xlsxStart&Finished
EMT1245.xlsxStart&Finished
EMT1246.xlsxStart&Finished
EMT1247-1248.xlsxStart&Finished
EMT1249.xlsxStart&Finished
EMT1250.xisxStart&Finished
EMT1251-1253.xlsxStart&Finished
EMT1254.xlsxStart&Finished
EMT1255-1256.xlsxStart&Finished
EMT1257.xlsxStart
EMT1257.xlsxFinished
EMT1258-1259.xlsxStart&Finished
EMT1260-1262.xlsxStartFinished
Excel Magic Trick
1260.xlsxStart&Finished
EMT1263.xlsxStartFile
EMT1263.xlsxFinishedFile
EMT1264-1265.xlsxStart&Finished
EMT1266-1268.xlsxStart&Finished
EMT1269.xlsxStart
EMT1269.xlsxFinished
EMT1270.xlsxStart&Finished
EMT1271-1272.xlsxStart&Finished
EMT1273-1275.xlsxStart&Finished
EMT1276.xlsxStart&Finished
EMT1277.xlsxStart&Finished
EMT1278-1279.xlsxStart&Finished
EMT1280-1281.xlsxStart&Finished
EMT1282.xlsxStart&Finshed
EMT1283-1285.xlsxStart&Finshed
EMT1286.xlsxStart&Finshed
EMT1287.xlsxStart&Finshed
EMT1288.xlsxStart&Finshed
EMT1289 All 4 Files and Zipped Folders:
EMT1289.xlsxStart&Finished,
EMT1289.csv, USDFile04.csv,
1289CVSFiles.zip
EMT1290 All
4 Files: EMT1290Start.xlsx ,
EMT1290Finished.xlsx ,
EMT1290Start.accdb ,
EMT1290Finished.accdb
EMT1291-1293.xlsxStart&Finished
EMT1294-1295.xlsxStart&Finished
EMT1296.xlsxStart&Finished
EMT1297.xlsxStart&Finished
EMT1298.xlsxStart
EMT1298.xlsxFinished
EMT1299.xlsxStart
EMT1299.xlsxFinished
EMT1300-1302.xlsxStart&Finished
EMT1303-1306.xlsxStart&Finished
EMT1307-1311.xlsxStart&Finished
EMT1312.xlsxStart&Finished
EMT1313.xlsxStart&Finished
EMT1314.xlsxStart&Finished
EMT1315.xlsxStart,
EMT1315.xlsxFinishedVersion
EMT1316.xlsxStart ,
EMT1316.xlsxFinished
EMT1317-1318.xlsxStart&Finished
EMT1319-1320.xlsxStart
EMT1319-1320.xlsxFinished
EMT1321.xlsxStart
EMT1321.xlsxFinished
EMT1322.xlsxStart
EMT1322.xlsxFinished
EMT1322-AccessDatabase
EMT1323.xlsxStart
EMT1323.xlsxFinished
EMT1324.xlsxStart&Finished
EMT1325.xlsxStart
EMT1325.xlsxFinished
EMT1326.xlsxStart
EMT1326.xlsxFinished
EMT1327-1328Start.xlsx
EMT1327-1328Finished.xlsx
EMT1329.xlsxStart
EMT1329.xlsxFinished
EMT1330-Part01Start.xlsx
EMT1330-Part01Finished.xlsx
EMT1330-Part02Start.xlsx
EMT1330-Part02Finished.xlsx
EMT1330-Part03Start.xlsx
EMT1330-Part03Finished.xlsx
EMT1331 files:
1331-Part01-SourceData.zip
1331-Part02-SourceData.zip
San Jose.xlsx
EMT1331-Part01-Start.xlsx
EMT1331-Part01-Finished.xlsx
EMT1331-Part02-Start.xlsx
EMT1331-Part02-Finished.xlsx
EMT1332 files (sames as for 1331, but we use
then with Power BI Desktop):
1331-Part01-SourceData.zip
San Jose.xlsx
1332 Boomerang Inc. 2016-2017 Dashboard.pbix (Finished Power BI Desktop
Dashboard)
EMT1332.xlsx (Just Cover Shot at Introduction of Video)
EMT1333.xlsxStart
EMT1333.xlsxFinished
EMT1334.xlsxStart
EMT1334.xlsxFinished
EMT1335 files:
EMT1335.xlsx
Folder to download, unzip and then use to
try and reestablish refresh connection:
1335TextFiles.zip
EMT1336
files:
EMT1336ConnectionOnlyStart.xlsx
EMT1336ConnectionOnlyFinished.xlsx
EMT1336DataModelFinished.xlsx
EMT1337.xlsxStart
EMT1337.xlsxFinished
EMT1338Start.xlsx
EMT1338Finished.xlsx
EMT1339.xlsxStart
EMT1339.xlsxFinished
EMT1340.xlsxStart&Finished
EMT1341.xlsxStart
EMT1341.xlsxFinished
EMT1342.xlsxStart&Finished
EMT1343.xlsxStart&Finished
EMT1344.xlsxStart&Finished
EMT1345.xlsxStart&Finished
EMT1346.xlsxStart
EMT1346.xlsxFinished
EMT1347.xlsxStart
EMT1347.xlsxFinished
EMT1348.xlsxStart&Finished
EMT1349.xlsmStart
EMT1349.xlsmFinished
EMT1350.xlsxStart
EMT1350.xlsxFinished
EMT1351.xlsxStart
EMT1351.xlsxFinished
EMT1351ZippedFolderWithTextFiles
EMT1352.xlsmStart
EMT1352.xlsmFinished
EMT1353.xlsxStart
EMT1353.xlsxFinished
EMT1354.xlsxStart&Finished
EMT1355.xlsmStart
EMT1355.xlsmFinished
EMT1356.xlsxStart
EMT1356.xlsxFinished
EMT1357:
EMT1357.xlsxStart
1357SourceFiles.zip
EMT1357.xlsxFinished
EMT1358: Download "EMT1349.xlsmFinished" from above
EMT1359.xlsx
EMT 1360 Power BI
Desktop Files:
Source Excel Files:
EMT1360SourceExcelFiles.zip
Excel File:
EMT1360Excel.xlsx
Finished Power BI Desktop File:
1360FinalReport.pbix
EMT1361.xlsxFinished
EMT1362.xlsxStart
EMT1363 Files:
EMT1363Start.xlsx
EMT1363Finished.xlsx
1363PicturePage (Don't Download - web
address used in video to access pictures)
EMT1364 Files:
EMT1364.xlsx
1364-PowerBI-DesktopFinishedFile.pbix
EMT1365 Files:
EMT1365.xlsx
1365PowerBIDesktop.pbix
EMT1366 Files:
EMT1366Files.zip (Text Files, Excel Files, Access Files, PowerBI Files)
Published Power BI Report (New Web Page with Example
of Published Power BI Report)
EMT1367 Files:
EMT1367.xlsx
Start PBI File:
PowerBIEMT1367-DAX-CALENDAR-Table-START.pbix
Finished
PBI File:
PowerBIEMT1367-DAX-CALENDAR-Table-FINISHED.pbix
EMT1368.xlsx
EMT1369.xlsx
EMT1370-1371.xlsxStart&Finished
EMT1372.xlsxStart
EMT1372.xlsxFinished
EMT1373.xlsxStart&Finished
EMT1374.xlsxStart&Finished
EMT1375.xlsxStart
EMT1375.xlsxFinished
EMT1376.xlsxStart&Finished
EMT1377.xlsxStart&Finished
EMT1378:
EMT1378.xlsxStart
EMT1378.xlsxFinished
EMT1378-TimeArrayFormulas.xlsm
EMT1379:
EMT1379.xlsxStart
EMT1379.xlsxFinished
Video17ImportTextFiles-05.zip
EMT1380.xlsxStart
EMT1380.xlsxFinished
EMT1381.xlsxStart
EMT1381.xlsxFinished
EMT1382.xlsxStart
EMT1382.xlsxFinished
EMT1383.xlsmStart&Finished
EMT1384:
EMT1384Start.xlsx
EMT1384Finished.xlsx
1384SourceDataSheet.xlsx
1384SourceDataTable.xlsx
EMT1385Start.xlsx (0.002
MB)
EMT1385Finished.xlsx
(130 MB)
EMT1386 Files:
EMT1386Start.xlsx (130 MB)
EMT1386-ImportTestData-2018.txt (56 MB - 0.9 Millions transactions)
EMT1386Finished.xlsx
(146 MB)
EMT1387Start.xlsx (146 MB)
EMT1387Finished.xlsx
(147 MB)
EMT1388.xlsxStart&Finished
EMT1389-90.xlsxStart&Finished
EMT1391.xlsmStart&Finished
EMT1392.xlsxStart
EMT1392.xlsxFinished
EMT1393-94.xlsxStart&Finished
EMT1394Part02.xlsxStart&Finished
EMT1395.xlsxStart
EMT1395.xlsxFinished
EMT1396-97.xlsxStart&Finished
EMT1397 Part 2.xlsxStart&Finished
EMT1397 Part 3.xlsxStart&Finished
EMT1398.xlsxStart
EMT1398.xlsxFinished
EMT1399-40.xlsxStart&Finished
(This file has EMT 1399 and EMT 1400)
EMT1400 Part 2.xlsxStart&Finished
EMT1400 Part
2-Timing.xlsm
EMT1401.xlsmStart&Finished
EMT1402.xlsxStart&Finished
EMT1402 Part 2 And 3 Start.xlsx
EMT1402 Part 2 And 3 Finished.xlsx
EMT1402 Part 4.xlsxStart&Finished
EMT1402 Part 5.xlsxStart&Finished
EMT1403.xlsxStart
EMT1403.xlsxFinished
EMT1404.xlsxStart&Finished
EMT1405.xlsxStart&Finished
EMT1406.xlsxStart&Finished
EMT1407Start.xlsx
EMT1407Finished.xlsx
... Example from John:
EMT1407PQ-ExampleFromJohnThomas.xlsx
EMT1408Start.xlsx
EMT1408Finished.xlsx
EMT1409Start.xlsx
EMT1409Finished.xlsx
EMT1410.xlsxStart&Finished
EMT1411StartFile.xlsx
EMT1412Start.xlsx
EMT1412Finished.xlsx
EMT1413Start.xlsx
EMT1413Finished.xlsx
EMT1414Start.xlsx
EMT1414Finished.xlsx
EMT1415Start.xlsx
EMT1415Finished.xlsx
EMT1416.xlsx
EMT1417.xlsx
EMT1418Start.xlsx
EMT1418Finished.xlsx
EMT1419Start.xlsx
EMT1419Finished.xlsx
EMT1420StartFile.xlsx
EMT1420FinishedFile.xlsx
EMT1421.xlsx
EMT1422Start.xlsx
EMT1422Finished.xlsx
EMT1423Start.xlsx
EMT1423Finished.xlsx
EMT1424Start.xlsx
EMT1424Finished.xlsx
EMT1425-1426.xlsx
EMT1427Start.xlsx
EMT1427Finished.xlsx
EMT1428.xlsx
EMT1429Start.xlsx
EMT1429Finished.xlsx
EMT1430Start.xlsx
EMT1430Finished.xlsx
EMT1431.xlsx
EMT1432Start.xlsx
EMT1432Finished.xlsx
EMT1433Start.xlsx
EMT1433Finished.xlsx
EMT1434Start.xlsx
EMT1434Finished.xlsx
EMT1435Start.xlsx
EMT1435Finished.xlsx
EMT1436Start.xlsx
EMT1436Finished.xlsx
EMT1437Start.xlsx
EMT1437Finished.xlsx
EMT1438-1439Start.xlsx
EMT1438-1439Finished.xlsx
EMT1440Start.xlsx
EMT1440Finished.xlsx
EMT1441-1442Start.xlsx
EMT1441-1442Finished.xlsx
EMT1443Start.xlsx
EMT1443Finished.xlsx
EMT1444-1445.xlsx
EMT1444-Part02.xlsx
EMT1446Start.xlsx
EMT1446Finished.xlsx
EMT1447Start.xlsx
EMT1447Finished.xlsx
EMT1448.xlsx
EMT1449Start.xlsx
EMT1449Finished.xlsx
1449BigDataTimeTest.xlsx
EMT1450Start.xlsx
EMT1450Finished.xlsx
EMT1451Start.xlsx
EMT1451Finished.xlsx
EMT1452Start.xlsx
EMT1452Finished.xlsx
EMT1453.xlsx
EMT1454Start.xlsx
EMT1454Finished.xlsx
EMT1455-1456.xlsx
EMT1457.xlsx
EMT1458Start.xlsx
EMT1458Finished.xlsx
EMT1459.xlsx
EMT1460.xlsx
EMT1461.xlsx
EMT1462.xlsx
EMT1463.xlsx
EMT1464.xlsx
EMT1465.xlsx
EMT1466-1467.xlsx
EMT
1468 Files:
EMT1468.xlsm
EMT1468Finished.xlsm
EMT1468TextFiles.zip
EMT1469.xlsx
EMT
1470 Files:
EMT1470Start.xlsx
EMT1470Finished.xlsx
1470TextDataFiles.zip
EMT1471Start.xlsx
EMT1470Finished.xlsx
EMT1472-1473.xlsx
EMT1474.xlsx
EMT1475Start.xlsx
EMT1475Finished.xlsx
EMT1476.xlsx
EMT1477-1478.xlsx
EMT1479-1481.xlsx
EMT1482.xlsx
EMT1483-1487.xlsx
EMT1489.xlsx
EMT
1490 Files:
EMT1490Start.xlsx
EMT1490Finished.xlsx
EMT1490Start.pbix
EMT1490Finished.pbix
No EMT1491 file
EMT1492Start.xlsx
EMT1492Finished.xlsx
EMT1493Start.xlsx
EMT1493Finished.xlsx
EMT1494Start.xlsx
EMT1494Finished.xlsx
EMT1495Start.xlsx
EMT1495Finished.xlsx
EMT1495-Part02-Start.xlsx
EMT1495-Part02-Finished.xlsx
EMT1496Start.pbix
EMT1496Finished.pbix
EMT1498-SourceModel.xlsx (Source Data Tables)
EMT-1498-PowerBIDesktopPowerQuery.pbix (Finished Power BI File)
EMT1499-1500.xlsx
EMT1501-1502.xlsx
EMT1501Part02.xlsx
No
EMT1503 file
EMT1504.xlsx
No EMT1505 file
EMT1506Start.xlsx
EMT1506Finished.xlsx
EMT1507.xlsx
EMT 1508 Files:
EMT1508-dEmployeeTextFile.txt
EMT1508StartFile.xlsx
EMT1508FinishedFile.xlsx
EMT1509.xlsx
EMT1510.xlsx
EMT1511.xlsx
EMT1512.xlsx
EMT1513.xlsx
EMT1514:
StartFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx
FinishedFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx
EMT1515:
EMT1515Start.xlsx
EMT1515Finished.xlsx
EMT1516-ModernArrayFormulas-DynamicArrays.xlsx
EMT1518-1523.xlsx
EMT1524-1525.xlsx
1525-SpilledArrayConverstions.xlsx
EMT1526-1527.xlsx
EMT1528.xlsx
EMT1529.xlsx
EMT1530-1531.xlsx
EMT 1532 and 1532 Part 02:
EMT1532.xlsx
EMT1533:
EMT1533Start.xlsx
EMT1533Finished.xlsx
EMT1534-1535.xlsx
EMT1536:
EMT1536Start.xlsx
EMT1536Finished.xlsx
EMT1536TextFiles.zip
EMT1537.xlsx
EMT1538-1542.xlsx
EMT1543.xlsx
EMT1545.xlsx
EMT1546.xlsm Text file:
GEStockPricesEMT1546.txt
EMT1547-1548.xlsx
EMT1549-1550.xlsx
EMT1551.xlsx
EMT1552Start.xlsx and
EMT1552Finished.xlsx
EMT1553Start.xlsx and
EMT1553Finished.xlsx
EMT1554Start.xlsx and
EMT1554Finished.xlsx
EMT1555
EMT1556-1560.xlsx
EMT1561:
EMT1561.xlsx
EMT1561Start.pbix
EMT1561Finished.pbix
EMT1562.xlsx
EMT1563-1564.xlsx
EMT1565-1566.xlsx
EMT1567-1570.xlsx
EMT
1571:
EMT1571Start.xlsx
EMT1571Finished.xlsx
EMT1572.xlsx
EMT1573-1574.xlsx
EMT1575.xlsx
EMT1576.xlsx
EMT1577-1578.xlsx
EMT1579-1580:
EMT1579-1580.xlsx
Textfiles for EMT 1580:
EMT1580TextFiles.zip
EMT1581-1583.xlsx
EMT1584.xlsx
EMT1585-1587.xlsx
EMt1588.xlsx
EMT1589.xlsx
EMT1590-1591.xlsx
EMT1592.xlsx
EMT1593.xlsx
EMT1594-1595.xlsx
EMT1596.xlsx
EMT1597.xlsx
EMT1598.xlsx
EMT1599.xlsx
EMT1600.xlsx
EMT1600Finished.xlsx
EMT1601-1602.xlsx
EMT1603-1605.xlsx
1606-FilesForDownload.zip
EMT1607Start.xlsx
EMT1607Finished.xlsx
EMT1608.xlsx
EMT1609.xlsx
EMT1610.xlsx
EMT1611.xlsx
EMT1612.xlsx
EMT1613.xlsx
EMT1614.xlsx
EMT 1615:
EMT1615Start.xlsx
EMT1615Finished.xlsx
EMT1616:
EMT1616Start.xlsm
EMT1616Finished.xlsm
1617:
EMT1617.xlsx (From excelisfun)
EMT1617_GDE.xlsx (From
Geert)
Split on caps
Peter B.xlsx (From Peter B)
EMT1618.xlsx
EMT 1619:
EMT1619.xlsx
EMT1619-TextFile.txt
EMT1619-TextFile.csv
EMT1620.xlsx
EMT1621:
EMT1621-Start.xlsx
EMT1621-Finished.xlsx
EMT1622:
EMT1622-Start.xlsx
EMT1622-Finished.xlsx
EMt1623:
EMT1623Start.xlsx
EMT1623Finished.xlsx
EMT1624
EMT1624-Start.xlsx
EMT1624-Finished.xlsx
EMT1625.xlsx
EMT1626:
EMT1626-Start.xlsx
EMT1626-Finished.xlsm
EMT1627.xlsx
EMT1628-2019ChristmasExcelTreeGoTeam.xlsx
EMT1629.xlsx
EMT1630.xlsx
EMT 1631:
EMT1631.xlsx
EMT1631Part02TimeTwoLookupValueFormulas.xlsx
EMT1632.xlsx
EMT1633.xlsx
EMT1634.xlsx
EMT1635.xlsx
EMT1636.xlsx
EMT1637.xlsx
EMT1638:
EMT1638TextFile.txt
EMT1638Start.xlsx
EMT1638Finished.xlsx
EMT1639.xlsx
EMT1641.xlsx
EMT1642.xlsx
EMT1643.xlsx
EMT1644:
EMT1644Start.xlsx
EMT1644Finished.xlsx
EMT1645.xlsx
EMT1646.xlsx
EMT1647.xlsx
EMT1648.xlsx
EMT1649.xlsx
EMT1650.xlsx
EMT1651.xlsx
EMT1652.xlsx
EMT1653.xlsm
EMT1654.xlsx
EMT1655.xlsx
EMT1656-1658:
EMT1656-1658Start.xlsx
EMT1656-1658Finished.xlsx
1658TextFiles.zip
EMT1659:
ZippedTextFiles:
1659TextFiles.zip
Finished Power BI Desktop File:
CrossTabReportEMT1659.pbix
EMT1660:
Start Excel
File: EMT1660Start.xlsx
Zipped Excel Files for Import:
ExcelFiles.zip
Finished Excel File:
EMT1660Finished.xlsx
EMT1661.xlsx
No file for
1662
EMT1663.xlsx
EMT1664.xlsx
EMT1665.xlsx
No file for
1666.
EMT 1667:
EMT1667Start.xlsx
EMT1667Finished.xlsx
1667Files.zip
EMT1668.xlsx
EMT1669.xlsx
EMT1670.xlsx
EMT1671.xlsx
EMT1672.xlsx
Basic Excel Business Analytics: Highline BI 348 Class
Download files for video #01:
BI348Chapter01.pptx
Download files for video #02-11:
BI348Chapter07.pptx
BI348Chapter07Start.xlsm
BI348Chapter07Finished.xlsm
BI348Chapter07-SecondFile.xlsx
Excel'sGoldenRule.docx
Download files for video #12-26:
BI348Chapter02.pptx
BI348Chapter02Start.xlsx
BI348Chapter02Finished.xlsx
NormalDistributionExcelFunctionsEmpirical RuleNotes.pdf
Download files for video #27:
BI348-Chapter02.5-ExcelDataTransformMethods.xlsx
BI348-Chapter02.5-ExcelDataTransformMethodsFinished.xlsx
Download files for videos #28 & 29 & 30:
Import-01-TxtCvsFiles.zip
BI348-Chapter02.5-Import01-TextFiles.xlsx
BI348-Chapter02.5-Import01-TextFilesFinished.xlsx
BI348-Chapter02.5-Import01-TextFilesFinishedNoDataModel.xlsx
Download files for video #31:
Import-02-ExcelFilesOneSheetEach.zip
BI348-Chapter02.5-Import02.xlsx
BI348-Chapter02.5-Import02Finished.xlsx
Download files for videos #32:
Import-03-ExcelFilesMultipleSheetsEach.zip
BI348-Chapter02.5-Import03.xlsx
BI348-Chapter02.5-Import03Finished.xlsx
Download files for videos #33:
Import-04-ExcelNotProperDataSets.zip
BI348-Chapter02.5-Import04.xlsx
BI348-Chapter02.5-Import04Finished.xlsx
Download files for videos #34:
Import-05-SeparateFileTypes.zip
BI348-Chapter02.5-Import05.xlsx
BI348-Chapter02.5-Import05Finished.xlsx
Download files for videos #35:
BI348-Chapter02.5-Import06.xlsx
BI348-Chapter02.5-Import06Finished.xlsx
Download files for videos #36 & 37:
BI348-Chapter02.5-Import07.xlsx
BI348-Chapter02.5-Import07Finished.xlsx
Download files for videos #38:
Import-08-4MillionsRowsIntoDataModel.zip
BI348-Chapter02.5-Import08-TextFiles.xlsx
BI348-Chapter02.5-Import08-TextFilesFinished.xlsx
BI348-Chapter02.5-Import08-ExcelFiles.xlsx
BI348-Chapter02.5-Import08-ExcelFilesFinished.xlsx
Download files for videos #39:
Import-09-SalesTable.txt
Import-09-SR-RegionTable.xlsx
BI348-Chapter02.5-Import09.xlsx
BI348-Chapter02.5-Import09Finished.xlsx
Download files for videos #40 & 41:
BI348-Chapter02.75-PowerPivot.pptx
BI348-Chapter02.75Example01Start.xlsx
BI348-Chapter02.75Example01Finished.xlsx
Download files for videos #42:
BI348-Chapter02.75Example02-SourceData.zip
BI348-Chapter02.75Example02Start.xlsx
BI348-Chapter02.75Example02Finished.xlsx
Download files for videos #43:
BI348-Chapter03.pptx
Chapter03/BI348Chapter03.xlsx
Download files for video #44-52:
BI348-Chapter04.xlsm
BI348-Chapter04.pptx
Linear Regression Slope Deductive Proof.pdf (If you want)
Download files for video #52-56:
BI348-Chapter05.xlsx
BI348-Chapter05.pptx
Download files for video #57-63:
BI348-Chapter08.xlsx
BI348-Chapter08.pptx
Download files for videos #64-69:
Chapter11/BI348-Chapter11.pptx
BI348-Chapter11-Video64-IntroToSimulation.xlsx
BI348-Chapter11-Video65-CreatingRandomVariables.xlsx
BI348-Chapter11-Video66-NewProduct.xlsx
BI348-Chapter11-Video67-MarketingAnalysis.xlsx
BI348-Chapter11-Video68-ConstructionSequentialProject.xlsx
BI348-Chapter11-Video69-Baseball.xlsx
Excel 2013 Statistics Class Series (Excel 2010 and 2007 Statistics Series further down)
Excel2013StatisticsChapter00.xlsx
Excel2013StatisticsChapter01.xlsm
Excel2013StatisticsChapter02.xlsx
Grades.zip
Excel2013StatisticsChapter03.xlsm
Excel2013StatisticsChapter04.xlsm
Ch04PDFBusn210.pdf
Excel2013StatisticsChapter05.xlsm
Excel2013StatisticsChapter05SecondFile.xlsm
Excel2013StatisticsChapter05ThirdFile.xlsm
Ch05PDFBusn210.pdf
Excel2013StatisticsChapter06.xlsm
Ch06PDFBusn210.pdf
Ch06PDFBusn210ExcelFunctionsAndFormulas.pdf
Excel2013StatisticsChapter07.xlsm
Excel2013StatisticsChapter07-Second.xlsm
Ch07PDFBusn210.pdf
Busn210ch08.xlsm
<<==different name convention from the earlier Excel workbooks
Ch08pdf-Busn210.pdf
Busn210ch09-First.xlsm
<<==different name convention from the earlier Excel workbooks
Busn210ch09-Second.xlsm
<<==different name convention from the earlier Excel
workbooks
Ch09PDFBusn210.pdf
Ch09PDFBusn210-JustFormulas.pdf
Excel2013StatisticsChapter10.xlsm
Ch10PDFBusn210.pdf
Excel2013StatisticsChapter11.xlsx
Ch11PDFBusn210.pdf
Excel2013StatisticsChapter12.xlsm
Ch12PDFBusn210.pdf
Excel 2010 Statistics Class Series (Excel 2007 Statistics Series further down)
Busn210Excel2010Chapter00ExcelBasics.xlsm
Busn210Excel2010ChartsAndWhenToUseThem.pdf <<== Right-click and point to
"Save Target As"
Busn210Excel2010Chapter01.xlsm
Busn210Excel2010Chapter02.xlsm
Excel2010StatisticsCh03.xlsm (when you download file
name is "Excel2010StatisticsCh03correct.xlsm")
Excel2010StatisticsCh03SecondFile.xlsm
Excel2010StatisticsCh03ThirdFile.xlsm
Busn210ch04.xlsm
(Excel 2010 Statistics Series Chapter 4)
Busn210ch04SecondFile.xlsm
(Excel 2010 Statistics Series Chapter 4 second file)
StatsBusn210Ch04.pdf <<== Right-click and point to
"Save Target As"
Busn210ch05.xlsm
(Excel 2010 Statistics Series Chapter 5)
StatsBusn210Ch05.pdf
<<== Right-click and point to "Save Target As"
Busn210ch06.xlsm
Busn210Ch06.pdf,
and two others with Updates For Excel 2010 Functions:
Excel 2010 Normal Probability Functions.pdf and
Excel 2010 Exponential Probability Function.pdf
Busn210ch07.xlsm
Busn210Ch07.pdf
Busn210ch08.xlsm
Busn210h08.pdf
Busn210ch09-First.xlsm
Busn210ch09-Second.xlsm (huge file 10 MB -
has many pictures)
Ch09Busn210.pdf
(47 pages - full handwritten notes from Michael Girvin)
Short-FormulasAndProceduresCh09Busn210.pdf (7pages -
just Formulas and Procedures)
more soon...
Busn210Ch04Start&FinishedFile
Busn210Ch04HandwrittenNotes(pdfFile)
Busn210Ch05Start&FinishedFile
Busn210Ch05HandwrittenNotes(pdfFile)
Busn210Ch06 Start&FinishedFile
(Big File 3.3 MB)
Busn210Ch06HandwrittenNotes(pdfFile)
Busn210Ch07 Start&FinishedFile
Busn210Ch07HandwrittenNotes(pdfFile)
Busn210Ch08 Start&FinishedFile
Busn210Ch08HandwrittenNotes(pdfFile)
Busn210Ch09 Start&FinishedFile
Busn210Ch09HandwrittenNotes(pdfFile)
Excel Finance Class Series:
Finance&ExcelCh00ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh00.pdf HandwrittenNotes(pdfFile)
Finance&ExcelCh01.pdf
HandwrittenNotes(pdfFile)
Finance&ExcelCh01EconomistArticle about Whether Markets are
Free, Efficient or Rational (.pdf)
Finance&ExcelCh02ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh02.pdf
HandwrittenNotes (Banking Note)
Finance&ExcelCh02.pdf:
HandwrittenNotes (Deductive Proof For Cash Flow Identity)
Ch02PowerPoint: (Notes about Cash Flow Identity)
Chapter02Word:
(Question about market incentives)
Finance&ExcelCh03ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh03.pdf HandwrittenNotes(pdfFile)
2ndExcelFileForCashCycleCh03ExcelWorkbook.xlsx
Start&FinishedFile
2ndPdfFileForCashCycleCh03.pdf
Start&FinishedFile
Finance&ExcelCh04ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh04.pdf HandwrittenNotes(pdfFile)
Finance&ExcelCh05ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh05.pdf HandwrittenNotes(pdfFile)
DeductiveProof.pdf
Finance&ExcelCh06ExcelWorkbook.xlsx
Start&FinishedFile
Busn233Ch06-SecondFileExcelWorkbook.xlsx
Start&FinishedFile
Busn233Ch06-ThirdFileExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh06.pdf HandwrittenNotes(pdfFile)
Finance&ExcelCh07ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh07.pptPowerPoints
Finance&ExcelCh07.pdf HandwrittenNotes(pdfFile)
Finance&ExcelCh08ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh08.pptPowerPoints
Finance&ExcelCh09ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh09.pptxPowerPoints
Finance&ExcelCh10ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh10.pptxPowerPoints
Finance&ExcelCh11ExcelWorkbook.xlsx
Start&FinishedFile
Finance&ExcelCh11.pptxPowerPoints
1st Excel Workbook:
Excel2010BusnMathCh03.xlsm
2nd Excel Workbook:
Excel2010BusnMathCh03-SECTION-3.5.xlsm
BusnMathCh03-Final.pdf
Ch 3 Percent Video Drawings Sections 3.1 & 3,2 & 3.3 & 3.4.pptx
Ch03 Video Drawings Fractional Percentages To Decimals.pptx
Ch 3 Percent Video Drawings Sections 3.5.pptx
Chapter 4: Note: file says
Ch04, but it is really Ch05
Excel2010BusnMathCh04.xlsm
(Chapter in the textbook is 5, but workbook
says 4!!!)
Chapter 6:
Excel2010BusnMathCh06.xlsx
Chapter 7:
Excel2010BusnMathCh07.xlsx
Chapter 8:
Excel2010BusnMathCh08.xlsx
Busn135Ch04.xlsStartFile
Busn135Ch04.xlsFinishedFile
Busn135Ch05.xlsStartFile
Busn135Ch05.xlsFinishedFile
Busn135Ch06.xlsStart&FinishedFile
Busn135Ch06HandwrittenNotes.pdf
Busn135Ch07.xlsStart&FinishedFile
Busn135Ch07HandwrittenNotes.pdf
Busn135Ch08.xlsStart&FinishedFile
Busn135Ch08HandwrittenNotes.pdf
Busn135Ch09.xlsStart&FinishedFile
Busn135Ch09HandwrittenNotes.pdf
Busn135Ch10.xlsStart&FinishedFile
Busn135Ch10HandwrittenNotes.pdf
Excel Basics (EB) for Excel 2016:
EB01-Gradebook-Finished.xlsx
Office2016Class13-ExcelBasics01-IntroductionToExcel01.pdf
EB02-NetIncomeProjections.xlsx
Office2016Class14-ExcelBasics02-IntroductionToExcel02.pdf
EB03-CountingAddingWithCriteria.xlsx
EB03-CountingAddingWithCriteriaFinished.xlsx
Office2016Class15-ExcelBasics03-IntroductionToExcel03.pdf
EB04-SUMIFSandPivotTables.xlsx
Office2016Class16-ExcelBasics04-IntroductionToExcel04.pdf
EB05-PivotTableCalculationsLayout.xlsx
Office2016Class17-ExcelBasics05PivotTableCalculationsLayout.pdf
EB06-08QATKeyboardsDefaultAlign.xlsx
Office2016Class18-20-ExcelBasics06-08QATKeyboardDefaultAlign.pdf
EB09-NumberFormattingAndROUND.xlsm
Office2016Class21-ExcelBasics09-NumberFormattingAndROUND.pdf
EB10DateTimeNumberFormattingAndCalculations.xlsm
Office2016Class22-ExcelBasics10-DateTimeNumberFormatAndCalculations.pdf
EB11SearchForFunctions.xlsm
Office2016Class23-ExcelBasics11-SearchForFunctions.pdf
EB12-FormulaElements.xlsm
Office2016Class24-ExcelBasics12-FormulaElements.pdf
EB13-IF-FunctionAnd-IS-Functions.xlsm
Office2016Class25-ExcelBasics13-IF-FunctionAndIs-Function.pdf
EB14-VLOOKUPFunction.xlsm
Office2016Class26-ExcelBasics14-VLOOKUPFunction.pdf
EB15-ExcelTableFeature.xlsm
Office2016Class27-ExcelBasics15-VExcelTableFeature.pdf
EB16MixedCellReferences.xlsm
Office2016Class28-ExcelBasics16-MixedCellReferences.pdf
EB17StyleFormatting.xlsm
Office2016Class29-ExcelBasics17-StyleFormatting.pdf
EB18-DefinedNamesStartFile.xlsm
EB18-DefinedNamesFinishedFile.xlsm
Office2016Class30-ExcelBasics18-DefinedNames.pdf
EB19-SUMIFSandSimilarFunctions.xlsm
Office2016Class31-ExcelBasics19-SUMIFSandSimilarFunctions.pdf
EB20-PivotTablesStart.xlsm
EB20-PivotTablesFinished.xlsm
Office2016Class32-ExcelBasics20PivotTables.pdf
EB21-PivotTablesRelationshipsStart.xlsm
EB21-PivotTablesRelationshipsFinished.xlsm
EB21-PivotTablesVLOOKUPFinished.xlsm
Office2016Class33-ExcelBasics21PivotTablesRelationships.pdf
EB22-DefaultPivotTableLayoutExcel2016.xlsx
Office2016Class34-ExcelBasics22DefaultPivotTableLayoutExcel2016.pdf
EB23-SortFilterFlashFillStart.xlsx
EB23-SortFilterFlashFillFinished.xlsx
Office2016Class35-ExcelBasics23SortFilterFlashFill.pdf
EB24Charts.xlsm
Office2016Class36-ExcelBasics24Charts.pdf
EB25GetAndTransformPowerQueryStart.xlsm
EB25GetAndTransformPowerQueryFinished.xlsm
EB25FileDownloads.zip
Office2016Class37-ExcelBasics25-PowerQueryGetAndTransform.pdf
ExcelDynamicChartsSeries12-16StartFile
ExcelDynamicChartsSeries12-16FinishedFile
Excel and Law Exercises 1 - 3 Start&FinishFile
ReinemerGregoryPhysicsClassHighlineCommunityCollege.xlsx Start&FinishFile
GregoryExcelLesson01-04.xlsx Start&FinishFile
SlayingExcelDragonPaperBookIsOut.xlsxStart&FinishFile
WorkbookExcelMagicTricks776(Rank Function From Two Columns)StartFile&FinishedFile (.xlsx file format)
Highline Community College Science Seminer May 20, 2011: SomeOfTheWondersOfExcel.xlsx StartFile&FinishedFile
Northwest Accounting Educators Conference 2011 -- Excel 2010 20 New Features
NWAE2015-Excel2013-PivotTablesSTART-FILE.xlsx
500000RowsSourceDataToImport.xlsx
ImportBigDataWithPowerQueryToConnectionBuildPT.xlsx
Downlaod FINISHED files:
NWAE2015-Excel2013-PivotTablesFINISHED-FILE.xlsx
ImportBigDataWithPowerQueryToConnectionBuildPTFinished.xlsx
Download Data Source File:
HugeDataSetHighlineCollegeProDevDay.xlsx
Highline College Professional Developement Day
2015: Using Excel to Calculate Grades -
Many Cool Ticks, Seminar Oct 16, 2015
Download file:
Using Excel to Calculate Grades - Many Cool Ticks.xlsx (This file
included the start templates and the finisjhed examples after the video is
completed)
Finished File with Completed Examples AFTER the video was completed Done :
The Magic Of Excel High School Excel Seminar Finished File.xlsx
Excel Workbook with over 4000 searchable Excel Videos from Mr Excel & excelisfun: ListOfAllYouTubeExcelVideosThatCanPlayInExcelWorkbook.xlsm also, workbook with code to get YouTube Links: GetVideoLinksFromPlaylistVBACode.xlsm
Completed and Ready To Use BMX State Point Workbook: BMXStatePointTracker.xlsx
Goeff Turck Accounting Class workbook file: Geoff_Turck_BudgetingExcelAccountingVideo.xlsx
E W T M
Accounting Excel Seminar, Seattle, WA: START FILE Used To
Follow Along With Video:
E W T M Accounting Excel Seminar-StartFileSoYouCanFollowAlong.xlsx
E
W T M Accounting Excel Seminar, Seattle, WA: FINISHED FILE
(Completed Examples From After Video Is Completed):
E W T M Accounting Excel SeminarAllFinishedExamplesAfterVideoDone.xlsm
Excel TV Episode 7 Excel workbook:
YouTubeExcelIsFun/ExcelTVEpisode07.xlsx
Highline Chemistry Videos:
HighlineChemistryVideoNumber01-03.xlsx
Highline Match 146 Statistics
Class:
Math146-Excel2013PivotTables&ChartsForDescriptiiveStatistics-AustinRoberts.xlsx
Poodle Dog Excel CPE Credit
Download:
Start File:
WondersOfExcel2013ForCPECreditAtThePoodleDogRestaurant-Start.xlsx (Workbook with blank templates)
Download: Finished File:
WondersOfExcel2013ForCPECreditAtThePoodleDogRestaurant-Answer.xlsx (Completed Examples of Video Demonstrations)
WAAT: Washington Association of Accounting & Tax Preparation Excel Seminar
August 26, 2016 files:
Lookup Formulas:
WAAT-LookupFormulas-Start&Finished-08-26-2016-Accounting Seminar.xlsx
WAAT-LookupFormulas-08-26-2016-Accounting Seminar.pdf
PivotTables:
WAAT-PivotTables-Start-08-26-2016-Accounting Seminar.xlsx
WAAT-PivotTables-Finished-08-26-2016-Accounting Seminar.xlsx
WAAT-PivotTables-08-26-2016-Accounting Seminar.pdf
CWU Lynnwood Accounting Excel Seminar Files:
CWUExcelForAccountantsVLOOKUPivotTablesSTART-FILE.xlsx
CWUExcelForAccountantsVLOOKUPivotTablesFINISHED-FILE.xlsx
CWU Des Moines Accounting Excel Seminar Files:
CWUDesMoines-StartFile-ExcelForAccountants-April.xlsx
CWUDesMoines-FinishedFile-ExcelForAccountants-April.xlsx
CWUAllExcelFiles.zip
Excel Accounting Seminar: 2017 WAATP Tacoma Accounting Conferences
at La Quinta Inn, July 12 :
Excel Start File:
WAATP2017TacomaAccountingExcelConferenceStart.xlsx
Excel Finished File:
WAATP2017TacomaAccountingExcelConferenceFinished.xlsx
Finished Data Model File for Last Example in Video 02:
WAATP2017TacomaAccountingExcelConferenceStartDataModel.xlsx
Zipped Folder with Text Files for Video #2:
WAATP2017-ExcelFiles.zip
Video #3 Zipped Folder:
WAATP2017-Power-BI-Desktop-TextFiles.zip
Video #3
Excel File:
WAATP2017-Power-BI-Desktop-Example-Start.xlsx
SeaTac Accounting Seminar May 01, 2018:
Excel Start File:
StartFile-ExcelForAccountants-May01.xlsx
Excel Finished File:
FinishedFile-ExcelForAccountants-May01.xlsx
Zipped Folder:
AccountingMay01AllExcelFiles.zip
Excel Hash Video:
Start File:
excelisfunExcelHashVideo01-StartFile.xlsm
Data
Source File:
BestCityAwardTable.xlsx
Finished File:
excelisfunExcelHashVideo01-FinishedFile.xlsm
Test: 01NewModleFromMikeGirvin.zip
Excel: The Only App That Matters Book Files: ExcelTheOnlyAppThatMattersFiles.zip
Test 2: HelperTableToSortPivotSlicer02.xlsm