|
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
|
BeyondFormulas Complete MS Excel Techniques & Modeling
[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 (429.7 MB)
-
13. Model Engine→Full multi-period P&L in just a few steps.srt (35.4 KB)
-
7. Apply adoption curves to a phased geographic rollout.srt (35.0 KB)
-
8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.srt (32.4 KB)
-
9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.srt (30.7 KB)
-
11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.srt (28.3 KB)
-
6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.srt (27.4 KB)
-
12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.srt (24.0 KB)
-
5. Model adoption curves over time instead of modeling a simple growth rate.srt (15.2 KB)
-
2. EXCEL ENGINE ROOM - Course materials.html (0.2 KB)
-
10. ADVANCED Create a VBA function to calculate the distance between two locations.srt (9.2 KB)
-
15. Avoid public humiliation through Auditing and Error-checking.srt (7.1 KB)
-
3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.srt (6.4 KB)
-
4. Modeling the impact of time and economies of scale.srt (5.8 KB)
-
14. RECAP Of everything we've accomplished this section.srt (4.4 KB)
-
1. EXCEL ENGINE ROOM Section Intro.srt (1.8 KB)
-
12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.mp4 (340.9 MB)
-
2.1 Beyond+Formulas+Section+6+All+Files.zip (127.7 MB)
-
8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.mp4 (114.7 MB)
-
13. Model Engine→Full multi-period P&L in just a few steps.mp4 (110.9 MB)
-
7. Apply adoption curves to a phased geographic rollout.mp4 (101.2 MB)
-
6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.mp4 (79.7 MB)
-
11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.mp4 (75.6 MB)
-
5. Model adoption curves over time instead of modeling a simple growth rate.mp4 (39.9 MB)
-
10. ADVANCED Create a VBA function to calculate the distance between two locations.mp4 (20.1 MB)
-
15.1 Beyond Formulas Ca Wi Mak Case 6 Complete Modeling Basics Completed Xlsb.zip (11.8 MB)
-
13.1 Beyond Formulas Ca Wi Mak Case 6 8 Modeling Multi Period Pn L Starter Xlsb.zip (11.7 MB)
-
10.1 Beyond Formulas Ca Wi Mak Case 6 6B Modeling VBA Distance Calc Starter Xlsb.zip (11.7 MB)
-
11.1 Beyond Formulas Ca Wi Mak Case 6 7 Modeling Supply Chain 201 Optimization Starter Xlsb.zip (11.7 MB)
-
8.1 Beyond Formulas Ca Wi Mak Case 6 6 Modeling Supply Chain 101 Model 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)
-
7.1 Beyond Formulas Ca Wi Mak Case 6 5 Modeling Phased Rollout Starter Xlsb.zip (11.6 MB)
-
5.1 Beyond Formulas Ca Wi Mak Case 6 3 Modeling Adoption Curves Starter Xlsb.zip (11.5 MB)
-
4.1 Beyond Formulas Ca Wi Mak Case 6 2 Modeling Time And Scale Starter Xlsb.zip (11.5 MB)
-
3.1 Beyond Formulas Ca Wi Mak Case 6 1 Modeling Back Of The Envelope Starter Xlsb.zip (11.5 MB)
-
14. RECAP Of everything we've accomplished this section.mp4 (11.1 MB)
-
3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.mp4 (10.0 MB)
-
15. Avoid public humiliation through Auditing and Error-checking.mp4 (7.4 MB)
-
4. Modeling the impact of time and economies of scale.mp4 (6.8 MB)
-
1. EXCEL ENGINE ROOM Section Intro.mp4 (3.3 MB)
1. INTRO Learn to solve problems in excel, instead of just formula syntax
-
4. BEYONDFORMULAS - Download all course materials.html (0.3 KB)
-
4.1 Beyond+Formulas+All+Course+Files.zip (407.2 MB)
-
1. Why this Excel Course.srt (7.0 KB)
-
3. [optional] Consultants, or Managers of analysts take note.srt (6.3 KB)
-
2. [optional] What this course covers Modeling Approach & Excel Tools.srt (5.6 KB)
-
5. COURSE HANDOUT - Accompanying slides for each lesson.pdf (22.3 MB)
-
1. Why this Excel Course.mp4 (15.5 MB)
-
2. [optional] What this course covers Modeling Approach & Excel Tools.mp4 (10.7 MB)
-
3. [optional] Consultants, or Managers of analysts take note.mp4 (10.3 MB)
5. DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES
-
3. The best aggregation formula for analyzing & describing your data.srt (27.3 KB)
-
7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.srt (23.4 KB)
-
6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.srt (22.8 KB)
-
4. PIVOT TABLES Everything you need to know to instantly summarize your data.srt (22.8 KB)
-
5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.srt (21.5 KB)
-
8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.srt (19.1 KB)
-
1. DATA ANALYSIS Section Intro.srt (3.0 KB)
-
2. DATA ANALYSIS - Course materials.html (0.2 KB)
-
4. PIVOT TABLES Everything you need to know to instantly summarize your data.mp4 (126.5 MB)
-
5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.mp4 (115.8 MB)
-
3. The best aggregation formula for analyzing & describing your data.mp4 (114.9 MB)
-
7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.mp4 (80.9 MB)
-
2.1 Beyond+Formulas+Section+5+All+Files.zip (73.4 MB)
-
6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.mp4 (67.2 MB)
-
8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.mp4 (58.5 MB)
-
8.1 Beyond Formulas Ca Wi Mak Case 5 6 Analysis Next Level Lookup Starter Xlsb.zip (11.6 MB)
-
6.1 Beyond Formulas Ca Wi Mak Case 5 4 Analysis Getpivotdata And Trendline Starter Xlsb.zip (11.6 MB)
-
7.1 Beyond Formulas Ca Wi Mak Case 5 5 Analysis Forecasting Starter Xlsb.zip (11.6 MB)
-
5.1 Beyond Formulas Ca Wi Mak Case 5 3 Analysis Intermediate Pivot Tables Starter Xlsb.zip (11.5 MB)
-
3.1 Beyond Formulas Ca Wi Mak Case 5 1 Analysis Basic Aggregation Starter Xlsb.zip (7.6 MB)
-
4.1 Beyond Formulas Ca Wi Mak Case 5 2 Analysis Pivot Tables Starter Xlsb.zip (7.5 MB)
-
1. DATA ANALYSIS Section Intro.mp4 (4.9 MB)
8. SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations
-
4. Creating the charts you want, and saving your favorite charts with “templates”.srt (26.9 KB)
-
3. Create an OUTPUT tab to easily consolidate & manage all model output.srt (11.7 KB)
-
1. SLIDE-READY OUTPUT Section Intro.srt (1.4 KB)
-
2. SLIDE-READY OUTPUT - Course materials.html (0.2 KB)
-
files
|
|
udp://open.stealth.si:80/announce udp://tracker.tiny-vps.com:6969/announce udp://fasttracker.foreverpirates.co:6969/announce udp://tracker.opentrackr.org:1337/announce udp://explodie.org:6969/announce udp://tracker.cyberia.is:6969/announce udp://ipv4.tracker.harry.lu:80/announce udp://tracker.uw0.xyz:6969/announce udp://opentracker.i2p.rocks:6969/announce udp://tracker.birkenwald.de:6969/announce udp://tracker.torrent.eu.org:451/announce udp://tracker.moeking.me:6969/announce udp://tracker.dler.org:6969/announce udp://9.rarbg.me:2970/announce |
