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!)

 

 
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

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

 

 

Highline Excel 2007 Class Series:

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)

 

Excel Magic Tricks Series:
WorkbookExcelMagicTricks01-10StartFile
WorkbookExcelMagicTricks01-10FinishedFile
WorkbookExcelMagicTricks11-22StartFile
Workbook
ExcelMagicTricks11-22FinishedFile
EMT70FinishedFile
no workbook for 23-89

WorkbookExcelMagicTricks90StartFile
WorkbookExcelMagicTricks90FinishedFile
WorkbookExcelMagicTricks91-99StartFile
WorkbookExcelMagicTricks91-99FinishedFile
WorkbookExcelMagicTricks100StartFile
WorkbookExcelMagicTricks100FinishedFile
WorkbookExcelMagicTricks101-106StartFile
WorkbookExcelMagicTricks101-106FinishedFile
WorkbookExcelMagicTricks107-119StartFile
WorkbookExcelMagicTricks107-119FinishedFile
WorkbookExcelMagicTricks120-132StartFile
WorkbookExcelMagicTricks120-132FinishedFile
WorkbookExcelMagicTricks133-145StartFile
WorkbookExcelMagicTricks133-145FinishedFile
WorkbookExcelMagicTricks146-154StartFile
WorkbookExcelMagicTricks146-154FinishedFile
WorkbookExcelMagicTricks155-167StartFile
WorkbookExcelMagicTricks155-167FinishedFile
WorkbookExcelMagicTricks168-174StartFile
WorkbookExcelMagicTricks168-174FinishedFile
WorkbookExcelMagicTricks175-184StartFile
WorkbookExcelMagicTricks175-184FinishedFile
WorkbookExcelMagicTricks185-202StartFile (Also includes Tricks 203 & 204)
WorkbookExcelMagicTricks185-202FinishedFile
(Also includes Tricks 203 & 204)
WorkbookExcelMagicTricks203-210StartFile (These include a different 203 & 204, Opps!)
WorkbookExcelMagicTricks203-210FinishedFile (These include a different 203 & 204, Opps!)
WorkbookExcelMagicTricks211-214StartFile
WorkbookExcelMagicTricks211-214FinishedFile
WorkbookExcelMagicTricks215-217StartFile
WorkbookExcelMagicTricks215-217FinishedFile
WorkbookExcelMagicTricks218-220StartFile
WorkbookExcelMagicTricks218-220FinishedFile
WorkbookExcelMagicTricks221-229StartFile
WorkbookExcelMagicTricks221-229FinishedFile

