589689.xyz

[ ] Udemy - The secrets to generate the most automated Excel Dashboards

  • 收录时间:2023-09-02 13:29:47
  • 文件大小:3GB
  • 下载次数:1
  • 最近下载:2023-09-02 13:29:47
  • 磁力链接:

文件列表

  1. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/6. Format the tables of data (Part III).mp4 46MB
  2. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/21. Define formulas for daily figures.mp4 45MB
  3. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/27. Re-elaborate some formulas for the calculation worksheet.mp4 42MB
  4. ~Get Your Files Here !/7. Customer Service Dashboard/13. Prepare the dashboard (Part VIII).mp4 40MB
  5. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/8. Prepare the calculation worksheet (Part I).mp4 38MB
  6. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/24. Customize the dashboard (Part III).mp4 37MB
  7. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/2. Preparation of the data (part I).mp4 37MB
  8. ~Get Your Files Here !/7. Customer Service Dashboard/2. Preparation of data (Part II).mp4 37MB
  9. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/15. Generate the charts for the Dashboard (Part II).mp4 36MB
  10. ~Get Your Files Here !/11. Financial Dashboard/9. Preparation of data and of the dashboard (Part IV).mp4 34MB
  11. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/8. Retrieve data from several external workbooks.mp4 33MB
  12. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/16. Make the chart be updated dynamically.mp4 33MB
  13. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/7. Format the tables of data and set formulas (Part IV).mp4 32MB
  14. ~Get Your Files Here !/1. Introduction/6. Summary of useful Lookup & Reference Formulas.mp4 31MB
  15. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/6. Working with charts and objects with VBA (Part II).mp4 31MB
  16. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/24. Finalize the dashboard with project status information.mp4 31MB
  17. ~Get Your Files Here !/7. Customer Service Dashboard/12. Prepare the dashboard (Part VII).mp4 30MB
  18. ~Get Your Files Here !/7. Customer Service Dashboard/9. Prepare the dashboard (Part IV).mp4 30MB
  19. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/14. Prepare the dashboard (Part VII).mp4 29MB
  20. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/7. Retrieve data from external workbooks without opening them.mp4 29MB
  21. ~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 29MB
  22. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/4. Prepare the dashboard (insert the pivot charts).mp4 28MB
  23. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/20. Prepare the risk assessment sheet (Part II).mp4 28MB
  24. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/4. Prepare the calculation worksheet (Part II).mp4 28MB
  25. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/19. Prepare the formulas for the ticket figures.mp4 28MB
  26. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/22. Customize the dashboard (Part I).mp4 27MB
  27. ~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 27MB
  28. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/3. Prepare the calculation worksheet (Part I).mp4 26MB
  29. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/7. Prepare the dashboard (Part I - the milestone summary).mp4 26MB
  30. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/3. Prepare the calculation worksheet (Part I).mp4 25MB
  31. ~Get Your Files Here !/11. Financial Dashboard/11. Preparation of data and of the dashboard (Part VI).mp4 25MB
  32. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/5. Preparation of the Gantt chart (Part IV - display the project progress).mp4 25MB
  33. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/17. Prepare the ticket table.mp4 25MB
  34. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/21. Prepare the dashboard (Part XIV).mp4 24MB
  35. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/3. Prepare the pivot tables.mp4 23MB
  36. ~Get Your Files Here !/10. KPI Dashboard/11. Prepare the dashboard (Part VII).mp4 23MB
  37. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/2. Retrieve and edit properties of objects.mp4 23MB
  38. ~Get Your Files Here !/1. Introduction/5. What is a Dashboard.mp4 23MB
  39. ~Get Your Files Here !/7. Customer Service Dashboard/1. Overview of the case study and preparation of data.mp4 22MB
  40. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/20. Define formulas for totals and references.mp4 22MB
  41. ~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 22MB
  42. ~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 22MB
  43. ~Get Your Files Here !/10. KPI Dashboard/9. Prepare the dashboard (Part V).mp4 22MB
  44. ~Get Your Files Here !/1. Introduction/1. Introduction.mp4 21MB
  45. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/1. Overview of the case study.mp4 21MB
  46. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/19. Prepare the dashboard (Part XII).mp4 21MB
  47. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/18. Prepare the resource plan sheet (Part VI).mp4 21MB
  48. ~Get Your Files Here !/7. Customer Service Dashboard/3. Prepare the calculation worksheet.mp4 21MB
  49. ~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 20MB
  50. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/16. Prepare the dashboard (Part IX).mp4 20MB
  51. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/3. Preparation of the Gantt chart (Part II).mp4 20MB
  52. ~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 20MB
  53. ~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 20MB
  54. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/16. Prepare the meta data for the resource plan sheet (Part I).mp4 20MB
  55. ~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 20MB
  56. ~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 20MB
  57. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/3. Preparation of data (Part II).mp4 20MB
  58. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/12. Prepare the dashboard (Part V).mp4 20MB
  59. ~Get Your Files Here !/11. Financial Dashboard/7. Preparation of data and of the dashboard (Part II).mp4 20MB
  60. ~Get Your Files Here !/11. Financial Dashboard/18. Prepare the dashboard (Part IX - images connected to tables).mp4 20MB
  61. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/5. Format the tables of data (Part II).mp4 19MB
  62. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/6. Connect the slicers to the pivot tables.mp4 19MB
  63. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/2. Preparation of data.mp4 18MB
  64. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/4. Format the tables of data (Part I).mp4 18MB
  65. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/21. Finaliye the risk assessment sheet and report figures to the dashboard.mp4 18MB
  66. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/11. Prepare the calculation worksheet (Part V).mp4 18MB
  67. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/5. Prepare the dashboard (Part I).mp4 18MB
  68. ~Get Your Files Here !/10. KPI Dashboard/5. Prepare the dashboard (Part II).mp4 18MB
  69. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/19. Prepare the risk assessment sheet (Part I).mp4 18MB
  70. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/7. Prepare the calculation worksheet (Part V).mp4 17MB
  71. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/9. Prepare the dashboard (Part II).mp4 17MB
  72. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/9. UserForms.mp4 17MB
  73. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/10. Record a macro and reuse it.mp4 17MB
  74. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/25. Customize the dashboard (Part IV).mp4 17MB
  75. ~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 16MB
  76. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/6. Preparation of the Gantt chart (Part V - display the milestones).mp4 16MB
  77. ~Get Your Files Here !/1. Introduction/3. Organization of the course.mp4 16MB
  78. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/10. Format the text in objects with VBA.mp4 16MB
  79. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/10. Prepare the calculation worksheet (Part IV).mp4 16MB
  80. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/1. Overview of the case study.mp4 16MB
  81. ~Get Your Files Here !/7. Customer Service Dashboard/10. Prepare the dashboard (Part V).mp4 16MB
  82. ~Get Your Files Here !/7. Customer Service Dashboard/5. Prepare the calculation worksheet and the dashboard (Part II).mp4 15MB
  83. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/18. Prepare the ticket summary table.mp4 15MB
  84. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/15. Prepare the dashboard (Part VIII).mp4 15MB
  85. ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/2. Use dynamically populated ActiveX ComboBox in Excel Dashboards.mp4 15MB
  86. ~Get Your Files Here !/11. Financial Dashboard/15. Preparation of data - pivot tables (Part II).mp4 15MB
  87. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/9. Format the data in a table with VBA.mp4 15MB
  88. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/2. Preparation of the Gantt chart (Part I).mp4 15MB
  89. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/1. Understand the events on a workbook.mp4 14MB
  90. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/8. Prepare the dashboard (Part II).mp4 14MB
  91. ~Get Your Files Here !/10. KPI Dashboard/3. Prepare the calculation worksheet (Part II).mp4 14MB
  92. ~Get Your Files Here !/11. Financial Dashboard/13. Preparation of data - pivot tables (Part I).mp4 14MB
  93. ~Get Your Files Here !/11. Financial Dashboard/2. Preparation of data and of the dashboard (Part I).mp4 14MB
  94. ~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 14MB
  95. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/2. Preparation of data.mp4 14MB
  96. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/1. What is a slicer.mp4 14MB
  97. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/5. Preparation of the dashboard (Part III).mp4 14MB
  98. ~Get Your Files Here !/7. Customer Service Dashboard/7. Prepare the dashboard (insert and customize charts).mp4 13MB
  99. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/4. Add events to cells and ranges.mp4 13MB
  100. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/11. Prepare the dashboard (Part IV).mp4 13MB
  101. ~Get Your Files Here !/7. Customer Service Dashboard/6. Prepare the calculation worksheet and the dashboard (Part III).mp4 13MB
  102. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/1. Overview of the case study.mp4 13MB
  103. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/18. Prepare the dashboard (Part XI).mp4 13MB
  104. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/6. Prepare the dashboard (Part II).mp4 13MB
  105. ~Get Your Files Here !/11. Financial Dashboard/10. Prepare the dashboard (Part V).mp4 13MB
  106. ~Get Your Files Here !/11. Financial Dashboard/3. Preparation of data (Part II).mp4 12MB
  107. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/5. Sub, functions and declarations in modules, workbook and worksheets.mp4 12MB
  108. ~Get Your Files Here !/11. Financial Dashboard/12. Preparation of data and of the dashboard (Part VII).mp4 12MB
  109. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/14. Prepare the resource plan sheet (Part IV).mp4 12MB
  110. ~Get Your Files Here !/7. Customer Service Dashboard/8. Prepare the calculation worksheet (call durations).mp4 12MB
  111. ~Get Your Files Here !/8. KPI Dashboard/1. Overview of the case study and preparation of data.mp4 12MB
  112. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/7. User defined functions.mp4 12MB
  113. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/10. Prepare the dashboard (Part IV).mp4 12MB
  114. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/8. Prepare the dashboard (Part I).mp4 12MB
  115. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/13. Prepare the resource plan sheet (Part III).mp4 11MB
  116. ~Get Your Files Here !/11. Financial Dashboard/19. Finalize the dashboard.mp4 11MB
  117. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/26. Customize the dashboard (Part V).mp4 11MB
  118. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/5. Format data series of charts with VBA.mp4 11MB
  119. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/5. Prepare the calculation worksheet (Part III).mp4 11MB
  120. ~Get Your Files Here !/8. KPI Dashboard/2. Prepare the dashboard.mp4 11MB
  121. ~Get Your Files Here !/7. Customer Service Dashboard/11. Prepare the dashboard (Part VI).mp4 11MB
  122. ~Get Your Files Here !/11. Financial Dashboard/5. Prepare the calculation worksheet (Part II).mp4 11MB
  123. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/22. Report risk assessment figures to the dashboard (Part I).mp4 10MB
  124. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/1. Overview of VBA.mp4 10MB
  125. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/4. Prepare the calculation worksheet (Part II).mp4 10MB
  126. ~Get Your Files Here !/11. Financial Dashboard/8. Prepare the dashboard (Part III).mp4 10MB
  127. ~Get Your Files Here !/10. KPI Dashboard/10. Prepare the dashboard (Part VI).mp4 10MB
  128. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/6. VBA object hierarchy, properties and events.mp4 10MB
  129. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/9. Prepare the dashboard (Part III).mp4 9MB
  130. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/5. Prepare the dashboard (insert the slicers).mp4 9MB
  131. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/2. Form Controls and ActiveX Controls.mp4 9MB
  132. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/17. Prepare the dashboard (Part X).mp4 9MB
  133. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/17. Prepare the meta data for the resource plan sheet (Part II).mp4 9MB
  134. ~Get Your Files Here !/11. Financial Dashboard/17. Preparation of data - pivot tables (Part IV).mp4 9MB
  135. ~Get Your Files Here !/11. Financial Dashboard/14. Prepare the dashboard (Part VIII).mp4 9MB
  136. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/23. Customize the dashboard (Part II).mp4 9MB
  137. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/3. Preparation of the dashboard (Part I).mp4 8MB
  138. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/15. Prepare the resource plan sheet (Part V).mp4 8MB
  139. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/13. Prepare the dashboard (Part VI).mp4 8MB
  140. ~Get Your Files Here !/10. KPI Dashboard/2. Preparation of data and setup the calculation sheet.mp4 8MB
  141. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/4. The structure of a VBA project.mp4 8MB
  142. ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/5. Manipulate data label on Excel charts.mp4 7MB
  143. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/1. Overview of the case study and definition of project management.mp4 7MB
  144. ~Get Your Files Here !/10. KPI Dashboard/8. Prepare the calculation worksheet (Part III).mp4 7MB
  145. ~Get Your Files Here !/11. Financial Dashboard/6. Prepare the calculation worksheet (Part III).mp4 7MB
  146. ~Get Your Files Here !/1. Introduction/4. What you need to know before starting.mp4 7MB
  147. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/2. Overview of the case study and preparation of data.mp4 7MB
  148. ~Get Your Files Here !/7. Customer Service Dashboard/4. Prepare the dashboard (Part I).mp4 7MB
  149. ~Get Your Files Here !/11. Financial Dashboard/16. Preparation of data - pivot tables (Part III).mp4 6MB
  150. ~Get Your Files Here !/11. Financial Dashboard/4. Prepare the calculation worksheet (Part I).mp4 6MB
  151. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/10. Prepare the dashboard (Part III).mp4 6MB
  152. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/3. Move objects using VBA.mp4 6MB
  153. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/6. Prepare the calculation worksheet (Part IV).mp4 6MB
  154. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/4. Preparation of the Gantt chart (Part III).mp4 6MB
  155. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/13. Prepare the calculation worksheet (Part VII).mp4 6MB
  156. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/20. Prepare the dashboard (Part XIII).mp4 6MB
  157. ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/4. Add date picker to an Excel file.mp4 6MB
  158. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/14. Generate the charts for the Dashboard (Part I).mp4 5MB
  159. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/2. Preparation of data.mp4 5MB
  160. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/9. Prepare the calculation worksheet (Part III).mp4 5MB
  161. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/12. Prepare the calculation worksheet (Part VI).mp4 5MB
  162. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/3. Controls and VBA code.mp4 5MB
  163. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/1. Overview of the case study.mp4 5MB
  164. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/8. Assign subroutinesmacros to objects on a worksheet.mp4 5MB
  165. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/11. Prepare the resource plan sheet (Part I).mp4 5MB
  166. ~Get Your Files Here !/10. KPI Dashboard/4. Prepare the dashboard (Part I).mp4 5MB
  167. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/23. Report risk assessment figures to the dashboard (Part II).mp4 4MB
  168. ~Get Your Files Here !/1. Introduction/2. About the Author.mp4 4MB
  169. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/4. Preparation of the dashboard (Part II).mp4 4MB
  170. ~Get Your Files Here !/10. KPI Dashboard/7. Prepare the dashboard (Part IV).mp4 3MB
  171. ~Get Your Files Here !/10. KPI Dashboard/6. Prepare the dashboard (Part III).mp4 2MB
  172. ~Get Your Files Here !/11. Financial Dashboard/1. Overview of the case study.mp4 2MB
  173. ~Get Your Files Here !/10. KPI Dashboard/1. Overview of the case study.mp4 2MB
  174. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/excel-dashboard-lecture-43.pdf 1MB
  175. ~Get Your Files Here !/11. Financial Dashboard/11-ex-financial-dashboard-01.xlsx 304KB
  176. ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/14-ex-dashboard-vba-01-v1b.xlsm 292KB
  177. ~Get Your Files Here !/7. Customer Service Dashboard/07-ex-customer-service-data.xlsm 261KB
  178. ~Get Your Files Here !/7. Customer Service Dashboard/07-ex-customer-service.xlsm 260KB
  179. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/13-ex-dashboard-vba-01.xlsm 245KB
  180. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/02-ex-UAT-testing-overview.xlsm 235KB
  181. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/13-ex-dashboard-vba-01-data.xlsm 228KB
  182. ~Get Your Files Here !/11. Financial Dashboard/11-ex-financial-dashboard-01-data.xlsx 167KB
  183. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/05-ex-kpi-dashboard-01-data.xlsx 160KB
  184. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/05-ex-kpi-dashboard-01.xlsx 160KB
  185. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/09-ex-project-management.xlsx 100KB
  186. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/02-ex-UAT-testing-overview-data.xlsm 97KB
  187. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/06-ex-dashboard-pivot-slicers.xlsx 88KB
  188. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/09-ex-project-management-data.xlsx 53KB
  189. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/06-ex-dashboard-pivot-slicers-data.xlsx 38KB
  190. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/12-vba-ex-01-data.xlsm 34KB
  191. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/12-vba-ex-01.xlsm 34KB
  192. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/04-ex-sales.xlsm 34KB
  193. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/03-ex-hyperlink.xlsm 21KB
  194. ~Get Your Files Here !/10. KPI Dashboard/10-ex-kpi-dashboard-02-data.xlsx 18KB
  195. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/03-ex-hyperlink-data.xlsm 16KB
  196. ~Get Your Files Here !/8. KPI Dashboard/08-ex-kpi-basic.xlsx 14KB
  197. ~Get Your Files Here !/7. Customer Service Dashboard/13. Prepare the dashboard (Part VIII)-en_US.srt 14KB
  198. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/04-ex-sales-data.xlsm 13KB
  199. ~Get Your Files Here !/7. Customer Service Dashboard/12. Prepare the dashboard (Part VII)-en_US.srt 13KB
  200. ~Get Your Files Here !/8. KPI Dashboard/08-ex-kpi-basic-data.xlsx 12KB
  201. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/21. Define formulas for daily figures-en_US.srt 12KB
  202. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/8. Prepare the calculation worksheet (Part I)-en_US.srt 11KB
  203. ~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 11KB
  204. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/24. Customize the dashboard (Part III)-en_US.srt 10KB
  205. ~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 10KB
  206. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/8. Retrieve data from several external workbooks-en_US.srt 10KB
  207. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/27. Re-elaborate some formulas for the calculation worksheet-en_US.srt 10KB
  208. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/2. Retrieve and edit properties of objects-en_US.srt 10KB
  209. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/24. Finalize the dashboard with project status information-en_US.srt 10KB
  210. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/16. Make the chart be updated dynamically-en_US.srt 10KB
  211. ~Get Your Files Here !/7. Customer Service Dashboard/2. Preparation of data (Part II)-en_US.srt 9KB
  212. ~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 9KB
  213. ~Get Your Files Here !/11. Financial Dashboard/9. Preparation of data and of the dashboard (Part IV)-en_US.srt 9KB
  214. ~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 9KB
  215. ~Get Your Files Here !/7. Customer Service Dashboard/9. Prepare the dashboard (Part IV)-en_US.srt 9KB
  216. ~Get Your Files Here !/7. Customer Service Dashboard/1. Overview of the case study and preparation of data-en_US.srt 9KB
  217. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/15. Generate the charts for the Dashboard (Part II)-en_US.srt 9KB
  218. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/6. Format the tables of data (Part III)-en_US.srt 9KB
  219. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/4. Prepare the dashboard (insert the pivot charts)-en_US.srt 8KB
  220. ~Get Your Files Here !/1. Introduction/6. Summary of useful Lookup & Reference Formulas-en_US.srt 8KB
  221. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/18. Prepare the resource plan sheet (Part VI)-en_US.srt 8KB
  222. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/2. Preparation of the data (part I)-en_US.srt 8KB
  223. ~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 8KB
  224. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/7. Prepare the dashboard (Part I - the milestone summary)-en_US.srt 7KB
  225. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/21. Prepare the dashboard (Part XIV)-en_US.srt 7KB
  226. ~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 7KB
  227. ~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 7KB
  228. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/3. Preparation of the Gantt chart (Part II)-en_US.srt 7KB
  229. ~Get Your Files Here !/1. Introduction/3. Organization of the course-en_US.srt 7KB
  230. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/22. Customize the dashboard (Part I)-en_US.srt 7KB
  231. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/3. Prepare the calculation worksheet (Part I)-en_US.srt 7KB
  232. ~Get Your Files Here !/10. KPI Dashboard/11. Prepare the dashboard (Part VII)-en_US.srt 7KB
  233. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/3. Prepare the calculation worksheet (Part I)-en_US.srt 7KB
  234. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/2. Preparation of data-en_US.srt 7KB
  235. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/5. Prepare the dashboard (Part I)-en_US.srt 7KB
  236. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/20. Prepare the risk assessment sheet (Part II)-en_US.srt 7KB
  237. ~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 6KB
  238. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/7. Format the tables of data and set formulas (Part IV)-en_US.srt 6KB
  239. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/9. UserForms-en_US.srt 6KB
  240. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/1. Overview of the case study-en_US.srt 6KB
  241. ~Get Your Files Here !/1. Introduction/5. What is a Dashboard-en_US.srt 6KB
  242. ~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 6KB
  243. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/1. Overview of the case study-en_US.srt 6KB
  244. ~Get Your Files Here !/7. Customer Service Dashboard/10. Prepare the dashboard (Part V)-en_US.srt 6KB
  245. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/3. Prepare the pivot tables-en_US.srt 6KB
  246. ~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 6KB
  247. ~Get Your Files Here !/10. KPI Dashboard/3. Prepare the calculation worksheet (Part II)-en_US.srt 6KB
  248. ~Get Your Files Here !/11. Financial Dashboard/18. Prepare the dashboard (Part IX - images connected to tables)-en_US.srt 6KB
  249. ~Get Your Files Here !/11. Financial Dashboard/11. Preparation of data and of the dashboard (Part VI)-en_US.srt 6KB
  250. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/4. Add events to cells and ranges-en_US.srt 6KB
  251. ~Get Your Files Here !/7. Customer Service Dashboard/3. Prepare the calculation worksheet-en_US.srt 6KB
  252. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/6. Connect the slicers to the pivot tables-en_US.srt 6KB
  253. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/20. Define formulas for totals and references-en_US.srt 6KB
  254. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/5. Preparation of the dashboard (Part III)-en_US.srt 6KB
  255. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/4. Prepare the calculation worksheet (Part II)-en_US.srt 5KB
  256. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/19. Prepare the formulas for the ticket figures-en_US.srt 5KB
  257. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/12. Prepare the dashboard (Part V)-en_US.srt 5KB
  258. ~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 5KB
  259. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/5. Sub, functions and declarations in modules, workbook and worksheets-en_US.srt 5KB
  260. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/10. Prepare the calculation worksheet (Part IV)-en_US.srt 5KB
  261. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/8. Prepare the dashboard (Part II)-en_US.srt 5KB
  262. ~Get Your Files Here !/11. Financial Dashboard/12. Preparation of data and of the dashboard (Part VII)-en_US.srt 5KB
  263. ~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 5KB
  264. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/10. Format the text in objects with VBA-en_US.srt 5KB
  265. ~Get Your Files Here !/7. Customer Service Dashboard/7. Prepare the dashboard (insert and customize charts)-en_US.srt 5KB
  266. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/1. Overview of the case study-en_US.srt 5KB
  267. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/11. Prepare the dashboard (Part IV)-en_US.srt 5KB
  268. ~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 5KB
  269. ~Get Your Files Here !/11. Financial Dashboard/2. Preparation of data and of the dashboard (Part I)-en_US.srt 5KB
  270. ~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 5KB
  271. ~Get Your Files Here !/7. Customer Service Dashboard/5. Prepare the calculation worksheet and the dashboard (Part II)-en_US.srt 5KB
  272. ~Get Your Files Here !/10. KPI Dashboard/5. Prepare the dashboard (Part II)-en_US.srt 5KB
  273. ~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 5KB
  274. ~Get Your Files Here !/11. Financial Dashboard/7. Preparation of data and of the dashboard (Part II)-en_US.srt 5KB
  275. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/5. Format the tables of data (Part II)-en_US.srt 5KB
  276. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/19. Prepare the risk assessment sheet (Part I)-en_US.srt 5KB
  277. ~Get Your Files Here !/10. KPI Dashboard/9. Prepare the dashboard (Part V)-en_US.srt 5KB
  278. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/10. Record a macro and reuse it-en_US.srt 5KB
  279. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/6. Prepare the dashboard (Part II)-en_US.srt 5KB
  280. ~Get Your Files Here !/7. Customer Service Dashboard/11. Prepare the dashboard (Part VI)-en_US.srt 5KB
  281. ~Get Your Files Here !/8. KPI Dashboard/1. Overview of the case study and preparation of data-en_US.srt 5KB
  282. ~Get Your Files Here !/8. KPI Dashboard/2. Prepare the dashboard-en_US.srt 5KB
  283. ~Get Your Files Here !/11. Financial Dashboard/10. Prepare the dashboard (Part V)-en_US.srt 5KB
  284. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/18. Prepare the dashboard (Part XI)-en_US.srt 5KB
  285. ~Get Your Files Here !/11. Financial Dashboard/13. Preparation of data - pivot tables (Part I)-en_US.srt 4KB
  286. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/10. Prepare the dashboard (Part IV)-en_US.srt 4KB
  287. ~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 4KB
  288. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/4. Format the tables of data (Part I)-en_US.srt 4KB
  289. ~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 4KB
  290. ~Get Your Files Here !/11. Financial Dashboard/19. Finalize the dashboard-en_US.srt 4KB
  291. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/16. Prepare the dashboard (Part IX)-en_US.srt 4KB
  292. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/11. Prepare the calculation worksheet (Part V)-en_US.srt 4KB
  293. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/1. Understand the events on a workbook-en_US.srt 4KB
  294. ~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 4KB
  295. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/4. Prepare the calculation worksheet (Part II)-en_US.srt 4KB
  296. ~Get Your Files Here !/7. Customer Service Dashboard/8. Prepare the calculation worksheet (call durations)-en_US.srt 4KB
  297. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/7. Prepare the calculation worksheet (Part V)-en_US.srt 4KB
  298. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/3. Preparation of data (Part II)-en_US.srt 4KB
  299. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/1. Overview of VBA-en_US.srt 4KB
  300. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/2. Preparation of data-en_US.srt 4KB
  301. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/14. Prepare the resource plan sheet (Part IV)-en_US.srt 4KB
  302. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/17. Prepare the ticket table-en_US.srt 4KB
  303. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/14. Prepare the dashboard (Part VII)-en_US.srt 4KB
  304. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/6. VBA object hierarchy, properties and events-en_US.srt 4KB
  305. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/2. Form Controls and ActiveX Controls-en_US.srt 4KB
  306. ~Get Your Files Here !/11. Financial Dashboard/15. Preparation of data - pivot tables (Part II)-en_US.srt 4KB
  307. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/8. Prepare the dashboard (Part I)-en_US.srt 4KB
  308. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/7. User defined functions-en_US.srt 4KB
  309. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/3. Preparation of the dashboard (Part I)-en_US.srt 4KB
  310. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/25. Customize the dashboard (Part IV)-en_US.srt 4KB
  311. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/19. Prepare the dashboard (Part XII)-en_US.srt 4KB
  312. ~Get Your Files Here !/7. Customer Service Dashboard/6. Prepare the calculation worksheet and the dashboard (Part III)-en_US.srt 4KB
  313. ~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 3KB
  314. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/22. Report risk assessment figures to the dashboard (Part I)-en_US.srt 3KB
  315. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/26. Customize the dashboard (Part V)-en_US.srt 3KB
  316. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/2. Preparation of the Gantt chart (Part I)-en_US.srt 3KB
  317. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/5. Prepare the dashboard (insert the slicers)-en_US.srt 3KB
  318. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/13. Prepare the resource plan sheet (Part III)-en_US.srt 3KB
  319. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/15. Prepare the dashboard (Part VIII)-en_US.srt 3KB
  320. ~Get Your Files Here !/11. Financial Dashboard/14. Prepare the dashboard (Part VIII)-en_US.srt 3KB
  321. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/4. The structure of a VBA project-en_US.srt 3KB
  322. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/5. Format data series of charts with VBA-en_US.srt 3KB
  323. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/9. Prepare the dashboard (Part III)-en_US.srt 3KB
  324. ~Get Your Files Here !/11. Financial Dashboard/5. Prepare the calculation worksheet (Part II)-en_US.srt 3KB
  325. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/13. Prepare the dashboard (Part VI)-en_US.srt 3KB
  326. ~Get Your Files Here !/1. Introduction/4. What you need to know before starting-en_US.srt 3KB
  327. ~Get Your Files Here !/6. Make Dynamic Dashboards using Pivot Tables & Slicers/1. What is a slicer-en_US.srt 3KB
  328. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/15. Prepare the resource plan sheet (Part V)-en_US.srt 3KB
  329. ~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 3KB
  330. ~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 3KB
  331. ~Get Your Files Here !/10. KPI Dashboard/2. Preparation of data and setup the calculation sheet-en_US.srt 3KB
  332. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/18. Prepare the ticket summary table-en_US.srt 3KB
  333. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/5. Prepare the calculation worksheet (Part III)-en_US.srt 3KB
  334. ~Get Your Files Here !/14. Special Bonus use VBA to enhance your Excel dashboards/5. Manipulate data label on Excel charts-en_US.srt 3KB
  335. ~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 3KB
  336. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/9. Prepare the dashboard (Part II)-en_US.srt 3KB
  337. ~Get Your Files Here !/11. Financial Dashboard/6. Prepare the calculation worksheet (Part III)-en_US.srt 3KB
  338. ~Get Your Files Here !/11. Financial Dashboard/8. Prepare the dashboard (Part III)-en_US.srt 3KB
  339. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/1. Overview of the case study-en_US.srt 3KB
  340. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/23. Customize the dashboard (Part II)-en_US.srt 3KB
  341. ~Get Your Files Here !/11. Financial Dashboard/4. Prepare the calculation worksheet (Part I)-en_US.srt 2KB
  342. ~Get Your Files Here !/1. Introduction/1. Introduction-en_US.srt 2KB
  343. ~Get Your Files Here !/13. Enhance the user acceptance test dashboard with VBA/3. Move objects using VBA-en_US.srt 2KB
  344. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/17. Prepare the dashboard (Part X)-en_US.srt 2KB
  345. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/3. Controls and VBA code-en_US.srt 2KB
  346. ~Get Your Files Here !/11. Financial Dashboard/17. Preparation of data - pivot tables (Part IV)-en_US.srt 2KB
  347. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/11. Prepare the resource plan sheet (Part I)-en_US.srt 2KB
  348. ~Get Your Files Here !/10. KPI Dashboard/10. Prepare the dashboard (Part VI)-en_US.srt 2KB
  349. ~Get Your Files Here !/11. Financial Dashboard/16. Preparation of data - pivot tables (Part III)-en_US.srt 2KB
  350. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/10. Prepare the dashboard (Part III)-en_US.srt 2KB
  351. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/9. Prepare the calculation worksheet (Part III)-en_US.srt 2KB
  352. ~Get Your Files Here !/7. Customer Service Dashboard/4. Prepare the dashboard (Part I)-en_US.srt 2KB
  353. ~Get Your Files Here !/10. KPI Dashboard/8. Prepare the calculation worksheet (Part III)-en_US.srt 2KB
  354. ~Get Your Files Here !/12. Understand Visual Basic for Applications (VBA)/8. Assign subroutinesmacros to objects on a worksheet-en_US.srt 2KB
  355. ~Get Your Files Here !/11. Financial Dashboard/3. Preparation of data (Part II)-en_US.srt 2KB
  356. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/20. Prepare the dashboard (Part XIII)-en_US.srt 2KB
  357. ~Get Your Files Here !/10. KPI Dashboard/4. Prepare the dashboard (Part I)-en_US.srt 2KB
  358. ~Get Your Files Here !/1. Introduction/2. About the Author-en_US.srt 2KB
  359. ~Get Your Files Here !/5. Complex KPI Excel Dashboard/6. Prepare the calculation worksheet (Part IV)-en_US.srt 2KB
  360. ~Get Your Files Here !/4. Dashboard with Interactive Sales Chart/2. Preparation of data-en_US.srt 2KB
  361. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/4. Preparation of the Gantt chart (Part III)-en_US.srt 2KB
  362. ~Get Your Files Here !/3. Interactive Dashboard in Excel using Hyperlinks/4. Preparation of the dashboard (Part II)-en_US.srt 2KB
  363. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/14. Generate the charts for the Dashboard (Part I)-en_US.srt 1KB
  364. ~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 1KB
  365. ~Get Your Files Here !/10. KPI Dashboard/7. Prepare the dashboard (Part IV)-en_US.srt 1KB
  366. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/12. Prepare the calculation worksheet (Part VI)-en_US.srt 1KB
  367. ~Get Your Files Here !/9. Project Management Dashboard Project Status Report/23. Report risk assessment figures to the dashboard (Part II)-en_US.srt 1KB
  368. ~Get Your Files Here !/2. User Acceptance Tests Dashboard/13. Prepare the calculation worksheet (Part VII)-en_US.srt 970B
  369. ~Get Your Files Here !/10. KPI Dashboard/6. Prepare the dashboard (Part III)-en_US.srt 935B
  370. ~Get Your Files Here !/10. KPI Dashboard/1. Overview of the case study-en_US.srt 929B
  371. ~Get Your Files Here !/11. Financial Dashboard/1. Overview of the case study-en_US.srt 777B
  372. ~Get Your Files Here !/Bonus Resources.txt 357B
  373. Get Bonus Downloads Here.url 176B