1 Overview&ExcelSetup
2Navigation&DataManipulation
3Formatting
4Grouping,Hiding,Zooming&Printing
5Formulas,Lookups&Calculations
6Graphs&Charts
7IntrotoVBA,Macros,andUDFs

+Module-01-All-Files            823.0 KB
  01-02-Excel-Setup-Checklist.xlsx             634.0 KB
  01-04-Excel-2.0-Course-Highlights.pdf             189.0 KB
+Module-02-All-Files            3.6 MB
  02-01-Customer-Sales-Rep-Data-After.xlsx             116.0 KB
  02-01-Customer-Sales-Rep-Data-Before.xlsx             116.0 KB
  02-01-Walmart-Model-Valuation.xlsx             96.5 KB
  02-02-Navigation-Customer-Sales-Rep-Data-After.xlsx             116.0 KB
  02-02-Navigation-Customer-Sales-Rep-Data-Before.xlsx             115.0 KB
  02-02-Navigation-Walmart-Model-Valuation-After.xlsx             96.6 KB
  02-02-Navigation-Walmart-Model-Valuation-Before.xlsx             96.5 KB
  02-03-Rows-Columns-Customer-Sales-Rep-Data-After.xlsx             111.0 KB
  02-03-Rows-Columns-Customer-Sales-Rep-Data-Before.xlsx             116.0 KB
  02-03-Rows-Columns-Walmart-Model-Valuation-After.xlsx             98.0 KB
  02-03-Rows-Columns-Walmart-Model-Valuation-Before.xlsx             96.6 KB
  02-04-Cells-Customer-Sales-Rep-Data-After.xlsx             111.0 KB
  02-04-Cells-Customer-Sales-Rep-Data-Before.xlsx             111.0 KB
  02-04-Cells-Walmart-Model-Valuation-After.xlsx             98.0 KB
  02-04-Cells-Walmart-Model-Valuation-Before.xlsx             98.0 KB
  02-05-Enter-Formulas-Customer-Sales-Rep-Data.xlsx             111.0 KB
  02-05-Enter-Formulas-Walmart-Model-Valuation-After.xlsx             98.0 KB
  02-05-Enter-Formulas-Walmart-Model-Valuation-Before.xlsx             98.0 KB
  02-06-Refreshing-Customer-Sales-Rep-Data.xlsx             111.0 KB
  02-06-Refreshing-Walmart-Model-Valuation-After.xlsx             99.0 KB
  02-06-Refreshing-Walmart-Model-Valuation-Before.xlsx             104.0 KB
  02-07-References-Customer-Sales-Rep-Data.xlsx             112.0 KB
  02-07-References-Walmart-Model-Valuation-After.xlsx             99.0 KB
  02-07-References-Walmart-Model-Valuation-Before.xlsx             98.0 KB
  02-08-Naming-Cells-Customer-Sales-Rep-Data.xlsx             112.0 KB
  02-08-Naming-Cells-Walmart-Model-Valuation-After.xlsx             100.0 KB
  02-08-Naming-Cells-Walmart-Model-Valuation-Before.xlsx             100.0 KB
  02-09-Worksheets-1-Customer-Sales-Rep-Data-After.xlsx             112.0 KB
  02-09-Worksheets-1-Customer-Sales-Rep-Data-Before.xlsx             113.0 KB
  02-09-Worksheets-1-Walmart-Model-Valuation-After.xlsx             100.0 KB
  02-09-Worksheets-1-Walmart-Model-Valuation-Before.xlsx             100.0 KB
  02-10-Worksheets-2-Customer-Sales-Rep-Data-After.xlsx             113.0 KB
  02-10-Worksheets-2-Customer-Sales-Rep-Data-Before.xlsx             112.0 KB
  02-10-Worksheets-2-Walmart-Model-Valuation-After.xlsx             101.0 KB
  02-10-Worksheets-2-Walmart-Model-Valuation-Before.xlsx             101.0 KB