WorkbookExcelMagicTricks230-232StartFile
WorkbookExcelMagicTricks230-232FinishedFile
WorkbookExcelMagicTricks233-245StartFile
WorkbookExcelMagicTricks233-245FinishedFile
WorkbookExcelMagicTricks246-251StartFile
WorkbookExcelMagicTricks246-251FinishedFile
WorkbookExcelMagicTricks252-260StartFile
WorkbookExcelMagicTricks252-260FinishedFile
WorkbookExcelMagicTricks261-264StartFile
WorkbookExcelMagicTricks261-264FinishedFile
WorkbookExcelMagicTricks265-267StartFile
WorkbookExcelMagicTricks265-267FinishedFile
WorkbookExcelMagicTricks268-275StartFile
WorkbookExcelMagicTricks268-275FinishedFile
WorkbookExcelMagicTricks276-284StartFile
WorkbookExcelMagicTricks276-284FinishedFile
WorkbookExcelMagicTricks285-294StartFile
WorkbookExcelMagicTricks285-294FinishedFile
WorkbookExcelMagicTricks295DropDownListStartFile
WorkbookExcelMagicTricks295DropDownListFinishedFile
WorkbookExcelMagicTricks295SourceDataStartFile
WorkbookExcelMagicTricks295
SourceDataFinishedFile
WorkbookExcelMagicTricks296-301StartFile
WorkbookExcelMagicTricks296-301FinishedFile
WorkbookExcelMagicTricks302-306StartFile
WorkbookExcelMagicTricks302-306FinishedFile
WorkbookExcelMagicTricks307-315StartFile
DataForSUMIF.xlsDataFile
extract to new workbook w formula.xlsDataFile
WorkbookExcelMagicTricks307-315FinishedFile
WorkbookExcelMagicTricks316StartFile&FinishedFile
WorkbookExcelMagicTricks317-323StartFile
WorkbookExcelMagicTricks317-323FinishedFile
WorkbookExcelMagicTricks324-326StartFile&FinishedFile
WorkbookExcelMagicTricks327-328StartFile&FinishedFile
WorkbookExcelMagicTricks329-331StartFile&FinishedFile
WorkbookExcelMagicTricks332-334StartFile
ProductData.xlsDataFile
WorkbookExcelMagicTricks332-334FinishedFile
WorkbookExcelMagicTricks335-336StartFile
WorkbookExcelMagicTricks335-336FinishedFile
WorkbookExcelMagicTricks337StartFile&FinishedFile
WorkbookExcelMagicTricks338StartFile
WorkbookExcelMagicTricks338FinishedFile
WorkbookExcelMagicTricks339-341StartFile&FinishedFile
WorkbookExcelMagicTricks342StartFile&FinishedFile
WorkbookExcelMagicTricks343 No workbook for this one
WorkbookExcelMagicTricks344-348StartFile&FinishedFile
WorkbookExcelMagicTricks349-352StartFile&FinishedFile
WorkbookExcelMagicTricks353-356StartFile&FinishedFile
2WorkbookExpandableTableTwoWatLookup.xlsDataFileForTrick356
WorkbookExcelMagicTricks357StartFile&FinishedFile
WorkbookExcelMagicTricks358-369StartFile&FinishedFile
WorkbookExcelMagicTricks370StartFile&FinishedFile
WorkbookExcelMagicTricks371-376StartFile&FinishedFile
WorkbookExcelMagicTricks377-380StartFile&FinishedFile
WorkbookExcelMagicTricks381-386StartFile&FinishedFile
WorkbookExcelMagicTricks387-393StartFile&FinishedFile
WorkbookExcelMagicTricks394-396StartFile&FinishedFile
WorkbookExcelMagicTricks397StartFile&FinishedFile
WorkbookExcelMagicTricks398-405StartFile&FinishedFile
WorkbookExcelMagicTricks406StartFile&FinishedFile
WorkbookExcelMagicTricks407-414StartFile&FinishedFile
WorkbookExcelMagicTricks415-422StartFile&FinishedFile
WorkbookExcelMagicTricks423-430StartFile&FinishedFile
WorkbookExcelMagicTricks431-439StartFile&FinishedFile
WorkbookExcelMagicTricks440-451StartFile&FinishedFile
WorkbookExcelMagicTricks452StartFile&FinishedFile
WorkbookExcelMagicTricks453-457StartFile&FinishedFile
WorkbookExcelMagicTricks458-465StartFile&FinishedFile
WorkbookExcelMagicTricks466-471StartFile&FinishedFile
WorkbookExcelMagicTricks472-473StartFile&FinishedFile
WorkbookExcelMagicTricks474StartFile&FinishedFile
WorkbookExcelMagicTricks475-477StartFile&FinishedFile
WorkbookExcelMagicTricks478-479StartFile&FinishedFile
WorkbookExcelMagicTricks480StartFile&FinishedFile
WorkbookExcelMagicTricks481-483StartFile&FinishedFile
WorkbookExcelMagicTricks484-489StartFile&FinishedFile
WorkbookExcelMagicTricks490-493StartFile&FinishedFile
WorkbookExcelMagicTricks494-501StartFile&FinishedFile
WorkbookExcelMagicTricks502-505StartFile&FinishedFile
WorkbookExcelMagicTricks506StartFile
WorkbookExcelMagicTricks506FinishedFile
WorkbookExcelMagicTricks507StartFile
WorkbookExcelMagicTricks507FinishedFile
WorkbookExcelMagicTricks508-513StartFile&FinishedFile
WorkbookExcelMagicTricks514-515StartFile&FinishedFile
WorkbookExcelMagicTricks516-523StartFile&FinishedFile
WorkbookExcelMagicTricks524-530StartFile&FinishedFile
WorkbookExcelMagicTricks531-533StartFile&FinishedFile
WorkbookExcelMagicTricks534-536StartFile&FinishedFile
WorkbookExcelMagicTricks537-538StartFile&FinishedFile
WorkbookExcelMagicTricks537-538StartFile&FinishedFile
WorkbookExcelMagicTricks539-550StartFile&FinishedFile
StartWordFileForExcelMagicTrick542StartFile
WorkbookExcelMagicTricks551-557StartFile&FinishedFile
WorkbookExcelMagicTricks558-562StartFile&FinishedFile
WorkbookExcelMagicTricks563-567StartFile&FinishedFile
WorkbookExcelMagicTricks568-569StartFile&FinishedFile
WorkbookExcelMagicTricks570-574StartFile&FinishedFile
WorkbookExcelMagicTricks575-578StartFile&FinishedFile
WorkbookExcelMagicTricks579-581StartFile&FinishedFile
WorkbookExcelMagicTricks582-585StartFile&FinishedFile
WorkbookExcelMagicTricks586-590StartFile&FinishedFile
WorkbookExcelMagicTricks591StartFile&FinishedFile
WorkbookExcelMagicTricks592-595StartFile&FinishedFile
WorkbookExcelMagicTricks596StartFile&FinishedFile
WorkbookExcelMagicTricks597-603StartFile&FinishedFile
WorkbookExcelMagicTricks604-607StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks608-614StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks615-622StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks623-625StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks626StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks627StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks628-635StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks636-639StartFile (.xlsx file format)
WorkbookExcelMagicTricks636-639FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks640-643(DOES NOT INCLUDE 640)StartFile&
FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks640
StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks644-646StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks647StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks648-660StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks661-671StartFile&FinishedFile (.xlsx file format) (Amazing AGGREGATE function!)
WorkbookExcelMagicTricks672StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks673-682StartFile&FinishedFile (.xlsm file format)

 WorkbookExcelMagicTricks683-685
StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks686-697
StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks698-702StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks703-706StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks707-710StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks711-714StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks715-721StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks722-726StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks727-732StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks733-735StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks736-739StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks740-752StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks753-755StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks756-758StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks757.5&758.5StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks759-760StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks761-770StartFile&FinishedFile (.xlsx file format) (No 770 in this workbook)
WorkbookExcelMagicTricks770-775StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks776(Rank Function From Two Columns)StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks777StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks777.5StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks777.75StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricksSourceData777.5StartFile&FinishedFile (.xlsx file format)
4 Year Old Makes RAND Conditional Format Bubble Chart
StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks778
StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks779-786StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks787StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks788-791StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks792-794StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks795-796StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks797-800StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks801StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks802StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks803-805StartFile&FinishedFile (.xlsx file format)
1st-WorkbookExcelMagicTricks806-811StartFile&FinishedFile (.xlsm file format)
2nd-WorkbookExcelMagicTricks806-811StartFile&FinishedFile (.xlsm file format)
1st-WorkbookExcelMagicTricks812StartFile(.xlsx file format)
2nd-WorkbookExcelMagicTricks812FinishedFile(.xlsx file format)
WorkbookExcelMagicTricks813StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks815-818StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks819-821StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks822StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks823-825StartFile&FinishedFile (.xlsx file format)
826-827 No Workbook
WorkbookExcelMagicTricks828-829StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks830StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks831-834StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks835StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks836-847StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks848-849StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks850-853StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks854-855StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks856StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks857StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks858-859StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks860StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks861StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks862StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks863StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks864-865StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks866 StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks867-868StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks869-872StartFile&FinishedFile (.xlsm file format)
WorkbookExcelMagicTricks873StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks874-875StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks876StartFile&FinishedFile (.xlsx file format)
GLAccounts workbook for EMT876StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks877StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks878StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks879StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks880StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks881StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks882StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks883StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks884StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks885StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks885.5StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks886-889StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks890-895StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks896StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks897StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks898StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks899StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks900StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks901-904StartFile&FinishedFile
(.xlsx file format)
WorkbookExcelMagicTricks905-906StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks907
StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks908-909StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks910StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks911StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks912StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks913StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks914StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks915StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks916StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks917StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks918StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks919StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks920 StartFile&FinishedFile
WorkbookExcelMagicTricks921 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks922 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)
WorkbookExcelMagicTricks926-929StartFile&FinishedFile (.xlsx file format)
WorkbookExcelMagicTricks930 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks931-932 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks933 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks934 StartFile.xlsx
WorkbookExcelMagicTricks934 FinishedFile.xlsx
WorkbookExcelMagicTricks935-936 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks937 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks938-941 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks942 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks943 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks944-945 StartFile&FinishedFile.xlsx
    source files for EMT945:
    SourceData1.xlsx    SourceData2.xlsx
