种子简介

种子名称： [ TutPig.com ] Udemy - The secrets to generate the most automated Excel Dashboards
文件类型： 视频
文件数目： 173个文件
文件大小： 2.78 GB
收录时间： 2021-12-8 09:25
已经下载： 3次
资源热度： 168
最近下载： 2024-6-13 17:13

下载BT种子文件

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

磁力链接下载

magnet:?xt=urn:btih:e0aac8c9b2e917e45b3274b9e7b3c6d149c39a2a&dn=[ TutPig.com ] Udemy - The secrets to generate the most automated Excel Dashboards 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[ TutPig.com ] Udemy - The secrets to generate the most automated Excel Dashboards.torrent

~Get Your Files Here !/1. Introduction/1. Introduction.mp421.38MB

~Get Your Files Here !/1. Introduction/2. About the Author.mp43.87MB

~Get Your Files Here !/1. Introduction/3. Organization of the course.mp416.22MB

~Get Your Files Here !/1. Introduction/4. What you need to know before starting.mp47.23MB

~Get Your Files Here !/1. Introduction/5. What is a Dashboard.mp422.52MB

~Get Your Files Here !/1. Introduction/6. Summary of useful Lookup & Reference Formulas.mp431.11MB

~Get Your Files Here !/10. KPI Dashboard/1. Overview of the case study.mp41.86MB

~Get Your Files Here !/10. KPI Dashboard/10. Prepare the dashboard (Part VI).mp49.99MB

~Get Your Files Here !/10. KPI Dashboard/11. Prepare the dashboard (Part VII).mp422.8MB

~Get Your Files Here !/10. KPI Dashboard/2. Preparation of data and setup the calculation sheet.mp47.67MB

~Get Your Files Here !/10. KPI Dashboard/3. Prepare the calculation worksheet (Part II).mp414.15MB

~Get Your Files Here !/10. KPI Dashboard/4. Prepare the dashboard (Part I).mp44.74MB

~Get Your Files Here !/10. KPI Dashboard/5. Prepare the dashboard (Part II).mp417.67MB

~Get Your Files Here !/10. KPI Dashboard/6. Prepare the dashboard (Part III).mp42.31MB

~Get Your Files Here !/10. KPI Dashboard/7. Prepare the dashboard (Part IV).mp43.45MB

~Get Your Files Here !/10. KPI Dashboard/8. Prepare the calculation worksheet (Part III).mp47.24MB

~Get Your Files Here !/10. KPI Dashboard/9. Prepare the dashboard (Part V).mp421.57MB

~Get Your Files Here !/11. Financial Dashboard/1. Overview of the case study.mp42.11MB

~Get Your Files Here !/11. Financial Dashboard/10. Prepare the dashboard (Part V).mp412.52MB

~Get Your Files Here !/11. Financial Dashboard/11. Preparation of data and of the dashboard (Part VI).mp425.04MB

~Get Your Files Here !/11. Financial Dashboard/12. Preparation of data and of the dashboard (Part VII).mp412.17MB

~Get Your Files Here !/11. Financial Dashboard/13. Preparation of data - pivot tables (Part I).mp413.76MB

~Get Your Files Here !/11. Financial Dashboard/14. Prepare the dashboard (Part VIII).mp48.62MB

~Get Your Files Here !/11. Financial Dashboard/15. Preparation of data - pivot tables (Part II).mp415.1MB

~Get Your Files Here !/11. Financial Dashboard/16. Preparation of data - pivot tables (Part III).mp46.49MB

~Get Your Files Here !/11. Financial Dashboard/17. Preparation of data - pivot tables (Part IV).mp48.64MB

~Get Your Files Here !/11. Financial Dashboard/18. Prepare the dashboard (Part IX - images connected to tables).mp419.55MB

~Get Your Files Here !/11. Financial Dashboard/19. Finalize the dashboard.mp411.42MB

~Get Your Files Here !/11. Financial Dashboard/2. Preparation of data and of the dashboard (Part I).mp413.72MB

~Get Your Files Here !/11. Financial Dashboard/3. Preparation of data (Part II).mp412.38MB

~Get Your Files Here !/11. Financial Dashboard/4. Prepare the calculation worksheet (Part I).mp46.48MB

~Get Your Files Here !/11. Financial Dashboard/5. Prepare the calculation worksheet (Part II).mp410.99MB

~Get Your Files Here !/11. Financial Dashboard/6. Prepare the calculation worksheet (Part III).mp47.24MB

~Get Your Files Here !/11. Financial Dashboard/7. Preparation of data and of the dashboard (Part II).mp419.61MB

~Get Your Files Here !/11. Financial Dashboard/8. Prepare the dashboard (Part III).mp410.09MB