+Module-03-All-Files            4.2 MB
  03-01-Formatting-Customer-Sales-Rep-Data-After.xlsx             113.0 KB
  03-01-Formatting-Customer-Sales-Rep-Data-Before.xlsx             112.0 KB
  03-01-Formatting-Walmart-Model-Valuation-After.xlsx             101.0 KB
  03-01-Formatting-Walmart-Model-Valuation-Before.xlsx             101.0 KB
  03-02-Formatting-Options-Customer-Sales-Rep-Data-After.xlsx             116.0 KB
  03-02-Formatting-Options-Customer-Sales-Rep-Data-Before.xlsx             113.0 KB
  03-02-Formatting-Options-Walmart-Model-Valuation-After.xlsx             102.0 KB
  03-02-Formatting-Options-Walmart-Model-Valuation-Before.xlsx             101.0 KB
  03-03-Built-in-Formats-Customer-Sales-Rep-Data-After.xlsx             116.0 KB
  03-03-Built-in-Formats-Customer-Sales-Rep-Data-Before.xlsx             115.0 KB
  03-03-Built-in-Formats-Walmart-Model-Valuation-After.xlsx             102.0 KB
  03-03-Built-in-Formats-Walmart-Model-Valuation-Before.xlsx             102.0 KB
  03-04-Color-Code-Walmart-Model-Valuation-After.xlsx             101.0 KB
  03-04-Color-Code-Walmart-Model-Valuation-Before.xlsx             101.0 KB
  03-05-Dates-Times-Customer-Sales-Rep-Data-After.xlsx             108.0 KB
  03-05-Dates-Times-Customer-Sales-Rep-Data-Before.xlsx             116.0 KB
  03-05-Dates-Times-Walmart-Model-Valuation-After.xlsx             102.0 KB
  03-05-Dates-Times-Walmart-Model-Valuation-Before.xlsx             101.0 KB
  03-06-Custom-Walmart-Model-Valuation-After.xlsx             107.0 KB
  03-06-Custom-Walmart-Model-Valuation-Before.xlsx             106.0 KB
  03-07-Import-Export-Customer-Sales-Rep-Data.txt             1.2 KB
  03-07-Import-Export-Customer-Sales-Rep-Data-After.xlsx             110.0 KB
  03-07-Import-Export-Customer-Sales-Rep-Data-Before.xlsx             109.0 KB
  03-08-Text-Customer-Sales-Rep-Data-After.xlsx             111.0 KB
  03-08-Text-Customer-Sales-Rep-Data-Before.xlsx             111.0 KB
  03-09-Cleaning-Up-Data-Customer-Sales-Rep-Data-After.xlsx             127.0 KB
  03-09-Cleaning-Up-Data-Customer-Sales-Rep-Data-Before.xlsx             111.0 KB
  03-09-Cleaning-Up-Data-Customer-Sales-Rep-Data-BONUS-Fix.xlsx             183.0 KB
  03-10-Sorting-Filtering-Customer-Sales-Rep-Data-After.xlsx             134.0 KB
  03-10-Sorting-Filtering-Customer-Sales-Rep-Data-Before.xlsx             131.0 KB
  03-11-Conditional-Formatting-Customer-Sales-Rep-Data-After.xlsx             140.0 KB
  03-11-Conditional-Formatting-Customer-Sales-Rep-Data-Before.xlsx             140.0 KB
  03-12-Data-Tables-Customer-Sales-Rep-Data-After.xlsx             139.0 KB
  03-12-Data-Tables-Customer-Sales-Rep-Data-Before.xlsx             138.0 KB
  03-13-Exercise-Customer-Sales-Rep-Data-After.xlsx             126.0 KB
  03-13-Exercise-Customer-Sales-Rep-Data-Before.xlsx             126.0 KB
  03-13-Exercise-Walmart-Model-Valuation-After.xlsx             107.0 KB
  03-13-Exercise-Walmart-Model-Valuation-Before.xlsx             107.0 KB