WorkbookExcelMagicTricks944.5 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks946 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks947-948 StartFile&FinishedFile.xlsx
WorkbookExcelMagicTricks949 StartFile&FinishedFile.xlsx (Excel 2013 Preview)
WorkbookExcelMagicTricks950-954 StartFile&FinishedFile.xlsx (Excel 2013 Preview)
WorkbookExcelMagicTricks955 StartFile.xlsx (Excel 2013 Preview)
WorkbookExcelMagicTricks955 FinishedFile.xlsx (Excel 2013 Preview)
WorkbookExcelMagicTricks956-957 StartFile&FinishedFile.xlsx (Excel 2013 Preview)
Workbook EMT 958-959.xlsx
Workbook EMT 960-963.xlsx
EMT964-966.xlsx
EMT 967

EMT 968-969.xlsx StartFile&FinishedFile.xlsx
EMT 970.xlsx StartFile&FinishedFile.xlsx
EMT971-975 StartFile&FinishedFile.xlsx
EMT976-977 StartFile&FinishedFile.xlsx

EMT978StartFile&FinishedFile.xlsx
EMT979-980 StartFile&FinishedFile.xlsx
EMT981Start&FinishFile.xlsx
EMT982Start&FinishFile.xlsm (if downloads as ".zip" file, simply change extension to ".xlsm")
EMT983Start&FinishFile.xlsx
EMT984Start&FinishFile.xlsx
EMT985Start&FinishFile.xlsx
EMT986Start&FinishFile.xlsx
EMT987-988Start&FinishFile.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