~Get Your Files Here !/11. Financial Dashboard/9. Preparation of data and of the dashboard (Part IV).mp433.77MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/1. Overview of VBA.mp410.27MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/10. Record a macro and reuse it.mp416.52MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/2. Form Controls and ActiveX Controls.mp49.27MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/3. Controls and VBA code.mp44.99MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/4. The structure of a VBA project.mp47.51MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/5. Sub, functions and declarations in modules, workbook and worksheets.mp412.22MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/6. VBA object hierarchy, properties and events.mp49.92MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/7. User defined functions.mp411.66MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/8. Assign subroutinesmacros to objects on a worksheet.mp44.87MB

~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/9. UserForms.mp417.11MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/1. Understand the events on a workbook.mp414.25MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/10. Format the text in objects with VBA.mp416.18MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/2. Retrieve and edit properties of objects.mp422.68MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/3. Move objects using VBA.mp45.96MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/4. Add events to cells and ranges.mp413.33MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/5. Format data series of charts with VBA.mp411.27MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/6. Working with charts and objects with VBA (Part II).mp430.95MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/7. Retrieve data from external workbooks without opening them.mp428.96MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/8. Retrieve data from several external workbooks.mp432.79MB

~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/9. Format the data in a table with VBA.mp414.78MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/1. Retrieve list of files in a directory and use their information on an Excel file.mp421.88MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/10. How to modify the size of an Excel table delete columns programmatically.mp428.78MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/11. How to modify the size of an Excel table insert columns programmatically.mp420MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/12. Use ActiveX radio buttons and comboboxes in combination on Excel files.mp416.46MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/13. Add refrences to worksheets and cells as internal links in Excel workbooks.mp413.71MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/2. Use dynamically populated ActiveX ComboBox in Excel Dashboards.mp415.29MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/3. Import data from files according to criteria and direct Excel reference.mp421.93MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/4. Add date picker to an Excel file.mp45.52MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/5. Manipulate data label on Excel charts.mp47.49MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/6. Manipulate and format single data labels on Excel charts.mp420.4MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/7. Change the position of data labels in Excel charts programmatically.mp420.19MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/8. How to modify the size of an Excel table programmatically.mp420.01MB

~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/9. How to modify the size of an Excel table prepare the function.mp420.1MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/1. Overview of the case study.mp421.3MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/10. Prepare the calculation worksheet (Part IV).mp416.11MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/11. Prepare the calculation worksheet (Part V).mp417.78MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/12. Prepare the calculation worksheet (Part VI).mp45.09MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/13. Prepare the calculation worksheet (Part VII).mp45.76MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/14. Generate the charts for the Dashboard (Part I).mp45.29MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/15. Generate the charts for the Dashboard (Part II).mp435.52MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/16. Make the chart be updated dynamically.mp432.75MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/17. Prepare the ticket table.mp424.55MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/18. Prepare the ticket summary table.mp415.4MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/19. Prepare the formulas for the ticket figures.mp427.54MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/2. Preparation of the data (part I).mp436.7MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/20. Define formulas for totals and references.mp421.95MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/21. Define formulas for daily figures.mp444.85MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/22. Customize the dashboard (Part I).mp426.77MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/23. Customize the dashboard (Part II).mp48.53MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/24. Customize the dashboard (Part III).mp436.8MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/25. Customize the dashboard (Part IV).mp416.51MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/26. Customize the dashboard (Part V).mp411.39MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/27. Re-elaborate some formulas for the calculation worksheet.mp442.09MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/3. Preparation of data (Part II).mp419.69MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/4. Format the tables of data (Part I).mp417.88MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/5. Format the tables of data (Part II).mp419.3MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/6. Format the tables of data (Part III).mp445.95MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/7. Format the tables of data and set formulas (Part IV).mp432.12MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/8. Prepare the calculation worksheet (Part I).mp438.37MB

~Get Your Files Here !/2. User Acceptance Tests Dashboard/9. Prepare the calculation worksheet (Part III).mp45.15MB

~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/1. Overview of the case study.mp44.89MB

~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/2. Preparation of data.mp413.7MB

~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/3. Preparation of the dashboard (Part I).mp48.07MB

~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/4. Preparation of the dashboard (Part II).mp43.72MB

~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/5. Preparation of the dashboard (Part III).mp413.64MB

~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/1. Overview of the case study.mp412.71MB

~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/2. Preparation of data.mp45.29MB

~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/3. Prepare the calculation worksheet (Part I).mp426.4MB

~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/4. Prepare the calculation worksheet (Part II).mp410.16MB

~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/5. Prepare the dashboard (Part I).mp417.68MB

