BeyondFormulas: Complete MS Excel Techniques & Modeling

Category Other
Type Tutorials
Language English
Total size 4.1 GB
Uploaded By tutsnode

Downloads 707
Last checked 1 day ago
Date uploaded 2 years ago
Seeders 40
Leechers 7

Infohash : 18023D14921CBF1E06C7C93638838B81CACA36A0

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

                Files: 

                BeyondFormulas Complete MS Excel Techniques & Modeling
[TutsNode.net] - BeyondFormulas Complete MS Excel Techniques & Modeling
EXCEL ENGINE ROOM Create a single, logical model flow to drive everything
Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.mp4 (429.7 MB)
Model Engine→Full multi-period P&L in just a few steps.srt (35.4 KB)
Apply adoption curves to a phased geographic rollout.srt (35.0 KB)
Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.srt (32.4 KB)
Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.srt (30.7 KB)
Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.srt (28.3 KB)
[Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.srt (27.4 KB)
Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.srt (24.0 KB)
Model adoption curves over time instead of modeling a simple growth rate.srt (15.2 KB)
EXCEL ENGINE ROOM - Course materials.html (0.2 KB)
ADVANCED Create a VBA function to calculate the distance between two locations.srt (9.2 KB)
Avoid public humiliation through Auditing and Error-checking.srt (7.1 KB)
Issue tree→Excel Creating a back-of- the-envelope business model “engine”.srt (6.4 KB)
Modeling the impact of time and economies of scale.srt (5.8 KB)
RECAP Of everything we've accomplished this section.srt (4.4 KB)
EXCEL ENGINE ROOM Section Intro.srt (1.8 KB)
Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.mp4 (340.9 MB)
1 Beyond+Formulas+Section+6+All+Files.zip (127.7 MB)
Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.mp4 (114.7 MB)
Model Engine→Full multi-period P&L in just a few steps.mp4 (110.9 MB)
Apply adoption curves to a phased geographic rollout.mp4 (101.2 MB)
[Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.mp4 (79.7 MB)
Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.mp4 (75.6 MB)
Model adoption curves over time instead of modeling a simple growth rate.mp4 (39.9 MB)
ADVANCED Create a VBA function to calculate the distance between two locations.mp4 (20.1 MB)
1 Beyond Formulas Ca Wi Mak Case 6 Complete Modeling Basics Completed Xlsb.zip (11.8 MB)
1 Beyond Formulas Ca Wi Mak Case 6 8 Modeling Multi Period Pn L Starter Xlsb.zip (11.7 MB)
1 Beyond Formulas Ca Wi Mak Case 6 6B Modeling VBA Distance Calc Starter Xlsb.zip (11.7 MB)
1 Beyond Formulas Ca Wi Mak Case 6 7 Modeling Supply Chain 201 Optimization Starter Xlsb.zip (11.7 MB)
1 Beyond Formulas Ca Wi Mak Case 6 6 Modeling Supply Chain 101 Model Starter Xlsb.zip (11.6 MB)
1 Beyond Formulas Ca Wi Mak Case 6 4 Modeling User Defined Formulas Starter Xlsb.zip (11.6 MB)
1 Beyond Formulas Ca Wi Mak Case 6 5 Modeling Phased Rollout Starter Xlsb.zip (11.6 MB)
1 Beyond Formulas Ca Wi Mak Case 6 3 Modeling Adoption Curves Starter Xlsb.zip (11.5 MB)
1 Beyond Formulas Ca Wi Mak Case 6 2 Modeling Time And Scale Starter Xlsb.zip (11.5 MB)
1 Beyond Formulas Ca Wi Mak Case 6 1 Modeling Back Of The Envelope Starter Xlsb.zip (11.5 MB)
RECAP Of everything we've accomplished this section.mp4 (11.1 MB)
Issue tree→Excel Creating a back-of- the-envelope business model “engine”.mp4 (10.0 MB)
Avoid public humiliation through Auditing and Error-checking.mp4 (7.4 MB)
Modeling the impact of time and economies of scale.mp4 (6.8 MB)
EXCEL ENGINE ROOM Section Intro.mp4 (3.3 MB)

INTRO Learn to solve problems in excel, instead of just formula syntax
BEYONDFORMULAS - Download all course materials.html (0.3 KB)
1 Beyond+Formulas+All+Course+Files.zip (407.2 MB)
Why this Excel Course.srt (7.0 KB)
[optional] Consultants, or Managers of analysts take note.srt (6.3 KB)
[optional] What this course covers Modeling Approach & Excel Tools.srt (5.6 KB)
COURSE HANDOUT - Accompanying slides for each lesson.pdf (22.3 MB)
Why this Excel Course.mp4 (15.5 MB)
[optional] What this course covers Modeling Approach & Excel Tools.mp4 (10.7 MB)
[optional] Consultants, or Managers of analysts take note.mp4 (10.3 MB)

DATA ANALYSIS Summarize your data with Formulas and PIVOT TABLES
The best aggregation formula for analyzing & describing your data.srt (27.3 KB)
Extrapolate CaWiMak sales data to forecast national sales using FORECAST.srt (23.4 KB)
Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.srt (22.8 KB)
PIVOT TABLES Everything you need to know to instantly summarize your data.srt (22.8 KB)
INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.srt (21.5 KB)
Next-level LOOKUPS Using “near match” lookups to group & categorize your data.srt (19.1 KB)
DATA ANALYSIS Section Intro.srt (3.0 KB)
DATA ANALYSIS - Course materials.html (0.2 KB)
PIVOT TABLES Everything you need to know to instantly summarize your data.mp4 (126.5 MB)
INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.mp4 (115.8 MB)
The best aggregation formula for analyzing & describing your data.mp4 (114.9 MB)
Extrapolate CaWiMak sales data to forecast national sales using FORECAST.mp4 (80.9 MB)
1 Beyond+Formulas+Section+5+All+Files.zip (73.4 MB)
Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.mp4 (67.2 MB)
Next-level LOOKUPS Using “near match” lookups to group & categorize your data.mp4 (58.5 MB)
1 Beyond Formulas Ca Wi Mak Case 5 6 Analysis Next Level Lookup Starter Xlsb.zip (11.6 MB)
1 Beyond Formulas Ca Wi Mak Case 5 4 Analysis Getpivotdata And Trendline Starter Xlsb.zip (11.6 MB)
1 Beyond Formulas Ca Wi Mak Case 5 5 Analysis Forecasting Starter Xlsb.zip (11.6 MB)
1 Beyond Formulas Ca Wi Mak Case 5 3 Analysis Intermediate Pivot Tables Starter Xlsb.zip (11.5 MB)
1 Beyond Formulas Ca Wi Mak Case 5 1 Analysis Basic Aggregation Starter Xlsb.zip (7.6 MB)
1 Beyond Formulas Ca Wi Mak Case 5 2 Analysis Pivot Tables Starter Xlsb.zip (7.5 MB)
DATA ANALYSIS Section Intro.mp4 (4.9 MB)

SLIDE-READY OUTPUT Synthesis, Data visualization and instant presentations
Creating the charts you want, and saving your favorite charts with “templates”.srt (26.9 KB)
Create an OUTPUT tab to easily consolidate & manage all model output.srt (11.7 KB)
SLIDE-READY OUTPUT Section Intro.srt (1.4 KB)
SLIDE-READY OUTPUT - Course materials.html (0.2 KB)
Creating the charts you want, and saving your favorite charts with “templates”.mp4 (108.2 MB)
Create an OUTPUT tab to easily consolidate & manage all model output.mp4 (25.3 MB)
1 Beyond+Formulas+Section+8+All+Files.zip (23.6 MB)
1 Beyond Formulas Ca Wi Mak Case 8 2 Output Ready Charting Fundamentals Starter Xlsb.zip (11.8 MB)
1 Beyond Formulas Ca Wi Mak Case 8 1 Output Ready Output Tab Starter Xlsb.zip (11.8 MB)
SLIDE-READY OUTPUT Section Intro.mp4 (2.3 MB)

DATA BASICS How to collect, clean, import, format, parse and lookup
Use Dynamic Named Ranges to give your data & cells easy-to-remember names.srt (25.0 KB)
DATA BASICS - Course materials.html (0.2 KB)
1 OpenRefine.html (0.1 KB)
Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).srt (22.6 KB)
Date & time parsing, conversion and manipulation.srt (12.3 KB)
Got data Now what Best practice for importing data into your model.srt (12.3 KB)
Gather real data based on your Analysis & Data Plan.srt (10.9 KB)
Using String formulas to parse & manipulate text fields in your data.srt (10.8 KB)
Use TABLES - Interact with your data using Excel's secret data weapon.srt (8.9 KB)
Primer on structuring data & making it useful Table or “Flat file” format.srt (8.5 KB)
Deal with Bad Data - Process, transform & clean large structured datasets.srt (8.2 KB)
DATA BASICS Section Intro.srt (2.0 KB)
2 Power Query.html (0.1 KB)
1 Beyond+Formulas+Section+4+All+Files.zip (203.8 MB)
Got data Now what Best practice for importing data into your model.mp4 (97.1 MB)
Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).mp4 (93.5 MB)
Use Dynamic Named Ranges to give your data & cells easy-to-remember names.mp4 (59.8 MB)
Use TABLES - Interact with your data using Excel's secret data weapon.mp4 (48.7 MB)
Date & time parsing, conversion and manipulation.mp4 (26.2 MB)
Primer on structuring data & making it useful Table or “Flat file” format.mp4 (25.1 MB)
1 Beyond Formulas Ca Wi Mak Case 4 9 Data Dynamic Named Ranges Xlsb.zip (18.0 MB)
Using String formulas to parse & manipulate text fields in your data.mp4 (18.0 MB)
1 Beyond Formulas Ca Wi Mak Case 4 8 Data Dates And Times Xlsb.zip (17.9 MB)
1 Beyond Formulas Ca Wi Mak Case 4 7 Data Text Parsing Xlsb.zip (17.5 MB)
1 Beyond Formulas Ca Wi Mak Case 4 6 Data Tables Xlsb.zip (16.9 MB)
Gather real data based on your Analysis & Data Plan.mp4 (14.5 MB)
Deal with Bad Data - Process, transform & clean large structured datasets.mp4 (11.5 MB)
1 Beyond Formulas Ca Wi Mak Case 4 5 Data Join Datasets Xlsb.zip (11.3 MB)
1 Beyond Formulas Ca Wi Mak Case 4 4 Data Flat File Xlsb.zip (11.3 MB)
1 Beyond Formulas RAW DATA All Files.zip (5.3 MB)
1 Beyond Formulas RAW DATA All Files.zip (5.3 MB)
DATA BASICS Section Intro.mp4 (3.9 MB)