Mr Excel & excelisfun Series:
WorkbookForMrExcel&excelisfunTrick01&02Start&Finished
WorkbookForMrExcel&excelisfunTrick03Start&Finished
WorkbookForMrExcel&excelisfunTrick04Start&Finished
WorkbookForMrExcel&excelisfunTrick05Start&Finished
WorkbookForMrExcel&excelisfunTrick06Start&Finished
WorkbookForMrExcel&excelisfunTrick07Start&Finished
WorkbookForMrExcel&excelisfunTrick08Start&Finished
WorkbookForMrExcel&excelisfunTrick09Start&Finished
WorkbookForMrExcel&excelisfunTrick10Start&Finished
WorkbookForMrExcel&excelisfunTrick11Start&Finished
WorkbookForMrExcel&excelisfunTrick12Start&Finished
WorkbookForMrExcel&excelisfunTrick13Start&Finished
WorkbookForMrExcel&excelisfunTrick14Start&Finished
WorkbookForMrExcelexcelisfunTrick15Start&Finished
WorkbookForMrExcelexcelisfunTrick16Start&Finished
WorkbookForMrExcelexcelisfunTrick17Start&Finished
WorkbookForMrExcelexcelisfunTrick18Start&Finished
WorkbookForMrExcelexcelisfunTrick19Start&Finished
WorkbookForMrExcelexcelisfunTrick20Start&Finished
WorkbookForMrExcelexcelisfunTrick21.xlsxFinished (2007/2010 file type)
WorkbookForMrExcelexcelisfunTrick22Start&Finished
WorkbookForMrExcelexcelisfunTrick23.xlsxFinished (2007/2010 file type)
WorkbookForMrExcelexcelisfunTrick24Start&Finished
WorkbookForMrExcelexcelisfunTrick25Start&Finished
WorkbookForMrExcelexcelisfunTrick26Start&Finished
WorkbookForMrExcelexcelisfunTrick27Start&Finished
WorkbookForMrExcelexcelisfunTrick28Start&Finished
WorkbookForMrExcelexcelisfunTrick29Start&Finished
WorkbookForMrExcelexcelisfunTrick30Start&Finished
WorkbookForMrExcelexcelisfunTrick31Start&Finished
WorkbookForMrExcelexcelisfunTrick32Start&Finished
WorkbookForMrExcelexcelisfunTrick33Start&Finished
WorkbookForMrExcelexcelisfunTrick34Start&Finished
WorkbookForMrExcelexcelisfunTrick35Start&Finished
WorkbookForMrExcelexcelisfunTrick36Start&Finished
WorkbookForMrExcelexcelisfunTrick37Start&Finished
WorkbookForMrExcelexcelisfunTrick38Start&Finished
WorkbookForMrExcelexcelisfunTrick39Start&Finished
WorkbookForMrExcelexcelisfunTrick40Start&Finished
WorkbookForMrExcelexcelisfunTrick41Start&Finished
WorkbookForMrExcelexcelisfunTrick42FinishedFromBillMrExcelJelen
WorkbookForMrExcelexcelisfunTrick42FinishedFromExcelisfun
WorkbookForMrExcelexcelisfunTrick43Start&Finished
WorkbookForMrExcelexcelisfunTrick44Start&Finished
WorkbookForMrExcelexcelisfunTrick45Start&Finished
WorkbookForMrExcelexcelisfunTrick46Start&Finished
WorkbookForMrExcelexcelisfunTrick47Start&Finished
Trick48  No Workbook
No Trick 49
WorkbookForMrExcelexcelisfunTrick50Start&Finished
WorkbookForMrExcelexcelisfunTrick51Start&Finished
WorkbookForMrExcelexcelisfunTrick52Start&Finished
WorkbookForMrExcelexcelisfunTrick53Start&Finished
WorkbookForMrExcelexcelisfunTrickLiveDuelStart&Finished
WorkbookForMrExcelexcelisfunTrick54Start&Finished
WorkbookForMrExcelexcelisfunTrick55Start&Finished
WorkbookForMrExcelexcelisfunTrick56Start&Finished
WorkbookForMrExcelexcelisfunTrick57Start&Finished
WorkbookForMrExcelexcelisfunTrick58Start&Finished
WorkbookForMrExcelexcelisfunTrick58.5Start&Finished
WorkbookForMrExcelexcelisfunTrick59Start&Finished
WorkbookForMrExcelexcelisfunTrick60Start&Finished
WorkbookForMrExcelexcelisfunTrick61Start&Finished
WorkbookForMrExcelexcelisfunTrick62Start&Finished
WorkbookForMrExcelexcelisfunTrick63Start
WorkbookForMrExcelexcelisfunTrick63Finished
WorkbookForMrExcelexcelisfunTrick64
Start&Finished
No #65
WorkbookForMrExcelexcelisfunTrick66
Start&Finished
WorkbookForMrExcelexcelisfunTrick67Start&Finished
WorkbookForMrExcelexcelisfunTrick68Start&Finished
WorkbookForMrExcelexcelisfunTrick69-72Start&Finished
WorkbookForMrExcelexcelisfunTrick73Start&Finished
WorkbookForMrExcelexcelisfunTrick74Start&Finished
WorkbookForMrExcelexcelisfunTrick75Start&Finished
WorkbookForMrExcelexcelisfunTrick76Start&Finished
WorkbookForMrExcelexcelisfunTrick77Start&Finished
WorkbookForMrExcelexcelisfunTrick78Start&Finished
WorkbookForMrExcelexcelisfunTrick79Start&Finished
MrExcelExcelisfunTrick80.xlsmFinished