~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/6. Prepare the dashboard (Part II).mp412.57MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/1. Overview of the case study.mp415.89MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/10. Prepare the dashboard (Part III).mp46.45MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/11. Prepare the dashboard (Part IV).mp413.31MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/12. Prepare the dashboard (Part V).mp419.67MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/13. Prepare the dashboard (Part VI).mp47.88MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/14. Prepare the dashboard (Part VII).mp429.48MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/15. Prepare the dashboard (Part VIII).mp415.31MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/16. Prepare the dashboard (Part IX).mp420.35MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/17. Prepare the dashboard (Part X).mp49.13MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/18. Prepare the dashboard (Part XI).mp412.57MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/19. Prepare the dashboard (Part XII).mp421.17MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/2. Preparation of data.mp418.49MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/20. Prepare the dashboard (Part XIII).mp45.74MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/21. Prepare the dashboard (Part XIV).mp423.54MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/3. Prepare the calculation worksheet (Part I).mp425.47MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/4. Prepare the calculation worksheet (Part II).mp427.89MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/5. Prepare the calculation worksheet (Part III).mp411.17MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/6. Prepare the calculation worksheet (Part IV).mp45.86MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/7. Prepare the calculation worksheet (Part V).mp417.48MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/8. Prepare the dashboard (Part I).mp411.51MB

~Get Your Files Here !/5. Complex KPI Excel Dashboard/9. Prepare the dashboard (Part II).mp417.13MB

~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/1. What is a slicer.mp413.65MB

~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/2. Overview of the case study and preparation of data.mp47.16MB

~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/3. Prepare the pivot tables.mp423.41MB

~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/4. Prepare the dashboard (insert the pivot charts).mp428.41MB

~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/5. Prepare the dashboard (insert the slicers).mp49.29MB

~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/6. Connect the slicers to the pivot tables.mp418.96MB

~Get Your Files Here !/7. Customer Service Dashboard/1. Overview of the case study and preparation of data.mp422.26MB

~Get Your Files Here !/7. Customer Service Dashboard/10. Prepare the dashboard (Part V).mp415.5MB

~Get Your Files Here !/7. Customer Service Dashboard/11. Prepare the dashboard (Part VI).mp411.08MB

~Get Your Files Here !/7. Customer Service Dashboard/12. Prepare the dashboard (Part VII).mp430.45MB

~Get Your Files Here !/7. Customer Service Dashboard/13. Prepare the dashboard (Part VIII).mp439.95MB

~Get Your Files Here !/7. Customer Service Dashboard/2. Preparation of data (Part II).mp436.68MB

~Get Your Files Here !/7. Customer Service Dashboard/3. Prepare the calculation worksheet.mp420.77MB

~Get Your Files Here !/7. Customer Service Dashboard/4. Prepare the dashboard (Part I).mp46.81MB

~Get Your Files Here !/7. Customer Service Dashboard/5. Prepare the calculation worksheet and the dashboard (Part II).mp415.47MB

~Get Your Files Here !/7. Customer Service Dashboard/6. Prepare the calculation worksheet and the dashboard (Part III).mp413.07MB

~Get Your Files Here !/7. Customer Service Dashboard/7. Prepare the dashboard (insert and customize charts).mp413.37MB

~Get Your Files Here !/7. Customer Service Dashboard/8. Prepare the calculation worksheet (call durations).mp411.93MB

~Get Your Files Here !/7. Customer Service Dashboard/9. Prepare the dashboard (Part IV).mp429.53MB

~Get Your Files Here !/8. KPI Dashboard/1. Overview of the case study and preparation of data.mp411.78MB

~Get Your Files Here !/8. KPI Dashboard/2. Prepare the dashboard.mp411.15MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/1. Overview of the case study and definition of project management.mp47.34MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/10. Prepare the dashboard (Part IV).mp411.63MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/11. Prepare the resource plan sheet (Part I).mp44.87MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/12. Prepare the resource plan sheet (Part II) and the burn down chart.mp426.59MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/13. Prepare the resource plan sheet (Part III).mp411.5MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/14. Prepare the resource plan sheet (Part IV).mp412.13MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/15. Prepare the resource plan sheet (Part V).mp47.99MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/16. Prepare the meta data for the resource plan sheet (Part I).mp420.02MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/17. Prepare the meta data for the resource plan sheet (Part II).mp49.06MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/18. Prepare the resource plan sheet (Part VI).mp421.06MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/19. Prepare the risk assessment sheet (Part I).mp417.52MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/2. Preparation of the Gantt chart (Part I).mp414.7MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/20. Prepare the risk assessment sheet (Part II).mp428.01MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/21. Finaliye the risk assessment sheet and report figures to the dashboard.mp417.87MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/22. Report risk assessment figures to the dashboard (Part I).mp410.35MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/23. Report risk assessment figures to the dashboard (Part II).mp44.07MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/24. Finalize the dashboard with project status information.mp430.51MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/3. Preparation of the Gantt chart (Part II).mp420.34MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/4. Preparation of the Gantt chart (Part III).mp45.76MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/5. Preparation of the Gantt chart (Part IV - display the project progress).mp424.91MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/6. Preparation of the Gantt chart (Part V - display the milestones).mp416.29MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/7. Prepare the dashboard (Part I - the milestone summary).mp425.64MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/8. Prepare the dashboard (Part II).mp414.16MB

~Get Your Files Here !/9. Project Management Dashboard Project Status Report/9. Prepare the dashboard (Part III).mp49.4MB