zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[ TutPig.com ] Udemy - The secrets to generate the most automated Excel Dashboards
magnet:?xt=urn:btih:e0aac8c9b2e917e45b3274b9e7b3c6d149c39a2a&dn=[ TutPig.com ] Udemy - The secrets to generate the most automated Excel Dashboards
磁力链接详情
Hash值:
e0aac8c9b2e917e45b3274b9e7b3c6d149c39a2a
点击数:
190
文件大小:
2.78 GB
文件数量:
173
创建日期:
2021-12-8 09:25
最后访问:
2024-8-18 19:52
访问标签:
TutPig
com
Udemy
-
The
secrets
to
generate
the
most
automated
Excel
Dashboards
文件列表详情
~Get Your Files Here !/1. Introduction/1. Introduction.mp4 21.38 MB
~Get Your Files Here !/1. Introduction/2. About the Author.mp4 3.87 MB
~Get Your Files Here !/1. Introduction/3. Organization of the course.mp4 16.22 MB
~Get Your Files Here !/1. Introduction/4. What you need to know before starting.mp4 7.23 MB
~Get Your Files Here !/1. Introduction/5. What is a Dashboard.mp4 22.52 MB
~Get Your Files Here !/1. Introduction/6. Summary of useful Lookup & Reference Formulas.mp4 31.11 MB
~Get Your Files Here !/10. KPI Dashboard/1. Overview of the case study.mp4 1.86 MB
~Get Your Files Here !/10. KPI Dashboard/10. Prepare the dashboard (Part VI).mp4 9.99 MB
~Get Your Files Here !/10. KPI Dashboard/11. Prepare the dashboard (Part VII).mp4 22.8 MB
~Get Your Files Here !/10. KPI Dashboard/2. Preparation of data and setup the calculation sheet.mp4 7.67 MB
~Get Your Files Here !/10. KPI Dashboard/3. Prepare the calculation worksheet (Part II).mp4 14.15 MB
~Get Your Files Here !/10. KPI Dashboard/4. Prepare the dashboard (Part I).mp4 4.74 MB
~Get Your Files Here !/10. KPI Dashboard/5. Prepare the dashboard (Part II).mp4 17.67 MB
~Get Your Files Here !/10. KPI Dashboard/6. Prepare the dashboard (Part III).mp4 2.31 MB
~Get Your Files Here !/10. KPI Dashboard/7. Prepare the dashboard (Part IV).mp4 3.45 MB
~Get Your Files Here !/10. KPI Dashboard/8. Prepare the calculation worksheet (Part III).mp4 7.24 MB
~Get Your Files Here !/10. KPI Dashboard/9. Prepare the dashboard (Part V).mp4 21.57 MB
~Get Your Files Here !/11. Financial Dashboard/1. Overview of the case study.mp4 2.11 MB
~Get Your Files Here !/11. Financial Dashboard/10. Prepare the dashboard (Part V).mp4 12.52 MB
~Get Your Files Here !/11. Financial Dashboard/11. Preparation of data and of the dashboard (Part VI).mp4 25.04 MB
~Get Your Files Here !/11. Financial Dashboard/12. Preparation of data and of the dashboard (Part VII).mp4 12.17 MB
~Get Your Files Here !/11. Financial Dashboard/13. Preparation of data - pivot tables (Part I).mp4 13.76 MB
~Get Your Files Here !/11. Financial Dashboard/14. Prepare the dashboard (Part VIII).mp4 8.62 MB
~Get Your Files Here !/11. Financial Dashboard/15. Preparation of data - pivot tables (Part II).mp4 15.1 MB
~Get Your Files Here !/11. Financial Dashboard/16. Preparation of data - pivot tables (Part III).mp4 6.49 MB
~Get Your Files Here !/11. Financial Dashboard/17. Preparation of data - pivot tables (Part IV).mp4 8.64 MB
~Get Your Files Here !/11. Financial Dashboard/18. Prepare the dashboard (Part IX - images connected to tables).mp4 19.55 MB
~Get Your Files Here !/11. Financial Dashboard/19. Finalize the dashboard.mp4 11.42 MB
~Get Your Files Here !/11. Financial Dashboard/2. Preparation of data and of the dashboard (Part I).mp4 13.72 MB
~Get Your Files Here !/11. Financial Dashboard/3. Preparation of data (Part II).mp4 12.38 MB
~Get Your Files Here !/11. Financial Dashboard/4. Prepare the calculation worksheet (Part I).mp4 6.48 MB
~Get Your Files Here !/11. Financial Dashboard/5. Prepare the calculation worksheet (Part II).mp4 10.99 MB
~Get Your Files Here !/11. Financial Dashboard/6. Prepare the calculation worksheet (Part III).mp4 7.24 MB
~Get Your Files Here !/11. Financial Dashboard/7. Preparation of data and of the dashboard (Part II).mp4 19.61 MB
~Get Your Files Here !/11. Financial Dashboard/8. Prepare the dashboard (Part III).mp4 10.09 MB
~Get Your Files Here !/11. Financial Dashboard/9. Preparation of data and of the dashboard (Part IV).mp4 33.77 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/1. Overview of VBA.mp4 10.27 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/10. Record a macro and reuse it.mp4 16.52 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/2. Form Controls and ActiveX Controls.mp4 9.27 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/3. Controls and VBA code.mp4 4.99 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/4. The structure of a VBA project.mp4 7.51 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/5. Sub, functions and declarations in modules, workbook and worksheets.mp4 12.22 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/6. VBA object hierarchy, properties and events.mp4 9.92 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/7. User defined functions.mp4 11.66 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/8. Assign subroutinesmacros to objects on a worksheet.mp4 4.87 MB
~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/9. UserForms.mp4 17.11 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/1. Understand the events on a workbook.mp4 14.25 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/10. Format the text in objects with VBA.mp4 16.18 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/2. Retrieve and edit properties of objects.mp4 22.68 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/3. Move objects using VBA.mp4 5.96 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/4. Add events to cells and ranges.mp4 13.33 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/5. Format data series of charts with VBA.mp4 11.27 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/6. Working with charts and objects with VBA (Part II).mp4 30.95 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/7. Retrieve data from external workbooks without opening them.mp4 28.96 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/8. Retrieve data from several external workbooks.mp4 32.79 MB
~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/9. Format the data in a table with VBA.mp4 14.78 MB
~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.mp4 21.88 MB
~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.mp4 28.78 MB
~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.mp4 20 MB
~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.mp4 16.46 MB
~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.mp4 13.71 MB
~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/2. Use dynamically populated ActiveX ComboBox in Excel Dashboards.mp4 15.29 MB
~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.mp4 21.93 MB
~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/4. Add date picker to an Excel file.mp4 5.52 MB
~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/5. Manipulate data label on Excel charts.mp4 7.49 MB
~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/6. Manipulate and format single data labels on Excel charts.mp4 20.4 MB
~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.mp4 20.19 MB
~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.mp4 20.01 MB
~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.mp4 20.1 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/1. Overview of the case study.mp4 21.3 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/10. Prepare the calculation worksheet (Part IV).mp4 16.11 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/11. Prepare the calculation worksheet (Part V).mp4 17.78 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/12. Prepare the calculation worksheet (Part VI).mp4 5.09 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/13. Prepare the calculation worksheet (Part VII).mp4 5.76 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/14. Generate the charts for the Dashboard (Part I).mp4 5.29 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/15. Generate the charts for the Dashboard (Part II).mp4 35.52 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/16. Make the chart be updated dynamically.mp4 32.75 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/17. Prepare the ticket table.mp4 24.55 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/18. Prepare the ticket summary table.mp4 15.4 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/19. Prepare the formulas for the ticket figures.mp4 27.54 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/2. Preparation of the data (part I).mp4 36.7 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/20. Define formulas for totals and references.mp4 21.95 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/21. Define formulas for daily figures.mp4 44.85 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/22. Customize the dashboard (Part I).mp4 26.77 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/23. Customize the dashboard (Part II).mp4 8.53 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/24. Customize the dashboard (Part III).mp4 36.8 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/25. Customize the dashboard (Part IV).mp4 16.51 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/26. Customize the dashboard (Part V).mp4 11.39 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/27. Re-elaborate some formulas for the calculation worksheet.mp4 42.09 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/3. Preparation of data (Part II).mp4 19.69 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/4. Format the tables of data (Part I).mp4 17.88 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/5. Format the tables of data (Part II).mp4 19.3 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/6. Format the tables of data (Part III).mp4 45.95 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/7. Format the tables of data and set formulas (Part IV).mp4 32.12 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/8. Prepare the calculation worksheet (Part I).mp4 38.37 MB
~Get Your Files Here !/2. User Acceptance Tests Dashboard/9. Prepare the calculation worksheet (Part III).mp4 5.15 MB
~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/1. Overview of the case study.mp4 4.89 MB
~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/2. Preparation of data.mp4 13.7 MB
~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/3. Preparation of the dashboard (Part I).mp4 8.07 MB
~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/4. Preparation of the dashboard (Part II).mp4 3.72 MB
~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/5. Preparation of the dashboard (Part III).mp4 13.64 MB
~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/1. Overview of the case study.mp4 12.71 MB
~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/2. Preparation of data.mp4 5.29 MB
~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/3. Prepare the calculation worksheet (Part I).mp4 26.4 MB
~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/4. Prepare the calculation worksheet (Part II).mp4 10.16 MB
~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/5. Prepare the dashboard (Part I).mp4 17.68 MB
~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/6. Prepare the dashboard (Part II).mp4 12.57 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/1. Overview of the case study.mp4 15.89 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/10. Prepare the dashboard (Part III).mp4 6.45 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/11. Prepare the dashboard (Part IV).mp4 13.31 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/12. Prepare the dashboard (Part V).mp4 19.67 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/13. Prepare the dashboard (Part VI).mp4 7.88 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/14. Prepare the dashboard (Part VII).mp4 29.48 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/15. Prepare the dashboard (Part VIII).mp4 15.31 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/16. Prepare the dashboard (Part IX).mp4 20.35 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/17. Prepare the dashboard (Part X).mp4 9.13 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/18. Prepare the dashboard (Part XI).mp4 12.57 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/19. Prepare the dashboard (Part XII).mp4 21.17 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/2. Preparation of data.mp4 18.49 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/20. Prepare the dashboard (Part XIII).mp4 5.74 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/21. Prepare the dashboard (Part XIV).mp4 23.54 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/3. Prepare the calculation worksheet (Part I).mp4 25.47 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/4. Prepare the calculation worksheet (Part II).mp4 27.89 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/5. Prepare the calculation worksheet (Part III).mp4 11.17 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/6. Prepare the calculation worksheet (Part IV).mp4 5.86 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/7. Prepare the calculation worksheet (Part V).mp4 17.48 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/8. Prepare the dashboard (Part I).mp4 11.51 MB
~Get Your Files Here !/5. Complex KPI Excel Dashboard/9. Prepare the dashboard (Part II).mp4 17.13 MB
~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/1. What is a slicer.mp4 13.65 MB
~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/2. Overview of the case study and preparation of data.mp4 7.16 MB
~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/3. Prepare the pivot tables.mp4 23.41 MB
~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/4. Prepare the dashboard (insert the pivot charts).mp4 28.41 MB
~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/5. Prepare the dashboard (insert the slicers).mp4 9.29 MB
~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/6. Connect the slicers to the pivot tables.mp4 18.96 MB
~Get Your Files Here !/7. Customer Service Dashboard/1. Overview of the case study and preparation of data.mp4 22.26 MB
~Get Your Files Here !/7. Customer Service Dashboard/10. Prepare the dashboard (Part V).mp4 15.5 MB
~Get Your Files Here !/7. Customer Service Dashboard/11. Prepare the dashboard (Part VI).mp4 11.08 MB
~Get Your Files Here !/7. Customer Service Dashboard/12. Prepare the dashboard (Part VII).mp4 30.45 MB
~Get Your Files Here !/7. Customer Service Dashboard/13. Prepare the dashboard (Part VIII).mp4 39.95 MB
~Get Your Files Here !/7. Customer Service Dashboard/2. Preparation of data (Part II).mp4 36.68 MB
~Get Your Files Here !/7. Customer Service Dashboard/3. Prepare the calculation worksheet.mp4 20.77 MB
~Get Your Files Here !/7. Customer Service Dashboard/4. Prepare the dashboard (Part I).mp4 6.81 MB
~Get Your Files Here !/7. Customer Service Dashboard/5. Prepare the calculation worksheet and the dashboard (Part II).mp4 15.47 MB
~Get Your Files Here !/7. Customer Service Dashboard/6. Prepare the calculation worksheet and the dashboard (Part III).mp4 13.07 MB
~Get Your Files Here !/7. Customer Service Dashboard/7. Prepare the dashboard (insert and customize charts).mp4 13.37 MB
~Get Your Files Here !/7. Customer Service Dashboard/8. Prepare the calculation worksheet (call durations).mp4 11.93 MB
~Get Your Files Here !/7. Customer Service Dashboard/9. Prepare the dashboard (Part IV).mp4 29.53 MB
~Get Your Files Here !/8. KPI Dashboard/1. Overview of the case study and preparation of data.mp4 11.78 MB
~Get Your Files Here !/8. KPI Dashboard/2. Prepare the dashboard.mp4 11.15 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/1. Overview of the case study and definition of project management.mp4 7.34 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/10. Prepare the dashboard (Part IV).mp4 11.63 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/11. Prepare the resource plan sheet (Part I).mp4 4.87 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/12. Prepare the resource plan sheet (Part II) and the burn down chart.mp4 26.59 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/13. Prepare the resource plan sheet (Part III).mp4 11.5 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/14. Prepare the resource plan sheet (Part IV).mp4 12.13 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/15. Prepare the resource plan sheet (Part V).mp4 7.99 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/16. Prepare the meta data for the resource plan sheet (Part I).mp4 20.02 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/17. Prepare the meta data for the resource plan sheet (Part II).mp4 9.06 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/18. Prepare the resource plan sheet (Part VI).mp4 21.06 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/19. Prepare the risk assessment sheet (Part I).mp4 17.52 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/2. Preparation of the Gantt chart (Part I).mp4 14.7 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/20. Prepare the risk assessment sheet (Part II).mp4 28.01 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/21. Finaliye the risk assessment sheet and report figures to the dashboard.mp4 17.87 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/22. Report risk assessment figures to the dashboard (Part I).mp4 10.35 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/23. Report risk assessment figures to the dashboard (Part II).mp4 4.07 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/24. Finalize the dashboard with project status information.mp4 30.51 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/3. Preparation of the Gantt chart (Part II).mp4 20.34 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/4. Preparation of the Gantt chart (Part III).mp4 5.76 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/5. Preparation of the Gantt chart (Part IV - display the project progress).mp4 24.91 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/6. Preparation of the Gantt chart (Part V - display the milestones).mp4 16.29 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/7. Prepare the dashboard (Part I - the milestone summary).mp4 25.64 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/8. Prepare the dashboard (Part II).mp4 14.16 MB
~Get Your Files Here !/9. Project Management Dashboard Project Status Report/9. Prepare the dashboard (Part III).mp4 9.4 MB
其他位置