[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.mp4 450.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/4.1 Beyond+Formulas+All+Course+Files.zip 427.0 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.mp4 357.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/2.1 Beyond+Formulas+Section+4+All+Files.zip 213.7 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/2.1 Beyond+Formulas+Section+6+All+Files.zip 133.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/4. PIVOT TABLES Everything you need to know to instantly summarize your data.mp4 132.7 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.mp4 121.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/3. The best aggregation formula for analyzing & describing your data.mp4 120.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.mp4 120.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/13. Model Engine→Full multi-period P&L in just a few steps.mp4 116.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/4. Creating the charts you want, and saving your favorite charts with “templates”.mp4 113.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/7. Apply adoption curves to a phased geographic rollout.mp4 106.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/5. Got data Now what Best practice for importing data into your model.mp4 101.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/7. Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).mp4 98.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.mp4 84.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.mp4 83.6 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/6. Building a model for stakeholders Save hours of rework - make it “client-ready.mp4 79.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.mp4 79.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/2.1 Beyond+Formulas+Section+5+All+Files.zip 76.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.mp4 70.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/11. Use Dynamic Named Ranges to give your data & cells easy-to-remember names.mp4 62.7 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.mp4 61.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/8. Use TABLES - Interact with your data using Excel's secret data weapon.mp4 51.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/2.1 Beyond+Formulas+Section+7+All+Files.zip 49.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/4. Upgrade your new P&L model into a scenario crunching machine.mp4 46.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/5. Model adoption curves over time instead of modeling a simple growth rate.mp4 41.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/6. The star chart approach to understanding variable-level sensitivity.mp4 35.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/10. Date & time parsing, conversion and manipulation.mp4 27.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/3. Create an OUTPUT tab to easily consolidate & manage all model output.mp4 26.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/6. Primer on structuring data & making it useful Table or “Flat file” format.mp4 26.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/2.1 Beyond+Formulas+Section+8+All+Files.zip 24.7 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/5. Use DATA TABLES to instantly get the answers to all of your scenarios at once.mp4 24.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/5. COURSE HANDOUT - Accompanying slides for each lesson.pdf 23.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/9. CONCLUSION/2. COURSE HANDOUT - Accompanying slides for each lesson.pdf 23.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/4. What is Modular Model Design and why should you care.mp4 21.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/10. ADVANCED Create a VBA function to calculate the distance between two locations.mp4 21.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/11.1 Beyond Formulas Ca Wi Mak Case 4 9 Data Dynamic Named Ranges Xlsb.zip 18.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/9. Using String formulas to parse & manipulate text fields in your data.mp4 18.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/10.1 Beyond Formulas Ca Wi Mak Case 4 8 Data Dates And Times Xlsb.zip 18.7 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/3. Keyboard shortcut game Improve speed, save HOURS.mp4 18.7 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/9.1 Beyond Formulas Ca Wi Mak Case 4 7 Data Text Parsing Xlsb.zip 18.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/8. Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.mp4 17.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/8.1 Beyond Formulas Ca Wi Mak Case 4 6 Data Tables Xlsb.zip 17.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/5. Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.mp4 16.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/1. Why this Excel Course.mp4 16.2 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/3. Gather real data based on your Analysis & Data Plan.mp4 15.2 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/3. You can’t predict the future, but you can glance at the range of possibilities.mp4 14.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/7. [optional] ADVANCED What to do if your model becomes really BIG or really SLOW.mp4 13.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/6. Case-study Creating the issue tree for the Widget Manufacturing Company problem.mp4 12.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/4.1 Beyond Formulas Ca Wi Mak Case 8 2 Output Ready Charting Fundamentals Starter Xlsb.zip 12.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/4.1 Beyond Formulas Ca Wi Mak Case 7 2 Scenarios Scenario Powerhouse Starter Xlsb.zip 12.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/3.1 Beyond Formulas Ca Wi Mak Case 8 1 Output Ready Output Tab Starter Xlsb.zip 12.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/15.1 Beyond Formulas Ca Wi Mak Case 6 Complete Modeling Basics Completed Xlsb.zip 12.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/6.1 Beyond Formulas Ca Wi Mak Case 7 4 Scenarios Sensitivity Star Chart Starter Xlsb.zip 12.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/5.1 Beyond Formulas Ca Wi Mak Case 7 3 Scenarios Data Tables Starter Xlsb.zip 12.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/13.1 Beyond Formulas Ca Wi Mak Case 6 8 Modeling Multi Period Pn L Starter Xlsb.zip 12.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/10.1 Beyond Formulas Ca Wi Mak Case 6 6B Modeling VBA Distance Calc Starter Xlsb.zip 12.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/11.1 Beyond Formulas Ca Wi Mak Case 6 7 Modeling Supply Chain 201 Optimization Starter Xlsb.zip 12.3 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/8.1 Beyond Formulas Ca Wi Mak Case 5 6 Analysis Next Level Lookup Starter Xlsb.zip 12.2 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/8.1 Beyond Formulas Ca Wi Mak Case 6 6 Modeling Supply Chain 101 Model Starter Xlsb.zip 12.2 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/6.1 Beyond Formulas Ca Wi Mak Case 5 4 Analysis Getpivotdata And Trendline Starter Xlsb.zip 12.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/6.1 Beyond Formulas Ca Wi Mak Case 6 4 Modeling User Defined Formulas Starter Xlsb.zip 12.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/7.1 Beyond Formulas Ca Wi Mak Case 5 5 Analysis Forecasting Starter Xlsb.zip 12.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/7.1 Beyond Formulas Ca Wi Mak Case 6 5 Modeling Phased Rollout Starter Xlsb.zip 12.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/5.1 Beyond Formulas Ca Wi Mak Case 6 3 Modeling Adoption Curves Starter Xlsb.zip 12.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/4.1 Beyond Formulas Ca Wi Mak Case 6 2 Modeling Time And Scale Starter Xlsb.zip 12.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/4. Deal with Bad Data - Process, transform & clean large structured datasets.mp4 12.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/3.1 Beyond Formulas Ca Wi Mak Case 6 1 Modeling Back Of The Envelope Starter Xlsb.zip 12.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/5.1 Beyond Formulas Ca Wi Mak Case 5 3 Analysis Intermediate Pivot Tables Starter Xlsb.zip 12.0 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/7.1 Beyond Formulas Ca Wi Mak Case 4 5 Data Join Datasets Xlsb.zip 11.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/6.1 Beyond Formulas Ca Wi Mak Case 4 4 Data Flat File Xlsb.zip 11.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/14. RECAP Of everything we've accomplished this section.mp4 11.7 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/5. Structure the Problem Create the “Issue Tree” to break down & share your logic.mp4 11.2 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/2. [optional] What this course covers Modeling Approach & Excel Tools.mp4 11.2 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/4. Case-study Problem Statement for a Widget Manufacturing Company.mp4 10.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/3. [optional] Consultants, or Managers of analysts take note.mp4 10.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.mp4 10.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/3. Define the Problem Find true north with a problem statement & audience.mp4 10.0 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/9. CONCLUSION/1. CONCLUSION How to apply what you've learned to solve any new problem.mp4 9.6 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/2. Problem-solving 101 - the basic analytical problem solving process.mp4 8.6 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/3.1 Beyond Formulas Ca Wi Mak Case 5 1 Analysis Basic Aggregation Starter Xlsb.zip 7.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/4.1 Beyond Formulas Ca Wi Mak Case 5 2 Analysis Pivot Tables Starter Xlsb.zip 7.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/7. Prioritize Find and prioritize the main business drivers.mp4 7.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/15. Avoid public humiliation through Auditing and Error-checking.mp4 7.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/4. Modeling the impact of time and economies of scale.mp4 7.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/2.1 Beyond+Formulas+Section+2+All+Files.zip 5.7 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/3.1 Beyond Formulas RAW DATA All Files.zip 5.6 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/5.1 Beyond Formulas RAW DATA All Files.zip 5.6 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/1. DATA ANALYSIS Section Intro.mp4 5.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/1. DATA BASICS Section Intro.mp4 4.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/1. EXCEL ENGINE ROOM Section Intro.mp4 3.5 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/6.1 Beyond Formulas Modeling STARTER Template Xlsm.zip 3.1 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/1. MODELING UNCERTAINTY Section Intro.mp4 3.0 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/1. EXCEL EFFICIENCY Section Intro.mp4 2.9 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/1. PROBLEM SOLVING BASICS Section Intro.mp4 2.8 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/3.1 Beyond Formulas Keyboard Shortcut Olympics V Final Xlsb.zip 2.6 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/1. SLIDE-READY OUTPUT Section Intro.mp4 2.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/9. CaWiMak Case study - course materials.pdf 1.4 MB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/4.1 Beyond Formulas Ca Wi Mak Case Details.pdf 1.4 MB
.pad/36 1.0 MB
.pad/41 1.0 MB
.pad/23 971.4 kB
.pad/46 954.2 kB
.pad/29 938.5 kB
.pad/35 921.1 kB
.pad/71 914.2 kB
.pad/26 907.9 kB
.pad/12 900.9 kB
.pad/78 883.6 kB
.pad/11 852.3 kB
.pad/10 845.1 kB
.pad/79 801.7 kB
.pad/19 796.5 kB
.pad/24 795.0 kB
.pad/27 792.8 kB
.pad/70 782.5 kB
.pad/47 777.2 kB
.pad/75 775.0 kB
.pad/28 756.3 kB
.pad/74 752.0 kB
.pad/90 729.3 kB
.pad/86 725.1 kB
.pad/87 725.1 kB
.pad/96 718.3 kB
.pad/32 706.7 kB
.pad/33 706.7 kB
.pad/31 695.9 kB
.pad/69 695.3 kB
.pad/97 662.0 kB
.pad/18 646.1 kB
.pad/34 641.4 kB
.pad/83 613.1 kB
.pad/85 577.6 kB
.pad/44 553.5 kB
.pad/68 547.2 kB
.pad/82 545.6 kB
.pad/67 525.8 kB
.pad/95 524.0 kB
.pad/40 522.2 kB
.pad/21 521.9 kB
.pad/66 519.6 kB
.pad/65 513.9 kB
.pad/45 509.7 kB
.pad/5 507.5 kB
.pad/77 504.5 kB
.pad/13 499.5 kB
.pad/64 492.1 kB
.pad/81 471.9 kB
.pad/63 471.1 kB
.pad/62 459.5 kB
.pad/80 459.0 kB
.pad/61 443.0 kB
.pad/60 441.3 kB
.pad/1 432.7 kB
.pad/30 423.6 kB
.pad/17 409.1 kB
.pad/59 403.8 kB
.pad/58 401.4 kB
.pad/94 392.4 kB
.pad/16 354.4 kB
.pad/4 325.0 kB
.pad/57 320.7 kB
.pad/56 320.3 kB
.pad/15 304.4 kB
.pad/73 301.6 kB
.pad/72 296.2 kB
.pad/55 286.5 kB
.pad/8 278.8 kB
.pad/22 274.4 kB
.pad/54 262.2 kB
.pad/93 257.2 kB
.pad/53 241.6 kB
.pad/52 240.9 kB
.pad/51 230.6 kB
.pad/50 225.7 kB
.pad/84 200.1 kB
.pad/49 182.7 kB
.pad/39 175.8 kB
.pad/6 173.8 kB
.pad/20 166.6 kB
.pad/3 165.4 kB
.pad/92 160.3 kB
.pad/38 153.4 kB
.pad/48 152.3 kB
.pad/14 146.2 kB
.pad/89 132.4 kB
.pad/88 94.8 kB
.pad/2 86.6 kB
.pad/7 81.4 kB
.pad/42 72.8 kB
.pad/25 68.6 kB
.pad/9 59.2 kB
.pad/76 47.0 kB
.pad/91 40.8 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/13. Model Engine→Full multi-period P&L in just a few steps.srt 36.2 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/7. Apply adoption curves to a phased geographic rollout.srt 35.8 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.srt 33.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.srt 31.4 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.srt 29.0 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.srt 28.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/3. The best aggregation formula for analyzing & describing your data.srt 28.0 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/4. Creating the charts you want, and saving your favorite charts with “templates”.srt 27.6 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/11. Use Dynamic Named Ranges to give your data & cells easy-to-remember names.srt 25.6 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.srt 24.5 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.srt 24.0 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.srt 23.4 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/4. PIVOT TABLES Everything you need to know to instantly summarize your data.srt 23.3 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/7. Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).srt 23.2 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.srt 22.0 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/6. Building a model for stakeholders Save hours of rework - make it “client-ready.srt 21.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/4. Upgrade your new P&L model into a scenario crunching machine.srt 19.6 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.srt 19.6 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/5. Model adoption curves over time instead of modeling a simple growth rate.srt 15.6 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/6. The star chart approach to understanding variable-level sensitivity.srt 13.9 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/10. Date & time parsing, conversion and manipulation.srt 12.6 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/5. Got data Now what Best practice for importing data into your model.srt 12.5 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/3. Create an OUTPUT tab to easily consolidate & manage all model output.srt 12.0 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/3. You can’t predict the future, but you can glance at the range of possibilities.srt 11.9 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/5. Structure the Problem Create the “Issue Tree” to break down & share your logic.srt 11.5 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/3. Gather real data based on your Analysis & Data Plan.srt 11.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/9. Using String formulas to parse & manipulate text fields in your data.srt 11.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/5. Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.srt 10.8 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/7. [optional] ADVANCED What to do if your model becomes really BIG or really SLOW.srt 10.0 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/10. ADVANCED Create a VBA function to calculate the distance between two locations.srt 9.4 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/5. Use DATA TABLES to instantly get the answers to all of your scenarios at once.srt 9.2 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/8. Use TABLES - Interact with your data using Excel's secret data weapon.srt 9.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/6. Primer on structuring data & making it useful Table or “Flat file” format.srt 8.7 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/3. Define the Problem Find true north with a problem statement & audience.srt 8.6 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/4. Deal with Bad Data - Process, transform & clean large structured datasets.srt 8.4 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/8. Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.srt 7.3 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/4. What is Modular Model Design and why should you care.srt 7.3 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/15. Avoid public humiliation through Auditing and Error-checking.srt 7.3 kB
.pad/43 7.2 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/1. Why this Excel Course.srt 7.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/2. Problem-solving 101 - the basic analytical problem solving process.srt 6.7 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.srt 6.5 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/9. CONCLUSION/1. CONCLUSION How to apply what you've learned to solve any new problem.srt 6.5 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/3. [optional] Consultants, or Managers of analysts take note.srt 6.4 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/7. Prioritize Find and prioritize the main business drivers.srt 6.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/4. Modeling the impact of time and economies of scale.srt 6.0 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/2. [optional] What this course covers Modeling Approach & Excel Tools.srt 5.8 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/4. Case-study Problem Statement for a Widget Manufacturing Company.srt 5.6 kB
.pad/37 5.4 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/3. Keyboard shortcut game Improve speed, save HOURS.srt 4.7 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/14. RECAP Of everything we've accomplished this section.srt 4.5 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/6. Case-study Creating the issue tree for the Widget Manufacturing Company problem.srt 4.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/1. DATA ANALYSIS Section Intro.srt 3.1 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/1. DATA BASICS Section Intro.srt 2.0 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/1. EXCEL ENGINE ROOM Section Intro.srt 1.9 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/1. EXCEL EFFICIENCY Section Intro.srt 1.5 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/1. MODELING UNCERTAINTY Section Intro.srt 1.5 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/3. PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first/1. PROBLEM SOLVING BASICS Section Intro.srt 1.4 kB
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/1. SLIDE-READY OUTPUT Section Intro.srt 1.4 kB
[TGx]Downloaded from torrentgalaxy.to .txt 585 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/1. INTRO Learn to solve problems in excel, instead of just formula syntax/4. BEYONDFORMULAS - Download all course materials.html 346 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/6. EXCEL ENGINE ROOM Create a single, logical model flow to drive everything/2. EXCEL ENGINE ROOM - Course materials.html 198 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/2. EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone/2. EXCEL EFFICIENCY - Course materials.html 195 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/2. DATA BASICS - Course materials.html 195 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES/2. DATA ANALYSIS - Course materials.html 195 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/7. MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple/2. MODELING UNCERTAINTY - Course materials.html 195 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations/2. SLIDE-READY OUTPUT - Course materials.html 195 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/6.2 Power Query.html 122 Bytes
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling/4. DATA BASICS How to collect, clean, import, format, parse and lookup/4.1 OpenRefine.html 96 Bytes