|
|
001 Conclusion.en.srt
|
SRT
|
3.7 KB
|
|
|
001 Conclusion.mp4
|
MP4
|
50.2 MB
|
|
|
001 Introduction.en.srt
|
SRT
|
1.2 KB
|
|
|
001 Introduction.mp4
|
MP4
|
17.8 MB
|
|
|
002 Adding Instructions.en.srt
|
SRT
|
2.5 KB
|
|
|
002 Adding Instructions.mp4
|
MP4
|
22.6 MB
|
|
|
002 Automating Data Dump through a Script.en.srt
|
SRT
|
4.2 KB
|
|
|
002 Automating Data Dump through a Script.mp4
|
MP4
|
43 MB
|
|
|
002 Bonus Lecture.en.srt
|
SRT
|
5 KB
|
|
|
002 Bonus Lecture.mp4
|
MP4
|
38.9 MB
|
|
|
002 Defining Sheet Structure.en.srt
|
SRT
|
1.4 KB
|
|
|
002 Defining Sheet Structure.mp4
|
MP4
|
12.9 MB
|
|
|
002 Intro to the First Graph.en.srt
|
SRT
|
1.8 KB
|
|
|
002 Intro to the First Graph.mp4
|
MP4
|
10.2 MB
|
|
|
002 Key Formula Combination - INDEX & MATCH.en.srt
|
SRT
|
10.3 KB
|
|
|
002 Key Formula Combination - INDEX & MATCH.mp4
|
MP4
|
68.5 MB
|
|
|
002 Mapping Down the Metrics.en.srt
|
SRT
|
15.8 KB
|
|
|
002 Mapping Down the Metrics.mp4
|
MP4
|
79.8 MB
|
|
|
002 Pulling Data with INDIRECT & ADDRESS.en.srt
|
SRT
|
4.1 KB
|
|
|
002 Pulling Data with INDIRECT & ADDRESS.mp4
|
MP4
|
28.4 MB
|
|
|
002 Status for Data Dump.en.srt
|
SRT
|
7.7 KB
|
|
|
002 Status for Data Dump.mp4
|
MP4
|
50.2 MB
|
|
|
002 What to Include in the Cover tab_.en.srt
|
SRT
|
8.9 KB
|
|
|
002 What to Include in the Cover tab_.mp4
|
MP4
|
39.5 MB
|
|
|
002 Why Google Sheets, not Excel_.en.srt
|
SRT
|
4.7 KB
|
|
|
002 Why Google Sheets, not Excel_.mp4
|
MP4
|
63.5 MB
|
|
|
003 Connecting the Data to the Tab.en.srt
|
SRT
|
5.1 KB
|
|
|
003 Connecting the Data to the Tab.mp4
|
MP4
|
40.5 MB
|
|
|
003 Connecting the Formulas.en.srt
|
SRT
|
3 KB
|
|
|
003 Connecting the Formulas.mp4
|
MP4
|
25.9 MB
|
|
|
003 Creating Multi-Level Reporting System.en.srt
|
SRT
|
5.1 KB
|
|
|
003 Creating Multi-Level Reporting System.mp4
|
MP4
|
60.1 MB
|
|
|
003 Creating the Framework for Competitor Tracking.en.srt
|
SRT
|
4.8 KB
|
|
|
003 Creating the Framework for Competitor Tracking.mp4
|
MP4
|
17.1 MB
|
|
|
003 Data Visualisation Principles.en.srt
|
SRT
|
3.7 KB
|
|
|
003 Data Visualisation Principles.mp4
|
MP4
|
40.8 MB
|
|
|
003 Defining the Week Periods and Week References.en.srt
|
SRT
|
5.4 KB
|
|
|
003 Defining the Week Periods and Week References.mp4
|
MP4
|
8 MB
|
|
|
003 Determining Year with TEXT.en.srt
|
SRT
|
3.1 KB
|
|
|
003 Determining Year with TEXT.mp4
|
MP4
|
7.4 MB
|
|
|
003 Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE.en.srt
|
SRT
|
4.8 KB
|
|
|
003 Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE.mp4
|
MP4
|
34.8 MB
|
|
|
003 Quick Example_ How to Efficiently Automate Reporting.en.srt
|
SRT
|
2.9 KB
|
|
|
003 Quick Example_ How to Efficiently Automate Reporting.mp4
|
MP4
|
12.2 MB
|
|
|
003 Reviewing Links in Cover tab.en.srt
|
SRT
|
1.4 KB
|
|
|
003 Reviewing Links in Cover tab.mp4
|
MP4
|
8.6 MB
|
|
|
003 Setting Up Forecasting Formulas.en.srt
|
SRT
|
10.7 KB
|
|
|
003 Setting Up Forecasting Formulas.mp4
|
MP4
|
56 MB
|
|
|
003 Table of Contents.en.srt
|
SRT
|
3.7 KB
|
|
|
003 Table of Contents.mp4
|
MP4
|
22.8 MB
|
|
|
003 Use OFFSET for Dynamic Calculations.en.srt
|
SRT
|
6.3 KB
|
|
|
003 Use OFFSET for Dynamic Calculations.mp4
|
MP4
|
38.1 MB
|
|
|
004 Adding Formulas to Framework.en.srt
|
SRT
|
6.4 KB
|
|
|
004 Adding Formulas to Framework.mp4
|
MP4
|
39.3 MB
|
|
|
004 Advanced_ Connecting Stable Metrics to Dataset.en.srt
|
SRT
|
15.1 KB
|
|
|
004 Advanced_ Connecting Stable Metrics to Dataset.mp4
|
MP4
|
109.3 MB
|
|
|
004 Color Coding for Weekly Trends.en.srt
|
SRT
|
3.9 KB
|
|
|
004 Color Coding for Weekly Trends.mp4
|
MP4
|
14.4 MB
|
|
|
004 Connecting the Formulas with INDEX & MATCH.en.srt
|
SRT
|
4.1 KB
|
|
|
004 Connecting the Formulas with INDEX & MATCH.mp4
|
MP4
|
31.7 MB
|
|
|
004 Dynamic Budget Connection with QUERY.en.srt
|
SRT
|
5.4 KB
|
|
|
004 Dynamic Budget Connection with QUERY.mp4
|
MP4
|
36 MB
|
|
|
004 Final Touches on Whole File.en.srt
|
SRT
|
3.8 KB
|
|
|
004 Final Touches on Whole File.mp4
|
MP4
|
26.6 MB
|
|
|
004 Graph I_ Key Actuals with Targets.en.srt
|
SRT
|
20.7 KB
|
|
|
004 Graph I_ Key Actuals with Targets.mp4
|
MP4
|
119.7 MB
|
|
|
004 IMPORTRANGE with INDEX & MATCH.en.srt
|
SRT
|
7.7 KB
|
|
|
004 IMPORTRANGE with INDEX & MATCH.mp4
|
MP4
|
44.1 MB
|
|
|
004 Linking Key Information.en.srt
|
SRT
|
3.4 KB
|
|
|
004 Linking Key Information.mp4
|
MP4
|
27 MB
|
|
|
004 Not Showing Data for Unpassed Weeks.en.srt
|
SRT
|
2.4 KB
|
|
|
004 Not Showing Data for Unpassed Weeks.mp4
|
MP4
|
20.9 MB
|
|
|
004 Optimise Spreadsheet Performance.en.srt
|
SRT
|
2.6 KB
|
|
|
004 Optimise Spreadsheet Performance.mp4
|
MP4
|
31.4 MB
|
|
|
004 Overview of Course Projects.en.srt
|
SRT
|
3.7 KB
|
|
|
004 Overview of Course Projects.mp4
|
MP4
|
42.7 MB
|
|
|
004 Smart use of IF's - Dynamic SUMIF and AVERAGEIF.en.srt
|
SRT
|
11.1 KB
|
|
|
004 Smart use of IF's - Dynamic SUMIF and AVERAGEIF.mp4
|
MP4
|
77.5 MB
|
|
|
005 Advanced Formula_ QUERY.en.srt
|
SRT
|
4.3 KB
|
|
|
005 Advanced Formula_ QUERY.mp4
|
MP4
|
38.8 MB
|
|
|
005 Calculating the Variances.en.srt
|
SRT
|
2.4 KB
|
|
|
005 Calculating the Variances.mp4
|
MP4
|
19.5 MB
|
|
|
005 Color Coding for Monthly Budgets.en.srt
|
SRT
|
11 KB
|
|
|
005 Color Coding for Monthly Budgets.mp4
|
MP4
|
62.4 MB
|
|
|
005 Estimating Competitor and Market Size.en.srt
|
SRT
|
13.5 KB
|
|
|
005 Estimating Competitor and Market Size.mp4
|
MP4
|
84.1 MB
|
|
|
005 Final Touches.en.srt
|
SRT
|
3.8 KB
|
|
|
005 Final Touches.mp4
|
MP4
|
37.7 MB
|
|
|
005 Graph II_ Monthly Actuals with Budgeted Forecasts.en.srt
|
SRT
|
18.3 KB
|
|
|
005 Graph II_ Monthly Actuals with Budgeted Forecasts.mp4
|
MP4
|
85.5 MB
|
|
|
005 Linking Targets with Actuals.en.srt
|
SRT
|
8.8 KB
|
|
|
005 Linking Targets with Actuals.mp4
|
MP4
|
66.3 MB
|
|
|
005 Protecting the Sheets.en.srt
|
SRT
|
4.6 KB
|
|
|
005 Protecting the Sheets.mp4
|
MP4
|
25.8 MB
|
|
|
005 Setting Up Budget Connections and Calculations.en.srt
|
SRT
|
10.4 KB
|
|
|
005 Setting Up Budget Connections and Calculations.mp4
|
MP4
|
65.1 MB
|
|
|
005 Use Your Brand Colours.en.srt
|
SRT
|
5.1 KB
|
|
|
005 Use Your Brand Colours.mp4
|
MP4
|
42.8 MB
|
|
|
005 Use of COUNTIF(S).en.srt
|
SRT
|
5.2 KB
|
|
|
005 Use of COUNTIF(S).mp4
|
MP4
|
33 MB
|
|
|
005 Workaround for IMPORTRANGE Internal Errors.en.srt
|
SRT
|
3.6 KB
|
|
|
005 Workaround for IMPORTRANGE Internal Errors.mp4
|
MP4
|
33.1 MB
|
|
|
005 Your Feedback is Valuable.en.srt
|
SRT
|
1.3 KB
|
|
|
005 Your Feedback is Valuable.mp4
|
MP4
|
20.3 MB
|
|
|
006 Advanced Formula_ QUERY 2.en.srt
|
SRT
|
5.3 KB
|
|
|
006 Advanced Formula_ QUERY 2.mp4
|
MP4
|
29.3 MB
|
|
|
006 Conditional Formatting for Variances.en.srt
|
SRT
|
4.8 KB
|
|
|
006 Conditional Formatting for Variances.mp4
|
MP4
|
24 MB
|
|
|
006 Defining Current Week through TODAY Formula.en.srt
|
SRT
|
4.5 KB
|
|
|
006 Defining Current Week through TODAY Formula.mp4
|
MP4
|
31.9 MB
|
|
|
006 Dynamic Table_ Data Layout for Competitor Tracking.en.srt
|
SRT
|
14.7 KB
|
|
|
006 Dynamic Table_ Data Layout for Competitor Tracking.mp4
|
MP4
|
76.9 MB
|
|
|
006 Final Touches.en.srt
|
SRT
|
1.9 KB
|
|
|
006 Final Touches.mp4
|
MP4
|
11 MB
|
|
|
006 Formatting of Week Numbers.en.srt
|
SRT
|
2.8 KB
|
|
|
006 Formatting of Week Numbers.mp4
|
MP4
|
18.9 MB
|
|
|
006 Identify ROW & COLUMN Numbers.en.srt
|
SRT
|
3.3 KB
|
|
|
006 Identify ROW & COLUMN Numbers.mp4
|
MP4
|
18.4 MB
|
|
|
006 Manage Reporting Files through Scripts.en.srt
|
SRT
|
3 KB
|
|
|
006 Manage Reporting Files through Scripts.mp4
|
MP4
|
28.3 MB
|
|
|
006 Recap of Course Project.en.srt
|
SRT
|
2.8 KB
|
|
|
006 Recap of Course Project.mp4
|
MP4
|
40 MB
|
|
|
006 Section Recap.en.srt
|
SRT
|
2.2 KB
|
|
|
006 Section Recap.mp4
|
MP4
|
32.5 MB
|
|
|
006 Summary of Key Metrics.en.srt
|
SRT
|
9.7 KB
|
|
|
006 Summary of Key Metrics.mp4
|
MP4
|
73.3 MB
|
|
|
007 Conditional Color Notifications.en.srt
|
SRT
|
9 KB
|
|
|
007 Conditional Color Notifications.mp4
|
MP4
|
64.1 MB
|
|
|
007 Dynamic Table_ Ranking for Competitor Tracking.en.srt
|
SRT
|
8.1 KB
|
|
|
007 Dynamic Table_ Ranking for Competitor Tracking.mp4
|
MP4
|
39.2 MB
|
|
|
007 Final Touches.en.srt
|
SRT
|
7.1 KB
|
|
|
007 Final Touches.mp4
|
MP4
|
69.5 MB
|
|
|
007 RANK the Data.en.srt
|
SRT
|
2.7 KB
|
|
|
007 RANK the Data.mp4
|
MP4
|
13.9 MB
|
|
|
007 Section Recap.en.srt
|
SRT
|
1.4 KB
|
|
|
007 Section Recap.mp4
|
MP4
|
23.3 MB
|
|
|
007 Target Conversion from Weekly to Monthly.en.srt
|
SRT
|
6 KB
|
|
|
007 Target Conversion from Weekly to Monthly.mp4
|
MP4
|
44.5 MB
|
|
|
007 Visual Formatting.en.srt
|
SRT
|
11.9 KB
|
|
|
007 Visual Formatting.mp4
|
MP4
|
80 MB
|
|
|
008 Avoid Errors with IFERROR.en.srt
|
SRT
|
4.1 KB
|
|
|
008 Avoid Errors with IFERROR.mp4
|
MP4
|
40.6 MB
|
|
|
008 Comparison between Targets and Budgets.en.srt
|
SRT
|
6.6 KB
|
|
|
008 Comparison between Targets and Budgets.mp4
|
MP4
|
40.4 MB
|
|
|
008 Connection with Other Tabs.en.srt
|
SRT
|
9.8 KB
|
|
|
008 Connection with Other Tabs.mp4
|
MP4
|
69.9 MB
|
|
|
008 Final Touches.en.srt
|
SRT
|
2 KB
|
|
|
008 Final Touches.mp4
|
MP4
|
14.1 MB
|
|
|
008 Graph III_ Tracking Weekly Performance over Monthly Budget.en.srt
|
SRT
|
12.2 KB
|
|
|
008 Graph III_ Tracking Weekly Performance over Monthly Budget.mp4
|
MP4
|
71.6 MB
|
|
|
009 Final Touches.en.srt
|
SRT
|
921.6 B
|
|
|
009 Final Touches.mp4
|
MP4
|
6.1 MB
|
|
|
009 Improve Calculation Accuracy with AVERAGE.WEIGHTED.en.srt
|
SRT
|
3.7 KB
|
|
|
009 Improve Calculation Accuracy with AVERAGE.WEIGHTED.mp4
|
MP4
|
29.3 MB
|
|
|
009 Notification for Reconciliation with Budgets.en.srt
|
SRT
|
9.3 KB
|
|
|
009 Notification for Reconciliation with Budgets.mp4
|
MP4
|
57.6 MB
|
|
|
009 Sections Recap.en.srt
|
SRT
|
2.4 KB
|
|
|
009 Sections Recap.mp4
|
MP4
|
33.8 MB
|
|
|
010 Section Recap.en.srt
|
SRT
|
2.7 KB
|
|
|
010 Section Recap.mp4
|
MP4
|
39.6 MB
|
|
|
010 Sections Recap.en.srt
|
SRT
|
1.8 KB
|
|
|
010 Sections Recap.mp4
|
MP4
|
27.7 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
external-assets-links.txt
|
TXT
|
512 B
|
