BeyondFormulas: Complete MS Excel Techniques & Modeling

seeders: 0 leechers: 0
Added 2 years ago by tutsnode in Other
Downloaded 6 times.
1337x.to thepiratebay.org
BeyondFormulas: Complete MS Excel Techniques & Modeling

Torrent Contents Size: 4.1 GB

BeyondFormulas: Complete MS Excel Techniques & Modeling
▼ show more 250 files
0
0 B
1. CONCLUSION How to apply what you've learned to solve any new problem.mp4
MP4
9.2 MB
1. CONCLUSION How to apply what you've learned to solve any new problem.srt
SRT
6.3 KB
1. DATA ANALYSIS Section Intro.mp4
MP4
4.9 MB
1. DATA ANALYSIS Section Intro.srt
SRT
3 KB
1. DATA BASICS Section Intro.mp4
MP4
3.9 MB
1. DATA BASICS Section Intro.srt
SRT
2 KB
1. EXCEL EFFICIENCY Section Intro.mp4
MP4
2.8 MB
1. EXCEL EFFICIENCY Section Intro.srt
SRT
1.5 KB
1. EXCEL ENGINE ROOM Section Intro.mp4
MP4
3.3 MB
1. EXCEL ENGINE ROOM Section Intro.srt
SRT
1.8 KB
1. MODELING UNCERTAINTY Section Intro.mp4
MP4
2.8 MB
1. MODELING UNCERTAINTY Section Intro.srt
SRT
1.5 KB
1. PROBLEM SOLVING BASICS Section Intro.mp4
MP4
2.6 MB
1. PROBLEM SOLVING BASICS Section Intro.srt
SRT
1.4 KB
1. SLIDE-READY OUTPUT Section Intro.mp4
MP4
2.3 MB
1. SLIDE-READY OUTPUT Section Intro.srt
SRT
1.4 KB
1. Why this Excel Course.mp4
MP4
15.5 MB
1. Why this Excel Course.srt
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
MP4
20.1 MB
10. ADVANCED Create a VBA function to calculate the distance between two locations.srt
SRT
9.2 KB
10. Date & time parsing, conversion and manipulation.mp4
MP4
26.2 MB
10. Date & time parsing, conversion and manipulation.srt
SRT
12.3 KB
10.1 Beyond Formulas Ca Wi Mak Case 4 8 Data Dates And Times Xlsb.zip
ZIP
17.9 MB
10.1 Beyond Formulas Ca Wi Mak Case 6 6B Modeling VBA Distance Calc Starter Xlsb.zip
ZIP
11.7 MB
11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.mp4
MP4
75.6 MB
11. Supply Chain 201 (PART A) Elegant Optimization Just add DATA TABLES.srt
SRT
28.3 KB
11. Use Dynamic Named Ranges to give your data & cells easy-to-remember names.mp4
MP4
59.8 MB
11. Use Dynamic Named Ranges to give your data & cells easy-to-remember names.srt
SRT
25 KB
11.1 Beyond Formulas Ca Wi Mak Case 4 9 Data Dynamic Named Ranges Xlsb.zip
ZIP
18 MB
11.1 Beyond Formulas Ca Wi Mak Case 6 7 Modeling Supply Chain 201 Optimization Starter Xlsb.zip
ZIP
11.7 MB
12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.mp4
MP4
340.9 MB
12. Supply Chain 201 (PART B) Elegant Optimization Just add DATA TABLES.srt
SRT
24 KB
13. Model Engine→Full multi-period P&L in just a few steps.mp4
MP4
110.9 MB
13. Model Engine→Full multi-period P&L in just a few steps.srt
SRT
35.4 KB
13.1 Beyond Formulas Ca Wi Mak Case 6 8 Modeling Multi Period Pn L Starter Xlsb.zip
ZIP
11.7 MB
14. RECAP Of everything we've accomplished this section.mp4
MP4
11.1 MB
14. RECAP Of everything we've accomplished this section.srt
SRT
4.4 KB
15. Avoid public humiliation through Auditing and Error-checking.mp4
MP4
7.4 MB
15. Avoid public humiliation through Auditing and Error-checking.srt
SRT
7.1 KB
15.1 Beyond Formulas Ca Wi Mak Case 6 Complete Modeling Basics Completed Xlsb.zip
ZIP
11.8 MB
2. COURSE HANDOUT - Accompanying slides for each lesson.pdf
PDF
22.3 MB
2. DATA ANALYSIS - Course materials.html
HTML
204.8 B
2. DATA BASICS - Course materials.html
HTML
204.8 B
2. EXCEL EFFICIENCY - Course materials.html
HTML
204.8 B
2. EXCEL ENGINE ROOM - Course materials.html
HTML
204.8 B
2. MODELING UNCERTAINTY - Course materials.html
HTML
204.8 B
2. Problem-solving 101 - the basic analytical problem solving process.mp4
MP4
8.2 MB
2. Problem-solving 101 - the basic analytical problem solving process.srt
SRT
6.6 KB
2. SLIDE-READY OUTPUT - Course materials.html
HTML
204.8 B
2. [optional] What this course covers Modeling Approach & Excel Tools.mp4
MP4
10.7 MB
2. [optional] What this course covers Modeling Approach & Excel Tools.srt
SRT
5.6 KB
2.1 Beyond+Formulas+Section+2+All+Files.zip
ZIP
5.4 MB
2.1 Beyond+Formulas+Section+4+All+Files.zip
ZIP
203.8 MB
2.1 Beyond+Formulas+Section+5+All+Files.zip
ZIP
73.4 MB
2.1 Beyond+Formulas+Section+6+All+Files.zip
ZIP
127.7 MB
2.1 Beyond+Formulas+Section+7+All+Files.zip
ZIP
47.1 MB
2.1 Beyond+Formulas+Section+8+All+Files.zip
ZIP
23.6 MB
3. Create an OUTPUT tab to easily consolidate & manage all model output.mp4
MP4
25.3 MB
3. Create an OUTPUT tab to easily consolidate & manage all model output.srt
SRT
11.7 KB
3. Define the Problem Find true north with a problem statement & audience.mp4
MP4
9.5 MB
3. Define the Problem Find true north with a problem statement & audience.srt
SRT
8.4 KB
3. Gather real data based on your Analysis & Data Plan.mp4
MP4
14.5 MB
3. Gather real data based on your Analysis & Data Plan.srt
SRT
10.9 KB
3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.mp4
MP4
10 MB
3. Issue tree→Excel Creating a back-of- the-envelope business model “engine”.srt
SRT
6.4 KB
3. Keyboard shortcut game Improve speed, save HOURS.mp4
MP4
17.8 MB
3. Keyboard shortcut game Improve speed, save HOURS.srt
SRT
4.6 KB
3. The best aggregation formula for analyzing & describing your data.mp4
MP4
114.9 MB
3. The best aggregation formula for analyzing & describing your data.srt
SRT
27.3 KB
3. You can’t predict the future, but you can glance at the range of possibilities.mp4
MP4
14.1 MB
3. You can’t predict the future, but you can glance at the range of possibilities.srt
SRT
11.6 KB
3. [optional] Consultants, or Managers of analysts take note.mp4
MP4
10.3 MB
3. [optional] Consultants, or Managers of analysts take note.srt
SRT
6.3 KB
3.1 Beyond Formulas Ca Wi Mak Case 5 1 Analysis Basic Aggregation Starter Xlsb.zip
ZIP
7.6 MB
3.1 Beyond Formulas Ca Wi Mak Case 6 1 Modeling Back Of The Envelope Starter Xlsb.zip
ZIP
11.5 MB
3.1 Beyond Formulas Ca Wi Mak Case 8 1 Output Ready Output Tab Starter Xlsb.zip
ZIP
11.8 MB
3.1 Beyond Formulas Keyboard Shortcut Olympics V Final Xlsb.zip
ZIP
2.5 MB
3.1 Beyond Formulas RAW DATA All Files.zip
ZIP
5.3 MB
4. BEYONDFORMULAS - Download all course materials.html
HTML
307.2 B
4. Case-study Problem Statement for a Widget Manufacturing Company.mp4
MP4
10.3 MB
4. Case-study Problem Statement for a Widget Manufacturing Company.srt
SRT
5.4 KB
4. Creating the charts you want, and saving your favorite charts with “templates”.mp4
MP4
108.2 MB
4. Creating the charts you want, and saving your favorite charts with “templates”.srt
SRT
26.9 KB
4. Deal with Bad Data - Process, transform & clean large structured datasets.mp4
MP4
11.5 MB
4. Deal with Bad Data - Process, transform & clean large structured datasets.srt
SRT
8.2 KB
4. Modeling the impact of time and economies of scale.mp4
MP4
6.8 MB
4. Modeling the impact of time and economies of scale.srt
SRT
5.8 KB
4. PIVOT TABLES Everything you need to know to instantly summarize your data.mp4
MP4
126.5 MB
4. PIVOT TABLES Everything you need to know to instantly summarize your data.srt
SRT
22.8 KB
4. Upgrade your new P&L model into a scenario crunching machine.mp4
MP4
44.2 MB
4. Upgrade your new P&L model into a scenario crunching machine.srt
SRT
19.2 KB
4. What is Modular Model Design and why should you care.mp4
MP4
20.4 MB
4. What is Modular Model Design and why should you care.srt
SRT
7.1 KB
4.1 Beyond Formulas Ca Wi Mak Case 5 2 Analysis Pivot Tables Starter Xlsb.zip
ZIP
7.5 MB
4.1 Beyond Formulas Ca Wi Mak Case 6 2 Modeling Time And Scale Starter Xlsb.zip
ZIP
11.5 MB
4.1 Beyond Formulas Ca Wi Mak Case 7 2 Scenarios Scenario Powerhouse Starter Xlsb.zip
ZIP
11.8 MB
4.1 Beyond Formulas Ca Wi Mak Case 8 2 Output Ready Charting Fundamentals Starter Xlsb.zip
ZIP
11.8 MB
4.1 Beyond Formulas Ca Wi Mak Case Details.pdf
PDF
1.4 MB
4.1 Beyond+Formulas+All+Course+Files.zip
ZIP
407.2 MB
4.1 OpenRefine.html
HTML
102.4 B
5. Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.mp4
MP4
16 MB
5. Avoid embarrassing yourself Reduce spreadsheet risk to preempt mistakes.srt
SRT
10.5 KB
5. COURSE HANDOUT - Accompanying slides for each lesson.pdf
PDF
22.3 MB
5. Got data Now what Best practice for importing data into your model.mp4
MP4
97.1 MB
5. Got data Now what Best practice for importing data into your model.srt
SRT
12.3 KB
5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.mp4
MP4
115.8 MB
5. INTERMEDIATE PIVOT TABLES “Show Values As” options & Calculated fields.srt
SRT
21.5 KB
5. Model adoption curves over time instead of modeling a simple growth rate.mp4
MP4
39.9 MB
5. Model adoption curves over time instead of modeling a simple growth rate.srt
SRT
15.2 KB
5. Structure the Problem Create the “Issue Tree” to break down & share your logic.mp4
MP4
10.7 MB
5. Structure the Problem Create the “Issue Tree” to break down & share your logic.srt
SRT
11.2 KB
5. Use DATA TABLES to instantly get the answers to all of your scenarios at once.mp4
MP4
23.3 MB
5. Use DATA TABLES to instantly get the answers to all of your scenarios at once.srt
SRT
8.9 KB
5.1 Beyond Formulas Ca Wi Mak Case 5 3 Analysis Intermediate Pivot Tables Starter Xlsb.zip
ZIP
11.5 MB
5.1 Beyond Formulas Ca Wi Mak Case 6 3 Modeling Adoption Curves Starter Xlsb.zip
ZIP
11.5 MB
5.1 Beyond Formulas Ca Wi Mak Case 7 3 Scenarios Data Tables Starter Xlsb.zip
ZIP
11.7 MB
5.1 Beyond Formulas RAW DATA All Files.zip
ZIP
5.3 MB
6. Building a model for stakeholders Save hours of rework - make it “client-ready.mp4
MP4
75.7 MB
6. Building a model for stakeholders Save hours of rework - make it “client-ready.srt
SRT
20.6 KB
6. Case-study Creating the issue tree for the Widget Manufacturing Company problem.mp4
MP4
11.9 MB
6. Case-study Creating the issue tree for the Widget Manufacturing Company problem.srt
SRT
4 KB
6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.mp4
MP4
67.2 MB
6. Dynamic dashboards & data merging using GETPIVOTDATA, Pivot charts & slicers.srt
SRT
22.8 KB
6. Primer on structuring data & making it useful Table or “Flat file” format.mp4
MP4
25.1 MB
6. Primer on structuring data & making it useful Table or “Flat file” format.srt
SRT
8.5 KB
6. The star chart approach to understanding variable-level sensitivity.mp4
MP4
34.1 MB
6. The star chart approach to understanding variable-level sensitivity.srt
SRT
13.5 KB
6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.mp4
MP4
79.7 MB
6. [Optional] ADVANCED Create your own user-defined formulas with VBA. It's easy!.srt
SRT
27.4 KB
6.1 Beyond Formulas Ca Wi Mak Case 4 4 Data Flat File Xlsb.zip
ZIP
11.3 MB
6.1 Beyond Formulas Ca Wi Mak Case 5 4 Analysis Getpivotdata And Trendline Starter Xlsb.zip
ZIP
11.6 MB
6.1 Beyond Formulas Ca Wi Mak Case 6 4 Modeling User Defined Formulas Starter Xlsb.zip
ZIP
11.6 MB
6.1 Beyond Formulas Ca Wi Mak Case 7 4 Scenarios Sensitivity Star Chart Starter Xlsb.zip
ZIP
11.8 MB
6.1 Beyond Formulas Modeling STARTER Template Xlsm.zip
ZIP
3 MB
6.2 Power Query.html
HTML
102.4 B
7. Apply adoption curves to a phased geographic rollout.mp4
MP4
101.2 MB
7. Apply adoption curves to a phased geographic rollout.srt
SRT
35 KB
7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.mp4
MP4
80.9 MB
7. Extrapolate CaWiMak sales data to forecast national sales using FORECAST.srt
SRT
23.4 KB
7. Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).mp4
MP4
93.5 MB
7. Mergingjoining data using a Primary Key+INDEX+MATCH (instead of VLOOKUP).srt
SRT
22.6 KB
7. Prioritize Find and prioritize the main business drivers.mp4
MP4
7.5 MB
7. Prioritize Find and prioritize the main business drivers.srt
SRT
5.9 KB
7. [optional] ADVANCED What to do if your model becomes really BIG or really SLOW.mp4
MP4
13.3 MB
7. [optional] ADVANCED What to do if your model becomes really BIG or really SLOW.srt
SRT
9.8 KB
7.1 Beyond Formulas Ca Wi Mak Case 4 5 Data Join Datasets Xlsb.zip
ZIP
11.3 MB
7.1 Beyond Formulas Ca Wi Mak Case 5 5 Analysis Forecasting Starter Xlsb.zip
ZIP
11.6 MB
7.1 Beyond Formulas Ca Wi Mak Case 6 5 Modeling Phased Rollout Starter Xlsb.zip
ZIP
11.6 MB
8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.mp4
MP4
58.5 MB
8. Next-level LOOKUPS Using “near match” lookups to group & categorize your data.srt
SRT
19.1 KB
8. Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.mp4
MP4
17 MB
8. Plan Plan every detail of each analysis to go from Issue tree → Plan of Attack.srt
SRT
7.1 KB
8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.mp4
MP4
114.7 MB
8. Supply Chain modeling 101 (Part A) Shipping cost & manufacturing locations.srt
SRT
32.4 KB
8. Use TABLES - Interact with your data using Excel's secret data weapon.mp4
MP4
48.7 MB
8. Use TABLES - Interact with your data using Excel's secret data weapon.srt
SRT
8.9 KB
8.1 Beyond Formulas Ca Wi Mak Case 4 6 Data Tables Xlsb.zip
ZIP
16.9 MB
8.1 Beyond Formulas Ca Wi Mak Case 5 6 Analysis Next Level Lookup Starter Xlsb.zip
ZIP
11.6 MB
8.1 Beyond Formulas Ca Wi Mak Case 6 6 Modeling Supply Chain 101 Model Starter Xlsb.zip
ZIP
11.6 MB
9. CaWiMak Case study - course materials.pdf
PDF
1.4 MB
9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.mp4
MP4
429.7 MB
9. Supply Chain modeling 101 (Part B) Shipping cost & manufacturing locations.srt
SRT
30.7 KB
9. Using String formulas to parse & manipulate text fields in your data.mp4
MP4
18 MB
9. Using String formulas to parse & manipulate text fields in your data.srt
SRT
10.8 KB
9.1 Beyond Formulas Ca Wi Mak Case 4 7 Data Text Parsing Xlsb.zip
ZIP
17.5 MB
TutsNode.net.txt
TXT
102.4 B
[TGx]Downloaded from torrentgalaxy.to .txt
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

Description

Location

Trackers

Tracker name
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
udp://tracker.opentrackr.org:1337/announce
http://tracker.openbittorrent.com:80/announce
udp://opentracker.i2p.rocks:6969/announce
udp://tracker.internetwarriors.net:1337/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://coppersurfer.tk:6969/announce
udp://tracker.zer0day.to:1337/announce
Torrent hash: