种子简介

种子名称： [ FreeCourseWeb.com ] Udemy - Master Reporting Automation with Google Sheets
文件类型： 视频
文件数目： 97个文件
文件大小： 3.64 GB
收录时间： 2023-5-24 21:47
已经下载： 3次
资源热度： 116
最近下载： 2024-6-3 02:29

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:546c5a6cd8802c2d5cb588ca9ca87bcd2e725a04&dn=[ FreeCourseWeb.com ] Udemy - Master Reporting Automation with Google Sheets 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[ FreeCourseWeb.com ] Udemy - Master Reporting Automation with Google Sheets.torrent

~Get Your Files Here !/01 Introduction/001 Introduction.mp4112.13MB

~Get Your Files Here !/01 Introduction/002 Why Google Sheets, not Excel_.mp463.51MB

~Get Your Files Here !/01 Introduction/003 Quick Example_ How to Efficiently Automate Reporting.mp412.22MB

~Get Your Files Here !/01 Introduction/004 Overview of Course Projects.mp442.73MB

~Get Your Files Here !/01 Introduction/005 Your Feedback is Valuable.mp420.28MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/001 Introduction.mp425.79MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/002 Key Formula Combination - INDEX & MATCH.mp468.46MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/003 Determining Year with TEXT.mp47.39MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/004 Smart use of IF's - Dynamic SUMIF and AVERAGEIF.mp477.53MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/005 Use of COUNTIF(S).mp432.96MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/006 Identify ROW & COLUMN Numbers.mp418.39MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/007 RANK the Data.mp413.87MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/008 Avoid Errors with IFERROR.mp440.56MB

~Get Your Files Here !/02 Learn and Practice the Key Formulas/009 Improve Calculation Accuracy with AVERAGE.WEIGHTED.mp429.33MB

~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/001 Introduction.mp414.15MB

~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/002 Pulling Data with INDIRECT & ADDRESS.mp428.36MB

~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/003 Use OFFSET for Dynamic Calculations.mp438.05MB

~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/004 IMPORTRANGE with INDEX & MATCH.mp444.13MB

~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/005 Advanced Formula_ QUERY.mp438.76MB

~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/006 Advanced Formula_ QUERY 2.mp429.3MB

~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/007 Section Recap.mp422.06MB

~Get Your Files Here !/04 Putting Together the Project/001 Introduction.mp441.02MB

~Get Your Files Here !/04 Putting Together the Project/002 Mapping Down the Metrics.mp479.78MB

~Get Your Files Here !/04 Putting Together the Project/003 Defining the Week Periods and Week References.mp48.02MB

~Get Your Files Here !/04 Putting Together the Project/004 Connecting the Formulas with INDEX & MATCH.mp431.69MB

~Get Your Files Here !/04 Putting Together the Project/005 Setting Up Budget Connections and Calculations.mp465.1MB

~Get Your Files Here !/04 Putting Together the Project/006 Formatting of Week Numbers.mp418.94MB

~Get Your Files Here !/04 Putting Together the Project/007 Visual Formatting.mp479.99MB

~Get Your Files Here !/05 Adding the Forecasts/001 Introduction.mp415.32MB

~Get Your Files Here !/05 Adding the Forecasts/002 Defining Sheet Structure.mp430.62MB

~Get Your Files Here !/05 Adding the Forecasts/003 Setting Up Forecasting Formulas.mp455.95MB

~Get Your Files Here !/05 Adding the Forecasts/004 Advanced_ Connecting Stable Metrics to Dataset.mp4109.3MB

~Get Your Files Here !/05 Adding the Forecasts/005 Linking Targets with Actuals.mp466.25MB

~Get Your Files Here !/05 Adding the Forecasts/006 Defining Current Week through TODAY Formula.mp431.88MB

~Get Your Files Here !/05 Adding the Forecasts/007 Target Conversion from Weekly to Monthly.mp444.5MB

~Get Your Files Here !/05 Adding the Forecasts/008 Comparison between Targets and Budgets.mp440.41MB

~Get Your Files Here !/05 Adding the Forecasts/009 Notification for Reconciliation with Budgets.mp457.6MB

~Get Your Files Here !/05 Adding the Forecasts/010 Sections Recap.mp427.71MB

~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/001 Introduction.mp410.42MB

~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/002 Defining Sheet Structure.mp429.11MB

~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/003 Connecting the Formulas.mp425.85MB