+Module-04-All-Files            1.6 MB
  04-01-Grouping-Hiding-Customer-Sales-Rep-Data-After.xlsx             127.0 KB
  04-01-Grouping-Hiding-Customer-Sales-Rep-Data-Before.xlsx             127.0 KB
  04-01-Grouping-Hiding-Walmart-Model-Valuation-After.xlsx             109.0 KB
  04-01-Grouping-Hiding-Walmart-Model-Valuation-Before.xlsx             109.0 KB
  04-02-Freeze-Panes-Zooming-Customer-Sales-Rep-Data-After.xlsx             127.0 KB
  04-02-Freeze-Panes-Zooming-Customer-Sales-Rep-Data-Before.xlsx             127.0 KB
  04-02-Freeze-Panes-Zooming-Walmart-Model-Valuation-After.xlsx             109.0 KB
  04-02-Freeze-Panes-Zooming-Walmart-Model-Valuation-Before.xlsx             109.0 KB
  04-03-Printing-Customer-Sales-Rep-Data-After.xlsx             127.0 KB
  04-03-Printing-Customer-Sales-Rep-Data-Before.xlsx             127.0 KB
  04-03-Printing-Walmart-Model-Valuation-After.xlsx             109.0 KB
  04-03-Printing-Walmart-Model-Valuation-Before.xlsx             109.0 KB
  04-04-Printing-Exercise-Walmart-Model-Valuation-After.xlsx             111.0 KB
  04-04-Printing-Exercise-Walmart-Model-Valuation-Before.xlsx             109.0 KB