MrExcelExcelisfunTrick81.xlsmStart&Finished
MrExcelExcelisfunTrick82.xlsmStart&Finished
MrExcelExcelisfunTrick83.xlsmStart&Finished - Only excelisfun Helper Column and PivotTable solution (no PowerPivot)
MrExcelExcelisfunTrick84.xlsmStart&Finished
MrExcelExcelisfunTrick85.xlsxStart&Finished
MrExcelExcelisfunTrick86.xlsmStart&Finished
MrExcelExcelisfunTrick87.xlsxStart&Finished
MrExcelExcelisfunTrick88.xlsmStart&Finished
MrExcelExcelisfunTrick89.xlsmStart&Finished
MrExcelExcelisfunTrick90.xlsxStart&Finished
MrExcelExcelisfunTrick91.xlsmStart&Finished
MrExcelExcelisfunTrick92.xlsxStart&Finished
MrExcelExcelisfunTrick93 - MrExcel VBA.xlsmStart&Finished
MrExcelExcelisfunTrick93 - excelisfun.xlsmStart&Finished
MrExcelExcelisfunTrick94.xlsmStart&Finished
MrExcelExcelisfunTrick95.xlsxStart&Finished
MrExcelExcelisfunTrick96.xlsxStart&Finished
MrExcelExcelisfunTrick97.xlsxStart&Finished
MrExcelExcelisfunTrick98.xlsxStart&Finished
MrExcelExcelisfunTrick99.xlsmStart&Finished (Just has finished Macros from Mr Excel and excelisfun) (if file downloads as ".zip", change extension to ".xlsm")
MrExcelExcelisfunTrick100.xlsxStart&Finished
MrExcelExcelisfunTrick101.xlsxStart&Finished
MrExcelExcelisfunTrick102.xlsxStart&Finished
MrExcelExcelisfunTrick103.xlsxStart&Finished
None for 104
MrExcelExcelisfunTrick105.xls - From Bill "Mr Excel" Jelen Start&Finished
MrExcelExcelisfunTrick105.xlsx - From excelsifun Start&Finished
MrExcelExcelisfunTrick106.xlsxStart&Finished
MrExcelExcelisfunTrick107.xlsxStart&Finished
MrExcelExcelisfunTrick108.xlsxStart&Finished
MrExcelExcelisfunTrick109.xlsxStart&Finished
MrExcelExcelisfunTrick110.xlsxStart&Finished
MrExcelExcelisfunTrick111.xlsxStart&Finished
MrExcelExcelisfunTrick112.xlsxStart&Finished
MrExcelExcelisfunTrick-TruelWithExcelisfunner-113.xlsxStart&Finished  (Isaac, Bill, Mike: Excelisfunner, MrExcel, excelisfun)
MrExcelExcelisfunTrick114.xlsxStart&Finished
MrExcelExcelisfunTrick115.xlsxStart&Finished
MrExcelExcelisfunTrick116.xlsmStart&Finished ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick117.xlsmStart&Finished ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick118.xlsxStart&Finished
MrExcelExcelisfunTrick119.xlsxStart&Finished
MrExcelExcelisfunTrick120.xlsxStart&Finish
MrExcelExcelisfunTrick121.xlsxStart&Finish
MrExcelExcelisfunTrick122.xlsxStart&Finish
MrExcelExcelisfunTrick123.xlsStart&Finish
MrExcelExcelisfunTrick124.xlsxStart&Finish
MrExcelExcelisfunTrick125.xlsxStart&Finish
MrExcelExcelisfunTrick126.xlsxStart&Finish
MrExcelExcelisfunTrick127.xlsmStart&Finish  ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick128.xlsxStart&Finish
MrExcelExcelisfunTrick129.xlsxStart&Finish
MrExcelExcelisfunTrick130.xlsxStart&Finish
MrExcelExcelisfunTrick131.xlsxStart&Finish
MrExcelExcelisfunTrick132.xlsxStart&Finish
MrExcelExcelisfunTrick133.xlsxStart&Finish
MrExcelExcelisfunTrick134.xlsxStart&Finish
MrExcelExcelisfunTrick135.xlsxStart&Finish
MrExcelExcelisfunTrick136.xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick137.xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick138.xlsxStart&Finish
MrExcelExcelisfunTrick139.xlsxStart&Finish
MrExcelExcelisfunTrick140.xlsxStart&Finish
MrExcelExcelisfunTrick141.xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick142.xlsxStart&Finish
MrExcelExcelisfunTrick143.xlsxStart&Finish
none for 144
MrExcelExcelisfunTrick145.xlsxStart&Finish
none for 146
MrExcelExcelisfunTrick147.xlsxStart&Finish
MrExcelExcelisfunTrick148.xlsxStart&Finish
MrExcelExcelisfunTrick149.xlsxStart&Finish
MrExcelExcelisfunTrick150.xlsxStart&Finish
MrExcelExcelisfunTrick151.xlsxStart&Finish
MrExcelExcelisfunTrick152.xlsxStart&Finish
MrExcelExcelisfunTrick153.xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick154.xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick155.xlsxStart&Finish
MrExcelExcelisfunTrick156.xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick157.xlsxStart&Finish
MrExcelExcelisfunTrick158.xlsxStart&Finish
MrExcelExcelisfunTrick159.xlsxStart&Finish
MrExcelExcelisfunTrick160.xlsxStart&Finish
MrExcelExcelisfunTrick161FromMikeExcelisfunGirvin.xlsxStart&Finish
MrExcelExcelisfunTrick161FromBillMrExcelJelen.xlsxStart&Finish
MrExcelExcelisfunTrick162.xlsxStart&Finish
MrExcelExcelisfunTrick163.xlsxStart&Finish
MrExcelExcelisfunTrick164.xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick165.xlsxStart&Finish
MrExcelExcelisfunTrick166.xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick167xlsmStart&Finish ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick168xlsmStart&Finish
MrExcelExcelisfunTrick169.xlsxStart&Finished
MrExcelExcelisfunTrick170.xlsmStart&Finished  ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick171.xlsmStart&Finished  ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfnTrick172.xlsxStart&Finished
MrExcelExcelisfunTrick173.xlsxStart&Finished
MrExcelexcelisfunTrick174.xlsxStart&Finished

