| 001 Conclusion.en.srt | 3.7 KB | ||
| 001 Conclusion.mp4 | 50.2 MB | ||
| 001 Introduction.en.srt | 1.2 KB | ||
| 001 Introduction.mp4 | 17.8 MB | ||
| 002 Adding Instructions.en.srt | 2.5 KB | ||
| 002 Adding Instructions.mp4 | 22.6 MB | ||
| 002 Automating Data Dump through a Script.en.srt | 4.2 KB | ||
| 002 Automating Data Dump through a Script.mp4 | 43 MB | ||
| 002 Bonus Lecture.en.srt | 5 KB | ||
| 002 Bonus Lecture.mp4 | 38.9 MB | ||
| 002 Defining Sheet Structure.en.srt | 1.4 KB | ||
| 002 Defining Sheet Structure.mp4 | 12.9 MB | ||
| 002 Intro to the First Graph.en.srt | 1.8 KB | ||
| 002 Intro to the First Graph.mp4 | 10.2 MB | ||
| 002 Key Formula Combination - INDEX & MATCH.en.srt | 10.3 KB | ||
| 002 Key Formula Combination - INDEX & MATCH.mp4 | 68.5 MB | ||
| 002 Mapping Down the Metrics.en.srt | 15.8 KB | ||
| 002 Mapping Down the Metrics.mp4 | 79.8 MB | ||
| 002 Pulling Data with INDIRECT & ADDRESS.en.srt | 4.1 KB | ||
| 002 Pulling Data with INDIRECT & ADDRESS.mp4 | 28.4 MB | ||
| 002 Status for Data Dump.en.srt | 7.7 KB | ||
| 002 Status for Data Dump.mp4 | 50.2 MB | ||
| 002 What to Include in the Cover tab_.en.srt | 8.9 KB | ||
| 002 What to Include in the Cover tab_.mp4 | 39.5 MB | ||
| 002 Why Google Sheets, not Excel_.en.srt | 4.7 KB | ||
| 002 Why Google Sheets, not Excel_.mp4 | 63.5 MB | ||
| 003 Connecting the Data to the Tab.en.srt | 5.1 KB | ||
| 003 Connecting the Data to the Tab.mp4 | 40.5 MB | ||
| 003 Connecting the Formulas.en.srt | 3 KB | ||
| 003 Connecting the Formulas.mp4 | 25.9 MB | ||
| 003 Creating Multi-Level Reporting System.en.srt | 5.1 KB | ||
| 003 Creating Multi-Level Reporting System.mp4 | 60.1 MB | ||
| 003 Creating the Framework for Competitor Tracking.en.srt | 4.8 KB | ||
| 003 Creating the Framework for Competitor Tracking.mp4 | 17.1 MB | ||
| 003 Data Visualisation Principles.en.srt | 3.7 KB | ||
| 003 Data Visualisation Principles.mp4 | 40.8 MB | ||
| 003 Defining the Week Periods and Week References.en.srt | 5.4 KB | ||
| 003 Defining the Week Periods and Week References.mp4 | 8 MB | ||
| 003 Determining Year with TEXT.en.srt | 3.1 KB | ||
| 003 Determining Year with TEXT.mp4 | 7.4 MB | ||
| 003 Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE.en.srt | 4.8 KB | ||
| 003 Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE.mp4 | 34.8 MB | ||
| 003 Quick Example_ How to Efficiently Automate Reporting.en.srt | 2.9 KB | ||
| 003 Quick Example_ How to Efficiently Automate Reporting.mp4 | 12.2 MB | ||
| 003 Reviewing Links in Cover tab.en.srt | 1.4 KB | ||
| 003 Reviewing Links in Cover tab.mp4 | 8.6 MB | ||
| 003 Setting Up Forecasting Formulas.en.srt | 10.7 KB | ||
| 003 Setting Up Forecasting Formulas.mp4 | 56 MB | ||
| 003 Table of Contents.en.srt | 3.7 KB | ||
| 003 Table of Contents.mp4 | 22.8 MB | ||
| 003 Use OFFSET for Dynamic Calculations.en.srt | 6.3 KB | ||
| 003 Use OFFSET for Dynamic Calculations.mp4 | 38.1 MB | ||
| 004 Adding Formulas to Framework.en.srt | 6.4 KB | ||
| 004 Adding Formulas to Framework.mp4 | 39.3 MB | ||
| 004 Advanced_ Connecting Stable Metrics to Dataset.en.srt | 15.1 KB | ||
| 004 Advanced_ Connecting Stable Metrics to Dataset.mp4 | 109.3 MB | ||
| 004 Color Coding for Weekly Trends.en.srt | 3.9 KB | ||
| 004 Color Coding for Weekly Trends.mp4 | 14.4 MB | ||
| 004 Connecting the Formulas with INDEX & MATCH.en.srt | 4.1 KB | ||
| 004 Connecting the Formulas with INDEX & MATCH.mp4 | 31.7 MB | ||
| 004 Dynamic Budget Connection with QUERY.en.srt | 5.4 KB | ||
| 004 Dynamic Budget Connection with QUERY.mp4 | 36 MB | ||
| 004 Final Touches on Whole File.en.srt | 3.8 KB | ||
| 004 Final Touches on Whole File.mp4 | 26.6 MB | ||
| 004 Graph I_ Key Actuals with Targets.en.srt | 20.7 KB | ||
| 004 Graph I_ Key Actuals with Targets.mp4 | 119.7 MB | ||
| 004 IMPORTRANGE with INDEX & MATCH.en.srt | 7.7 KB | ||
| 004 IMPORTRANGE with INDEX & MATCH.mp4 | 44.1 MB | ||
| 004 Linking Key Information.en.srt | 3.4 KB | ||
| 004 Linking Key Information.mp4 | 27 MB | ||
| 004 Not Showing Data for Unpassed Weeks.en.srt | 2.4 KB | ||
| 004 Not Showing Data for Unpassed Weeks.mp4 | 20.9 MB | ||
| 004 Optimise Spreadsheet Performance.en.srt | 2.6 KB | ||
| 004 Optimise Spreadsheet Performance.mp4 | 31.4 MB | ||
| 004 Overview of Course Projects.en.srt | 3.7 KB | ||
| 004 Overview of Course Projects.mp4 | 42.7 MB | ||
| 004 Smart use of IF's - Dynamic SUMIF and AVERAGEIF.en.srt | 11.1 KB | ||
| 004 Smart use of IF's - Dynamic SUMIF and AVERAGEIF.mp4 | 77.5 MB | ||
| 005 Advanced Formula_ QUERY.en.srt | 4.3 KB | ||
| 005 Advanced Formula_ QUERY.mp4 | 38.8 MB | ||
| 005 Calculating the Variances.en.srt | 2.4 KB | ||
| 005 Calculating the Variances.mp4 | 19.5 MB | ||
| 005 Color Coding for Monthly Budgets.en.srt | 11 KB | ||
| 005 Color Coding for Monthly Budgets.mp4 | 62.4 MB | ||
| 005 Estimating Competitor and Market Size.en.srt | 13.5 KB | ||
| 005 Estimating Competitor and Market Size.mp4 | 84.1 MB | ||
| 005 Final Touches.en.srt | 3.8 KB | ||
| 005 Final Touches.mp4 | 37.7 MB | ||
| 005 Graph II_ Monthly Actuals with Budgeted Forecasts.en.srt | 18.3 KB | ||
| 005 Graph II_ Monthly Actuals with Budgeted Forecasts.mp4 | 85.5 MB | ||
| 005 Linking Targets with Actuals.en.srt | 8.8 KB | ||
| 005 Linking Targets with Actuals.mp4 | 66.3 MB | ||
| 005 Protecting the Sheets.en.srt | 4.6 KB | ||
| 005 Protecting the Sheets.mp4 | 25.8 MB | ||
| 005 Setting Up Budget Connections and Calculations.en.srt | 10.4 KB | ||
| 005 Setting Up Budget Connections and Calculations.mp4 | 65.1 MB | ||
| 005 Use Your Brand Colours.en.srt | 5.1 KB | ||
| 005 Use Your Brand Colours.mp4 | 42.8 MB | ||
| 005 Use of COUNTIF(S).en.srt | 5.2 KB | ||
| 005 Use of COUNTIF(S).mp4 | 33 MB | ||
| 005 Workaround for IMPORTRANGE Internal Errors.en.srt | 3.6 KB | ||
| 005 Workaround for IMPORTRANGE Internal Errors.mp4 | 33.1 MB | ||
| 005 Your Feedback is Valuable.en.srt | 1.3 KB | ||
| 005 Your Feedback is Valuable.mp4 | 20.3 MB | ||
| 006 Advanced Formula_ QUERY 2.en.srt | 5.3 KB | ||
| 006 Advanced Formula_ QUERY 2.mp4 | 29.3 MB | ||
| 006 Conditional Formatting for Variances.en.srt | 4.8 KB | ||
| 006 Conditional Formatting for Variances.mp4 | 24 MB | ||
| 006 Defining Current Week through TODAY Formula.en.srt | 4.5 KB | ||
| 006 Defining Current Week through TODAY Formula.mp4 | 31.9 MB | ||
| 006 Dynamic Table_ Data Layout for Competitor Tracking.en.srt | 14.7 KB | ||
| 006 Dynamic Table_ Data Layout for Competitor Tracking.mp4 | 76.9 MB | ||
| 006 Final Touches.en.srt | 1.9 KB | ||
| 006 Final Touches.mp4 | 11 MB | ||
| 006 Formatting of Week Numbers.en.srt | 2.8 KB | ||
| 006 Formatting of Week Numbers.mp4 | 18.9 MB | ||
| 006 Identify ROW & COLUMN Numbers.en.srt | 3.3 KB | ||
| 006 Identify ROW & COLUMN Numbers.mp4 | 18.4 MB | ||
| 006 Manage Reporting Files through Scripts.en.srt | 3 KB | ||
| 006 Manage Reporting Files through Scripts.mp4 | 28.3 MB | ||
| 006 Recap of Course Project.en.srt | 2.8 KB | ||
| 006 Recap of Course Project.mp4 | 40 MB | ||
| 006 Section Recap.en.srt | 2.2 KB | ||
| 006 Section Recap.mp4 | 32.5 MB | ||
| 006 Summary of Key Metrics.en.srt | 9.7 KB | ||
| 006 Summary of Key Metrics.mp4 | 73.3 MB | ||
| 007 Conditional Color Notifications.en.srt | 9 KB | ||
| 007 Conditional Color Notifications.mp4 | 64.1 MB | ||
| 007 Dynamic Table_ Ranking for Competitor Tracking.en.srt | 8.1 KB | ||
| 007 Dynamic Table_ Ranking for Competitor Tracking.mp4 | 39.2 MB | ||
| 007 Final Touches.en.srt | 7.1 KB | ||
| 007 Final Touches.mp4 | 69.5 MB | ||
| 007 RANK the Data.en.srt | 2.7 KB | ||
| 007 RANK the Data.mp4 | 13.9 MB | ||
| 007 Section Recap.en.srt | 1.4 KB | ||
| 007 Section Recap.mp4 | 23.3 MB | ||
| 007 Target Conversion from Weekly to Monthly.en.srt | 6 KB | ||
| 007 Target Conversion from Weekly to Monthly.mp4 | 44.5 MB | ||
| 007 Visual Formatting.en.srt | 11.9 KB | ||
| 007 Visual Formatting.mp4 | 80 MB | ||
| 008 Avoid Errors with IFERROR.en.srt | 4.1 KB | ||
| 008 Avoid Errors with IFERROR.mp4 | 40.6 MB | ||
| 008 Comparison between Targets and Budgets.en.srt | 6.6 KB | ||
| 008 Comparison between Targets and Budgets.mp4 | 40.4 MB | ||
| 008 Connection with Other Tabs.en.srt | 9.8 KB | ||
| 008 Connection with Other Tabs.mp4 | 69.9 MB | ||
| 008 Final Touches.en.srt | 2 KB | ||
| 008 Final Touches.mp4 | 14.1 MB | ||
| 008 Graph III_ Tracking Weekly Performance over Monthly Budget.en.srt | 12.2 KB | ||
| 008 Graph III_ Tracking Weekly Performance over Monthly Budget.mp4 | 71.6 MB | ||
| 009 Final Touches.en.srt | 921.6 B | ||
| 009 Final Touches.mp4 | 6.1 MB | ||
| 009 Improve Calculation Accuracy with AVERAGE.WEIGHTED.en.srt | 3.7 KB | ||
| 009 Improve Calculation Accuracy with AVERAGE.WEIGHTED.mp4 | 29.3 MB | ||
| 009 Notification for Reconciliation with Budgets.en.srt | 9.3 KB | ||
| 009 Notification for Reconciliation with Budgets.mp4 | 57.6 MB | ||
| 009 Sections Recap.en.srt | 2.4 KB | ||
| 009 Sections Recap.mp4 | 33.8 MB | ||
| 010 Section Recap.en.srt | 2.7 KB | ||
| 010 Section Recap.mp4 | 39.6 MB | ||
| 010 Sections Recap.en.srt | 1.8 KB | ||
| 010 Sections Recap.mp4 | 27.7 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| external-assets-links.txt | 512 B | ||
| ▲ 210 total files | |||
Master Reporting Automation with Google Sheets
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 97 lectures (6h 37m) | Size: 3.53 GB
Learn How To to Build A Completely Automated Reporting Tool & Solve Any Business Modeling Task You Might Ever Experience
What you'll learn:
Advanced Google Sheets / Excel formulas that help you to solve any business modeling task you might ever experience
How to make your files look professional and easy-to-track
Creating highly complex formula combinations that will save you hours of time from automating manual work
How to minimise manual reporting and focus on value-creating tasks
Analytical skills on how to approach competitor analytics and market size estimation
Tips and tricks to effective data visualisation
Create an automated business forecasting framework that works
How to build a complete reporting system in Google Sheets with maximum automation
Ideas how to combine Google Sheets with (Python) scripts
Secrets how to impress your colleagues with your exceptional Excel skills
Requirements
At least intermediate level Excel / Google Sheets skills
Google account to build the reporting solution along with the course
Description
Learn to solve any business modeling task you might ever experience!
Have you ever felt that you're regularly repeating some tasks in Google Sheets or Excel?
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1018.5 MB | freecoursewb | 6 days | 0 | 0 | |
| 1.2 GB | freecoursewb | 1 week | 7 | 11 | |
| 358.1 MB | freecoursewb | 1 week | 15 | 6 | |
| 1.4 GB | freecoursewb | 3 weeks | 0 | 0 | |
| 3.1 GB | freecoursewb | 1 month | 0 | 0 |
All Comments