| 0 | 0 B | ||
| 1. CONCLUSION How to apply what you've learned to solve any new problem.mp4 | 9.2 MB | ||
| 1. CONCLUSION How to apply what you've learned to solve any new problem.srt | 6.3 KB | ||
| 1. DATA ANALYSIS Section Intro.mp4 | 4.9 MB | ||
| 1. DATA ANALYSIS Section Intro.srt | 3 KB | ||
| 1. DATA BASICS Section Intro.mp4 | 3.9 MB | ||
| 1. DATA BASICS Section Intro.srt | 2 KB | ||
| 1. EXCEL EFFICIENCY Section Intro.mp4 | 2.8 MB | ||
| 1. EXCEL EFFICIENCY Section Intro.srt | 1.5 KB | ||
| 1. EXCEL ENGINE ROOM Section Intro.mp4 | 3.3 MB | ||
| 1. EXCEL ENGINE ROOM Section Intro.srt | 1.8 KB | ||
| 1. MODELING UNCERTAINTY Section Intro.mp4 | 2.8 MB | ||
| 1. MODELING UNCERTAINTY Section Intro.srt | 1.5 KB | ||
| 1. PROBLEM SOLVING BASICS Section Intro.mp4 | 2.6 MB | ||
| 1. PROBLEM SOLVING BASICS Section Intro.srt | 1.4 KB | ||
| 1. SLIDE-READY OUTPUT Section Intro.mp4 | 2.3 MB | ||
| 1. SLIDE-READY OUTPUT Section Intro.srt | 1.4 KB | ||
| 1. Why this Excel Course.mp4 | 15.5 MB | ||
| 1. Why this Excel Course.srt | 7 KB | ||
| 1 | 422.5 KB | ||
| 2 | 84.6 KB | ||
| 3 | 161.5 KB | ||
| 4 | 317.4 KB | ||
| 5 | 495.6 KB | ||
| 6 | 169.7 KB | ||
| 7 | 79.5 KB | ||
| 8 | 272.2 KB | ||
| 9 | 57.8 KB | ||
| 10. ADVANCED Create a VBA function to calculate the distance between two locations.mp4 | 20.1 MB | ||
| 10. ADVANCED Create a VBA function to calculate the distance between two locations.srt | 9.2 KB | ||
| 10. Date & time parsing, conversion and manipulation.mp4 | 26.2 MB | ||
| 10. Date & time parsing, conversion and manipulation.srt | 12.3 KB | ||
| 10.1 Beyond Formulas Ca Wi Mak Case 4 8 Data Dates And Times Xlsb.zip | 17.9 MB | ||
| 10.1 Beyond Formulas Ca Wi Mak Case 6 6B Modeling VBA Distance Calc Starter Xlsb.zip | 11.7 MB | ||
| 11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.mp4 | 75.6 MB | ||
| 11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.srt | 28.3 KB | ||
| 11. Use Dynamic Named Ranges to give your data & cells easy-to-remember names.mp4 | 59.8 MB | ||
| 11. Use Dynamic Named Ranges to give your data & cells easy-to-remember names.srt | 25 KB | ||
| 11.1 Beyond Formulas Ca Wi Mak Case 4 9 Data Dynamic Named Ranges Xlsb.zip | 18 MB | ||
| 11.1 Beyond Formulas Ca Wi Mak Case 6 7 Modeling Supply Chain 201 Optimization Starter Xlsb.zip | 11.7 MB | ||
| 12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.mp4 | 340.9 MB | ||
| 12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.srt | 24 KB | ||
| 13. Model Engine→Full multi-period P&L in just a few steps.mp4 | 110.9 MB | ||
| 13. Model Engine→Full multi-period P&L in just a few steps.srt | 35.4 KB | ||
| 13.1 Beyond Formulas Ca Wi Mak Case 6 8 Modeling Multi Period Pn L Starter Xlsb.zip | 11.7 MB | ||
| 14. RECAP Of everything we've accomplished this section.mp4 | 11.1 MB | ||
| 14. RECAP Of everything we've accomplished this section.srt | 4.4 KB | ||
| 15. Avoid public humiliation through Auditing and Error-checking.mp4 | 7.4 MB | ||
| 15. Avoid public humiliation through Auditing and Error-checking.srt | 7.1 KB | ||
| 15.1 Beyond Formulas Ca Wi Mak Case 6 Complete Modeling Basics Completed Xlsb.zip | 11.8 MB | ||
| 2. COURSE HANDOUT - Accompanying slides for each lesson.pdf | 22.3 MB | ||
| 2. DATA ANALYSIS - Course materials.html | 204.8 B | ||
| 2. DATA BASICS - Course materials.html | 204.8 B | ||
| 2. EXCEL EFFICIENCY - Course materials.html | 204.8 B | ||
| 2. EXCEL ENGINE ROOM - Course materials.html | 204.8 B | ||
| 2. MODELING UNCERTAINTY - Course materials.html | 204.8 B | ||
| 2. Problem-solving 101 - the basic analytical problem solving process.mp4 | 8.2 MB | ||
| 2. Problem-solving 101 - the basic analytical problem solving process.srt | 6.6 KB | ||
| 2. SLIDE-READY OUTPUT - Course materials.html | 204.8 B | ||
| 2. [optional] What this course covers Modeling Approach & Excel Tools.mp4 | 10.7 MB | ||
| 2. [optional] What this course covers Modeling Approach & Excel Tools.srt | 5.6 KB | ||
| 2.1 Beyond+Formulas+Section+2+All+Files.zip | 5.4 MB | ||
| 2.1 Beyond+Formulas+Section+4+All+Files.zip | 203.8 MB | ||
| 2.1 Beyond+Formulas+Section+5+All+Files.zip | 73.4 MB | ||
| 2.1 Beyond+Formulas+Section+6+All+Files.zip | 127.7 MB | ||
| 2.1 Beyond+Formulas+Section+7+All+Files.zip | 47.1 MB | ||
| 2.1 Beyond+Formulas+Section+8+All+Files.zip | 23.6 MB | ||
| 3. Create an OUTPUT tab to easily consolidate & manage all model output.mp4 | 25.3 MB | ||
| 3. Create an OUTPUT tab to easily consolidate & manage all model output.srt | 11.7 KB | ||
| 3. Define the Problem Find true north with a problem statement & audience.mp4 | 9.5 MB | ||
| 3. Define the Problem Find true north with a problem statement & audience.srt | 8.4 KB | ||
| 3. Gather real data based on your Analysis & Data Plan.mp4 | 14.5 MB | ||
| 3. Gather real data based on your Analysis & Data Plan.srt | 10.9 KB | ||
| 3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.mp4 | 10 MB | ||
| 3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.srt | 6.4 KB | ||
| 3. Keyboard shortcut game Improve speed, save HOURS.mp4 | 17.8 MB | ||
| 3. Keyboard shortcut game Improve speed, save HOURS.srt | 4.6 KB | ||
| 3. The best aggregation formula for analyzing & describing your data.mp4 | 114.9 MB | ||
| 3. The best aggregation formula for analyzing & describing your data.srt | 27.3 KB | ||
| 3. You can’t predict the future, but you can glance at the range of possibilities.mp4 | 14.1 MB | ||
| 3. You can’t predict the future, but you can glance at the range of possibilities.srt | 11.6 KB | ||
| 3. [optional] Consultants, or Managers of analysts take note.mp4 | 10.3 MB | ||
| 3. [optional] Consultants, or Managers of analysts take note.srt | 6.3 KB | ||
| 3.1 Beyond Formulas Ca Wi Mak Case 5 1 Analysis Basic Aggregation Starter Xlsb.zip | 7.6 MB | ||
| 3.1 Beyond Formulas Ca Wi Mak Case 6 1 Modeling Back Of The Envelope Starter Xlsb.zip | 11.5 MB | ||
| 3.1 Beyond Formulas Ca Wi Mak Case 8 1 Output Ready Output Tab Starter Xlsb.zip | 11.8 MB | ||
| 3.1 Beyond Formulas Keyboard Shortcut Olympics V Final Xlsb.zip | 2.5 MB | ||
| 3.1 Beyond Formulas RAW DATA All Files.zip | 5.3 MB | ||
| 4. BEYONDFORMULAS - Download all course materials.html | 307.2 B | ||
| 4. Case-study Problem Statement for a Widget Manufacturing Company.mp4 | 10.3 MB | ||
| 4. Case-study Problem Statement for a Widget Manufacturing Company.srt | 5.4 KB | ||
| 4. Creating the charts you want, and saving your favorite charts with “templates”.mp4 | 108.2 MB | ||
| 4. Creating the charts you want, and saving your favorite charts with “templates”.srt | 26.9 KB | ||
| 4. Deal with Bad Data - Process, transform & clean large structured datasets.mp4 | 11.5 MB | ||
| 4. Deal with Bad Data - Process, transform & clean large structured datasets.srt | 8.2 KB | ||
| 4. Modeling the impact of time and economies of scale.mp4 | 6.8 MB | ||
| 4. Modeling the impact of time and economies of scale.srt | 5.8 KB | ||
| 4. PIVOT TABLES Everything you need to know to instantly summarize your data.mp4 | 126.5 MB | ||
| 4. PIVOT TABLES Everything you need to know to instantly summarize your data.srt | 22.8 KB | ||
| 4. Upgrade your new P&L model into a scenario crunching machine.mp4 | 44.2 MB | ||
| 4. Upgrade your new P&L model into a scenario crunching machine.srt | 19.2 KB | ||
| 4. What is Modular Model Design and why should you care.mp4 | 20.4 MB | ||
| 4. What is Modular Model Design and why should you care.srt | 7.1 KB | ||
| 4.1 Beyond Formulas Ca Wi Mak Case 5 2 Analysis Pivot Tables Starter Xlsb.zip | 7.5 MB | ||
| 4.1 Beyond Formulas Ca Wi Mak Case 6 2 Modeling Time And Scale Starter Xlsb.zip | 11.5 MB | ||
| 4.1 Beyond Formulas Ca Wi Mak Case 7 2 Scenarios Scenario Powerhouse Starter Xlsb.zip | 11.8 MB | ||
| 4.1 Beyond Formulas Ca Wi Mak Case 8 2 Output Ready Charting Fundamentals Starter Xlsb.zip | 11.8 MB | ||
| 4.1 Beyond Formulas Ca Wi Mak Case Details.pdf | 1.4 MB | ||
| 4.1 Beyond+Formulas+All+Course+Files.zip | 407.2 MB | ||
| 4.1 OpenRefine.html | 102.4 B | ||
| 5. Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.mp4 | 16 MB | ||
| 5. Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.srt | 10.5 KB | ||
| 5. COURSE HANDOUT - Accompanying slides for each lesson.pdf | 22.3 MB | ||
| 5. Got data Now what Best practice for importing data into your model.mp4 | 97.1 MB | ||
| 5. Got data Now what Best practice for importing data into your model.srt | 12.3 KB | ||
| 5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.mp4 | 115.8 MB | ||
| 5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.srt | 21.5 KB | ||
| 5. Model adoption curves over time instead of modeling a simple growth rate.mp4 | 39.9 MB | ||
| 5. Model adoption curves over time instead of modeling a simple growth rate.srt | 15.2 KB | ||
| 5. Structure the Problem Create the “Issue Tree” to break down & share your logic.mp4 | 10.7 MB | ||
| 5. Structure the Problem Create the “Issue Tree” to break down & share your logic.srt | 11.2 KB | ||
| 5. Use DATA TABLES to instantly get the answers to all of your scenarios at once.mp4 | 23.3 MB | ||
| 5. Use DATA TABLES to instantly get the answers to all of your scenarios at once.srt | 8.9 KB | ||
| 5.1 Beyond Formulas Ca Wi Mak Case 5 3 Analysis Intermediate Pivot Tables Starter Xlsb.zip | 11.5 MB | ||
| 5.1 Beyond Formulas Ca Wi Mak Case 6 3 Modeling Adoption Curves Starter Xlsb.zip | 11.5 MB | ||
| 5.1 Beyond Formulas Ca Wi Mak Case 7 3 Scenarios Data Tables Starter Xlsb.zip | 11.7 MB | ||
| 5.1 Beyond Formulas RAW DATA All Files.zip | 5.3 MB | ||
| 6. Building a model for stakeholders Save hours of rework - make it “client-ready.mp4 | 75.7 MB | ||
| 6. Building a model for stakeholders Save hours of rework - make it “client-ready.srt | 20.6 KB | ||
| 6. Case-study Creating the issue tree for the Widget Manufacturing Company problem.mp4 | 11.9 MB | ||
| 6. Case-study Creating the issue tree for the Widget Manufacturing Company problem.srt | 4 KB | ||
| 6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.mp4 | 67.2 MB | ||
| 6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.srt | 22.8 KB | ||
| 6. Primer on structuring data & making it useful Table or “Flat file” format.mp4 | 25.1 MB | ||
| 6. Primer on structuring data & making it useful Table or “Flat file” format.srt | 8.5 KB | ||
| 6. The star chart approach to understanding variable-level sensitivity.mp4 | 34.1 MB | ||
| 6. The star chart approach to understanding variable-level sensitivity.srt | 13.5 KB | ||
| 6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.mp4 | 79.7 MB | ||
| 6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.srt | 27.4 KB | ||
| 6.1 Beyond Formulas Ca Wi Mak Case 4 4 Data Flat File Xlsb.zip | 11.3 MB | ||
| 6.1 Beyond Formulas Ca Wi Mak Case 5 4 Analysis Getpivotdata And Trendline Starter Xlsb.zip | 11.6 MB | ||
| 6.1 Beyond Formulas Ca Wi Mak Case 6 4 Modeling User Defined Formulas Starter Xlsb.zip | 11.6 MB | ||
| 6.1 Beyond Formulas Ca Wi Mak Case 7 4 Scenarios Sensitivity Star Chart Starter Xlsb.zip | 11.8 MB | ||
| 6.1 Beyond Formulas Modeling STARTER Template Xlsm.zip | 3 MB | ||
| 6.2 Power Query.html | 102.4 B | ||
| 7. Apply adoption curves to a phased geographic rollout.mp4 | 101.2 MB | ||
| 7. Apply adoption curves to a phased geographic rollout.srt | 35 KB | ||
| 7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.mp4 | 80.9 MB | ||
| 7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.srt | 23.4 KB | ||
| 7. Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).mp4 | 93.5 MB | ||
| 7. Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).srt | 22.6 KB | ||
| 7. Prioritize Find and prioritize the main business drivers.mp4 | 7.5 MB | ||
| 7. Prioritize Find and prioritize the main business drivers.srt | 5.9 KB | ||
| 7. [optional] ADVANCED What to do if your model becomes really BIG or really SLOW.mp4 | 13.3 MB | ||
| 7. [optional] ADVANCED What to do if your model becomes really BIG or really SLOW.srt | 9.8 KB | ||
| 7.1 Beyond Formulas Ca Wi Mak Case 4 5 Data Join Datasets Xlsb.zip | 11.3 MB | ||
| 7.1 Beyond Formulas Ca Wi Mak Case 5 5 Analysis Forecasting Starter Xlsb.zip | 11.6 MB | ||
| 7.1 Beyond Formulas Ca Wi Mak Case 6 5 Modeling Phased Rollout Starter Xlsb.zip | 11.6 MB | ||
| 8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.mp4 | 58.5 MB | ||
| 8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.srt | 19.1 KB | ||
| 8. Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.mp4 | 17 MB | ||
| 8. Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.srt | 7.1 KB | ||
| 8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.mp4 | 114.7 MB | ||
| 8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.srt | 32.4 KB | ||
| 8. Use TABLES - Interact with your data using Excel's secret data weapon.mp4 | 48.7 MB | ||
| 8. Use TABLES - Interact with your data using Excel's secret data weapon.srt | 8.9 KB | ||
| 8.1 Beyond Formulas Ca Wi Mak Case 4 6 Data Tables Xlsb.zip | 16.9 MB | ||
| 8.1 Beyond Formulas Ca Wi Mak Case 5 6 Analysis Next Level Lookup Starter Xlsb.zip | 11.6 MB | ||
| 8.1 Beyond Formulas Ca Wi Mak Case 6 6 Modeling Supply Chain 101 Model Starter Xlsb.zip | 11.6 MB | ||
| 9. CaWiMak Case study - course materials.pdf | 1.4 MB | ||
| 9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.mp4 | 429.7 MB | ||
| 9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.srt | 30.7 KB | ||
| 9. Using String formulas to parse & manipulate text fields in your data.mp4 | 18 MB | ||
| 9. Using String formulas to parse & manipulate text fields in your data.srt | 10.8 KB | ||
| 9.1 Beyond Formulas Ca Wi Mak Case 4 7 Data Text Parsing Xlsb.zip | 17.5 MB | ||
| TutsNode.net.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614.4 B | ||
| 10 | 825.3 KB | ||
| 11 | 832.3 KB | ||
| 12 | 879.8 KB | ||
| 13 | 487.8 KB | ||
| 14 | 142.8 KB | ||
| 15 | 297.2 KB | ||
| 16 | 346.1 KB | ||
| 17 | 399.5 KB | ||
| 18 | 630.9 KB | ||
| 19 | 777.8 KB | ||
| 20 | 162.6 KB | ||
| 21 | 509.7 KB | ||
| 22 | 268 KB | ||
| 23 | 948.6 KB | ||
| 24 | 776.4 KB | ||
| 25 | 67 KB | ||
| 26 | 886.6 KB | ||
| 27 | 774.2 KB | ||
| 28 | 738.6 KB | ||
| 29 | 916.5 KB | ||
| 30 | 413.6 KB | ||
| 31 | 679.6 KB | ||
| 32 | 690.1 KB | ||
| 33 | 690.1 KB | ||
| 34 | 626.4 KB | ||
| 35 | 899.5 KB | ||
| 36 | 987.7 KB | ||
| 37 | 5.3 KB | ||
| 38 | 149.8 KB | ||
| 39 | 171.7 KB | ||
| 40 | 510 KB | ||
| 41 | 981.4 KB | ||
| 42 | 71 KB | ||
| 43 | 7.1 KB | ||
| 44 | 540.5 KB | ||
| 45 | 497.8 KB | ||
| 46 | 931.8 KB | ||
| 47 | 759 KB | ||
| 48 | 148.7 KB | ||
| 49 | 178.5 KB | ||
| 50 | 220.4 KB | ||
| 51 | 225.2 KB | ||
| 52 | 235.2 KB | ||
| 53 | 235.9 KB | ||
| 54 | 256 KB | ||
| 55 | 279.7 KB | ||
| 56 | 312.8 KB | ||
| 57 | 313.2 KB | ||
| 58 | 392 KB | ||
| 59 | 394.3 KB | ||
| 60 | 430.9 KB | ||
| 61 | 432.6 KB | ||
| 62 | 448.7 KB | ||
| 63 | 460 KB | ||
| 64 | 480.6 KB | ||
| 65 | 501.9 KB | ||
| 66 | 507.5 KB | ||
| 67 | 513.5 KB | ||
| 68 | 534.4 KB | ||
| 69 | 679 KB | ||
| 70 | 764.2 KB | ||
| 71 | 892.8 KB | ||
| 72 | 289.2 KB | ||
| 73 | 294.5 KB | ||
| 74 | 734.3 KB | ||
| 75 | 756.8 KB | ||
| 76 | 45.9 KB | ||
| 77 | 492.6 KB | ||
| 78 | 862.9 KB | ||
| 79 | 782.9 KB | ||
| 80 | 448.2 KB | ||
| 81 | 460.9 KB | ||
| 82 | 532.8 KB | ||
| 83 | 598.7 KB | ||
| 84 | 195.4 KB | ||
| 85 | 564.1 KB | ||
| 86 | 708.1 KB | ||
| 87 | 708.1 KB | ||
| 88 | 92.6 KB | ||
| 89 | 129.3 KB | ||
| 90 | 712.2 KB | ||
| 91 | 39.9 KB | ||
| 92 | 156.6 KB | ||
| 93 | 251.2 KB | ||
| 94 | 383.2 KB | ||
| 95 | 511.7 KB | ||
| 96 | 701.4 KB | ||
| 97 | 646.4 KB | ||
| ▲ 265 total files | |||
Description
*** This training teaches you:
1) All of the crucial excel techniques you should care about: including model structure, data handling, smart lookups, aggregation & basic statistics, tables, pivot tables, charts, VBA macros & custom formulas, and many more.
2) Unlike other training, I’ll teach you how to combine these tools to solve real world problems, and help you stand out in any analytical environment.
*** Learn, then immediately apply your new knowledge:
Bite-sized and Step-by-step curriculum, so you can learn one skill at a time, combine it all into a single beautiful model output.
The only Excel techniques and tips you’ll ever need, from over a year of research, and ten years of experience.
Learn to “manage upwards” so that you, the Modeler, don’t work all night.
Hands-on case study approach, to practice what you learn on a real problem. All starter materials provided for each course so you can get started quickly.
Holistic model design focus, so that your models to scale, adapt and evolve easily.
Keyboard shortcut game, coded in Excel, so you can get around Excel lightning fast.
Who this course is for:
Students / graduates trying to get hired for analytical skills
Consultants and corporate analysts looking to develop core skills
Entrepreneurs needing to model their new businesses
Experienced professionals trying to brush up on new tools
Requirements
Most of this training is Excel version agnostic. A few lessons require: Windows PC Excel 2007+ or Mac Excel 2011+
Requires only a very basic understanding of Excel (getting around the ribbon, formatting and basic IF statements)
Last Updated 11/2020
All Comments