EXCEL EFFICIENCY Be faster, more accurate, more impressive & less error-prone
EXCEL EFFICIENCY Section Intro.srt (1.5 KB)
EXCEL EFFICIENCY - Course materials.html (0.2 KB)
Building a model for stakeholders Save hours of rework - make it “client-ready.srt (20.6 KB)
Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.srt (10.5 KB)
[optional] ADVANCED What to do if your model becomes really BIG or really SLOW.srt (9.8 KB)
What is Modular Model Design and why should you care.srt (7.1 KB)
Keyboard shortcut game Improve speed, save HOURS.srt (4.6 KB)
Building a model for stakeholders Save hours of rework - make it “client-ready.mp4 (75.7 MB)
What is Modular Model Design and why should you care.mp4 (20.4 MB)
Keyboard shortcut game Improve speed, save HOURS.mp4 (17.8 MB)
Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.mp4 (16.0 MB)
[optional] ADVANCED What to do if your model becomes really BIG or really SLOW.mp4 (13.3 MB)
1 Beyond+Formulas+Section+2+All+Files.zip (5.4 MB)
1 Beyond Formulas Modeling STARTER Template Xlsm.zip (3.0 MB)
EXCEL EFFICIENCY Section Intro.mp4 (2.8 MB)
1 Beyond Formulas Keyboard Shortcut Olympics V Final Xlsb.zip (2.5 MB)

