Excel Is Fun!

27/12/2018 Excel is Fun!
YouTube link:
Click here to go to the ExcelIsFun You Tube Site
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)
2) excelisfun-Finished.xlsm (file to use for whole book)
3) excelisfun-Finished-File-Video-Series.xlsm (file slightly different than book version)
4) MayNetIncome.xlsm (file for pages 195 - 198)
5) Products.zip (files in zipped folder for Impioart Data section pages 497 - 461)
6) Homework files Chapters 1 - 9 (103 Practice Homework problems)
Get Slaying Excel Book at:

Amazon
MrExcel.com
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:

CtrlShiftEnterExtraWorkbook01.xlsm

Appendix 3 Array Formula Examples Workbook:
CtrlShiftEnterAppendixExamples.xlsx
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!)
https://people.highline.edu/mgirvin/ExcelIsFun.htm 1/31
Office (Word, Excel PowerPoint, Access) Files, Go To This Link:

https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm

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
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
Highline Excel 2016 Class 08 Text Functions.pdf
Highline Excel 2016 Class 09 Date Functions.pdf
Highline Excel 2016 Class 10 Data Validation.pdf
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
Highline Excel 2016 Class 15 Excel Charts.pdf
Busn218-Charts.pptx
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
Highline Excel 2016 Class 18 Clean Transform Data Replace Flash Fill TTC Formulas.pdf
Highline Excel 2016 Class 19 Transform Data Sets Advanced Filter.pdf
Video20-3ExcelFilesImport.zip
Highline Excel 2016 Class 20 Clean Transform & Import Excel Workbook Data with Power Query.pdf
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
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
Highline Excel 2016 Class 26 Recorded Macros.pdf
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
Week2Busn214Workbook2StartFile
Week4Busn214StartZippedFolder
Week6Busn214StartFile&FinishedFile
(File name is: Busn214SIBWMOE2007Chapter02andChartsfromMGirvin.xls)
Week8Busn214Workbook2StartFile
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 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:
Video #12:
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)
Excel Magic Tricks Series:
WorkbookExcelMagicTricks0110StartFile

WorkbookExcelMagicTricks0110FinishedFile

no workbook for 2389






WorkbookExcelMagicTricks185202StartFile (Also includes Tricks 203 & 204)

WorkbookExcelMagicTricks185202FinishedFile (Also includes Tricks 203 & 204)

WorkbookExcelMagicTricks203210StartFile (These include a different 203 & 204, Opps!)

WorkbookExcelMagicTricks203210FinishedFile (These include a different 203 & 204, Opps!)
WorkbookExcelMagicTricks295DropDownListStartFile
WorkbookExcelMagicTricks295DropDownListFinishedFile
WorkbookExcelMagicTricks295SourceDataStartFile
WorkbookExcelMagicTricks295SourceDataFinishedFile
DataForSUMIF.xlsDataFile

extract to new workbook w formula.xlsDataFile
WorkbookExcelMagicTricks316StartFile&FinishedFile

ProductData.xlsDataFile



WorkbookExcelMagicTricks343 No workbook for this one

2WorkbookExpandableTableTwoWatLookup.xlsDataFileForTrick356










StartWordFileForExcelMagicTrick542StartFile




WorkbookExcelMagicTricks604607StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks623625StartFile&FinishedFile (.xlsx file format)

WorkbookExcelMagicTricks636639StartFile (.xlsx file format)

WorkbookExcelMagicTricks636639FinishedFile (.xlsx file format)

WorkbookExcelMagicTricks640643(DOES NOT INCLUDE 640)StartFile&FinishedFile (.xlsx file format)



WorkbookExcelMagicTricks661671StartFile&FinishedFile (.xlsx file format) (Amazing AGGREGATE function!)

WorkbookExcelMagicTricks757.5&758.5StartFile&FinishedFile (.xlsx file format)

WorkbookExcelMagicTricks761770StartFile&FinishedFile (.xlsx file format) (No 770 in this workbook)