Excelisfunner Mr Excel Excelsifun Truel 06.xlsxStart&Finished

MrExcelExcelisfunTrick175.xlsmStart&Finished  ( .xlsm file type   --- If downloads as zip, change file extension from .zip to .xlsm)
MrExcelExcelisfunTrick176.xlsxStart&Finished
MrExcelExcelisfunTrick176.5.xlsxStart&Finished (Second Attempt at 176)
MrExcelExcelisfunTrick177.xlsxStart&Finished
...No 178,179...
MrExcelExcelisfunTrick180.xlsmStart&Finished
MrExcelExcelisfunTrick181.xlsmStart&Finished
MrExcelExcelisfunTrick182.xlsmStart&Finished
MrExcelExcelisfunTrick183.xlsm
No 184...
MrExcelExcelisfunTrick185.xlsm
MrExcelExcelisfunTrick186.xlsm
MrExcelExcelisfunTrick187.xlsx
MrExcelExcelisfunTrick188.xlsm (just excelisfun Data Model example) and MrExcelExcelisfunTrick188Duel188.xlsm (the other 4 examples)
MrExcelExcelisfunTrick189.xlsx
MrExcelExcelisfunTrick190.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
Ch1
2PDFBusn210.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

Busn210Ch01StartFile
Busn210Ch01FinishedFile

Busn210Ch02StartFile
Busn210Ch02FinishedFile
Busn210Ch02ExtraFrequencyDistributionNotesStart&FinishedFile

Busn210Ch03StartFile
Busn210Ch03FinishedFile
Busn210Ch03ExtraArithmeticMeanVs.GeometricMeanStart&FinishedFile

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.ppt
PowerPoints
Finance&ExcelCh07.pdf HandwrittenNotes(pdfFile)

Finance&ExcelCh08ExcelWorkbook.xlsx Start&FinishedFile
Finance&ExcelCh08.ppt
PowerPoints

Finance&ExcelCh09ExcelWorkbook.xlsx Start&FinishedFile
Finance&ExcelCh09.pptx
PowerPoints

Finance&ExcelCh10ExcelWorkbook.xlsx Start&FinishedFile
Finance&ExcelCh10.pptx
PowerPoints

Finance&ExcelCh11ExcelWorkbook.xlsx Start&FinishedFile
Finance&ExcelCh11.pptx
PowerPoints

 

 

Excel 2010 Business Math Series (Busn 135):

Chapter 0:
Excel2010-135Chapter00.xlsm

Chapter 1:
Excel2010BusnMathCh01.xlsm

Chapter 2:
Excel2010BusnMathCh02.xlsm
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:
Excel2010BusnMathCh07.xlsx