MODELING UNCERTAINTY Amazing Scenario and Sensitivity analyses made dead simple
Upgrade your new P&L model into a scenario crunching machine.srt (19.2 KB)
The star chart approach to understanding variable-level sensitivity.srt (13.5 KB)
You can’t predict the future, but you can glance at the range of possibilities.srt (11.6 KB)
Use DATA TABLES to instantly get the answers to all of your scenarios at once.srt (8.9 KB)
MODELING UNCERTAINTY Section Intro.srt (1.5 KB)
MODELING UNCERTAINTY - Course materials.html (0.2 KB)
1 Beyond+Formulas+Section+7+All+Files.zip (47.1 MB)
Upgrade your new P&L model into a scenario crunching machine.mp4 (44.2 MB)
The star chart approach to understanding variable-level sensitivity.mp4 (34.1 MB)
Use DATA TABLES to instantly get the answers to all of your scenarios at once.mp4 (23.3 MB)
You can’t predict the future, but you can glance at the range of possibilities.mp4 (14.1 MB)
1 Beyond Formulas Ca Wi Mak Case 7 2 Scenarios Scenario Powerhouse Starter Xlsb.zip (11.8 MB)
1 Beyond Formulas Ca Wi Mak Case 7 4 Scenarios Sensitivity Star Chart Starter Xlsb.zip (11.8 MB)
1 Beyond Formulas Ca Wi Mak Case 7 3 Scenarios Data Tables Starter Xlsb.zip (11.7 MB)
MODELING UNCERTAINTY Section Intro.mp4 (2.8 MB)