+Module-05-All-Files            9.6 MB
  05-01-Arithmetic-Customer-Sales-Rep-Data-After.xlsx             130.0 KB
  05-01-Arithmetic-Customer-Sales-Rep-Data-Before.xlsx             139.0 KB
  05-01-Arithmetic-Walmart-Model-Valuation-After.xlsx             119.0 KB
  05-01-Arithmetic-Walmart-Model-Valuation-Before.xlsx             123.0 KB
  05-02-Example-JCG-LBO-Model.xlsx             48.1 KB
  05-02-Financial-After.xlsx             18.5 KB
  05-02-Financial-Before.xlsx             15.3 KB
  05-03-Logicals-Customer-Sales-Rep-Data-After.xlsx             131.0 KB
  05-03-Logicals-Customer-Sales-Rep-Data-Before.xlsx             131.0 KB
  05-03-Logicals-Walmart-Model-Valuation-After.xlsx             118.0 KB
  05-03-Logicals-Walmart-Model-Valuation-Before.xlsx             118.0 KB
  05-04-Copy-Paste-Move-Customer-Sales-Rep-Data-After.xlsx             131.0 KB
  05-04-Copy-Paste-Move-Customer-Sales-Rep-Data-Before.xlsx             130.0 KB
  05-04-Copy-Paste-Move-Walmart-Model-Valuation-After.xlsx             119.0 KB
  05-04-Copy-Paste-Move-Walmart-Model-Valuation-Before.xlsx             119.0 KB
  05-05-Lookups-Customer-Sales-Rep-Data-After.xlsx             151.0 KB
  05-05-Lookups-Customer-Sales-Rep-Data-Before.xlsx             138.0 KB
  05-05-Lookups-Walmart-Model-Valuation-After.xlsx             119.0 KB
  05-05-Lookups-Walmart-Model-Valuation-Before.xlsx             122.0 KB
  05-06-Index-Match-Indirect-Customer-Sales-Rep-Data-After.xlsx             182.0 KB
  05-06-Index-Match-Indirect-Customer-Sales-Rep-Data-Before.xlsx             181.0 KB
  05-06-Index-Match-Indirect-REIT-Data-After.xlsx             36.3 KB
  05-06-Index-Match-Indirect-REIT-Data-Before.xlsx             27.6 KB
  05-06-REIT-Data.pdf             2.3 MB
  05-07-Database-Customer-Sales-Rep-Data-After.xlsx             182.0 KB
  05-07-Database-Customer-Sales-Rep-Data-Before.xlsx             182.0 KB
  05-08-Arrays-Customer-Sales-Rep-Data-After.xlsx             148.0 KB
  05-08-Arrays-Customer-Sales-Rep-Data-Before.xlsx             147.0 KB
  05-08-Arrays-Walmart-Model-Valuation-After.xlsx             119.0 KB
  05-08-Arrays-Walmart-Model-Valuation-Before.xlsx             118.0 KB
  05-09-Data-Validation-Customer-Sales-Rep-Data-After.xlsx             149.0 KB
  05-09-Data-Validation-Customer-Sales-Rep-Data-Before.xlsx             148.0 KB
  05-10-Scenarios-Walmart-Model-Valuation-After.xlsx             132.0 KB
  05-10-Scenarios-Walmart-Model-Valuation-Before.xlsx             132.0 KB
  05-10-WMT-10-K.pdf             759.0 KB
  05-10-WMT-CS-Equity-Research.pdf             331.0 KB
  05-10-WMT-SQ-FT-Information.pdf             115.0 KB
  05-11-Circular-Walmart-Model-Valuation-After.xlsx             132.0 KB
  05-11-Circular-Walmart-Model-Valuation-Before.xlsx             131.0 KB
  05-12-Auditing-Walmart-Model-Valuation-After.xlsx             140.0 KB
  05-12-Auditing-Walmart-Model-Valuation-Before.xlsx             140.0 KB
  05-13-Comments-Walmart-Model-Valuation-After.xlsx             133.0 KB
  05-13-Comments-Walmart-Model-Valuation-Before.xlsx             133.0 KB
  05-14-Errors-Customer-Sales-Rep-Data-After.xlsx             150.0 KB
  05-14-Errors-Customer-Sales-Rep-Data-Before.xlsx             150.0 KB
  05-14-Errors-Walmart-Model-Valuation-After.xlsx             134.0 KB
  05-14-Errors-Walmart-Model-Valuation-Before.xlsx             134.0 KB
  05-15-Sensitivity-Tables-Walmart-Model-Valuation-After.xlsx             135.0 KB
  05-15-Sensitivity-Tables-Walmart-Model-Valuation-Before.xlsx             134.0 KB
  05-16-Goal-Seek-Financial-Functions.xlsx             18.2 KB
  05-16-Goal-Seek-Walmart-Model-Valuation-After.xlsx             135.0 KB
  05-16-Goal-Seek-Walmart-Model-Valuation-Before.xlsx             135.0 KB
  05-17-Pivot-Tables-Customer-Sales-Rep-Data-After.xlsx             219.0 KB
  05-17-Pivot-Tables-Customer-Sales-Rep-Data-Before.xlsx             148.0 KB
+Module-06-All-Files            4.1 MB
  06-01-Graphs-Customer-Sales-Rep-Data-After.xlsx             235.0 KB
  06-01-Graphs-Customer-Sales-Rep-Data-Before.xlsx             222.0 KB
  06-01-Graphs-Walmart-Model-Valuation-After.xlsx             145.0 KB
  06-01-Graphs-Walmart-Model-Valuation-Before.xlsx             133.0 KB
  06-02-Formatting-Graphs-Customer-Sales-Rep-Data-After.xlsx             236.0 KB
  06-02-Formatting-Graphs-Customer-Sales-Rep-Data-Before.xlsx             236.0 KB
  06-02-Formatting-Graphs-Walmart-Model-Valuation-After.xlsx             148.0 KB
  06-02-Formatting-Graphs-Walmart-Model-Valuation-Before.xlsx             147.0 KB
  06-03-Combination-Charts-Customer-Sales-Rep-Data-After.xlsx             238.0 KB
  06-03-Combination-Charts-Customer-Sales-Rep-Data-Before.xlsx             236.0 KB
  06-03-Combination-Charts-Walmart-Model-Valuation-After.xlsx             149.0 KB
  06-03-Combination-Charts-Walmart-Model-Valuation-Before.xlsx             148.0 KB
  06-04-Pie-Charts-Customer-Sales-Rep-Data-After.xlsx             248.0 KB
  06-04-Pie-Charts-Customer-Sales-Rep-Data-Before.xlsx             238.0 KB
  06-05-Valuation-Multiples-Walmart-Model-Valuation-After.xlsx             177.0 KB
  06-05-Valuation-Multiples-Walmart-Model-Valuation-Before.xlsx             152.0 KB
  06-06-Football-Field-Walmart-Model-Valuation-After.xlsx             194.0 KB
  06-06-Football-Field-Walmart-Model-Valuation-Before.xlsx             183.0 KB
  06-07-Price-Volume-Graphs-Walmart-Model-Valuation-After.xlsx             229.0 KB
  06-07-Price-Volume-Graphs-Walmart-Model-Valuation-Before.xlsx             195.0 KB
  06-08-Waterfall-Graph-After.xlsx             24.2 KB
  06-08-Waterfall-Graph-Before.xlsx             16.1 KB
  06-08-Waterfall-Graph-Instructions.pdf             169.0 KB
  06-09-Waterfall-Graph-Connectors-After.xlsx             39.9 KB
  06-09-Waterfall-Graph-Connectors-Before.xlsx             28.2 KB