WorkbookExcelMagicTricks776(Rank Function From Two Columns)StartFile&FinishedFile (.xlsx file format)

WorkbookExcelMagicTricks777.5StartFile&FinishedFile (.xlsx file format)

WorkbookExcelMagicTricksSourceData777.5StartFile&FinishedFile (.xlsx file format)

4 Year Old Makes RAND Conditional Format Bubble ChartStartFile&FinishedFile (.xlsx file format)


1stWorkbookExcelMagicTricks806811StartFile&FinishedFile (.xlsm file format)
2ndWorkbookExcelMagicTricks806811StartFile&FinishedFile (.xlsm file format)
1stWorkbookExcelMagicTricks812StartFile(.xlsx file format)

2ndWorkbookExcelMagicTricks812FinishedFile(.xlsx file format)



826827 No Workbook




WorkbookExcelMagicTricks866 StartFile&FinishedFile (.xlsx file format)


GLAccounts workbook for EMT876StartFile&FinishedFile (.xlsx file format)


WorkbookExcelMagicTricks920 StartFile&FinishedFile

WorkbookExcelMagicTricks921 StartFile&FinishedFile.xlsx

WorkbookExcelMagicTricks923Start .xlsm (Start File without code))

WorkbookExcelMagicTricks923Finished .xlsm (Finished File with code)
WorkbookExcelMagicTricks924 StartFile&FinishedFile.xls

WorkbookExcelMagicTricks925Start .xlsm (Start File Only there is no finished file)

WorkbookExcelMagicTricks934 StartFile.xlsx

WorkbookExcelMagicTricks934 FinishedFile.xlsx



source files for EMT945:

SourceData1.xlsx SourceData2.xlsx

WorkbookExcelMagicTricks944.5 StartFile&FinishedFile.xlsx


WorkbookExcelMagicTricks949 StartFile&FinishedFile.xlsx (Excel 2013 Preview)
WorkbookExcelMagicTricks955 StartFile.xlsx (Excel 2013 Preview)
WorkbookExcelMagicTricks955 FinishedFile.xlsx (Excel 2013 Preview)

Workbook EMT 958959.xlsx
Workbook EMT 960963.xlsx
EMT964966.xlsx
EMT 967
EMT 968-969.xlsx StartFile&FinishedFile.xlsx

EMT 970.xlsx StartFile&FinishedFile.xlsx
EMT971975 StartFile&FinishedFile.xlsx
EMT978StartFile&FinishedFile.xlsx

EMT981Start&FinishFile.xlsx

EMT982Start&FinishFile.xlsm (if downloads as ".zip" file, simply change extension to ".xlsm")

EMT989993Start&FinishFile.xlsm (if downloads as ".zip" file, simply change extension to ".xlsm")
EMT1007Start&Finished.xlsx


EMT10131016Start&Finish.xlsx

EMT1023.xlsx (Start and Finished File)


EMT1033Start&Finished.xlsm (if downloads as ".zip" file, simply change extension to ".xlsm")






EMT1063Start.xlsx

EMT1063Finish.xlsx (Answer)

EMT1073.xlsxStart
EMT1073.xlsxFinish
EMT1074.xlsxFinish
EMT1075.xlsxFinish
EMT1076.xlsxFinish

EMT10771078.xlsxStart&Finished
No 1081


For 1084, download the workbook directly above: "EMT10821083"

EMT10861088xlsxStart&Finished


EMT10951097.xlsmStart&Finished (if downloads as ".zip" file, simply change extension to ".xlsm")


EMT1111.xlsxStart&Finish
EMT1112.xlsxStart&Finish



EMT1128.xlsxWorkbook01Start (file name: EMT1128DataSourceStart.xlsx)
EMT1128.xlsxWorkbook02Start (file name: EMT1128AgingStart.xlsx)

EMT1128.xlsxWorkbook01Finished (file name: EMT1128DataSourceFinished.xlsx)
EMT1128.xlsxWorkbook02Finished (file name: EMT1128AgingFinished.xlsx)
EMT1134.xlsbStart&Finished

EMT1141.xlsxStart