PROBLEM SOLVING BASICS Forget Excel. Problem solve on paper first
PROBLEM SOLVING BASICS Section Intro.srt (1.4 KB)
Structure the Problem Create the “Issue Tree” to break down & share your logic.srt (11.2 KB)
Define the Problem Find true north with a problem statement & audience.srt (8.4 KB)
Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.srt (7.1 KB)
Problem-solving 101 - the basic analytical problem solving process.srt (6.6 KB)
Prioritize Find and prioritize the main business drivers.srt (5.9 KB)
Case-study Problem Statement for a Widget Manufacturing Company.srt (5.4 KB)
Case-study Creating the issue tree for the Widget Manufacturing Company problem.srt (4.0 KB)
Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.mp4 (17.0 MB)
Case-study Creating the issue tree for the Widget Manufacturing Company problem.mp4 (11.9 MB)
Structure the Problem Create the “Issue Tree” to break down & share your logic.mp4 (10.7 MB)
Case-study Problem Statement for a Widget Manufacturing Company.mp4 (10.3 MB)
Define the Problem Find true north with a problem statement & audience.mp4 (9.5 MB)
Problem-solving 101 - the basic analytical problem solving process.mp4 (8.2 MB)
Prioritize Find and prioritize the main business drivers.mp4 (7.5 MB)
PROBLEM SOLVING BASICS Section Intro.mp4 (2.6 MB)
CaWiMak Case study - course materials.pdf (1.4 MB)
1 Beyond Formulas Ca Wi Mak Case Details.pdf (1.4 MB)

CONCLUSION
CONCLUSION How to apply what you've learned to solve any new problem.srt (6.3 KB)
COURSE HANDOUT - Accompanying slides for each lesson.pdf (22.3 MB)
CONCLUSION How to apply what you've learned to solve any new problem.mp4 (9.2 MB)

TutsNode.net.txt (0.1 KB)
.pad0 (0.0 KB)
(422.5 KB)
(84.6 KB)
(161.5 KB)
(317.4 KB)
(495.6 KB)
(169.7 KB)
(79.5 KB)
(272.2 KB)
(57.8 KB)
(825.3 KB)
(832.3 KB)
(879.8 KB)
(487.8 KB)
(142.8 KB)
(297.2 KB)
(346.1 KB)
(399.5 KB)
(630.9 KB)
(777.8 KB)
(162.6 KB)
(509.7 KB)
(268.0 KB)
(948.6 KB)
(776.4 KB)
(67.0 KB)
(886.6 KB)
(774.2 KB)
(738.6 KB)
(916.5 KB)
(413.6 KB)
(679.6 KB)
(690.1 KB)
(690.1 KB)
(626.4 KB)
(899.5 KB)
(987.7 KB)
(5.3 KB)
(149.8 KB)
(171.7 KB)
(510.0 KB)
(981.4 KB)
(71.0 KB)
(7.1 KB)
(540.5 KB)
(497.8 KB)
(931.8 KB)
(759.0 KB)
(148.7 KB)
(178.5 KB)
(220.4 KB)
(225.2 KB)
(235.2 KB)
(235.9 KB)
(256.0 KB)
(279.7 KB)
(312.8 KB)
(313.2 KB)
(392.0 KB)
(394.3 KB)
(430.9 KB)
(432.6 KB)
(448.7 KB)
(460.0 KB)
(480.6 KB)
(501.9 KB)
(507.5 KB)
(513.5 KB)
(534.4 KB)
(679.0 KB)
(764.2 KB)
(892.8 KB)
(289.2 KB)
(294.5 KB)
(734.3 KB)
(756.8 KB)
(45.9 KB)
(492.6 KB)
(862.9 KB)
(782.9 KB)
(448.2 KB)
(460.9 KB)
(532.8 KB)
(598.7 KB)
(195.4 KB)
(564.1 KB)
(708.1 KB)
(708.1 KB)
(92.6 KB)
(129.3 KB)
(712.2 KB)
(39.9 KB)
(156.6 KB)
(251.2 KB)
(383.2 KB)
(511.7 KB)
(701.4 KB)
(646.4 KB)
[TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)

There are currently no comments. Feel free to leave one :)

Code:

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