|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| [TGx]Downloaded from torrentgalaxy.to .txt |
585B |
| 0 |
3B |
| 1 |
422.52KB |
| 1. CONCLUSION How to apply what you've learned to solve any new problem.mp4 |
9.16MB |
| 1. CONCLUSION How to apply what you've learned to solve any new problem.srt |
6.34KB |
| 1. DATA ANALYSIS Section Intro.mp4 |
4.91MB |
| 1. DATA ANALYSIS Section Intro.srt |
3.02KB |
| 1. DATA BASICS Section Intro.mp4 |
3.87MB |
| 1. DATA BASICS Section Intro.srt |
1.95KB |
| 1. EXCEL EFFICIENCY Section Intro.mp4 |
2.75MB |
| 1. EXCEL EFFICIENCY Section Intro.srt |
1.48KB |
| 1. EXCEL ENGINE ROOM Section Intro.mp4 |
3.30MB |
| 1. EXCEL ENGINE ROOM Section Intro.srt |
1.81KB |
| 1. MODELING UNCERTAINTY Section Intro.mp4 |
2.85MB |
| 1. MODELING UNCERTAINTY Section Intro.srt |
1.46KB |
| 1. PROBLEM SOLVING BASICS Section Intro.mp4 |
2.63MB |
| 1. PROBLEM SOLVING BASICS Section Intro.srt |
1.41KB |
| 1. SLIDE-READY OUTPUT Section Intro.mp4 |
2.32MB |
| 1. SLIDE-READY OUTPUT Section Intro.srt |
1.40KB |
| 1. Why this Excel Course.mp4 |
15.47MB |
| 1. Why this Excel Course.srt |
6.97KB |
| 10 |
825.33KB |
| 10.1 Beyond Formulas Ca Wi Mak Case 4 8 Data Dates And Times Xlsb.zip |
17.85MB |
| 10.1 Beyond Formulas Ca Wi Mak Case 6 6B Modeling VBA Distance Calc Starter Xlsb.zip |
11.69MB |
| 10. ADVANCED Create a VBA function to calculate the distance between two locations.mp4 |
20.12MB |
| 10. ADVANCED Create a VBA function to calculate the distance between two locations.srt |
9.20KB |
| 10. Date & time parsing, conversion and manipulation.mp4 |
26.24MB |
| 10. Date & time parsing, conversion and manipulation.srt |
12.31KB |
| 11 |
832.30KB |
| 11.1 Beyond Formulas Ca Wi Mak Case 4 9 Data Dynamic Named Ranges Xlsb.zip |
18.04MB |
| 11.1 Beyond Formulas Ca Wi Mak Case 6 7 Modeling Supply Chain 201 Optimization Starter Xlsb.zip |
11.69MB |
| 11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.mp4 |
75.61MB |
| 11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.srt |
28.32KB |
| 11. Use Dynamic Named Ranges to give your data & cells easy-to-remember names.mp4 |
59.84MB |
| 11. Use Dynamic Named Ranges to give your data & cells easy-to-remember names.srt |
24.97KB |
| 12 |
879.79KB |
| 12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.mp4 |
340.92MB |
| 12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.srt |
23.95KB |
| 13 |
487.77KB |
| 13.1 Beyond Formulas Ca Wi Mak Case 6 8 Modeling Multi Period Pn L Starter Xlsb.zip |
11.73MB |
| 13. Model Engine→Full multi-period P&L in just a few steps.mp4 |
110.94MB |
| 13. Model Engine→Full multi-period P&L in just a few steps.srt |
35.40KB |
| 14 |
142.82KB |
| 14. RECAP Of everything we've accomplished this section.mp4 |
11.13MB |
| 14. RECAP Of everything we've accomplished this section.srt |
4.42KB |
| 15 |
297.25KB |
| 15.1 Beyond Formulas Ca Wi Mak Case 6 Complete Modeling Basics Completed Xlsb.zip |
11.77MB |
| 15. Avoid public humiliation through Auditing and Error-checking.mp4 |
7.42MB |
| 15. Avoid public humiliation through Auditing and Error-checking.srt |
7.12KB |
| 16 |
346.10KB |
| 17 |
399.47KB |
| 18 |
630.93KB |
| 19 |
777.81KB |
| 2 |
84.59KB |
| 2. [optional] What this course covers Modeling Approach & Excel Tools.mp4 |
10.71MB |
| 2. [optional] What this course covers Modeling Approach & Excel Tools.srt |
5.65KB |
| 2.1 Beyond+Formulas+Section+2+All+Files.zip |
5.45MB |
| 2.1 Beyond+Formulas+Section+4+All+Files.zip |
203.84MB |
| 2.1 Beyond+Formulas+Section+5+All+Files.zip |
73.38MB |
| 2.1 Beyond+Formulas+Section+6+All+Files.zip |
127.69MB |
| 2.1 Beyond+Formulas+Section+7+All+Files.zip |
47.07MB |
| 2.1 Beyond+Formulas+Section+8+All+Files.zip |
23.60MB |
| 2. COURSE HANDOUT - Accompanying slides for each lesson.pdf |
22.33MB |
| 2. DATA ANALYSIS - Course materials.html |
195B |
| 2. DATA BASICS - Course materials.html |
195B |
| 2. EXCEL EFFICIENCY - Course materials.html |
195B |
| 2. EXCEL ENGINE ROOM - Course materials.html |
198B |
| 2. MODELING UNCERTAINTY - Course materials.html |
195B |
| 2. Problem-solving 101 - the basic analytical problem solving process.mp4 |
8.24MB |
| 2. Problem-solving 101 - the basic analytical problem solving process.srt |
6.56KB |
| 2. SLIDE-READY OUTPUT - Course materials.html |
195B |
| 20 |
162.65KB |
| 21 |
509.70KB |
| 22 |
268.00KB |
| 23 |
948.63KB |
| 24 |
776.40KB |
| 25 |
67.04KB |
| 26 |
886.63KB |
| 27 |
774.23KB |
| 28 |
738.60KB |
| 29 |
916.54KB |
| 3 |
161.51KB |
| 3. [optional] Consultants, or Managers of analysts take note.mp4 |
10.26MB |
| 3. [optional] Consultants, or Managers of analysts take note.srt |
6.26KB |
| 3.1 Beyond Formulas Ca Wi Mak Case 5 1 Analysis Basic Aggregation Starter Xlsb.zip |
7.56MB |
| 3.1 Beyond Formulas Ca Wi Mak Case 6 1 Modeling Back Of The Envelope Starter Xlsb.zip |
11.50MB |
| 3.1 Beyond Formulas Ca Wi Mak Case 8 1 Output Ready Output Tab Starter Xlsb.zip |
11.78MB |
| 3.1 Beyond Formulas Keyboard Shortcut Olympics V Final Xlsb.zip |
2.50MB |
| 3.1 Beyond Formulas RAW DATA All Files.zip |
5.31MB |
| 3. Create an OUTPUT tab to easily consolidate & manage all model output.mp4 |
25.28MB |
| 3. Create an OUTPUT tab to easily consolidate & manage all model output.srt |
11.69KB |
| 3. Define the Problem Find true north with a problem statement & audience.mp4 |
9.52MB |
| 3. Define the Problem Find true north with a problem statement & audience.srt |
8.35KB |
| 3. Gather real data based on your Analysis & Data Plan.mp4 |
14.51MB |
| 3. Gather real data based on your Analysis & Data Plan.srt |
10.86KB |
| 3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.mp4 |
9.96MB |
| 3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.srt |
6.36KB |
| 3. Keyboard shortcut game Improve speed, save HOURS.mp4 |
17.83MB |
| 3. Keyboard shortcut game Improve speed, save HOURS.srt |
4.62KB |
| 3. The best aggregation formula for analyzing & describing your data.mp4 |
114.92MB |
| 3. The best aggregation formula for analyzing & describing your data.srt |
27.33KB |
| 3. You can’t predict the future, but you can glance at the range of possibilities.mp4 |
14.09MB |
| 3. You can’t predict the future, but you can glance at the range of possibilities.srt |
11.62KB |
| 30 |
413.63KB |
| 31 |
679.63KB |
| 32 |
690.11KB |
| 33 |
690.11KB |
| 34 |
626.41KB |
| 35 |
899.55KB |
| 36 |
987.72KB |
| 37 |
5.31KB |
| 38 |
149.84KB |
| 39 |
171.71KB |
| 4 |
317.40KB |
| 4.1 Beyond+Formulas+All+Course+Files.zip |
407.18MB |
| 4.1 Beyond Formulas Ca Wi Mak Case 5 2 Analysis Pivot Tables Starter Xlsb.zip |
7.55MB |
| 4.1 Beyond Formulas Ca Wi Mak Case 6 2 Modeling Time And Scale Starter Xlsb.zip |
11.51MB |
| 4.1 Beyond Formulas Ca Wi Mak Case 7 2 Scenarios Scenario Powerhouse Starter Xlsb.zip |
11.78MB |
| 4.1 Beyond Formulas Ca Wi Mak Case 8 2 Output Ready Charting Fundamentals Starter Xlsb.zip |
11.83MB |
| 4.1 Beyond Formulas Ca Wi Mak Case Details.pdf |
1.37MB |
| 4.1 OpenRefine.html |
96B |
| 4. BEYONDFORMULAS - Download all course materials.html |
346B |
| 4. Case-study Problem Statement for a Widget Manufacturing Company.mp4 |
10.28MB |
| 4. Case-study Problem Statement for a Widget Manufacturing Company.srt |
5.44KB |
| 4. Creating the charts you want, and saving your favorite charts with “templates”.mp4 |
108.19MB |
| 4. Creating the charts you want, and saving your favorite charts with “templates”.srt |
26.93KB |
| 4. Deal with Bad Data - Process, transform & clean large structured datasets.mp4 |
11.50MB |
| 4. Deal with Bad Data - Process, transform & clean large structured datasets.srt |
8.19KB |
| 4. Modeling the impact of time and economies of scale.mp4 |
6.81MB |
| 4. Modeling the impact of time and economies of scale.srt |
5.81KB |
| 4. PIVOT TABLES Everything you need to know to instantly summarize your data.mp4 |
126.52MB |
| 4. PIVOT TABLES Everything you need to know to instantly summarize your data.srt |
22.76KB |
| 4. Upgrade your new P&L model into a scenario crunching machine.mp4 |
44.24MB |
| 4. Upgrade your new P&L model into a scenario crunching machine.srt |
19.17KB |
| 4. What is Modular Model Design and why should you care.mp4 |
20.39MB |
| 4. What is Modular Model Design and why should you care.srt |
7.13KB |
| 40 |
510.00KB |
| 41 |
981.35KB |
| 42 |
71.05KB |
| 43 |
7.06KB |
| 44 |
540.53KB |
| 45 |
497.76KB |
| 46 |
931.85KB |
| 47 |
758.96KB |
| 48 |
148.73KB |
| 49 |
178.46KB |
| 5 |
495.57KB |
| 5.1 Beyond Formulas Ca Wi Mak Case 5 3 Analysis Intermediate Pivot Tables Starter Xlsb.zip |
11.48MB |
| 5.1 Beyond Formulas Ca Wi Mak Case 6 3 Modeling Adoption Curves Starter Xlsb.zip |
11.53MB |
| 5.1 Beyond Formulas Ca Wi Mak Case 7 3 Scenarios Data Tables Starter Xlsb.zip |
11.75MB |
| 5.1 Beyond Formulas RAW DATA All Files.zip |
5.31MB |
| 5. Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.mp4 |
15.99MB |
| 5. Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.srt |
10.52KB |
| 5. COURSE HANDOUT - Accompanying slides for each lesson.pdf |
22.33MB |
| 5. Got data Now what Best practice for importing data into your model.mp4 |
97.14MB |
| 5. Got data Now what Best practice for importing data into your model.srt |
12.25KB |
| 5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.mp4 |
115.83MB |
| 5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.srt |
21.50KB |
| 5. Model adoption curves over time instead of modeling a simple growth rate.mp4 |
39.93MB |
| 5. Model adoption curves over time instead of modeling a simple growth rate.srt |
15.21KB |
| 5. Structure the Problem Create the “Issue Tree” to break down & share your logic.mp4 |
10.72MB |
| 5. Structure the Problem Create the “Issue Tree” to break down & share your logic.srt |
11.21KB |
| 5. Use DATA TABLES to instantly get the answers to all of your scenarios at once.mp4 |
23.34MB |
| 5. Use DATA TABLES to instantly get the answers to all of your scenarios at once.srt |
8.94KB |
| 50 |
220.44KB |
| 51 |
225.16KB |
| 52 |
235.21KB |
| 53 |
235.92KB |
| 54 |
256.05KB |
| 55 |
279.74KB |
| 56 |
312.80KB |
| 57 |
313.16KB |
| 58 |
392.00KB |
| 59 |
394.33KB |
| 6 |
169.68KB |
| 6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.mp4 |
79.71MB |
| 6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.srt |
27.41KB |
| 6.1 Beyond Formulas Ca Wi Mak Case 4 4 Data Flat File Xlsb.zip |
11.25MB |
| 6.1 Beyond Formulas Ca Wi Mak Case 5 4 Analysis Getpivotdata And Trendline Starter Xlsb.zip |
11.58MB |
| 6.1 Beyond Formulas Ca Wi Mak Case 6 4 Modeling User Defined Formulas Starter Xlsb.zip |
11.58MB |
| 6.1 Beyond Formulas Ca Wi Mak Case 7 4 Scenarios Sensitivity Star Chart Starter Xlsb.zip |
11.77MB |
| 6.1 Beyond Formulas Modeling STARTER Template Xlsm.zip |
2.96MB |
| 6.2 Power Query.html |
122B |
| 6. Building a model for stakeholders Save hours of rework - make it “client-ready.mp4 |
75.66MB |
| 6. Building a model for stakeholders Save hours of rework - make it “client-ready.srt |
20.59KB |
| 6. Case-study Creating the issue tree for the Widget Manufacturing Company problem.mp4 |
11.85MB |
| 6. Case-study Creating the issue tree for the Widget Manufacturing Company problem.srt |
4.04KB |
| 6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.mp4 |
67.24MB |
| 6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.srt |
22.81KB |
| 6. Primer on structuring data & making it useful Table or “Flat file” format.mp4 |
25.10MB |
| 6. Primer on structuring data & making it useful Table or “Flat file” format.srt |
8.48KB |
| 6. The star chart approach to understanding variable-level sensitivity.mp4 |
34.13MB |
| 6. The star chart approach to understanding variable-level sensitivity.srt |
13.55KB |
| 60 |
430.95KB |
| 61 |
432.61KB |
| 62 |
448.72KB |
| 63 |
460.03KB |
| 64 |
480.57KB |
| 65 |
501.86KB |
| 66 |
507.46KB |
| 67 |
513.48KB |
| 68 |
534.36KB |
| 69 |
679.01KB |
| 7 |
79.49KB |
| 7. [optional] ADVANCED What to do if your model becomes really BIG or really SLOW.mp4 |
13.26MB |
| 7. [optional] ADVANCED What to do if your model becomes really BIG or really SLOW.srt |
9.80KB |
| 7.1 Beyond Formulas Ca Wi Mak Case 4 5 Data Join Datasets Xlsb.zip |
11.34MB |
| 7.1 Beyond Formulas Ca Wi Mak Case 5 5 Analysis Forecasting Starter Xlsb.zip |
11.56MB |
| 7.1 Beyond Formulas Ca Wi Mak Case 6 5 Modeling Phased Rollout Starter Xlsb.zip |
11.55MB |
| 7. Apply adoption curves to a phased geographic rollout.mp4 |
101.19MB |
| 7. Apply adoption curves to a phased geographic rollout.srt |
34.99KB |
| 7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.mp4 |
80.86MB |
| 7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.srt |
23.39KB |
| 7. Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).mp4 |
93.52MB |
| 7. Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).srt |
22.64KB |
| 7. Prioritize Find and prioritize the main business drivers.mp4 |
7.48MB |
| 7. Prioritize Find and prioritize the main business drivers.srt |
5.94KB |
| 70 |
764.18KB |
| 71 |
892.78KB |
| 72 |
289.24KB |
| 73 |
294.52KB |
| 74 |
734.34KB |
| 75 |
756.83KB |
| 76 |
45.93KB |
| 77 |
492.63KB |
| 78 |
862.92KB |
| 79 |
782.88KB |
| 8 |
272.22KB |
| 8.1 Beyond Formulas Ca Wi Mak Case 4 6 Data Tables Xlsb.zip |
16.93MB |
| 8.1 Beyond Formulas Ca Wi Mak Case 5 6 Analysis Next Level Lookup Starter Xlsb.zip |
11.62MB |
| 8.1 Beyond Formulas Ca Wi Mak Case 6 6 Modeling Supply Chain 101 Model Starter Xlsb.zip |
11.61MB |
| 8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.mp4 |
58.50MB |
| 8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.srt |
19.13KB |
| 8. Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.mp4 |
17.04MB |
| 8. Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.srt |
7.14KB |
| 8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.mp4 |
114.73MB |
| 8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.srt |
32.35KB |
| 8. Use TABLES - Interact with your data using Excel's secret data weapon.mp4 |
48.74MB |
| 8. Use TABLES - Interact with your data using Excel's secret data weapon.srt |
8.93KB |
| 80 |
448.20KB |
| 81 |
460.88KB |
| 82 |
532.81KB |
| 83 |
598.73KB |
| 84 |
195.43KB |
| 85 |
564.05KB |
| 86 |
708.14KB |
| 87 |
708.14KB |
| 88 |
92.58KB |
| 89 |
129.27KB |
| 9 |
57.84KB |
| 9.1 Beyond Formulas Ca Wi Mak Case 4 7 Data Text Parsing Xlsb.zip |
17.50MB |
| 9. CaWiMak Case study - course materials.pdf |
1.37MB |
| 9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.mp4 |
429.67MB |
| 9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.srt |
30.68KB |
| 9. Using String formulas to parse & manipulate text fields in your data.mp4 |
17.99MB |
| 9. Using String formulas to parse & manipulate text fields in your data.srt |
10.84KB |
| 90 |
712.17KB |
| 91 |
39.87KB |
| 92 |
156.57KB |
| 93 |
251.18KB |
| 94 |
383.16KB |
| 95 |
511.74KB |
| 96 |
701.42KB |
| 97 |
646.44KB |
| TutsNode.net.txt |
63B |