EMT1141.xlsxFinished
EMT1141.accdbStart

EMT1141.accdbFinished

EMT1149.xlsx Start

EMT1149.xlsx Finished
EMT1150.xlsx Start

EMT1151.xlsx Start

EMT1152.xlsx Start

EMT1153.xlsx Start

EMT1154.xlsx Start


EMT1155.xlsx Start&Finished
EMT1158.xlsx Start

EMT1158.xlsx Finished (22 MB file)

EMT1158.accdb (HUGE file about 84 MB)
EMT1159.xlsx Start


EMT11601161.xlsx Start & Finished (20 MB File)
EMT1162.xlsx Start & Finished


EMT11661168.xlsm Start & Finished (if downloads as ".zip" file, simply change extension to ".xlsm")
EMT1171 .xlsx Start & Finished
EMT1173.xlsxStart & Finished
EMT11741176.xlsx Start&Finish







EMT1225StartFileCustomer Balances.xlsx
EMT1225-StartFile-LetterToCustomers.docx
EMT1225-FinishedFile-Customer Balances.xlsx
EMT1225-FinishedFile-LetterToCustomers.docx
EMT1226-1227.xlsxStart&Finished
EMT1230-1231.xlsxStart
EMT1230-1231.xlsxFinished
EMT1243.xlsxStart
EMT1250.xisxStart&Finished
EMT1257.xlsxStart
EMT1260-1262.xlsxStartFinished
Excel Magic Trick 1260.xlsxStart&Finished
EMT1263.xlsxStartFile
EMT1263.xlsxFinishedFile
EMT1269.xlsxStart
EMT1282.xlsxStart&Finshed
EMT1283-1285.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
EMT1298.xlsxStart
EMT1299.xlsxStart
EMT1315.xlsxStart, EMT1315.xlsxFinishedVersion
EMT1316.xlsxStart , EMT1316.xlsxFinished
EMT1319-1320.xlsxStart
EMT1319-1320.xlsxFinished
EMT1321.xlsxStart
EMT1322.xlsxStart
EMT1322-AccessDatabase
EMT1323.xlsxStart
EMT1325.xlsxStart
EMT1326.xlsxStart
EMT1327-1328Start.xlsx
EMT1327-1328Finished.xlsx
EMT1329.xlsxStart
EMT1330-Part01Start.xlsx
EMT1330-Part01Finished.xlsx
EMT1331 files:
1331-Part01-SourceData.zip
San Jose.xlsx
EMT1331-Part01-Start.xlsx
EMT1331-Part01-Finished.xlsx
EMT1332 files (sames as for 1331, but we use then with Power BI Desktop):
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
EMT1334.xlsxStart
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
EMT1338Start.xlsx
EMT1338Finished.xlsx
EMT1339.xlsxStart
EMT1341.xlsxStart
EMT1346.xlsxStart
EMT1347.xlsxStart
EMT1349.xlsmStart
EMT1349.xlsmFinished
EMT1350.xlsxStart
EMT1351.xlsxStart
EMT1351ZippedFolderWithTextFiles
EMT1352.xlsmStart
EMT1353.xlsxStart
EMT1355.xlsmStart
EMT1356.xlsxStart
EMT1357:
EMT1357.xlsxStart
1357SourceFiles.zip
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
EMT1362.xlsxStart
EMT1363 Files:
EMT1363Start.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
EMT1372.xlsxStart
EMT1375.xlsxStart
EMT1378:
EMT1378.xlsxStart
EMT1378-TimeArrayFormulas.xlsm
EMT1379:
EMT1379.xlsxStart
Video17ImportTextFiles-05.zip
EMT1380.xlsxStart
EMT1381.xlsxStart
EMT1382.xlsxStart
EMT1383.xlsmStart&Finished
EMT1384:
EMT1384Start.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)
EMT1387Start.xlsx (146 MB)

