zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[ FreeCourseWeb.com ] Udemy - Master Reporting Automation with Google Sheets
magnet:?xt=urn:btih:546c5a6cd8802c2d5cb588ca9ca87bcd2e725a04&dn=[ FreeCourseWeb.com ] Udemy - Master Reporting Automation with Google Sheets
磁力链接详情
Hash值:
546c5a6cd8802c2d5cb588ca9ca87bcd2e725a04
点击数:
113
文件大小:
3.64 GB
文件数量:
97
创建日期:
2023-5-24 21:47
最后访问:
2024-5-19 08:25
访问标签:
FreeCourseWeb
com
Udemy
-
Master
Reporting
Automation
with
Google
Sheets
文件列表详情
~Get Your Files Here !/01 Introduction/001 Introduction.mp4 112.13 MB
~Get Your Files Here !/01 Introduction/002 Why Google Sheets, not Excel_.mp4 63.51 MB
~Get Your Files Here !/01 Introduction/003 Quick Example_ How to Efficiently Automate Reporting.mp4 12.22 MB
~Get Your Files Here !/01 Introduction/004 Overview of Course Projects.mp4 42.73 MB
~Get Your Files Here !/01 Introduction/005 Your Feedback is Valuable.mp4 20.28 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/001 Introduction.mp4 25.79 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/002 Key Formula Combination - INDEX & MATCH.mp4 68.46 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/003 Determining Year with TEXT.mp4 7.39 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/004 Smart use of IF's - Dynamic SUMIF and AVERAGEIF.mp4 77.53 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/005 Use of COUNTIF(S).mp4 32.96 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/006 Identify ROW & COLUMN Numbers.mp4 18.39 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/007 RANK the Data.mp4 13.87 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/008 Avoid Errors with IFERROR.mp4 40.56 MB
~Get Your Files Here !/02 Learn and Practice the Key Formulas/009 Improve Calculation Accuracy with AVERAGE.WEIGHTED.mp4 29.33 MB
~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/001 Introduction.mp4 14.15 MB
~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/002 Pulling Data with INDIRECT & ADDRESS.mp4 28.36 MB
~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/003 Use OFFSET for Dynamic Calculations.mp4 38.05 MB
~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/004 IMPORTRANGE with INDEX & MATCH.mp4 44.13 MB
~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/005 Advanced Formula_ QUERY.mp4 38.76 MB
~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/006 Advanced Formula_ QUERY 2.mp4 29.3 MB
~Get Your Files Here !/03 Learn and Practice the Key Formulas_ Advanced Section/007 Section Recap.mp4 22.06 MB
~Get Your Files Here !/04 Putting Together the Project/001 Introduction.mp4 41.02 MB
~Get Your Files Here !/04 Putting Together the Project/002 Mapping Down the Metrics.mp4 79.78 MB
~Get Your Files Here !/04 Putting Together the Project/003 Defining the Week Periods and Week References.mp4 8.02 MB
~Get Your Files Here !/04 Putting Together the Project/004 Connecting the Formulas with INDEX & MATCH.mp4 31.69 MB
~Get Your Files Here !/04 Putting Together the Project/005 Setting Up Budget Connections and Calculations.mp4 65.1 MB
~Get Your Files Here !/04 Putting Together the Project/006 Formatting of Week Numbers.mp4 18.94 MB
~Get Your Files Here !/04 Putting Together the Project/007 Visual Formatting.mp4 79.99 MB
~Get Your Files Here !/05 Adding the Forecasts/001 Introduction.mp4 15.32 MB
~Get Your Files Here !/05 Adding the Forecasts/002 Defining Sheet Structure.mp4 30.62 MB
~Get Your Files Here !/05 Adding the Forecasts/003 Setting Up Forecasting Formulas.mp4 55.95 MB
~Get Your Files Here !/05 Adding the Forecasts/004 Advanced_ Connecting Stable Metrics to Dataset.mp4 109.3 MB
~Get Your Files Here !/05 Adding the Forecasts/005 Linking Targets with Actuals.mp4 66.25 MB
~Get Your Files Here !/05 Adding the Forecasts/006 Defining Current Week through TODAY Formula.mp4 31.88 MB
~Get Your Files Here !/05 Adding the Forecasts/007 Target Conversion from Weekly to Monthly.mp4 44.5 MB
~Get Your Files Here !/05 Adding the Forecasts/008 Comparison between Targets and Budgets.mp4 40.41 MB
~Get Your Files Here !/05 Adding the Forecasts/009 Notification for Reconciliation with Budgets.mp4 57.6 MB
~Get Your Files Here !/05 Adding the Forecasts/010 Sections Recap.mp4 27.71 MB
~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/001 Introduction.mp4 10.42 MB
~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/002 Defining Sheet Structure.mp4 29.11 MB
~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/003 Connecting the Formulas.mp4 25.85 MB
~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/004 Not Showing Data for Unpassed Weeks.mp4 20.86 MB
~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/005 Calculating the Variances.mp4 19.46 MB
~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/006 Conditional Formatting for Variances.mp4 24.03 MB
~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/007 Conditional Color Notifications.mp4 64.08 MB
~Get Your Files Here !/06 Building the Comparison Between Actuals and Forecasts/008 Final Touches.mp4 14.13 MB
~Get Your Files Here !/07 Designing the Landing Page/001 Introduction.mp4 7.96 MB
~Get Your Files Here !/07 Designing the Landing Page/002 What to Include in the Cover tab_.mp4 39.47 MB
~Get Your Files Here !/07 Designing the Landing Page/003 Table of Contents.mp4 22.81 MB
~Get Your Files Here !/07 Designing the Landing Page/004 Linking Key Information.mp4 26.95 MB
~Get Your Files Here !/07 Designing the Landing Page/005 Use Your Brand Colours.mp4 42.83 MB
~Get Your Files Here !/07 Designing the Landing Page/006 Section Recap.mp4 32.52 MB
~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/001 Introduction.mp4 15.42 MB
~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/002 Defining Sheet Structure.mp4 39.33 MB
~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/003 Connecting the Data to the Tab.mp4 40.55 MB
~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/004 Color Coding for Weekly Trends.mp4 14.41 MB
~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/005 Color Coding for Monthly Budgets.mp4 62.38 MB
~Get Your Files Here !/08 Reconciling Weekly Actuals with Monthly Budgets/006 Final Touches.mp4 11.04 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/001 Introduction.mp4 16.86 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/002 Defining Sheet Structure.mp4 12.9 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/003 Creating the Framework for Competitor Tracking.mp4 17.1 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/004 Adding Formulas to Framework.mp4 39.26 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/005 Estimating Competitor and Market Size.mp4 84.08 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/006 Summary of Key Metrics.mp4 73.31 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/007 Final Touches.mp4 69.51 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/008 Connection with Other Tabs.mp4 69.85 MB
~Get Your Files Here !/09 Setting Up Competitor and Market Size Tracking/009 Sections Recap.mp4 33.79 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/001 Introduction.mp4 31.57 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/002 Intro to the First Graph.mp4 10.17 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/003 Data Visualisation Principles.mp4 40.78 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/004 Graph I_ Key Actuals with Targets.mp4 119.66 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/005 Graph II_ Monthly Actuals with Budgeted Forecasts.mp4 85.48 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/006 Dynamic Table_ Data Layout for Competitor Tracking.mp4 76.92 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/007 Dynamic Table_ Ranking for Competitor Tracking.mp4 39.2 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/008 Graph III_ Tracking Weekly Performance over Monthly Budget.mp4 71.59 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/009 Final Touches.mp4 6.14 MB
~Get Your Files Here !/10 Professional and Effective Data Visualisation/010 Section Recap.mp4 39.6 MB
~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/001 Introduction.mp4 14.83 MB
~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/002 Status for Data Dump.mp4 50.16 MB
~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/003 Dynamic Budget Connection with IMPORTRANGE & TRANSPOSE.mp4 34.85 MB
~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/004 Dynamic Budget Connection with QUERY.mp4 36.01 MB
~Get Your Files Here !/11 Creating Dynamic and Reliable Data Connections/005 Final Touches.mp4 37.66 MB
~Get Your Files Here !/12 Wrapping Up the Project/001 Introduction.mp4 15.12 MB
~Get Your Files Here !/12 Wrapping Up the Project/002 Adding Instructions.mp4 22.58 MB
~Get Your Files Here !/12 Wrapping Up the Project/003 Reviewing Links in Cover tab.mp4 8.57 MB
~Get Your Files Here !/12 Wrapping Up the Project/004 Final Touches on Whole File.mp4 26.61 MB
~Get Your Files Here !/12 Wrapping Up the Project/005 Protecting the Sheets.mp4 25.79 MB
~Get Your Files Here !/12 Wrapping Up the Project/006 Recap of Course Project.mp4 39.96 MB
~Get Your Files Here !/13 Further Development Tips and Tricks/001 Introduction.mp4 17.77 MB
~Get Your Files Here !/13 Further Development Tips and Tricks/002 Automating Data Dump through a Script.mp4 42.96 MB
~Get Your Files Here !/13 Further Development Tips and Tricks/003 Creating Multi-Level Reporting System.mp4 60.09 MB
~Get Your Files Here !/13 Further Development Tips and Tricks/004 Optimise Spreadsheet Performance.mp4 31.39 MB
~Get Your Files Here !/13 Further Development Tips and Tricks/005 Workaround for IMPORTRANGE Internal Errors.mp4 33.12 MB
~Get Your Files Here !/13 Further Development Tips and Tricks/006 Manage Reporting Files through Scripts.mp4 28.33 MB
~Get Your Files Here !/13 Further Development Tips and Tricks/007 Section Recap.mp4 23.33 MB
~Get Your Files Here !/14 Conclusion/001 Conclusion.mp4 50.15 MB
~Get Your Files Here !/14 Conclusion/002 Bonus Lecture.mp4 38.86 MB
其他位置