Hot：174  Size：2.03 GB  Created：2019-10-14 18:44:05  File Count：407

1. Watch This First/2. Navigating Udemy.mp4  50.45 MB
13. Case Study Data Preparation (for Startup Market Data)/1. Startup Funding CSV File Import.mp4  47.53 MB
10. Case Study Crytocurrency Data/2. Getting and Prepping the Data.mp4  45.89 MB
13. Case Study Data Preparation (for Startup Market Data)/5. Join the Two Tables.mp4  45.56 MB
13. Case Study Data Preparation (for Startup Market Data)/3. Import and Fix Startup Info Data - Part 2.mp4  42.92 MB

Hot：181  Size：370.61 MB  Created：2017-09-12 17:33:07  File Count：21

158663_01_01_XR15_navigate.mp4  62.88 MB
158663_03_03_XR15_consolidation.mp4  36.66 MB
158663_02_01_XR15_displaymult.mp4  32.68 MB
158663_05_03_XR15_consolbooks.mp4  30.92 MB
158663_04_02_XR15_displaywkbook.mp4  30.03 MB

Hot：34  Size：5.13 MB  Created：2017-09-02 02:06:54  File Count：未知

Hot：43  Size：104.11 MB  Created：2017-08-31 03:14:17  File Count：29

00 Introduction/0001 Welcome.mov  9.22 MB
00 Introduction/0002 Using the exercise files.mov  362.17 KB
01 Excel's Date Time Entries/0101 Understanding how Excel records and stores dates.mov  4.98 MB
01 Excel's Date Time Entries/0102 Understanding how Excel records and stores times.mov  1.68 MB
02 Creating Date Time Entries/0204 Using Auto Fill to enter date and time series.mov  6.45 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：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：13  Size：2.91 GB  Created：2019-04-09 12:20:44  File Count：249

15 Student Questions Answered/179 VLookups (Or Any Application.WorksheetFunction) Over Ranges.mp4  136.06 MB
15 Student Questions Answered/167 Saving Multiple Sheets To A Single Workbook In A Specific Folder.mp4  80.94 MB
15 Student Questions Answered/175 File Picker And Report Generator With Intelligent Filing.mp4  58.49 MB
15 Student Questions Answered/174 Sequential PDF Creation With Pictures.mp4  48.99 MB
01 Whats It All About Alan/002 Why Should I Learn How To Code.mp4  47.11 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：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