EMT1392.xlsxStart
EMT1394Part02.xlsxStart&Finished
EMT1395.xlsxStart
EMT1397 Part 2.xlsxStart&Finished
EMT1398.xlsxStart
EMT1399-40.xlsxStart&Finished (This file has EMT 1399 and EMT 1400)
EMT1400 Part 2-Timing.xlsm
EMT1402 Part 2 And 3 Start.xlsx
EMT1402 Part 2 And 3 Finished.xlsx
EMT1403.xlsxStart
EMT1407Start.xlsx
EMT1407Finished.xlsx ... Example from John: EMT1407PQ-ExampleFromJohnThomas.xlsx
EMT1408Start.xlsx
EMT1409Start.xlsx
EMT1411StartFile.xlsx
EMT1412Start.xlsx
EMT1413Start.xlsx
EMT1414Start.xlsx
EMT1415Start.xlsx
EMT1416.xlsx
EMT1417.xlsx
EMT1418Start.xlsx
EMT1419Start.xlsx
EMT1420FinishedFile.xlsx
EMT1421.xlsx
EMT1422Start.xlsx
EMT1423Start.xlsx
EMT1424Start.xlsx
EMT1425-1426.xlsx
EMT1427Start.xlsx
EMT1428.xlsx
EMT1429Start.xlsx
EMT1430Start.xlsx
EMT1431.xlsx
EMT1432Start.xlsx
EMT1433Start.xlsx
EMT1434Start.xlsx
EMT1435Start.xlsx
EMT1436Start.xlsx
EMT1437Start.xlsx
EMT1440Start.xlsx
EMT1443Start.xlsx
EMT1444-1445.xlsx
EMT1444-Part02.xlsx
EMT1446Start.xlsx
EMT1447Start.xlsx
EMT1448.xlsx
EMT1449Start.xlsx
1449BigDataTimeTest.xlsx
EMT1450Start.xlsx
EMT1451Start.xlsx
EMT1452Start.xlsx
EMT1453.xlsx
EMT1454Start.xlsx
EMT1455-1456.xlsx
EMT1457.xlsx
EMT1458Start.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
1470TextDataFiles.zip
EMT1471Start.xlsx
EMT1472-1473.xlsx
EMT1474.xlsx
EMT1475Start.xlsx
EMT1476.xlsx
EMT1477-1478.xlsx
EMT1479-1481.xlsx
EMT1482.xlsx
EMT1483-1487.xlsx
EMT1489.xlsx
EMT 1490 Files:
EMT1490Start.xlsx
EMT1490Start.pbix
EMT1490Finished.pbix
No EMT1491 file
EMT1492Start.xlsx
EMT1493Start.xlsx
EMT1494Start.xlsx
EMT1495Start.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
EMT1507.xlsx
EMT 1508 Files:
EMT1508-dEmployeeTextFile.txt
EMT1508FinishedFile.xlsx
EMT1509.xlsx
EMT1510.xlsx
EMT1511.xlsx
EMT1512.xlsx
EMT1513.xlsx
EMT1514:
StartFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx
FinishedFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx
EMT1515:
EMT1515Start.xlsx
EMT1516-ModernArrayFormulas-DynamicArrays.xlsx
EMT1518-1523.xlsx
EMT1524-1525.xlsx
1525-SpilledArrayConverstions.xlsx
EMT1526-1527.xlsx
EMT1528.xlsx
EMT1529.xlsx
EMT1530-1531.xlsx
EMT1532.xlsx
EMT1533:
/EMT1533Start.xlsx
Mr Excel & excelisfun Series:

WorkbookForMrExcel&excelisfunTrick01&02Start&Finished
WorkbookForMrExcel&excelisfunTrick03Start&Finished
WorkbookForMrExcelexcelisfunTrick15Start&Finished
WorkbookForMrExcelexcelisfunTrick21.xlsxFinished (2007/2010 file type)
WorkbookForMrExcelexcelisfunTrick23.xlsxFinished (2007/2010 file type)
WorkbookForMrExcelexcelisfunTrick42FinishedFromBillMrExcelJelen
WorkbookForMrExcelexcelisfunTrick42FinishedFromExcelisfun
Trick48 No Workbook
No Trick 49
WorkbookForMrExcelexcelisfunTrickLiveDuelStart&Finished
WorkbookForMrExcelexcelisfunTrick58.5Start&Finished
WorkbookForMrExcelexcelisfunTrick63Start
WorkbookForMrExcelexcelisfunTrick63Finished
No #65
WorkbookForMrExcelexcelisfunTrick69-72Start&Finished
MrExcelExcelisfunTrick80.xlsmFinished
MrExcelExcelisfunTrick81.xlsmStart&Finished
MrExcelExcelisfunTrick83.xlsmStart&Finished - Only excelisfun Helper Column and PivotTable solution (no PowerPivot)
MrExcelExcelisfunTrick85.xlsxStart&Finished
MrExcelExcelisfunTrick93 - MrExcel VBA.xlsmStart&Finished
MrExcelExcelisfunTrick93 - excelisfun.xlsmStart&Finished
MrExcelExcelisfunTrick99.xlsmStart&Finished (Just has finished Macros from Mr Excel and excelisfun) (if file downloads as ".zip",
change extension to ".xlsm")
None for 104
MrExcelExcelisfunTrick105.xls - From Bill "Mr Excel" Jelen Start&Finished
MrExcelExcelisfunTrick105.xlsx - From excelsifun Start&Finished
MrExcelExcelisfunTrick-TruelWithExcelisfunner-113.xlsxStart&Finished (Isaac, Bill, Mike: Excelisfunner, MrExcel, excelisfun)
MrExcelExcelisfunTrick116.xlsmStart&Finished ( .xlsm file type --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick120.xlsxStart&Finish
MrExcelExcelisfunTrick123.xlsStart&Finish
MrExcelExcelisfunTrick127.xlsmStart&Finish ( .xlsm file type --- If downloads as zip, change file extension from .zip to .xlsm)
none for 144
none for 146
MrExcelExcelisfunTrick161FromMikeExcelisfunGirvin.xlsxStart&Finish
MrExcelExcelisfunTrick161FromBillMrExcelJelen.xlsxStart&Finish
MrExcelExcelisfunTrick167xlsmStart&Finish ( .xlsm file type --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick168xlsmStart&Finish
MrExcelExcelisfnTrick172.xlsxStart&Finished
MrExcelexcelisfunTrick174.xlsxStart&Finished
Excelisfunner Mr Excel Excelsifun Truel 06.xlsxStart&Finished
MrExcelExcelisfunTrick176.5.xlsxStart&Finished (Second Attempt at 176)
...No 178,179...
MrExcelExcelisfunTrick183.xlsm
No 184...
MrExcelExcelisfunTrick187.xlsx
MrExcelExcelisfunTrick188.xlsm (just excelisfun Data Model example) and MrExcelExcelisfunTrick188Duel188.xlsm (the other 4
examples)

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

BI348Chapter02.pptx
BI348Chapter02Start.xlsx
BI348Chapter02Finished.xlsx
NormalDistributionExcelFunctionsEmpirical RuleNotes.pdf

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
Import-02-ExcelFilesOneSheetEach.zip
BI348-Chapter02.5-Import02.xlsx
BI348-Chapter02.5-Import02Finished.xlsx
Download files for videos #32:
Import-03-ExcelFilesMultipleSheetsEach.zip
Import-04-ExcelNotProperDataSets.zip
Import-05-SeparateFileTypes.zip
Download files for videos #36 & 37:
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
Import-09-SalesTable.txt
Import-09-SR-RegionTable.xlsx
Download files for videos #40 & 41:

BI348-Chapter02.75-PowerPivot.pptx
BI348-Chapter02.75Example01Start.xlsx
BI348-Chapter02.75Example01Finished.xlsx

BI348-Chapter02.75Example02-SourceData.zip
BI348-Chapter02.75Example02Start.xlsx
BI348-Chapter02.75Example02Finished.xlsx

BI348-Chapter03.pptx
Chapter03/BI348Chapter03.xlsx

BI348-Chapter04.xlsm
Linear Regression Slope Deductive Proof.pdf (If you want)

BI348-Chapter05.xlsx

BI348-Chapter08.xlsx
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
Grades.zip
Ch04PDFBusn210.pdf
Excel2013StatisticsChapter05SecondFile.xlsm
Excel2013StatisticsChapter05ThirdFile.xlsm
Ch05PDFBusn210.pdf
Ch06PDFBusn210.pdf
Ch06PDFBusn210ExcelFunctionsAndFormulas.pdf
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
Ch10PDFBusn210.pdf
Ch11PDFBusn210.pdf
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)
Busn210ch14.xlsx
more soon...
Excel 2007 Business Statistics Class Series

IMPORTANT NOTE ABOUT PIVOT TABLES: IF YOU ARE USING EXCEL 2007, because these all have the file
extension ".xls", if you want the Pivot Tables to look the same as in the videos, after you create the Pivot Table,
right-click the Pivot Table, point to Pivot Table Options, click on the Display tab, then uncheck the checkbox
“Classic Pivot Table layout”.
Busn210Ch00StartFile
Busn210Ch00FinishedFile
Busn210Ch02ExtraFrequencyDistributionNotesStart&FinishedFile
Busn210Ch03ExtraArithmeticMeanVs.GeometricMeanStart&FinishedFile
Busn210Ch04Start&FinishedFile
Busn210Ch04HandwrittenNotes(pdfFile)
Busn210Ch05Start&FinishedFile
Busn210Ch06 Start&FinishedFile (Big File 3.3 MB)

Busn210Ch07 Start&FinishedFile
Excel Finance Class Series:

Finance&ExcelCh00ExcelWorkbook.xlsx Start&FinishedFile
Finance&ExcelCh00.pdf HandwrittenNotes(pdfFile)
Finance&ExcelCh01EconomistArticle about Whether Markets are Free, Efficient or Rational (.pdf)
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)
2ndExcelFileForCashCycleCh03ExcelWorkbook.xlsx Start&FinishedFile
2ndPdfFileForCashCycleCh03.pdf Start&FinishedFile
DeductiveProof.pdf
Busn233Ch06-SecondFileExcelWorkbook.xlsx Start&FinishedFile
Busn233Ch06-ThirdFileExcelWorkbook.xlsx Start&FinishedFile
Finance&ExcelCh07.pptPowerPoints
Finance&ExcelCh08.pptPowerPoints
Finance&ExcelCh09.pptxPowerPoints
Excel 2010 Business Math Series (Busn 135):

