Hot：88  Size：110.44 MB  Created：2017-09-11 19:14:17  File Count：29

00 Introduction/0001 Welcome.mov  8.48 MB
00 Introduction/0002 Using the exercise files.mov  562.12 KB
01 Excel's Date Time Entries/0101 Understanding how Excel records and stores dates.mov  5.62 MB
01 Excel's Date Time Entries/0102 Understanding how Excel records and stores times.mov  2.15 MB
02 Creating Date Time Entries/0204 Using Auto Fill to enter date and time series.mov  6.31 MB

Hot：56  Size：106.63 MB  Created：2017-09-12 03:00:14  File Count：21

00 Introduction/62644_00_01_MM01_welcome.mov  11.79 MB
00 Introduction/62644_00_02_SC11_exercisefiles.mov  574.45 KB
01 Mastering Utility Tasks/62644_01_01_SC11_nav.mov  7.32 MB
01 Mastering Utility Tasks/62644_01_02_SC11_insdel.mov  5.09 MB
01 Mastering Utility Tasks/62644_01_05_SC11_hide.mov  3.56 MB

Hot：220  Size：204.72 MB  Created：2017-08-28 01:25:04  File Count：21

00 Introduction/0001 Welcome.mov  12.33 MB
00 Introduction/0002 Using the exercise files.mov  1.36 MB
01 Mastering the Utility Tasks Associated with Multiple Worksheets/0101 Learning basic navigation tips.mov  18.34 MB
01 Mastering the Utility Tasks Associated with Multiple Worksheets/0105 Using the Hide function on worksheet tabs.mov  11.09 MB
01 Mastering the Utility Tasks Associated with Multiple Worksheets/0102 Inserting and deleting new sheets.mov  8.33 MB

Hot：460  Size：139.63 MB  Created：2017-08-30 12:13:05  File Count：11

01 Hand Positioning/001 How To Position Your Hands For Maximum Efficiency.mp4  4.65 MB
02 16 Shortcuts 65 Proven Time Savings/002 Everyday Essential 1 Save -- Save Time Saving Your Files.mp4  4.87 MB
02 16 Shortcuts 65 Proven Time Savings/003 Everyday Essentials 2 3 4 Cut Copy Paste.mp4  13.37 MB
02 16 Shortcuts 65 Proven Time Savings/004 Everyday Essentials 5 6 Undo Redo To The Rescue.mp4  12.07 MB
02 16 Shortcuts 65 Proven Time Savings/005 Everyday Essential 7 Basic Formatting -- Done Fast.mp4  12.96 MB

Hot：61  Size：3.33 GB  Created：2019-09-25 08:55:10  File Count：204

24-working-with-excels-lookup-functions/110-using-excels-index-and-match-functions.mp4  63.96 MB
35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/158-project-3-putting-it-all-together-with-a-little-vba.mp4  57.59 MB
36-project-4-using-vba-to-automate-excel-formulas/160-project-4-automate-the-sum-function-through-code.mp4  49.3 MB
29-automating-repetitive-tasks-in-excel-with-macros/128-creating-a-macro-with-the-macro-recorder.mp4  46.39 MB
19-working-with-excels-powerpivot-tools/091-creating-data-models-with-powerpivot.mp4  45.84 MB

Hot：35  Size：91.04 MB  Created：2017-09-05 04:16:57  File Count：24

00 Introduction/0001 Welcome.mov  6.27 MB
00 Introduction/0002 Using the exercise files.mov  337.58 KB
01 Managing Cash on Hand/0101 Creating an Excel table to track cash on hand.mov  4.49 MB
01 Managing Cash on Hand/0102 Tracking income and expenses by category and contract.mov  3.7 MB
01 Managing Cash on Hand/0103 Summarizing cash on hand in a chart.mov  2.99 MB

Hot：23  Size：91.04 MB  Created：2017-10-17 22:28:56  File Count：23

03 Budgeting Using Financial Statements/0301 Introducing the balance sheet.mov  12.76 MB
03 Budgeting Using Financial Statements/0304 Creating a management income statement.mov  8.06 MB
02 Calculating Load Repayments/0202 Calculating interest and principal components of a loan payment.mov  7.13 MB
05 Defining Alternative Budget Scenarios/0502 Creating and applying scenarios.mov  6.77 MB
00 Introduction/0001 Welcome.mov  6.27 MB

Hot：361  Size：94.66 MB  Created：2019-06-18 10:34:54  File Count：36

2. The Basics/4. Working with Excel Sheets.mp4  27.9 MB
4. Formulas/1. Excel Functions - SUM, AVERAGE & COUNT.mp4  10.23 MB
6. Best Practice & Shortcuts/1. Excel Best Practice.mp4  7.6 MB
2. The Basics/5. Sorting & Filtering Data in Excel.mp4  7.48 MB
2. The Basics/2. Working with Excel Cells.mp4  7.45 MB

Hot：2009  Size：534.35 MB  Created：2017-08-31 13:13:57  File Count：49

00_01-welcome.mp4  6.73 MB
00_02-need_to_know.mp4  6.95 MB
00_03-ex_files.mp4  4.01 MB
01_01-basics.mp4  10.05 MB
01_02-data_points.mp4  16.26 MB

Hot：526  Size：309.72 MB  Created：2017-08-26 14:03:11  File Count：28

