2015年8月4日星期二

Excel workbook file YouTube Download

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 BOOKFilesForCtrlShiftEnterBook.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

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 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-10StartFileWorkbookExcelMagicTricks01-10FinishedFile
WorkbookExcelMagicTricks11-22StartFile
Workbook
ExcelMagicTricks11-22FinishedFile
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
SourceDataFinishedFileWorkbookExcelMagicTricks296-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-323FinishedFileWorkbookExcelMagicTricks324-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
StartWordFileForExcelMagicTrick542StartFileWorkbookExcelMagicTricks551-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) WorkbookExcelMagicTricks778StartFile&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



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
 

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&FinishedFileFinance&ExcelCh02.pdf HandwrittenNotes (Banking Note)
Finance&ExcelCh02.pdfHandwrittenNotes (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

YouTubers Love Excel Series:
WorkbookYouTubersLoveExcel9-12StartFileWorkbookYouTubersLoveExcel9-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


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

没有评论:

发表评论