+Module-07-All-Files            2.0 MB
  07-01-Record-Macro-After.xlsm             31.2 KB
  07-01-Record-Macro-Before.xlsx             24.8 KB
  07-02-VBA-Intro-After.xlsm             38.9 KB
  07-02-VBA-Intro-Before.xlsm             36.1 KB
  07-03-User-Defined-Functions-Walmart-Model-Valuation-After.xlsm             263.0 KB
  07-03-User-Defined-Functions-Walmart-Model-Valuation-Before.xlsx             261.0 KB
  07-04-VBA-Formatting-After.xlsm             48.5 KB
  07-04-VBA-Formatting-Before.xlsm             45.3 KB
  07-05-Dynamic-Charts-Customer-Sales-Rep-Data-After.xlsx             256.0 KB
  07-05-Dynamic-Charts-Customer-Sales-Rep-Data-Before.xlsx             251.0 KB
  07-05-Dynamic-Charts-Walmart-Model-Valuation-After.xlsx             263.0 KB
  07-05-Dynamic-Charts-Walmart-Model-Valuation-Before.xlsx             259.0 KB
  07-06-Custom-Shortcuts-Walmart-Model-Valuation.xlsx             264.0 KB
+Practice-Quizzes            826.0 KB
  Excel-Module-01-Quizzes.pdf             78.8 KB
  Excel-Module-02-Quizzes.pdf             111.0 KB
  Excel-Module-03-Quizzes.pdf             128.0 KB
  Excel-Module-04-Quizzes.pdf             87.7 KB
  Excel-Module-05-Quizzes.pdf             179.0 KB
  Excel-Module-06-Quizzes.pdf             132.0 KB
  Excel-Module-07-Quizzes.pdf             109.0 KB
+Quick-References            5.6 MB
  01-04-Excel-2.0-Course-Highlights.pdf             189.0 KB
  BIWS-Excel-Custom-Number-Formats.pdf             443.0 KB
  BIWS-Excel-Formatting-Best-Practices.pdf             702.0 KB
  BIWS-Excel-Functions-Formulas.pdf             452.0 KB
  BIWS-Excel-Graphs-Charts.pdf             2.2 MB
  BIWS-Excel-Shortcuts-2003.pdf             397.0 KB
  BIWS-Excel-Shortcuts-2007-to-2013-Plus.pdf             346.0 KB
  BIWS-Excel-Shortcuts-Mac.pdf             1.0 MB