01. Introduction/01_01-Welcome.mp4  3.56 MB
01. Introduction/01_02-What you should know before watching this course.mp4  1.43 MB
01. Introduction/01_03-Using the exercise files.mp4  2.62 MB
02. Understanding How to Use Excel and Access for a Solution/02_01-Understanding Excel and Access can work together.mp4  5.73 MB
02. Understanding How to Use Excel and Access for a Solution/02_02-Using the Problem Step Recorder.mp4  7.71 MB

Hot：452  Size：162.9 MB  Created：2019-10-04 14:10:19  File Count：50

21-Examine impact of quantity discounts.mp4  17.21 MB
20-Determine increased cost of constrained purchases.mp4  12.73 MB
08-Determine inventory turns and per-unit costs.mp4  10.26 MB
16-Calculate optimal batch sizes for multiple products.mp4  10.17 MB
15-Calculate the optimal batch size for a process.mp4  8.73 MB

Hot：1131  Size：1.14 GB  Created：2017-09-09 22:36:28  File Count：94

01-before-we-dive-in/attached_files/002-downloading-the-course-resources/Excel-PivotTable-Slides.pdf  2.24 MB
01-before-we-dive-in/attached_files/002-downloading-the-course-resources/IMDd-Movie-Database.xlsx  457.64 KB
02-pivottable-101/attached_files/013-pro-tip-dealing-with-growing-source-data/2016-Movies.xlsx  9.83 KB
07-pivottable-case-studies/attached_files/064-setting-expectations/PivotTable-Case-Studies.pdf  2.27 MB
07-pivottable-case-studies/attached_files/064-setting-expectations/PivotTable-Case-Studies.xlsx  4.67 MB

Hot：643  Size：183.97 MB  Created：2017-08-26 15:45:41  File Count：54

00 Introduction/0001 Welcome.mov  5.13 MB
00 Introduction/0002 Using the exercise files.mov  662.65 KB
00 Introduction/0003 Disclaimer.mov  499.03 KB
01 Analyzing Loans, Payments, and Interest/0102 PPMT and IPMT Calculating principal and interest per loan payment.mov  6.83 MB
01 Analyzing Loans, Payments, and Interest/0103 CUMPRINC and CUMIPMT Calculating cumulative principal and interest paid between periods.mov  5.81 MB

Hot：2896  Size：596.96 MB  Created：2017-08-27 01:26:05  File Count：45

05 The Secret Ingredient/004 Blueprint To Customising Your Secret Charts.mp4  38.01 MB
03 Excel Data Charts Fundamentals/007 4 Charts Everyone Should Know How To Create.mp4  29.96 MB
04 Excel PowerPoint Automation/006 Important This Will Only Take You 2 Minutes.mp4  29.07 MB
04 Excel PowerPoint Automation/005 One Creative Way To Improve Your Tables.mp4  28.54 MB
05 The Secret Ingredient/003 The Most Effective Way To Create Link Charts To PowerPoint.mp4  25.07 MB

Hot：619  Size：260.07 MB  Created：2017-08-26 18:51:33  File Count：71

00-Introduction/01-Welcome.mp4  6.04 MB
00-Introduction/01-Welcome.srt  1.95 KB
00-Introduction/02-Need_to_know.mp4  2.45 MB
00-Introduction/02-Need_to_know.srt  2.76 KB
00-Introduction/03-Exercise_files.mp4  2.18 MB

Hot：538  Size：247.04 MB  Created：2017-09-02 05:33:33  File Count：49

00-Introduction/01-Welcome.mp4  9.98 MB
00-Introduction/01-Welcome.srt  1.9 KB
00-Introduction/02-What_you_should_know.mp4  1.22 MB
00-Introduction/02-What_you_should_know.srt  1.4 KB
00-Introduction/03-Exercise_files.mp4  2.26 MB

Hot：247  Size：490.39 MB  Created：2017-10-10 00:59:02  File Count：33

01_06-calculating.mp4  70.76 MB
01_09-adding_standard_costs2.mp4  45.53 MB
01_02-data_points.mp4  31.88 MB
01_11-analyzing.mp4  30.97 MB
02_02-finding.mp4  30.84 MB

Hot：291  Size：7.78 GB  Created：2021-08-17 15:17:54  File Count：未知

Hot：4  Size：165.61 MB  Created：2017-10-11 19:00:01  File Count：79

Introduction/00_01_MM01_welcome.mov  13.54 MB
00.02.Creating Basic Summary Formulas/02_05_SC01_condition.mov  9.58 MB
00.03.Sorting and Filtering PivotTable Data/03_08_SC01_vlookup.mov  8.98 MB
00.03.Sorting and Filtering PivotTable Data/03_06_SC01_exceltables.mov  7.98 MB
00.01.Introducing Excel 2007 Functions and Formulas/01_05_SC01_copypaste.mov  7.37 MB

Hot：168  Size：442.65 MB  Created：2019-05-03 09:45:53  File Count：51

3. McKinsey Cell And Data Formatting Secrets/3. McKinsey Data Formatting Secrets.mp4  95.07 MB
4. McKinsey Chart Formatting Secrets/2. Chart Formatting And Design Essentials.mp4  68.09 MB
5. Bonus Secrets/2. Bonus - How To Show Only Key Data - Hiding, Unhiding, Grouping.mp4  45.56 MB
3. McKinsey Cell And Data Formatting Secrets/2. Conditional Formatting Secrets.mp4  40.2 MB
5. Bonus Secrets/3. Bonus - Let Others Only Fill In Data You Want - Drop Down Menus.mp4  31.15 MB