Chapter 0:
Excel2010-135Chapter00.xlsm
Chapter 1:
Excel2010BusnMathCh01.xlsm
Chapter 2:
BusnMathCh02.pdf
Fraction Video Drawings Chapter 2.pptx
Homework Chapter 2.pptx
Chapter 3:
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:
Chapter 8:
Chapter 9:
Busn135Ch09.pdf
Chapter 10:
BusnMathCh10.pdf
BusnMathCh10secondfile.pdf
FV PV 01.tiff (Drawing 1 seen in video 83)
FV PV 02.tiff (Drawing 2 seen in video 83)
Chapter 11:
Busn135-Ch11.ppt
Excel Business Math Class Series (2003 and 2007):

Busn135Ch00.xlsStartFile
Busn135Ch00.xlsFinishedFile
Busn135Ch01HandwrittenNotes.pdf
Busn135Ch01LCMandQUOTIENTfunctions.doc
Busn135Ch06.xlsStart&FinishedFile
Excel Basics (EB) for Excel 2016:

EB01-Gradebook-Finished.xlsx
Office2016Class13-ExcelBasics01-IntroductionToExcel01.pdf
EB02-NetIncomeProjections.xlsx
EB03-CountingAddingWithCriteria.xlsx
EB03-CountingAddingWithCriteriaFinished.xlsx
EB04-SUMIFSandPivotTables.xlsx
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

YouTubers Love Excel Series:

WorkbookYouTubersLoveExcel9-12StartFile
WorkbookYouTubersLoveExcel9-12FinishedFile
WorkbookYouTubersLoveExcel13-16Start&FinishFile
WorkbookYouTubersLoveExcel26.2-30StartFile
WorkbookYouTubersLoveExcel26.2-30FinishedFile
YouTubeExcelIsFun/DynamicChartForExcelWithNames
Excel Dynamic Chart Series:

ExcelDynamicChartsSeriesStartFile
ExcelDynamicChartsSeriesFinishedFile
ExcelDynamicChartsSeries12-16StartFile
ExcelDynamicChartsSeries12-16FinishedFile
Other Excel Series:

TheBeautyOfExcelStart&FinishFile
WorkbookExcelFinanceTricksStartFile
WorkbookExcelFinanceTricksFinishedFile
WorkbookExcelLookupFunctionsSeriesStartFile
WorkbookExcelLookupFunctionsSeriesFinishedFile
WorkbookExcelNameTricksSeriesStartFile
WorkbookExcelNameTricksSeriesFinishedFile
WorkbookExcelArrayFormulaSeriesStartFile
WorkbookExcelArrayFormulaSeriesFinishedFile
WorkbookIgor'sPhysicsClassScatterDiagramFinishedFile
WorkbookExcelFormulaEfficiencySeriesStartFile (HUGE FILE 16 MB)

WorkbookExcelFormulaEfficiencySeriesFinishedFile (HUGE FILE 16 MB)
WorkbookExcel2010PreviewTricks01-08FinishedFile
Formula Inputs, Cell References and Assumption Tables
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: NAE-Excel2010.xlsm
Northwest Accounting Educators Conference 2012: -- Advanced Excel Accounting and Finance: Advanced Excel for Accounting
and Finance - Northwest Accounting Educators Conference 2012.xlsm
Northwest Accounting Educators Conference 2013: -- What's New In Excel 2013:

Download: START Excel Workbook.xlsm (Workbook with blank templates)
Download: FINISHED Excel Workbook.xlsm (Completed Examples of Video Demonstrations)
Download: Workbook with Array Formula and PowerPivot comparision
Northwest Accounting Educators Conference 2015: -- Excel 2013 PivotTables from A to Z:

Download START files:
NWAE2015-Excel2013-PivotTablesSTART-FILE.xlsx
500000RowsSourceDataToImport.xlsx
ImportBigDataWithPowerQueryToConnectionBuildPT.xlsx
Downlaod FINISHED files:

NWAE2015-Excel2013-PivotTablesFINISHED-FILE.xlsx
ImportBigDataWithPowerQueryToConnectionBuildPTFinished.xlsx
Northwest Accounting Educators Conference 2015: -- Excel 2013 PivotTables from A to Z: NWAE2015-PivotTAbles-
WorkbookSTART-FILE.xlsx
Highline Community College Professional Development Day 2011 (Tricks To Make Your Job Easier):
Highline Community College Professional Development Day 2012 (Data Analysis in Excel):
Download: Access file for importing example: StudentData.accdb
Download: CSV file for importing example:StudentData.txt
Highline Community College Professional Development Day 2013 (What's New In Excel 2013): Seminar September 17, 2013
and Professional Development Day October 18, 2013:
Download: START Excel Workbook.xlsx (Workbook with blank templates)
Download: FINISHED Excel Workbook.xlsx (Completed Examples of Video Demonstrations)
Highline College Professional Development Day 2014: (PivotTables Are Easy, Excel 2013 Version)
Download: Start File: PivotTablesAreEasyHighlineCollegeProDevDayStartFile.xlsx (Workbook with blank templates)
Download: Finished File: PivotTablesAreEasyHighlineCollegeProDevDayFinishedFile.xlsx (Completed Examples of Video
Demonstrations)
Download Data Source File: HugeDataSetHighlineCollegeProDevDay.xlsx
Download Finished Example of 4th file created during video: PowerPivot-BigDataIsMadeSmallFinished.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)
Highline Community College Library Quarterly Staff Meeting Top Ten Library Excel Questions : TopTenLibraryExcelTricks.xlsx
Highline Community College Make Formulas Do What You Want Seminar September 20, 2013:
ExcelFormulasMakeThemDoWhatYouWant.xlsx
Highline College High School Excel Seminar:

File to Download and Use While Watching Video: The Magic Of Excel High School Excel Seminar.xlsx
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:

ExcelForAccountantsVLOOKUPivotTablesSTART-FILE.xlsx
ExcelForAccountantsVLOOKUPivotTablesFINISHED-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


Excel Is Fun!

Uploaded by

Copyright:

Available Formats

Excel Is Fun!

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Excel Is Fun!

Uploaded by

Copyright:

Available Formats

What Excel files are mentioned?

What Excel files are mentioned?

What Excel functions or topics are discussed?

What Excel functions or topics are discussed?

27/12/2018 Excel is Fun!

Slaying Excel Dragons Book Download ﬁles:

Get Slaying Excel Book at:

Extra Workbooks From YouTube Videio Series:

Free Classes From Microsoft: http://www.microsoftvirtualacademy.com/?mtag=MVP4040052

Excel Basics Series Download ﬁles:

Ofﬁce (Word, Excel PowerPoint, Access) Files, Go To This Link:

Highline Excel 2016 Class Series:

Busn218-Video03-Start.xlsm and Busn218-Video03-Finished.xlsm and Video03TextFilesForImport.zip

Busn218-Video04Start.xlsm and Busn218-Video04Finished.xlsm and May Net Income.xlsx

Highline Excel 2013 Class Series:

Highline Excel 2007 Class Series:

PowerPivot Excel 2013 Series

Video #2 Start File 1: PowerPivot02-01-LotsOfNonNormalizedData.xlsx

Video #3 Start File 1: PowerPivot03-01ReplaceVLOOKUPwExcel2013RelationshipsStart.xlsx

Video #4 Start File: PowerPivot04-ArrayFormulaOrPowerPivot-Start.xlsx

Video #5 Start File 1: PowerPivot05-SourceTablesInExcelStart.xlsx

Video #6 Access Source Data File 1: PowerPivot06-SourceData.accdb

Video #7 Start File: PowerPivot07GroupingDatesCalendarTableStart.xlsx

Video #8 Start File: PowerPivot08EditExistingConnectionsImportNewDataStart.xlsx

Video #9 Start File: PowerPivot09-CalculatedFieldsStart.xlsx

Video #10 Start File: PowerPivot10-CALCULATE-Start.xlsx

Video renamed: PowerPivot #12 (ﬁle names still the same):

Excel Power Query:

Video #02 Files:

Video #03 Files:

Video #04 Files:

Video #05 Files:

Video #06 Files:

Video #08 Files:

Video #09 Files:

Video #10 Files:

VLOOKUP "Shark" Week Downloadable Workbooks

Video #2: (LOOKUP video): YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-video02-LOOKUPFunction-Start.xlsx (use this one

EMT 968-969.xlsx StartFile&FinishedFile.xlsx

EMT1385Start.xlsx (0.002 MB)

EMT1387Start.xlsx (146 MB)

Mr Excel & excelisfun Series:

Excelisfunner Mr Excel Excelsifun Truel 06.xlsxStart&Finished

Basic Excel Business Analytics: Highline BI 348 Class

Download ﬁles for video #02-11:

Download ﬁles for video #12-26:

Download ﬁles for video #27:

Download ﬁles for videos #40 & 41:

Download ﬁles for videos #42:

Download ﬁles for videos #43:

Download ﬁles for video #44-52:

Download ﬁles for video #52-56:

Download ﬁles for video #57-63:

Download ﬁles for videos #64-69:

Busn210ch08.xlsm <<==different name convention from the earlier Excel workbooks

Busn210ch09-First.xlsm <<==different name convention from the earlier Excel workbooks

Excel2010StatisticsCh03.xlsm (when you download ﬁle name is "Excel2010StatisticsCh03correct.xlsm")

Busn210ch04.xlsm (Excel 2010 Statistics Series Chapter 4)