+Transcripts            7.1 MB
  01-01-Overview.pdf             128.0 KB
  01-02-Excel-Setup.pdf             120.0 KB
  01-03-Excel-Interface.pdf             96.6 KB
  01-04-Quick-Start-Tour.pdf             107.0 KB
  02-01-Shortcuts-You-Already-Know.pdf             96.7 KB
  02-02-Basic-Navigation.pdf             96.2 KB
  02-03-Inserting-Editing-Deleting-Rows-Columns.pdf             105.0 KB
  02-04-Editing-Deleting-Cells.pdf             95.8 KB
  02-05-Entering-Formulas-Text-Numbers.pdf             113.0 KB
  02-06-Refreshing-Calculating-Results.pdf             81.9 KB
  02-07-References-Anchoring-Cells.pdf             100.0 KB
  02-08-Naming-Jumping-to-Cells.pdf             121.0 KB
  02-09-Copying-Deleting-Moving-Workbooks-Worksheets.pdf             101.0 KB
  02-10-Hiding-Naming-Coloring-Worksheets.pdf             99.0 KB
  03-01-Overview.pdf             108.0 KB
  03-02-Fills-Fonts-Borders-Alignment.pdf             130.0 KB
  03-03-Built-In-Formats.pdf             108.0 KB
  03-04-Color-Code-Models.pdf             94.9 KB
  03-05-Dates-Times.pdf             121.0 KB
  03-06-Custom-Number-Formats.pdf             137.0 KB
  03-07-Import-Export.pdf             117.0 KB
  03-08-Text-Manipulation.pdf             96.8 KB
  03-09-Cleaning-Up-Data.pdf             98.0 KB
  03-10-Sorting-Filtering-Data.pdf             119.0 KB
  03-11-Conditional-Formatting.pdf             107.0 KB
  03-12-Data-Tables.pdf             106.0 KB
  03-13-Formatting-Exercise.pdf             161.0 KB
  04-01-Grouping-Hiding.pdf             107.0 KB
  04-02-Freeze-Panes-Zooming.pdf             105.0 KB
  04-03-Printing-Overview.pdf             123.0 KB
  04-04-Printing-Exercise.pdf             110.0 KB
  05-01-Arithmetic.pdf             148.0 KB
  05-02-Financial.pdf             139.0 KB
  05-03-Logicals.pdf             100.0 KB
  05-04-Copy-Paste-Move.pdf             97.0 KB
  05-05-Lookups.pdf             136.0 KB
  05-06-Index-Match-Indirect.pdf             140.0 KB
  05-07-Database.pdf             90.2 KB
  05-08-Arrays.pdf             108.0 KB
  05-09-Data-Validation.pdf             107.0 KB
  05-10-Scenarios.pdf             100.0 KB
  05-11-Circular.pdf             103.0 KB
  05-12-Auditing.pdf             117.0 KB
  05-13-Comments.pdf             89.3 KB
  05-14-Errors.pdf             112.0 KB
  05-15-Sensitivity-Tables.pdf             105.0 KB
  05-16-Goal-Seek.pdf             87.7 KB
  05-17-Pivot-Tables.pdf             126.0 KB
  06-01-Line-Column-Graphs.pdf             114.0 KB
  06-02-Formatting-Graphs-Charts.pdf             154.0 KB
  06-03-Combination-Charts.pdf             138.0 KB
  06-04-Pie-Charts.pdf             129.0 KB
  06-05-Valuation-Multiples.pdf             126.0 KB
  06-06-Valuation-Football-Field.pdf             121.0 KB
  06-07-Price-Volume-Graphs.pdf             120.0 KB
  06-08-Waterfall-Graph.pdf             132.0 KB
  06-09-Waterfall-Graph-Connectors.pdf             129.0 KB
  07-01-Record-Macro.pdf             158.0 KB
  07-02-VBA-Intro.pdf             177.0 KB
  07-03-User-Defined-Functions.pdf             115.0 KB
  07-04-VBA-Formatting.pdf             129.0 KB
  07-05-Dynamic-Charts.pdf             161.0 KB
  07-06-Custom-Shortcuts.pdf             88.1 KB
00-Customer-Sales-Rep-Data-FINISHED.xlsx            253.0 KB
00-Walmart-Model-Valuation-FINISHED.xlsx            250.0 KB