磁力链接

magnet:?xt=urn:btih:E0AAC8C9B2E917E45B3274B9E7B3C6D149C39A2A
推荐使用PIKPAK网盘下载资源,PIKPAK是目前最好用网盘,10T超大空间,不和谐任何资源,支持无限次数离线下载,视频在线观看

资源截图

API Integration

文件列表

  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/6. Format the tables of data (Part III).mp4 48.2 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/21. Define formulas for daily figures.mp4 47.0 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/27. Re-elaborate some formulas for the calculation worksheet.mp4 44.1 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/13. Prepare the dashboard (Part VIII).mp4 41.9 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/8. Prepare the calculation worksheet (Part I).mp4 40.2 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/24. Customize the dashboard (Part III).mp4 38.6 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/2. Preparation of the data (part I).mp4 38.5 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/2. Preparation of data (Part II).mp4 38.5 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/15. Generate the charts for the Dashboard (Part II).mp4 37.2 MB
  • ~Get Your Files Here !/11. Financial Dashboard/9. Preparation of data and of the dashboard (Part IV).mp4 35.4 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/8. Retrieve data from several external workbooks.mp4 34.4 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/16. Make the chart be updated dynamically.mp4 34.3 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/7. Format the tables of data and set formulas (Part IV).mp4 33.7 MB
  • ~Get Your Files Here !/1. Introduction/6. Summary of useful Lookup & Reference Formulas.mp4 32.6 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 32.5 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/24. Finalize the dashboard with project status information.mp4 32.0 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/12. Prepare the dashboard (Part VII).mp4 31.9 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/9. Prepare the dashboard (Part IV).mp4 31.0 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/14. Prepare the dashboard (Part VII).mp4 30.9 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/7. Retrieve data from external workbooks without opening them.mp4 30.4 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 30.2 MB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/4. Prepare the dashboard (insert the pivot charts).mp4 29.8 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/20. Prepare the risk assessment sheet (Part II).mp4 29.4 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/4. Prepare the calculation worksheet (Part II).mp4 29.2 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/19. Prepare the formulas for the ticket figures.mp4 28.9 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/22. Customize the dashboard (Part I).mp4 28.1 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 27.9 MB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/3. Prepare the calculation worksheet (Part I).mp4 27.7 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/7. Prepare the dashboard (Part I - the milestone summary).mp4 26.9 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/3. Prepare the calculation worksheet (Part I).mp4 26.7 MB
  • ~Get Your Files Here !/11. Financial Dashboard/11. Preparation of data and of the dashboard (Part VI).mp4 26.3 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 26.1 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/17. Prepare the ticket table.mp4 25.7 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/21. Prepare the dashboard (Part XIV).mp4 24.7 MB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/3. Prepare the pivot tables.mp4 24.5 MB
  • ~Get Your Files Here !/10. KPI Dashboard/11. Prepare the dashboard (Part VII).mp4 23.9 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/2. Retrieve and edit properties of objects.mp4 23.8 MB
  • ~Get Your Files Here !/1. Introduction/5. What is a Dashboard.mp4 23.6 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/1. Overview of the case study and preparation of data.mp4 23.3 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/20. Define formulas for totals and references.mp4 23.0 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 23.0 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 22.9 MB
  • ~Get Your Files Here !/10. KPI Dashboard/9. Prepare the dashboard (Part V).mp4 22.6 MB
  • ~Get Your Files Here !/1. Introduction/1. Introduction.mp4 22.4 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/1. Overview of the case study.mp4 22.3 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/19. Prepare the dashboard (Part XII).mp4 22.2 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/18. Prepare the resource plan sheet (Part VI).mp4 22.1 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/3. Prepare the calculation worksheet.mp4 21.8 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 21.4 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/16. Prepare the dashboard (Part IX).mp4 21.3 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/3. Preparation of the Gantt chart (Part II).mp4 21.3 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 21.2 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 21.1 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 21.0 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 21.0 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 21.0 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/3. Preparation of data (Part II).mp4 20.7 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/12. Prepare the dashboard (Part V).mp4 20.6 MB
  • ~Get Your Files Here !/11. Financial Dashboard/7. Preparation of data and of the dashboard (Part II).mp4 20.6 MB
  • ~Get Your Files Here !/11. Financial Dashboard/18. Prepare the dashboard (Part IX - images connected to tables).mp4 20.5 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/5. Format the tables of data (Part II).mp4 20.2 MB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/6. Connect the slicers to the pivot tables.mp4 19.9 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/2. Preparation of data.mp4 19.4 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/4. Format the tables of data (Part I).mp4 18.8 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 18.7 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/11. Prepare the calculation worksheet (Part V).mp4 18.6 MB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/5. Prepare the dashboard (Part I).mp4 18.5 MB
  • ~Get Your Files Here !/10. KPI Dashboard/5. Prepare the dashboard (Part II).mp4 18.5 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/19. Prepare the risk assessment sheet (Part I).mp4 18.4 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/7. Prepare the calculation worksheet (Part V).mp4 18.3 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/9. Prepare the dashboard (Part II).mp4 18.0 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/9. UserForms.mp4 17.9 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/10. Record a macro and reuse it.mp4 17.3 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/25. Customize the dashboard (Part IV).mp4 17.3 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 17.3 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/6. Preparation of the Gantt chart (Part V - display the milestones).mp4 17.1 MB
  • ~Get Your Files Here !/1. Introduction/3. Organization of the course.mp4 17.0 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/10. Format the text in objects with VBA.mp4 17.0 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/10. Prepare the calculation worksheet (Part IV).mp4 16.9 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/1. Overview of the case study.mp4 16.7 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/10. Prepare the dashboard (Part V).mp4 16.3 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/5. Prepare the calculation worksheet and the dashboard (Part II).mp4 16.2 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/18. Prepare the ticket summary table.mp4 16.1 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/15. Prepare the dashboard (Part VIII).mp4 16.1 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 16.0 MB
  • ~Get Your Files Here !/11. Financial Dashboard/15. Preparation of data - pivot tables (Part II).mp4 15.8 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/9. Format the data in a table with VBA.mp4 15.5 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/2. Preparation of the Gantt chart (Part I).mp4 15.4 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/1. Understand the events on a workbook.mp4 14.9 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/8. Prepare the dashboard (Part II).mp4 14.8 MB
  • ~Get Your Files Here !/10. KPI Dashboard/3. Prepare the calculation worksheet (Part II).mp4 14.8 MB
  • ~Get Your Files Here !/11. Financial Dashboard/13. Preparation of data - pivot tables (Part I).mp4 14.4 MB
  • ~Get Your Files Here !/11. Financial Dashboard/2. Preparation of data and of the dashboard (Part I).mp4 14.4 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 14.4 MB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/2. Preparation of data.mp4 14.4 MB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/1. What is a slicer.mp4 14.3 MB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/5. Preparation of the dashboard (Part III).mp4 14.3 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/7. Prepare the dashboard (insert and customize charts).mp4 14.0 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/4. Add events to cells and ranges.mp4 14.0 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/11. Prepare the dashboard (Part IV).mp4 14.0 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/6. Prepare the calculation worksheet and the dashboard (Part III).mp4 13.7 MB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/1. Overview of the case study.mp4 13.3 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/18. Prepare the dashboard (Part XI).mp4 13.2 MB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/6. Prepare the dashboard (Part II).mp4 13.2 MB
  • ~Get Your Files Here !/11. Financial Dashboard/10. Prepare the dashboard (Part V).mp4 13.1 MB
  • ~Get Your Files Here !/11. Financial Dashboard/3. Preparation of data (Part II).mp4 13.0 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/5. Sub, functions and declarations in modules, workbook and worksheets.mp4 12.8 MB
  • ~Get Your Files Here !/11. Financial Dashboard/12. Preparation of data and of the dashboard (Part VII).mp4 12.8 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/14. Prepare the resource plan sheet (Part IV).mp4 12.7 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/8. Prepare the calculation worksheet (call durations).mp4 12.5 MB
  • ~Get Your Files Here !/8. KPI Dashboard/1. Overview of the case study and preparation of data.mp4 12.4 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/7. User defined functions.mp4 12.2 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/10. Prepare the dashboard (Part IV).mp4 12.2 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/8. Prepare the dashboard (Part I).mp4 12.1 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/13. Prepare the resource plan sheet (Part III).mp4 12.1 MB
  • ~Get Your Files Here !/11. Financial Dashboard/19. Finalize the dashboard.mp4 12.0 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/26. Customize the dashboard (Part V).mp4 11.9 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/5. Format data series of charts with VBA.mp4 11.8 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/5. Prepare the calculation worksheet (Part III).mp4 11.7 MB
  • ~Get Your Files Here !/8. KPI Dashboard/2. Prepare the dashboard.mp4 11.7 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/11. Prepare the dashboard (Part VI).mp4 11.6 MB
  • ~Get Your Files Here !/11. Financial Dashboard/5. Prepare the calculation worksheet (Part II).mp4 11.5 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/22. Report risk assessment figures to the dashboard (Part I).mp4 10.8 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/1. Overview of VBA.mp4 10.8 MB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/4. Prepare the calculation worksheet (Part II).mp4 10.6 MB
  • ~Get Your Files Here !/11. Financial Dashboard/8. Prepare the dashboard (Part III).mp4 10.6 MB
  • ~Get Your Files Here !/10. KPI Dashboard/10. Prepare the dashboard (Part VI).mp4 10.5 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/6. VBA object hierarchy, properties and events.mp4 10.4 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/9. Prepare the dashboard (Part III).mp4 9.9 MB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/5. Prepare the dashboard (insert the slicers).mp4 9.7 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/2. Form Controls and ActiveX Controls.mp4 9.7 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/17. Prepare the dashboard (Part X).mp4 9.6 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.5 MB
  • ~Get Your Files Here !/11. Financial Dashboard/17. Preparation of data - pivot tables (Part IV).mp4 9.1 MB
  • ~Get Your Files Here !/11. Financial Dashboard/14. Prepare the dashboard (Part VIII).mp4 9.0 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/23. Customize the dashboard (Part II).mp4 8.9 MB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/3. Preparation of the dashboard (Part I).mp4 8.5 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/15. Prepare the resource plan sheet (Part V).mp4 8.4 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/13. Prepare the dashboard (Part VI).mp4 8.3 MB
  • ~Get Your Files Here !/10. KPI Dashboard/2. Preparation of data and setup the calculation sheet.mp4 8.0 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/4. The structure of a VBA project.mp4 7.9 MB
  • ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/5. Manipulate data label on Excel charts.mp4 7.9 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.7 MB
  • ~Get Your Files Here !/10. KPI Dashboard/8. Prepare the calculation worksheet (Part III).mp4 7.6 MB
  • ~Get Your Files Here !/11. Financial Dashboard/6. Prepare the calculation worksheet (Part III).mp4 7.6 MB
  • ~Get Your Files Here !/1. Introduction/4. What you need to know before starting.mp4 7.6 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.5 MB
  • ~Get Your Files Here !/7. Customer Service Dashboard/4. Prepare the dashboard (Part I).mp4 7.1 MB
  • ~Get Your Files Here !/11. Financial Dashboard/16. Preparation of data - pivot tables (Part III).mp4 6.8 MB
  • ~Get Your Files Here !/11. Financial Dashboard/4. Prepare the calculation worksheet (Part I).mp4 6.8 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/10. Prepare the dashboard (Part III).mp4 6.8 MB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/3. Move objects using VBA.mp4 6.2 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/6. Prepare the calculation worksheet (Part IV).mp4 6.1 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/4. Preparation of the Gantt chart (Part III).mp4 6.0 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/13. Prepare the calculation worksheet (Part VII).mp4 6.0 MB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/20. Prepare the dashboard (Part XIII).mp4 6.0 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.8 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/14. Generate the charts for the Dashboard (Part I).mp4 5.5 MB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/2. Preparation of data.mp4 5.5 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/9. Prepare the calculation worksheet (Part III).mp4 5.4 MB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/12. Prepare the calculation worksheet (Part VI).mp4 5.3 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/3. Controls and VBA code.mp4 5.2 MB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/1. Overview of the case study.mp4 5.1 MB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/8. Assign subroutinesmacros to objects on a worksheet.mp4 5.1 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/11. Prepare the resource plan sheet (Part I).mp4 5.1 MB
  • ~Get Your Files Here !/10. KPI Dashboard/4. Prepare the dashboard (Part I).mp4 5.0 MB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/23. Report risk assessment figures to the dashboard (Part II).mp4 4.3 MB
  • ~Get Your Files Here !/1. Introduction/2. About the Author.mp4 4.1 MB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/4. Preparation of the dashboard (Part II).mp4 3.9 MB
  • ~Get Your Files Here !/10. KPI Dashboard/7. Prepare the dashboard (Part IV).mp4 3.6 MB
  • ~Get Your Files Here !/10. KPI Dashboard/6. Prepare the dashboard (Part III).mp4 2.4 MB
  • ~Get Your Files Here !/11. Financial Dashboard/1. Overview of the case study.mp4 2.2 MB
  • ~Get Your Files Here !/10. KPI Dashboard/1. Overview of the case study.mp4 2.0 MB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/excel-dashboard-lecture-43.pdf 1.2 MB
  • ~Get Your Files Here !/11. Financial Dashboard/11-ex-financial-dashboard-01.xlsx 311.4 kB
  • ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/14-ex-dashboard-vba-01-v1b.xlsm 299.0 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/07-ex-customer-service-data.xlsm 267.1 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/07-ex-customer-service.xlsm 266.0 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/13-ex-dashboard-vba-01.xlsm 250.6 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/02-ex-UAT-testing-overview.xlsm 240.8 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/13-ex-dashboard-vba-01-data.xlsm 233.3 kB
  • ~Get Your Files Here !/11. Financial Dashboard/11-ex-financial-dashboard-01-data.xlsx 170.9 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/05-ex-kpi-dashboard-01-data.xlsx 163.5 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/05-ex-kpi-dashboard-01.xlsx 163.5 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/09-ex-project-management.xlsx 102.3 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/02-ex-UAT-testing-overview-data.xlsm 99.6 kB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/06-ex-dashboard-pivot-slicers.xlsx 90.1 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/09-ex-project-management-data.xlsx 54.6 kB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/06-ex-dashboard-pivot-slicers-data.xlsx 39.0 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/12-vba-ex-01-data.xlsm 35.0 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/12-vba-ex-01.xlsm 35.0 kB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/04-ex-sales.xlsm 34.5 kB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/03-ex-hyperlink.xlsm 21.4 kB
  • ~Get Your Files Here !/10. KPI Dashboard/10-ex-kpi-dashboard-02-data.xlsx 18.6 kB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/03-ex-hyperlink-data.xlsm 16.2 kB
  • ~Get Your Files Here !/8. KPI Dashboard/08-ex-kpi-basic.xlsx 14.8 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/13. Prepare the dashboard (Part VIII)-en_US.srt 13.9 kB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/04-ex-sales-data.xlsm 13.3 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/12. Prepare the dashboard (Part VII)-en_US.srt 12.9 kB
  • ~Get Your Files Here !/8. KPI Dashboard/08-ex-kpi-basic-data.xlsx 12.1 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/21. Define formulas for daily figures-en_US.srt 11.8 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/8. Prepare the calculation worksheet (Part I)-en_US.srt 11.5 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/6. Working with charts and objects with VBA (Part II)-en_US.srt 10.9 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/24. Customize the dashboard (Part III)-en_US.srt 10.4 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/7. Retrieve data from external workbooks without opening them-en_US.srt 10.4 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/8. Retrieve data from several external workbooks-en_US.srt 10.3 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/27. Re-elaborate some formulas for the calculation worksheet-en_US.srt 10.3 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/2. Retrieve and edit properties of objects-en_US.srt 10.2 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/24. Finalize the dashboard with project status information-en_US.srt 10.2 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/16. Make the chart be updated dynamically-en_US.srt 10.1 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/2. Preparation of data (Part II)-en_US.srt 9.7 kB
  • ~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-en_US.srt 9.7 kB
  • ~Get Your Files Here !/11. Financial Dashboard/9. Preparation of data and of the dashboard (Part IV)-en_US.srt 9.4 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/12. Prepare the resource plan sheet (Part II) and the burn down chart-en_US.srt 9.2 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/9. Prepare the dashboard (Part IV)-en_US.srt 9.1 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/1. Overview of the case study and preparation of data-en_US.srt 9.1 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/15. Generate the charts for the Dashboard (Part II)-en_US.srt 9.0 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/6. Format the tables of data (Part III)-en_US.srt 8.7 kB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/4. Prepare the dashboard (insert the pivot charts)-en_US.srt 8.5 kB
  • ~Get Your Files Here !/1. Introduction/6. Summary of useful Lookup & Reference Formulas-en_US.srt 8.4 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/18. Prepare the resource plan sheet (Part VI)-en_US.srt 7.8 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/2. Preparation of the data (part I)-en_US.srt 7.8 kB
  • ~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-en_US.srt 7.7 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/7. Prepare the dashboard (Part I - the milestone summary)-en_US.srt 7.7 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/21. Prepare the dashboard (Part XIV)-en_US.srt 7.6 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/5. Preparation of the Gantt chart (Part IV - display the project progress)-en_US.srt 7.6 kB
  • ~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-en_US.srt 7.5 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/3. Preparation of the Gantt chart (Part II)-en_US.srt 7.3 kB
  • ~Get Your Files Here !/1. Introduction/3. Organization of the course-en_US.srt 7.2 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/22. Customize the dashboard (Part I)-en_US.srt 7.2 kB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/3. Prepare the calculation worksheet (Part I)-en_US.srt 7.1 kB
  • ~Get Your Files Here !/10. KPI Dashboard/11. Prepare the dashboard (Part VII)-en_US.srt 7.1 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/3. Prepare the calculation worksheet (Part I)-en_US.srt 6.9 kB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/2. Preparation of data-en_US.srt 6.9 kB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/5. Prepare the dashboard (Part I)-en_US.srt 6.8 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/20. Prepare the risk assessment sheet (Part II)-en_US.srt 6.8 kB
  • ~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-en_US.srt 6.6 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/7. Format the tables of data and set formulas (Part IV)-en_US.srt 6.5 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/9. UserForms-en_US.srt 6.5 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/1. Overview of the case study-en_US.srt 6.4 kB
  • ~Get Your Files Here !/1. Introduction/5. What is a Dashboard-en_US.srt 6.4 kB
  • ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/6. Manipulate and format single data labels on Excel charts-en_US.srt 6.3 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/1. Overview of the case study-en_US.srt 6.2 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/10. Prepare the dashboard (Part V)-en_US.srt 6.2 kB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/3. Prepare the pivot tables-en_US.srt 6.1 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/16. Prepare the meta data for the resource plan sheet (Part I)-en_US.srt 6.1 kB
  • ~Get Your Files Here !/10. KPI Dashboard/3. Prepare the calculation worksheet (Part II)-en_US.srt 6.1 kB
  • ~Get Your Files Here !/11. Financial Dashboard/18. Prepare the dashboard (Part IX - images connected to tables)-en_US.srt 6.1 kB
  • ~Get Your Files Here !/11. Financial Dashboard/11. Preparation of data and of the dashboard (Part VI)-en_US.srt 6.0 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/4. Add events to cells and ranges-en_US.srt 5.8 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/3. Prepare the calculation worksheet-en_US.srt 5.8 kB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/6. Connect the slicers to the pivot tables-en_US.srt 5.7 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/20. Define formulas for totals and references-en_US.srt 5.7 kB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/5. Preparation of the dashboard (Part III)-en_US.srt 5.6 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/4. Prepare the calculation worksheet (Part II)-en_US.srt 5.6 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/19. Prepare the formulas for the ticket figures-en_US.srt 5.6 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/12. Prepare the dashboard (Part V)-en_US.srt 5.6 kB
  • ~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-en_US.srt 5.5 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/5. Sub, functions and declarations in modules, workbook and worksheets-en_US.srt 5.5 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/10. Prepare the calculation worksheet (Part IV)-en_US.srt 5.4 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/8. Prepare the dashboard (Part II)-en_US.srt 5.4 kB
  • ~Get Your Files Here !/11. Financial Dashboard/12. Preparation of data and of the dashboard (Part VII)-en_US.srt 5.3 kB
  • ~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-en_US.srt 5.3 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/10. Format the text in objects with VBA-en_US.srt 5.3 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/7. Prepare the dashboard (insert and customize charts)-en_US.srt 5.3 kB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/1. Overview of the case study-en_US.srt 5.3 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/11. Prepare the dashboard (Part IV)-en_US.srt 5.2 kB
  • ~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-en_US.srt 5.2 kB
  • ~Get Your Files Here !/11. Financial Dashboard/2. Preparation of data and of the dashboard (Part I)-en_US.srt 5.1 kB
  • ~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-en_US.srt 5.1 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/5. Prepare the calculation worksheet and the dashboard (Part II)-en_US.srt 5.1 kB
  • ~Get Your Files Here !/10. KPI Dashboard/5. Prepare the dashboard (Part II)-en_US.srt 5.1 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/9. Format the data in a table with VBA-en_US.srt 5.0 kB
  • ~Get Your Files Here !/11. Financial Dashboard/7. Preparation of data and of the dashboard (Part II)-en_US.srt 5.0 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/5. Format the tables of data (Part II)-en_US.srt 5.0 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/19. Prepare the risk assessment sheet (Part I)-en_US.srt 5.0 kB
  • ~Get Your Files Here !/10. KPI Dashboard/9. Prepare the dashboard (Part V)-en_US.srt 5.0 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/10. Record a macro and reuse it-en_US.srt 4.9 kB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/6. Prepare the dashboard (Part II)-en_US.srt 4.9 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/11. Prepare the dashboard (Part VI)-en_US.srt 4.8 kB
  • ~Get Your Files Here !/8. KPI Dashboard/1. Overview of the case study and preparation of data-en_US.srt 4.8 kB
  • ~Get Your Files Here !/8. KPI Dashboard/2. Prepare the dashboard-en_US.srt 4.8 kB
  • ~Get Your Files Here !/11. Financial Dashboard/10. Prepare the dashboard (Part V)-en_US.srt 4.7 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/18. Prepare the dashboard (Part XI)-en_US.srt 4.7 kB
  • ~Get Your Files Here !/11. Financial Dashboard/13. Preparation of data - pivot tables (Part I)-en_US.srt 4.5 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/10. Prepare the dashboard (Part IV)-en_US.srt 4.5 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/6. Preparation of the Gantt chart (Part V - display the milestones)-en_US.srt 4.5 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/4. Format the tables of data (Part I)-en_US.srt 4.3 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/21. Finaliye the risk assessment sheet and report figures to the dashboard-en_US.srt 4.3 kB
  • ~Get Your Files Here !/11. Financial Dashboard/19. Finalize the dashboard-en_US.srt 4.3 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/16. Prepare the dashboard (Part IX)-en_US.srt 4.3 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/11. Prepare the calculation worksheet (Part V)-en_US.srt 4.3 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/1. Understand the events on a workbook-en_US.srt 4.2 kB
  • ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/2. Use dynamically populated ActiveX ComboBox in Excel Dashboards-en_US.srt 4.2 kB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/4. Prepare the calculation worksheet (Part II)-en_US.srt 4.2 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/8. Prepare the calculation worksheet (call durations)-en_US.srt 4.2 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/7. Prepare the calculation worksheet (Part V)-en_US.srt 4.1 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/3. Preparation of data (Part II)-en_US.srt 4.1 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/1. Overview of VBA-en_US.srt 4.1 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/2. Preparation of data-en_US.srt 4.1 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/14. Prepare the resource plan sheet (Part IV)-en_US.srt 4.0 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/17. Prepare the ticket table-en_US.srt 3.9 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/14. Prepare the dashboard (Part VII)-en_US.srt 3.9 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/6. VBA object hierarchy, properties and events-en_US.srt 3.9 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/2. Form Controls and ActiveX Controls-en_US.srt 3.8 kB
  • ~Get Your Files Here !/11. Financial Dashboard/15. Preparation of data - pivot tables (Part II)-en_US.srt 3.8 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/8. Prepare the dashboard (Part I)-en_US.srt 3.8 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/7. User defined functions-en_US.srt 3.7 kB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/3. Preparation of the dashboard (Part I)-en_US.srt 3.7 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/25. Customize the dashboard (Part IV)-en_US.srt 3.7 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/19. Prepare the dashboard (Part XII)-en_US.srt 3.6 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/6. Prepare the calculation worksheet and the dashboard (Part III)-en_US.srt 3.6 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/17. Prepare the meta data for the resource plan sheet (Part II)-en_US.srt 3.6 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/22. Report risk assessment figures to the dashboard (Part I)-en_US.srt 3.5 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/26. Customize the dashboard (Part V)-en_US.srt 3.5 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/2. Preparation of the Gantt chart (Part I)-en_US.srt 3.4 kB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/5. Prepare the dashboard (insert the slicers)-en_US.srt 3.4 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/13. Prepare the resource plan sheet (Part III)-en_US.srt 3.4 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/15. Prepare the dashboard (Part VIII)-en_US.srt 3.4 kB
  • ~Get Your Files Here !/11. Financial Dashboard/14. Prepare the dashboard (Part VIII)-en_US.srt 3.3 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/4. The structure of a VBA project-en_US.srt 3.3 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/5. Format data series of charts with VBA-en_US.srt 3.3 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/9. Prepare the dashboard (Part III)-en_US.srt 3.3 kB
  • ~Get Your Files Here !/11. Financial Dashboard/5. Prepare the calculation worksheet (Part II)-en_US.srt 3.3 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/13. Prepare the dashboard (Part VI)-en_US.srt 3.2 kB
  • ~Get Your Files Here !/1. Introduction/4. What you need to know before starting-en_US.srt 3.1 kB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/1. What is a slicer-en_US.srt 3.1 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/15. Prepare the resource plan sheet (Part V)-en_US.srt 3.1 kB
  • ~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-en_US.srt 3.0 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/1. Overview of the case study and definition of project management-en_US.srt 3.0 kB
  • ~Get Your Files Here !/10. KPI Dashboard/2. Preparation of data and setup the calculation sheet-en_US.srt 2.9 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/18. Prepare the ticket summary table-en_US.srt 2.8 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/5. Prepare the calculation worksheet (Part III)-en_US.srt 2.8 kB
  • ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/5. Manipulate data label on Excel charts-en_US.srt 2.8 kB
  • ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/2. Overview of the case study and preparation of data-en_US.srt 2.8 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/9. Prepare the dashboard (Part II)-en_US.srt 2.8 kB
  • ~Get Your Files Here !/11. Financial Dashboard/6. Prepare the calculation worksheet (Part III)-en_US.srt 2.7 kB
  • ~Get Your Files Here !/11. Financial Dashboard/8. Prepare the dashboard (Part III)-en_US.srt 2.7 kB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/1. Overview of the case study-en_US.srt 2.6 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/23. Customize the dashboard (Part II)-en_US.srt 2.6 kB
  • ~Get Your Files Here !/11. Financial Dashboard/4. Prepare the calculation worksheet (Part I)-en_US.srt 2.6 kB
  • ~Get Your Files Here !/1. Introduction/1. Introduction-en_US.srt 2.5 kB
  • ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/3. Move objects using VBA-en_US.srt 2.4 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/17. Prepare the dashboard (Part X)-en_US.srt 2.4 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/3. Controls and VBA code-en_US.srt 2.3 kB
  • ~Get Your Files Here !/11. Financial Dashboard/17. Preparation of data - pivot tables (Part IV)-en_US.srt 2.3 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/11. Prepare the resource plan sheet (Part I)-en_US.srt 2.2 kB
  • ~Get Your Files Here !/10. KPI Dashboard/10. Prepare the dashboard (Part VI)-en_US.srt 2.1 kB
  • ~Get Your Files Here !/11. Financial Dashboard/16. Preparation of data - pivot tables (Part III)-en_US.srt 2.1 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/10. Prepare the dashboard (Part III)-en_US.srt 2.0 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/9. Prepare the calculation worksheet (Part III)-en_US.srt 1.9 kB
  • ~Get Your Files Here !/7. Customer Service Dashboard/4. Prepare the dashboard (Part I)-en_US.srt 1.9 kB
  • ~Get Your Files Here !/10. KPI Dashboard/8. Prepare the calculation worksheet (Part III)-en_US.srt 1.9 kB
  • ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/8. Assign subroutinesmacros to objects on a worksheet-en_US.srt 1.8 kB
  • ~Get Your Files Here !/11. Financial Dashboard/3. Preparation of data (Part II)-en_US.srt 1.8 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/20. Prepare the dashboard (Part XIII)-en_US.srt 1.8 kB
  • ~Get Your Files Here !/10. KPI Dashboard/4. Prepare the dashboard (Part I)-en_US.srt 1.7 kB
  • ~Get Your Files Here !/1. Introduction/2. About the Author-en_US.srt 1.7 kB
  • ~Get Your Files Here !/5. Complex KPI Excel Dashboard/6. Prepare the calculation worksheet (Part IV)-en_US.srt 1.7 kB
  • ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/2. Preparation of data-en_US.srt 1.6 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/4. Preparation of the Gantt chart (Part III)-en_US.srt 1.6 kB
  • ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/4. Preparation of the dashboard (Part II)-en_US.srt 1.5 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/14. Generate the charts for the Dashboard (Part I)-en_US.srt 1.5 kB
  • ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/4. Add date picker to an Excel file-en_US.srt 1.5 kB
  • ~Get Your Files Here !/10. KPI Dashboard/7. Prepare the dashboard (Part IV)-en_US.srt 1.4 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/12. Prepare the calculation worksheet (Part VI)-en_US.srt 1.3 kB
  • ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/23. Report risk assessment figures to the dashboard (Part II)-en_US.srt 1.1 kB
  • ~Get Your Files Here !/2. User Acceptance Tests Dashboard/13. Prepare the calculation worksheet (Part VII)-en_US.srt 970 Bytes
  • ~Get Your Files Here !/10. KPI Dashboard/6. Prepare the dashboard (Part III)-en_US.srt 935 Bytes
  • ~Get Your Files Here !/10. KPI Dashboard/1. Overview of the case study-en_US.srt 929 Bytes
  • ~Get Your Files Here !/11. Financial Dashboard/1. Overview of the case study-en_US.srt 777 Bytes
  • ~Get Your Files Here !/Bonus Resources.txt 357 Bytes
  • Get Bonus Downloads Here.url 176 Bytes

温馨提示

本站不存储任何资源内容,只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符),并提供查询服务,是一个完全合法的搜索引擎系统。网站不提供种子下载服务,用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责,请用户注意甄别!