589689.xyz

[] Udemy - Visually Effective Excel Dashboards

  • 收录时间:2019-11-24 13:36:23
  • 文件大小:2GB
  • 下载次数:43
  • 最近下载:2020-12-23 14:49:55
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 7. Advanced Chart Techniques/8. Dynamic Map Chart with Drop-down.mp4 194MB
  2. 7. Advanced Chart Techniques/6. Pro Technique Changing Chart Ranges.mp4 177MB
  3. 5. Dashboard Formula Toolbox/5. Realistic Case Index for Dependent Drop-down Lists.mp4 128MB
  4. 7. Advanced Chart Techniques/7. Info-graphics in Excel Non-standard but Impressive Bar Chart.mp4 114MB
  5. 6. Form Controls for Interactive Dashboards/8. Bonus Dependent Combo Boxes (2nd list automatically resets).mp4 107MB
  6. 11. KPI Dashboard - TopBottom KPI Based on Selection/1. Show Top 6 Matches with Unique Identifier.mp4 51MB
  7. 9. KPI Dashboard - Scrolling Table & Bars/2. Complex Lookup with Index & Match.mp4 46MB
  8. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/1. Complex Lookup to Prepare data for Scrolling Chart.mp4 38MB
  9. 9. KPI Dashboard - Scrolling Table & Bars/4. Conditionally-Formatted Data Bars.mp4 37MB
  10. 9. KPI Dashboard - Scrolling Table & Bars/1. Setup a Combo Box to Ease Selection.mp4 36MB
  11. 11. KPI Dashboard - TopBottom KPI Based on Selection/2. List Box to Select KPI for Top 6 Matches.mp4 36MB
  12. 9. KPI Dashboard - Scrolling Table & Bars/3. Scrolling Data Table.mp4 35MB
  13. 8. KPI Dashboard - Setup/4. Setup of Raw Data Sheet.mp4 34MB
  14. 5. Dashboard Formula Toolbox/2. Index Match for Complex Lookups - Basics.mp4 32MB
  15. 11. KPI Dashboard - TopBottom KPI Based on Selection/5. Finalize Top Bottom Report on Dashboard.mp4 32MB
  16. 11. KPI Dashboard - TopBottom KPI Based on Selection/4. Actual to Budget Comparison - Sorted Bars with Error Bar Technique.mp4 31MB
  17. 5. Dashboard Formula Toolbox/3. Index Match for Complex Lookups - Advanced.mp4 30MB
  18. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/5. Line Series Tweaks for Better Readability.mp4 29MB
  19. 5. Dashboard Formula Toolbox/11. Text Function for Formatting.mp4 28MB
  20. 13. KPI Dashboard - Final Touches/2. Dashboard Protection, Hyperlinks and Final Touches.mp4 28MB
  21. 9. KPI Dashboard - Scrolling Table & Bars/5. Arrows for Deviations.mp4 27MB
  22. 2. Dashboards - Before You Start/3. Useful Excel Keyboard Shortcuts.mp4 26MB
  23. 7. Advanced Chart Techniques/4. Improve Charts 2 Add Series Labels Inside Chart.mp4 26MB
  24. 3. Report Design Principles/5. Bonus Setting a Default Theme for New Workbooks.mp4 25MB
  25. 5. Dashboard Formula Toolbox/6. SUMIFS, COUNTIFS, AVERAGEIFS to Handle Multiple Criteria.mp4 25MB
  26. 1. A Foundation in Dashboards/1. Introduction.mp4 25MB
  27. 8. KPI Dashboard - Setup/3. Spreadsheet Setup.mp4 25MB
  28. 5. Dashboard Formula Toolbox/4. Index for Dynamic List Selection.mp4 24MB
  29. 7. Advanced Chart Techniques/5. Improve Charts 3 Error Bars for Additional Control.mp4 24MB
  30. 5. Dashboard Formula Toolbox/13. GetPivotData Extract data Efficiently from Pivot Tables.mp4 24MB
  31. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/1. More Interactivity - Pivot Slicers as Buttons (also without Pivot Tables).mp4 23MB
  32. 11. KPI Dashboard - TopBottom KPI Based on Selection/3. Option Button to Toggle Between Top OR Bottom 6.mp4 23MB
  33. 2. Dashboards - Before You Start/4. 4 Time-Saving Tips for Excel.mp4 23MB
  34. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/5. Dynamic Comments with Slicer Selection.mp4 23MB
  35. 10. KPI Dashboard - Dynamic Headers/2. Adding Shapes & Text boxes.mp4 22MB
  36. 5. Dashboard Formula Toolbox/14. INDIRECT for Flexible References.mp4 21MB
  37. 8. KPI Dashboard - Setup/1. KPI Dashboard Overview.mp4 19MB
  38. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/2. Scroll-able Line Chart.mp4 19MB
  39. 16. Regional Dashboard - Impressive Charts Using Shapes/2. Info Charts Overcoming Pivot Chart Limitations.mp4 18MB
  40. 4. Dashboard Source Data & Formats/2. Source Excel Spreadsheet.mp4 18MB
  41. 9. KPI Dashboard - Scrolling Table & Bars/6. Formatting of Scrolling Data Table.mp4 18MB
  42. 17. Regional Dashboard - Secrets for Impressive Reports/3. Dashboard Complete - Final Touches.mp4 18MB
  43. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/3. Trick to Avoid Crashing Lines in Line Chart.mp4 18MB
  44. 1. A Foundation in Dashboards/5. New project This is Your Checklist.mp4 18MB
  45. 17. Regional Dashboard - Secrets for Impressive Reports/1. Camera for Improved Design.mp4 18MB
  46. 8. KPI Dashboard - Setup/5. Setup of Calculation sheet.mp4 17MB
  47. 15. Regional Dashboard - Advanced Pivot Table Techniques/1. Variances in Pivot Table.mp4 17MB
  48. 5. Dashboard Formula Toolbox/10. CHOOSE for Flexibility.mp4 17MB
  49. 6. Form Controls for Interactive Dashboards/7. Scroll Bar - Scroll Through Graphs & Tables.mp4 17MB
  50. 7. Advanced Chart Techniques/3. Improve Charts 1 Add Total Values to Stacked Column Charts.mp4 16MB
  51. 17. Regional Dashboard - Secrets for Impressive Reports/2. Advanced Camera - Lookups on Pictures.mp4 15MB
  52. 3. Report Design Principles/4. 10 Concrete Design Tips for Better Excel Reports.mp4 14MB
  53. 13. KPI Dashboard - Final Touches/1. Restrict Dashboard Area and Format for Printing.mp4 14MB
  54. 4. Dashboard Source Data & Formats/4. Source Text Data CSV File.mp4 14MB
  55. 2. Dashboards - Before You Start/1. First Steps for your Dashboard Project.mp4 14MB
  56. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/4. Check Box to Control Series Visibility (Hide or Show).mp4 14MB
  57. 5. Dashboard Formula Toolbox/9. ROW as Unique Identifier for Lookups.mp4 14MB
  58. 6. Form Controls for Interactive Dashboards/3. Check Box - Check Uncheck Option.mp4 14MB
  59. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/2. Column Chart Controlled by Slicer Buttons.mp4 14MB
  60. 15. Regional Dashboard - Advanced Pivot Table Techniques/5. Automatically Refresh Pivot Table with Simple VBA code.mp4 13MB
  61. 6. Form Controls for Interactive Dashboards/2. Combo Box - Select From a Drop Down List.mp4 13MB
  62. 3. Report Design Principles/1. Layout - Best Practice.mp4 12MB
  63. 5. Dashboard Formula Toolbox/8. ROW(S), COLUMN(S) for Indexing.mp4 12MB
  64. 2. Dashboards - Before You Start/5. Proper Spreadsheet Architecture & Workflow.mp4 12MB
  65. 1. A Foundation in Dashboards/2. Get the Most from the Course.mp4 12MB
  66. 5. Dashboard Formula Toolbox/15. Choose & Name Manager for Flexible Ranges (Alternative to Indirect).mp4 11MB
  67. 10. KPI Dashboard - Dynamic Headers/1. Conditional Comments in Header.mp4 11MB
  68. 6. Form Controls for Interactive Dashboards/5. Option Button - Choose One Option Only.mp4 11MB
  69. 3. Report Design Principles/2. Color - Best Practice.mp4 11MB
  70. 1. A Foundation in Dashboards/4. A Dashboard Primer.mp4 10MB
  71. 5. Dashboard Formula Toolbox/1. Excel Formulas You'll Need.mp4 10MB
  72. 15. Regional Dashboard - Advanced Pivot Table Techniques/2. Conditional Formatting in Pivot Table.mp4 10MB
  73. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/6. Finalize Profit Comparison Section on Dashboard.mp4 10MB
  74. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/3. Slicer Custom Sorting & Design.mp4 10MB
  75. 16. Regional Dashboard - Impressive Charts Using Shapes/1. Info Charts Adding Shapes to (Pivot) Charts.mp4 10MB
  76. 4. Dashboard Source Data & Formats/3. Source Microsoft Access.mp4 9MB
  77. 15. Regional Dashboard - Advanced Pivot Table Techniques/4. Pivot Charts in Dashboards.mp4 9MB
  78. 6. Form Controls for Interactive Dashboards/6. List Box - Select From a List of Option.mp4 9MB
  79. 3. Report Design Principles/3. A Color Scheme that fits with your Report.mp4 8MB
  80. 6. Form Controls for Interactive Dashboards/1. Introduction to Form Controls - Active X vs. Form Controls.mp4 7MB
  81. 7. Advanced Chart Techniques/1. Chart Overview & When to Use Which Graph.mp4 7MB
  82. 8. KPI Dashboard - Setup/2. Dashboard Wireframe.mp4 7MB
  83. 4. Dashboard Source Data & Formats/5. Source Excel Add-ins.mp4 6MB
  84. 5. Dashboard Formula Toolbox/12. N Function for Tracking.mp4 6MB
  85. 15. Regional Dashboard - Advanced Pivot Table Techniques/3. Pivot Table as Part of Dashboard Report.mp4 6MB
  86. 6. Form Controls for Interactive Dashboards/4. Spin Button - Move Up & Down Lists.mp4 6MB
  87. 4. Dashboard Source Data & Formats/1. Where is Your Source Data.mp4 6MB
  88. 5. Dashboard Formula Toolbox/7. LARGE and SMALL for Sorting.mp4 5MB
  89. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/4. Check to Ensure Single Slicer Button is Selected.mp4 4MB
  90. 18. What you Learnt/1. Final Words.mp4 4MB
  91. 3. Report Design Principles/1.1 Dashboard Design Layout.pdf.pdf 822KB
  92. 3. Report Design Principles/2.1 Dashboard Design Color.pdf.pdf 699KB
  93. 7. Advanced Chart Techniques/1.1 ChartPlaybook.pdf.pdf 503KB
  94. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/6.1 Slicer_Regional_Dashboard_Draft02.xlsx.xlsx 451KB
  95. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/1.1 Slicer_Regional_Dashboard_Draft01.xlsx.xlsx 439KB
  96. 1. A Foundation in Dashboards/3.2 Demo-WorkBook-Dashboard.xlsx.xlsx 380KB
  97. 16. Regional Dashboard - Impressive Charts Using Shapes/3.1 Slicer_Regional_Dashboard_Draft04.xlsm.xlsm 332KB
  98. 15. Regional Dashboard - Advanced Pivot Table Techniques/6.1 Slicer_Regional_Dashboard_Draft03.xlsm.xlsm 330KB
  99. 1. A Foundation in Dashboards/3.3 Slicer_Regional_Dashboard.xlsm.xlsm 139KB
  100. 17. Regional Dashboard - Secrets for Impressive Reports/4.1 Slicer_Regional_Dashboard.xlsm.xlsm 139KB
  101. 2. Dashboards - Before You Start/1.1 Dashboard First Steps.pdf.pdf 128KB
  102. 1. A Foundation in Dashboards/3.5 KPI-Dashboard.xlsx.xlsx 104KB
  103. 13. KPI Dashboard - Final Touches/3.1 KPI_Dashboard.xlsx.xlsx 103KB
  104. 1. A Foundation in Dashboards/3.4 Practice_Demo_WorkBook_Dashboard_Empty.xlsx.xlsx 101KB
  105. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/7.1 KPI_Dashboard_Draft05.xlsx.xlsx 99KB
  106. 11. KPI Dashboard - TopBottom KPI Based on Selection/6.1 KPI_Dashboard_Draft04.xlsx.xlsx 91KB
  107. 10. KPI Dashboard - Dynamic Headers/3.1 KPI_Dashboard_Draft03.xlsx.xlsx 74KB
  108. 9. KPI Dashboard - Scrolling Table & Bars/7.1 KPI_Dashboard_Draft02.xlsx.xlsx 72KB
  109. 8. KPI Dashboard - Setup/6.1 KPI_Dashboard_Draft01.xlsx.xlsx 54KB
  110. 3. Report Design Principles/3.1 Dashboard-Color-Palettes.xlsx.xlsx 46KB
  111. 1. A Foundation in Dashboards/5.1 Dashboard Starting Checklist.pdf.pdf 40KB
  112. 1. A Foundation in Dashboards/3.1 KPISampleData_Access.zip.zip 34KB
  113. 1. A Foundation in Dashboards/3.6 Source_Data_Examples_Workbook.xlsx.xlsx 22KB
  114. 2. Dashboards - Before You Start/2.1 Excel-Dashboard-Report-Vector-Elements.xlsx.xlsx 22KB
  115. 7. Advanced Chart Techniques/8. Dynamic Map Chart with Drop-down.vtt 18KB
  116. 7. Advanced Chart Techniques/7. Info-graphics in Excel Non-standard but Impressive Bar Chart.vtt 18KB
  117. 11. KPI Dashboard - TopBottom KPI Based on Selection/1. Show Top 6 Matches with Unique Identifier.vtt 16KB
  118. 5. Dashboard Formula Toolbox/11. Text Function for Formatting.vtt 15KB
  119. 6. Form Controls for Interactive Dashboards/8. Bonus Dependent Combo Boxes (2nd list automatically resets).vtt 15KB
  120. 9. KPI Dashboard - Scrolling Table & Bars/2. Complex Lookup with Index & Match.vtt 14KB
  121. 2. Dashboards - Before You Start/3. Useful Excel Keyboard Shortcuts.vtt 13KB
  122. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/5. Dynamic Comments with Slicer Selection.vtt 12KB
  123. 9. KPI Dashboard - Scrolling Table & Bars/3. Scrolling Data Table.vtt 12KB
  124. 7. Advanced Chart Techniques/5. Improve Charts 3 Error Bars for Additional Control.vtt 12KB
  125. 5. Dashboard Formula Toolbox/2. Index Match for Complex Lookups - Basics.vtt 12KB
  126. 9. KPI Dashboard - Scrolling Table & Bars/1. Setup a Combo Box to Ease Selection.vtt 12KB
  127. 9. KPI Dashboard - Scrolling Table & Bars/4. Conditionally-Formatted Data Bars.vtt 12KB
  128. 7. Advanced Chart Techniques/6. Pro Technique Changing Chart Ranges.vtt 12KB
  129. 5. Dashboard Formula Toolbox/13. GetPivotData Extract data Efficiently from Pivot Tables.vtt 12KB
  130. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/1. More Interactivity - Pivot Slicers as Buttons (also without Pivot Tables).vtt 11KB
  131. 5. Dashboard Formula Toolbox/14. INDIRECT for Flexible References.vtt 11KB
  132. 5. Dashboard Formula Toolbox/6. SUMIFS, COUNTIFS, AVERAGEIFS to Handle Multiple Criteria.vtt 11KB
  133. 5. Dashboard Formula Toolbox/3. Index Match for Complex Lookups - Advanced.vtt 11KB
  134. 11. KPI Dashboard - TopBottom KPI Based on Selection/4. Actual to Budget Comparison - Sorted Bars with Error Bar Technique.vtt 11KB
  135. 8. KPI Dashboard - Setup/3. Spreadsheet Setup.vtt 10KB
  136. 8. KPI Dashboard - Setup/4. Setup of Raw Data Sheet.vtt 10KB
  137. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/5. Line Series Tweaks for Better Readability.vtt 10KB
  138. 11. KPI Dashboard - TopBottom KPI Based on Selection/5. Finalize Top Bottom Report on Dashboard.vtt 10KB
  139. 5. Dashboard Formula Toolbox/10. CHOOSE for Flexibility.vtt 10KB
  140. 11. KPI Dashboard - TopBottom KPI Based on Selection/2. List Box to Select KPI for Top 6 Matches.vtt 10KB
  141. 9. KPI Dashboard - Scrolling Table & Bars/5. Arrows for Deviations.vtt 9KB
  142. 16. Regional Dashboard - Impressive Charts Using Shapes/2. Info Charts Overcoming Pivot Chart Limitations.vtt 9KB
  143. 2. Dashboards - Before You Start/4. 4 Time-Saving Tips for Excel.vtt 9KB
  144. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/1. Complex Lookup to Prepare data for Scrolling Chart.vtt 9KB
  145. 1. A Foundation in Dashboards/3.7 Tabular_data_set_csv.csv.csv 9KB
  146. 15. Regional Dashboard - Advanced Pivot Table Techniques/1. Variances in Pivot Table.vtt 9KB
  147. 7. Advanced Chart Techniques/4. Improve Charts 2 Add Series Labels Inside Chart.vtt 9KB
  148. 13. KPI Dashboard - Final Touches/2. Dashboard Protection, Hyperlinks and Final Touches.vtt 9KB
  149. 5. Dashboard Formula Toolbox/4. Index for Dynamic List Selection.vtt 9KB
  150. 17. Regional Dashboard - Secrets for Impressive Reports/1. Camera for Improved Design.vtt 8KB
  151. 17. Regional Dashboard - Secrets for Impressive Reports/3. Dashboard Complete - Final Touches.vtt 8KB
  152. 17. Regional Dashboard - Secrets for Impressive Reports/2. Advanced Camera - Lookups on Pictures.vtt 8KB
  153. 4. Dashboard Source Data & Formats/4. Source Text Data CSV File.vtt 8KB
  154. 5. Dashboard Formula Toolbox/5. Realistic Case Index for Dependent Drop-down Lists.vtt 7KB
  155. 10. KPI Dashboard - Dynamic Headers/2. Adding Shapes & Text boxes.vtt 7KB
  156. 8. KPI Dashboard - Setup/1. KPI Dashboard Overview.vtt 7KB
  157. 5. Dashboard Formula Toolbox/9. ROW as Unique Identifier for Lookups.vtt 7KB
  158. 4. Dashboard Source Data & Formats/2. Source Excel Spreadsheet.vtt 7KB
  159. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/2. Column Chart Controlled by Slicer Buttons.vtt 7KB
  160. 5. Dashboard Formula Toolbox/8. ROW(S), COLUMN(S) for Indexing.vtt 7KB
  161. 11. KPI Dashboard - TopBottom KPI Based on Selection/3. Option Button to Toggle Between Top OR Bottom 6.vtt 7KB
  162. 3. Report Design Principles/4. 10 Concrete Design Tips for Better Excel Reports.vtt 7KB
  163. 8. KPI Dashboard - Setup/5. Setup of Calculation sheet.vtt 7KB
  164. 1. A Foundation in Dashboards/1. Introduction.vtt 6KB
  165. 6. Form Controls for Interactive Dashboards/7. Scroll Bar - Scroll Through Graphs & Tables.vtt 6KB
  166. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/3. Trick to Avoid Crashing Lines in Line Chart.vtt 6KB
  167. 15. Regional Dashboard - Advanced Pivot Table Techniques/5. Automatically Refresh Pivot Table with Simple VBA code.vtt 6KB
  168. 9. KPI Dashboard - Scrolling Table & Bars/6. Formatting of Scrolling Data Table.vtt 6KB
  169. 3. Report Design Principles/5. Bonus Setting a Default Theme for New Workbooks.vtt 6KB
  170. 1. A Foundation in Dashboards/5. New project This is Your Checklist.vtt 6KB
  171. 5. Dashboard Formula Toolbox/15. Choose & Name Manager for Flexible Ranges (Alternative to Indirect).vtt 6KB
  172. 6. Form Controls for Interactive Dashboards/2. Combo Box - Select From a Drop Down List.vtt 5KB
  173. 16. Regional Dashboard - Impressive Charts Using Shapes/1. Info Charts Adding Shapes to (Pivot) Charts.vtt 5KB
  174. 6. Form Controls for Interactive Dashboards/3. Check Box - Check Uncheck Option.vtt 5KB
  175. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/3. Slicer Custom Sorting & Design.vtt 5KB
  176. 15. Regional Dashboard - Advanced Pivot Table Techniques/2. Conditional Formatting in Pivot Table.vtt 5KB
  177. 7. Advanced Chart Techniques/3. Improve Charts 1 Add Total Values to Stacked Column Charts.vtt 5KB
  178. 4. Dashboard Source Data & Formats/3. Source Microsoft Access.vtt 5KB
  179. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/2. Scroll-able Line Chart.vtt 5KB
  180. 6. Form Controls for Interactive Dashboards/5. Option Button - Choose One Option Only.vtt 5KB
  181. 18. What you Learnt/2. Do you want to Learn More.html 5KB
  182. 3. Report Design Principles/3. A Color Scheme that fits with your Report.vtt 5KB
  183. 13. KPI Dashboard - Final Touches/1. Restrict Dashboard Area and Format for Printing.vtt 5KB
  184. 15. Regional Dashboard - Advanced Pivot Table Techniques/4. Pivot Charts in Dashboards.vtt 4KB
  185. 2. Dashboards - Before You Start/1. First Steps for your Dashboard Project.vtt 4KB
  186. 1. A Foundation in Dashboards/3. Download Course Files Here.html 4KB
  187. 3. Report Design Principles/1. Layout - Best Practice.vtt 4KB
  188. 1. A Foundation in Dashboards/2. Get the Most from the Course.vtt 4KB
  189. 5. Dashboard Formula Toolbox/12. N Function for Tracking.vtt 4KB
  190. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/4. Check Box to Control Series Visibility (Hide or Show).vtt 4KB
  191. 3. Report Design Principles/2. Color - Best Practice.vtt 4KB
  192. 6. Form Controls for Interactive Dashboards/6. List Box - Select From a List of Option.vtt 3KB
  193. 2. Dashboards - Before You Start/5. Proper Spreadsheet Architecture & Workflow.vtt 3KB
  194. 15. Regional Dashboard - Advanced Pivot Table Techniques/3. Pivot Table as Part of Dashboard Report.vtt 3KB
  195. 10. KPI Dashboard - Dynamic Headers/1. Conditional Comments in Header.vtt 3KB
  196. 8. KPI Dashboard - Setup/2. Dashboard Wireframe.vtt 3KB
  197. 5. Dashboard Formula Toolbox/7. LARGE and SMALL for Sorting.vtt 3KB
  198. 1. A Foundation in Dashboards/4. A Dashboard Primer.vtt 3KB
  199. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/6. Finalize Profit Comparison Section on Dashboard.vtt 3KB
  200. 7. Advanced Chart Techniques/1. Chart Overview & When to Use Which Graph.vtt 3KB
  201. 4. Dashboard Source Data & Formats/5. Source Excel Add-ins.vtt 3KB
  202. 6. Form Controls for Interactive Dashboards/4. Spin Button - Move Up & Down Lists.vtt 2KB
  203. 2. Dashboards - Before You Start/2. Create a Mockup (Wireframe) in Excel.html 2KB
  204. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/4. Check to Ensure Single Slicer Button is Selected.vtt 2KB
  205. 4. Dashboard Source Data & Formats/1. Where is Your Source Data.vtt 2KB
  206. 5. Dashboard Formula Toolbox/1. Excel Formulas You'll Need.vtt 2KB
  207. 18. What you Learnt/1. Final Words.vtt 1KB
  208. 6. Form Controls for Interactive Dashboards/1. Introduction to Form Controls - Active X vs. Form Controls.vtt 1KB
  209. 11. KPI Dashboard - TopBottom KPI Based on Selection/6. Download Dashboard till here & practice along - Draft04.html 709B
  210. 15. Regional Dashboard - Advanced Pivot Table Techniques/6. Download Regional Dashboard till here - Draft03.html 683B
  211. 12. KPI Dashboard - Scrolling Line Chart with Check Boxes/7. Download Dashboard till here & practice along - Draft05.html 678B
  212. 14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/6. Download Regional Dashboard till here - Draft02.html 615B
  213. 16. Regional Dashboard - Impressive Charts Using Shapes/3. Download Regional Dashboard till here - Draft04.html 593B
  214. 10. KPI Dashboard - Dynamic Headers/3. Download Dashboard till here & practice along - Draft03.html 590B
  215. 9. KPI Dashboard - Scrolling Table & Bars/7. Download Dashboard till here & practice along - Draft02.html 542B
  216. 17. Regional Dashboard - Secrets for Impressive Reports/4. Download the final version of the SlicerRegional Dashboard.html 537B
  217. 7. Advanced Chart Techniques/2. Chart Basics (for those who need to get familiar with basic features).html 533B
  218. 13. KPI Dashboard - Final Touches/3. Download Dashboard till here - Final.html 514B
  219. 8. KPI Dashboard - Setup/6. Download Dashboard till here & practice along - Draft01.html 512B
  220. 3. Report Design Principles/6. Excel Report Design - Test Your Knowledge.html 130B
  221. [FreeCourseLab.com].url 126B
  222. 7. Advanced Chart Techniques/1.2 Sorted Bar Chart as Alternative to the Pie Chart.html 89B
  223. 7. Advanced Chart Techniques/5.1 Error bar example 1 Excel Better Variance Charts - Effective Variance Charts with Error Bars.html 89B
  224. 7. Advanced Chart Techniques/5.2 Error bar example 2 Excel Arrow Variance Chart.html 89B
  225. 1. A Foundation in Dashboards/5.2 Excel Online Compatibility.html 82B