FreeCourseWeb com Udemy Master Reporting Automation with Google Sheets

FreeCourseWeb com Udemy Master Reporting Automation with Google Sheets

Name	[ FreeCourseWeb.com ] Udemy - Master Reporting Automation with Google Sheets	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	3.9 GB
Total Files	210
Last Seen	2025-07-26 00:30
Hash	546C5A6CD8802C2D5CB588CA9CA87BCD2E725A04

/
Get Bonus Downloads Here.url	0.2 KB
/01 Introduction/
001 Introduction.en.srt	8.5 KB
001 Introduction.mp4	117.6 MB
002 Why Google Sheets, not Excel_.en.srt	4.8 KB
002 Why Google Sheets, not Excel_.mp4	66.6 MB
003 Quick Example_ How to Efficiently Automate Reporting.en.srt	3.0 KB
003 Quick Example_ How to Efficiently Automate Reporting.mp4	12.8 MB
004 Overview of Course Projects.en.srt	3.8 KB
004 Overview of Course Projects.mp4	44.8 MB
005 Your Feedback is Valuable.en.srt	1.3 KB
005 Your Feedback is Valuable.mp4	21.3 MB
external-assets-links.txt	0.1 KB
/.../02 Learn and Practice the Key Formulas/
001 Introduction.en.srt	1.8 KB
001 Introduction.mp4	27.0 MB
002 Key Formula Combination - INDEX & MATCH.en.srt	10.6 KB
002 Key Formula Combination - INDEX & MATCH.mp4	71.8 MB
003 Determining Year with TEXT.en.srt	3.2 KB
003 Determining Year with TEXT.mp4	7.7 MB
004 Smart use of IF's - Dynamic SUMIF and AVERAGEIF.en.srt	11.3 KB
004 Smart use of IF's - Dynamic SUMIF and AVERAGEIF.mp4	81.3 MB
005 Use of COUNTIF(S).en.srt	5.3 KB
005 Use of COUNTIF(S).mp4	34.6 MB
006 Identify ROW & COLUMN Numbers.en.srt	3.4 KB
006 Identify ROW & COLUMN Numbers.mp4	19.3 MB
007 RANK the Data.en.srt	2.8 KB
007 RANK the Data.mp4	14.5 MB
008 Avoid Errors with IFERROR.en.srt	4.2 KB
008 Avoid Errors with IFERROR.mp4	42.5 MB
009 Improve Calculation Accuracy with AVERAGE.WEIGHTED.en.srt	3.7 KB
009 Improve Calculation Accuracy with AVERAGE.WEIGHTED.mp4	30.8 MB
external-assets-links.txt	0.1 KB
/.../03 Learn and Practice the Key Formulas_ Advanced Section/
001 Introduction.en.srt	0.9 KB
001 Introduction.mp4	14.8 MB
002 Pulling Data with INDIRECT & ADDRESS.en.srt	4.2 KB
002 Pulling Data with INDIRECT & ADDRESS.mp4	29.7 MB
003 Use OFFSET for Dynamic Calculations.en.srt	6.5 KB
003 Use OFFSET for Dynamic Calculations.mp4	39.9 MB
004 IMPORTRANGE with INDEX & MATCH.en.srt	7.9 KB
004 IMPORTRANGE with INDEX & MATCH.mp4	46.3 MB
005 Advanced Formula_ QUERY.en.srt	4.4 KB
005 Advanced Formula_ QUERY.mp4	40.6 MB
006 Advanced Formula_ QUERY 2.en.srt	5.4 KB
006 Advanced Formula_ QUERY 2.mp4	30.7 MB
007 Section Recap.en.srt	1.4 KB
007 Section Recap.mp4	23.1 MB
external-assets-links.txt	0.4 KB
/.../04 Putting Together the Project/
001 Introduction.en.srt	4.7 KB
001 Introduction.mp4	43.0 MB
002 Mapping Down the Metrics.en.srt	16.2 KB
002 Mapping Down the Metrics.mp4	83.7 MB
003 Defining the Week Periods and Week References.en.srt	5.5 KB
003 Defining the Week Periods and Week References.mp4	8.4 MB
004 Connecting the Formulas with INDEX & MATCH.en.srt	4.2 KB
004 Connecting the Formulas with INDEX & MATCH.mp4	33.2 MB
005 Setting Up Budget Connections and Calculations.en.srt	10.6 KB
005 Setting Up Budget Connections and Calculations.mp4	68.3 MB
006 Formatting of Week Numbers.en.srt	2.9 KB
006 Formatting of Week Numbers.mp4	19.9 MB
007 Visual Formatting.en.srt	12.2 KB
007 Visual Formatting.mp4	83.9 MB
external-assets-links.txt	0.4 KB
/.../05 Adding the Forecasts/
001 Introduction.en.srt	1.0 KB
001 Introduction.mp4	16.1 MB
002 Defining Sheet Structure.en.srt	7.2 KB
002 Defining Sheet Structure.mp4	32.1 MB
003 Setting Up Forecasting Formulas.en.srt	10.9 KB
003 Setting Up Forecasting Formulas.mp4	58.7 MB
004 Advanced_ Connecting Stable Metrics to Dataset.en.srt	15.4 KB
004 Advanced_ Connecting Stable Metrics to Dataset.mp4	114.6 MB
005 Linking Targets with Actuals.en.srt	9.0 KB
005 Linking Targets with Actuals.mp4	69.5 MB
006 Defining Current Week through TODAY Formula.en.srt	4.6 KB
006 Defining Current Week through TODAY Formula.mp4	33.4 MB
007 Target Conversion from Weekly to Monthly.en.srt	6.1 KB
007 Target Conversion from Weekly to Monthly.mp4	46.7 MB
008 Comparison between Targets and Budgets.en.srt	6.8 KB
008 Comparison between Targets and Budgets.mp4	42.4 MB
009 Notification for Reconciliation with Budgets.en.srt	9.5 KB
009 Notification for Reconciliation with Budgets.mp4	60.4 MB
010 Sections Recap.en.srt	1.9 KB
010 Sections Recap.mp4	29.1 MB
external-assets-links.txt	0.1 KB
/.../06 Building the Comparison Between Actuals and Forecasts/
001 Introduction.en.srt	0.9 KB
001 Introduction.mp4	10.9 MB
002 Defining Sheet Structure.en.srt	4.7 KB
002 Defining Sheet Structure.mp4	30.5 MB
003 Connecting the Formulas.en.srt	3.1 KB
003 Connecting the Formulas.mp4	27.1 MB
004 Not Showing Data for Unpassed Weeks.en.srt	2.5 KB
004 Not Showing Data for Unpassed Weeks.mp4	21.9 MB
005 Calculating the Variances.en.srt	2.5 KB
005 Calculating the Variances.mp4	20.4 MB
006 Conditional Formatting for Variances.en.srt	4.9 KB
006 Conditional Formatting for Variances.mp4	25.2 MB
007 Conditional Color Notifications.en.srt	9.2 KB
007 Conditional Color Notifications.mp4	67.2 MB
008 Final Touches.en.srt	2.0 KB
008 Final Touches.mp4	14.8 MB
external-assets-links.txt	0.1 KB
/.../07 Designing the Landing Page/
001 Introduction.en.srt	0.6 KB
001 Introduction.mp4	8.4 MB
002 What to Include in the Cover tab_.en.srt	9.1 KB
002 What to Include in the Cover tab_.mp4	41.4 MB
003 Table of Contents.en.srt	3.8 KB
003 Table of Contents.mp4	23.9 MB
004 Linking Key Information.en.srt	3.5 KB
004 Linking Key Information.mp4	28.3 MB
005 Use Your Brand Colours.en.srt	5.2 KB
005 Use Your Brand Colours.mp4	44.9 MB
006 Section Recap.en.srt	2.3 KB
006 Section Recap.mp4	34.1 MB
external-assets-links.txt	0.1 KB
/.../08 Reconciling Weekly Actuals with Monthly Budgets/
001 Introduction.en.srt	1.6 KB
001 Introduction.mp4	16.2 MB
002 Defining Sheet Structure.en.srt	7.0 KB
002 Defining Sheet Structure.mp4	41.2 MB
003 Connecting the Data to the Tab.en.srt	5.2 KB
003 Connecting the Data to the Tab.mp4	42.5 MB
004 Color Coding for Weekly Trends.en.srt	4.0 KB
004 Color Coding for Weekly Trends.mp4	15.1 MB
005 Color Coding for Monthly Budgets.en.srt	11.2 KB
005 Color Coding for Monthly Budgets.mp4	65.4 MB
006 Final Touches.en.srt	2.0 KB
006 Final Touches.mp4	11.6 MB
external-assets-links.txt	0.1 KB
/.../09 Setting Up Competitor and Market Size Tracking/
001 Introduction.en.srt	1.4 KB
001 Introduction.mp4	17.7 MB
002 Defining Sheet Structure.en.srt	1.4 KB
002 Defining Sheet Structure.mp4	13.5 MB
003 Creating the Framework for Competitor Tracking.en.srt	5.0 KB
003 Creating the Framework for Competitor Tracking.mp4	17.9 MB
004 Adding Formulas to Framework.en.srt	6.6 KB
004 Adding Formulas to Framework.mp4	41.2 MB
005 Estimating Competitor and Market Size.en.srt	13.9 KB
005 Estimating Competitor and Market Size.mp4	88.2 MB
006 Summary of Key Metrics.en.srt	9.9 KB
006 Summary of Key Metrics.mp4	76.9 MB
007 Final Touches.en.srt	7.3 KB
007 Final Touches.mp4	72.9 MB
008 Connection with Other Tabs.en.srt	10.0 KB
008 Connection with Other Tabs.mp4	73.2 MB
009 Sections Recap.en.srt	2.5 KB
009 Sections Recap.mp4	35.4 MB
external-assets-links.txt	0.1 KB
/.../10 Professional and Effective Data Visualisation/
001 Introduction.en.srt	2.8 KB
001 Introduction.mp4	33.1 MB
002 Intro to the First Graph.en.srt	1.8 KB
002 Intro to the First Graph.mp4	10.7 MB
003 Data Visualisation Principles.en.srt	3.8 KB
003 Data Visualisation Principles.mp4	42.8 MB
004 Graph I_ Key Actuals with Targets.en.srt	21.2 KB
004 Graph I_ Key Actuals with Targets.mp4	125.5 MB
005 Graph II_ Monthly Actuals with Budgeted Forecasts.en.srt	18.7 KB
005 Graph II_ Monthly Actuals with Budgeted Forecasts.mp4	89.6 MB
006 Dynamic Table_ Data Layout for Competitor Tracking.en.srt	15.0 KB
006 Dynamic Table_ Data Layout for Competitor Tracking.mp4	80.7 MB
007 Dynamic Table_ Ranking for Competitor Tracking.en.srt	8.3 KB
007 Dynamic Table_ Ranking for Competitor Tracking.mp4	41.1 MB
008 Graph III_ Tracking Weekly Performance over Monthly Budget.en.srt	12.5 KB
008 Graph III_ Tracking Weekly Performance over Monthly Budget.mp4	75.1 MB
009 Final Touches.en.srt	0.9 KB
009 Final Touches.mp4	6.4 MB
010 Section Recap.en.srt	2.7 KB
010 Section Recap.mp4	41.5 MB
external-assets-links.txt	0.2 KB
/.../11 Creating Dynamic and Reliable Data Connections/
001 Introduction.en.srt	0.9 KB
001 Introduction.mp4	15.6 MB
002 Status for Data Dump.en.srt	7.9 KB
002 Status for Data Dump.mp4	52.6 MB
003 Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE.en.srt	5.0 KB
003 Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE.mp4	36.5 MB
004 Dynamic Budget Connection with QUERY.en.srt	5.5 KB
004 Dynamic Budget Connection with QUERY.mp4	37.8 MB
005 Final Touches.en.srt	3.9 KB
005 Final Touches.mp4	39.5 MB
external-assets-links.txt	0.1 KB
/.../12 Wrapping Up the Project/
001 Introduction.en.srt	1.0 KB
001 Introduction.mp4	15.9 MB
002 Adding Instructions.en.srt	2.6 KB
002 Adding Instructions.mp4	23.7 MB
003 Reviewing Links in Cover tab.en.srt	1.4 KB
003 Reviewing Links in Cover tab.mp4	9.0 MB
004 Final Touches on Whole File.en.srt	3.9 KB
004 Final Touches on Whole File.mp4	27.9 MB
005 Protecting the Sheets.en.srt	4.7 KB
005 Protecting the Sheets.mp4	27.0 MB
006 Recap of Course Project.en.srt	2.8 KB
006 Recap of Course Project.mp4	41.9 MB
external-assets-links.txt	0.2 KB
/.../13 Further Development Tips and Tricks/
001 Introduction.en.srt	1.2 KB
001 Introduction.mp4	18.6 MB
002 Automating Data Dump through a Script.en.srt	4.3 KB
002 Automating Data Dump through a Script.mp4	45.0 MB
003 Creating Multi-Level Reporting System.en.srt	5.2 KB
003 Creating Multi-Level Reporting System.mp4	63.0 MB
004 Optimise Spreadsheet Performance.en.srt	2.7 KB
004 Optimise Spreadsheet Performance.mp4	32.9 MB
005 Workaround for IMPORTRANGE Internal Errors.en.srt	3.6 KB
005 Workaround for IMPORTRANGE Internal Errors.mp4	34.7 MB
006 Manage Reporting Files through Scripts.en.srt	3.1 KB
006 Manage Reporting Files through Scripts.mp4	29.7 MB
007 Section Recap.en.srt	1.5 KB
007 Section Recap.mp4	24.5 MB
external-assets-links.txt	0.1 KB
/14 Conclusion/
001 Conclusion.en.srt	3.8 KB
001 Conclusion.mp4	52.6 MB
002 Bonus Lecture.en.srt	5.1 KB
002 Bonus Lecture.mp4	40.8 MB
external-assets-links.txt	0.5 KB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 210