~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/004 Not Showing Data for Unpassed Weeks.mp420.86MB

~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/005 Calculating the Variances.mp419.46MB

~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/006 Conditional Formatting for Variances.mp424.03MB

~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/007 Conditional Color Notifications.mp464.08MB

~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/008 Final Touches.mp414.13MB

~Get Your Files Here !/07 Designing the Landing Page/001 Introduction.mp47.96MB

~Get Your Files Here !/07 Designing the Landing Page/002 What to Include in the Cover tab_.mp439.47MB

~Get Your Files Here !/07 Designing the Landing Page/003 Table of Contents.mp422.81MB

~Get Your Files Here !/07 Designing the Landing Page/004 Linking Key Information.mp426.95MB

~Get Your Files Here !/07 Designing the Landing Page/005 Use Your Brand Colours.mp442.83MB

~Get Your Files Here !/07 Designing the Landing Page/006 Section Recap.mp432.52MB

~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/001 Introduction.mp415.42MB

~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/002 Defining Sheet Structure.mp439.33MB

~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/003 Connecting the Data to the Tab.mp440.55MB

~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/004 Color Coding for Weekly Trends.mp414.41MB

~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/005 Color Coding for Monthly Budgets.mp462.38MB

~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/006 Final Touches.mp411.04MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/001 Introduction.mp416.86MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/002 Defining Sheet Structure.mp412.9MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/003 Creating the Framework for Competitor Tracking.mp417.1MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/004 Adding Formulas to Framework.mp439.26MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/005 Estimating Competitor and Market Size.mp484.08MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/006 Summary of Key Metrics.mp473.31MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/007 Final Touches.mp469.51MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/008 Connection with Other Tabs.mp469.85MB

~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/009 Sections Recap.mp433.79MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/001 Introduction.mp431.57MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/002 Intro to the First Graph.mp410.17MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/003 Data Visualisation Principles.mp440.78MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/004 Graph I_ Key Actuals with Targets.mp4119.66MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/005 Graph II_ Monthly Actuals with Budgeted Forecasts.mp485.48MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/006 Dynamic Table_ Data Layout for Competitor Tracking.mp476.92MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/007 Dynamic Table_ Ranking for Competitor Tracking.mp439.2MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/008 Graph III_ Tracking Weekly Performance over Monthly Budget.mp471.59MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/009 Final Touches.mp46.14MB

~Get Your Files Here !/10 Professional and Effective Data Visualisation/010 Section Recap.mp439.6MB

~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/001 Introduction.mp414.83MB

~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/002 Status for Data Dump.mp450.16MB

~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/003 Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE.mp434.85MB

~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/004 Dynamic Budget Connection with QUERY.mp436.01MB

~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/005 Final Touches.mp437.66MB

~Get Your Files Here !/12 Wrapping Up the Project/001 Introduction.mp415.12MB

~Get Your Files Here !/12 Wrapping Up the Project/002 Adding Instructions.mp422.58MB

~Get Your Files Here !/12 Wrapping Up the Project/003 Reviewing Links in Cover tab.mp48.57MB

~Get Your Files Here !/12 Wrapping Up the Project/004 Final Touches on Whole File.mp426.61MB

~Get Your Files Here !/12 Wrapping Up the Project/005 Protecting the Sheets.mp425.79MB

~Get Your Files Here !/12 Wrapping Up the Project/006 Recap of Course Project.mp439.96MB

~Get Your Files Here !/13 Further Development Tips and Tricks/001 Introduction.mp417.77MB

~Get Your Files Here !/13 Further Development Tips and Tricks/002 Automating Data Dump through a Script.mp442.96MB

~Get Your Files Here !/13 Further Development Tips and Tricks/003 Creating Multi-Level Reporting System.mp460.09MB

~Get Your Files Here !/13 Further Development Tips and Tricks/004 Optimise Spreadsheet Performance.mp431.39MB

~Get Your Files Here !/13 Further Development Tips and Tricks/005 Workaround for IMPORTRANGE Internal Errors.mp433.12MB

~Get Your Files Here !/13 Further Development Tips and Tricks/006 Manage Reporting Files through Scripts.mp428.33MB

~Get Your Files Here !/13 Further Development Tips and Tricks/007 Section Recap.mp423.33MB

~Get Your Files Here !/14 Conclusion/001 Conclusion.mp450.15MB

~Get Your Files Here !/14 Conclusion/002 Bonus Lecture.mp438.86MB