Chapter 8:
Excel2010BusnMathCh08.xlsx

Chapter 9:
Excel2010BusnMathCh09.xlsx
Busn135Ch09.pdf

Chapter 10:
Excel2010BusnMathCh10.xlsx
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:
Excel2010BusnMathCh11.xlsm
Busn135-Ch11.ppt

 

Excel Business Math Class Series (2003 and 2007):
Busn135Ch00.xlsStartFile
Busn135Ch00.xlsFinishedFile

Busn135Ch01.xlsStartFile
Busn135Ch01.xlsFinishedFile
Busn135Ch01HandwrittenNotes.pdf

Busn135Ch01LCMandQUOTIENTfunctions.doc

Busn135Ch02.xlsStartFile
Busn135Ch02.xlsFinishedFile
Busn135Ch02HandwrittenNotes.pdf


Busn135Ch03.xlsStartFile
Busn135Ch03.xlsFinishedFile
Busn135Ch03HandwrittenNotes.pdf

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

 

 

 

YouTubers Love Excel Series:
WorkbookYouTubersLoveExcel9-12StartFile
WorkbookYouTubersLoveExcel9-12FinishedFile
WorkbookYouTubersLoveExcel13-16Start&FinishFile
WorkbookYouTubersLoveExcel17-21Start&FinishFile
WorkbookYouTubersLoveExcel22-26StartFile
WorkbookYouTubersLoveExcel22-26FinishedFile
WorkbookYouTubersLoveExcel26.2-30StartFile
WorkbookYouTubersLoveExcel26.2-30FinishedFile
WorkbookYouTubersLoveExcel31-34Start&FinishFile
WorkbookYouTubersLoveExcel35-40StartFile
WorkbookYouTubersLoveExcel35-40FinishedFile
WorkbookYouTubersLoveExcel41-48StartFile
WorkbookYouTubersLoveExcel41-48FinishedFile
WorkbookYouTubersLoveExcel49-52StartFile
WorkbookYouTubersLoveExcel49-52FinishedFile
WorkbookYouTubersLoveExcel53-57StartFile
WorkbookYouTubersLoveExcel53-57FinishedFile
WorkbookYouTubersLoveExcel58-62StartFile
WorkbookYouTubersLoveExcel58-62FinishedFile
WorkbookYouTubersLoveExcel63-66StartFile
WorkbookYouTubersLoveExcel63-66FinishedFile
WorkbookYouTubersLoveExcel67-71StartFile
WorkbookYouTubersLoveExcel67-71FinishedFile
WorkbookYouTubersLoveExcel72-77StartFile
WorkbookYouTubersLoveExcel72-77FinishedFile
WorkbookYouTubersLoveExcel78-81StartFile
WorkbookYouTubersLoveExcel78-81FinishedFile
WorkbookYouTubersLoveExcel82-86StartFile
WorkbookYouTubersLoveExcel82-86FinishedFile
WorkbookYouTubersLoveExcel87-92StartFile
WorkbookYouTubersLoveExcel87-92FinishedFile
WorkbookYouTubersLoveExcel93-96StartFile
WorkbookYouTubersLoveExcel93-96FinishedFile
WorkbookYouTubersLoveExcel97-100StartFile
WorkbookYouTubersLoveExcel97-100FinishedFile
WorkbookYouTubersLoveExcel101-111StartFile
WorkbookYouTubersLoveExcel101-111FinishedFile
WorkbookYouTubersLoveExcel112-120StartFile
WorkbookYouTubersLoveExcel112-120FinishedFile
WorkbookYouTubersLoveExcel121-125StartFile
WorkbookYouTubersLoveExcel121-125FinishedFile
WorkbookYouTubersLoveExcel126-130StartFile
WorkbookYouTubersLoveExcel126-130FinishedFile
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):
            Download: START Excel Workbook.xlsm (Workbook with blank templates)
            Download: FINISHED Excel Workbook.xlsm (Completed Examples of Video Demonstrations)

Highline Community College Professional Development Day 2012 (Data Analysis in Excel):
            Download: START Excel Workbook.xlsm (Workbook with blank templates)
            Download: FINISHED Excel Workbook.xlsm (Completed Examples of Video Demonstrations)
            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:

    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