589689.xyz

U*d*e*m*y Excel with Interactive Excel Dashboards

  • 收录时间:2018-05-23 14:28:57
  • 文件大小:2GB
  • 下载次数:71
  • 最近下载:2020-11-04 04:00:47
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 11 Homework/107 Myndas Homework Dashboard Part 2.mp4 107MB
  2. 05 Interactive Controls/037 Dynamic Date Filters 4 Ways.mp4 97MB
  3. 05 Interactive Controls/044 Scroll and Sort Table.mp4 77MB
  4. 05 Interactive Controls/031 List Boxes.mp4 68MB
  5. 10 Bonus Tour de France Dashboard/101 Dashboard Overview.mp4 66MB
  6. 09 Distributing Your Dashboard/097 Password Protection.mp4 60MB
  7. 05 Interactive Controls/041 Animating Charts.mp4 58MB
  8. 10 Bonus Tour de France Dashboard/105 Zoom Images VBA Code.mp4 57MB
  9. 06 Analysing the Data/049 GETPIVOTDATA Function.mp4 55MB
  10. 04 Display Principles/007 Sparklines.mp4 49MB
  11. 11 Homework/106 Myndas Homework Dashboard Part 1.mp4 48MB
  12. 06 Analysing the Data/050 Slicer PivotChart Olympic Dashboard Overview.mp4 47MB
  13. 04 Display Principles/016 Dynamic Data Range.mp4 46MB
  14. 05 Interactive Controls/043 Rollover Technique.mp4 44MB
  15. 04 Display Principles/014 Bullet Graphs.mp4 41MB
  16. 07 Automating Your Dashboard/077 Incorporating New Data Automatically.mp4 38MB
  17. 04 Display Principles/004 Charts and Tricks for Trending.mp4 37MB
  18. 04 Display Principles/022 Dynamic, Dynamic Data Validation Lists.mp4 36MB
  19. 05 Interactive Controls/042 INDIRECT Function Tricks.mp4 35MB
  20. 09 Distributing Your Dashboard/096 Publish with Excel Web App.mp4 34MB
  21. 08 Putting It All Together/090 Scatter Chart.mp4 33MB
  22. 08 Putting It All Together/087 Array Formula Alternative to SUMIFS.mp4 33MB
  23. 07 Automating Your Dashboard/076 Linking to Access.mp4 32MB
  24. 08 Putting It All Together/086 Pyramid Chart.mp4 32MB
  25. 04 Display Principles/024 Panel Charts.mp4 32MB
  26. 04 Display Principles/018 Text Formulas.mp4 32MB
  27. 06 Analysing the Data/075 Supplementary Excel Lecture SUMPRODUCT Formula.mp4 30MB
  28. 04 Display Principles/025 Step Charts.mp4 29MB
  29. 04 Display Principles/023 In Cell Charts.mp4 29MB
  30. 08 Putting It All Together/092 Formatting Quickly.mp4 27MB
  31. 05 Interactive Controls/039 Dynamic Named Range with INDEX.mp4 27MB
  32. 10 Bonus Tour de France Dashboard/102 SUMIFS Formula.mp4 27MB
  33. 05 Interactive Controls/040 Dynamic Ranges for Charts.mp4 26MB
  34. 04 Display Principles/026 Supplementary Excel Lecture Excel 2013 Chart Formatting.mp4 25MB
  35. 04 Display Principles/010 Top and Bottom Ranking.mp4 24MB
  36. 06 Analysing the Data/047 Slicers.mp4 24MB
  37. 10 Bonus Tour de France Dashboard/103 INDEX, MATCH and OFFSET Formula.mp4 24MB
  38. 05 Interactive Controls/032 Option Buttons.mp4 24MB
  39. 05 Interactive Controls/036 Combo Box with Macro.mp4 23MB
  40. 04 Display Principles/027 Supplementary Excel Lecture Excel 2013 Chart Labels.mp4 23MB
  41. 08 Putting It All Together/088 LARGE and SMALL Array and DAVERAGE.mp4 23MB
  42. 04 Display Principles/015 WinLossDraw Conditional Format.mp4 22MB
  43. 08 Putting It All Together/091 DMAX, DMIN, DAVERAGE.mp4 22MB
  44. 06 Analysing the Data/074 Supplementary Excel Lecture COUNTIF and COUNTIFS Formulas.mp4 22MB
  45. 06 Analysing the Data/061 Supplementary Excel Lecture VLOOKUP Formula Exact Match.mp4 22MB
  46. 09 Distributing Your Dashboard/095 Preparing Your File for Excel Web App.mp4 21MB
  47. 06 Analysing the Data/046 PivotCharts.mp4 21MB
  48. 05 Interactive Controls/038 Dynamic Named Range with OFFSET.mp4 20MB
  49. 04 Display Principles/019 Symbols in Formulas and Charts.mp4 20MB
  50. 01 Introduction/001 Course Overview and Introduction to Excel Dashboards.mp4 20MB
  51. 04 Display Principles/011 Frequency Distribution.mp4 17MB
  52. 06 Analysing the Data/066 Supplementary Excel Lecture IF Function.mp4 17MB
  53. 06 Analysing the Data/048 Capture Slicer Selection in Formula.mp4 16MB
  54. 07 Automating Your Dashboard/080 Supplementary Excel Lecture Recording a Macro.mp4 15MB
  55. 06 Analysing the Data/067 Supplementary Excel Lecture Nested IF Formula.mp4 15MB
  56. 08 Putting It All Together/089 Rank Values with PivotTable.mp4 15MB
  57. 04 Display Principles/021 Embedding Graphics in Charts.mp4 14MB
  58. 06 Analysing the Data/065 Supplementary Excel Lecture INDEX and MATCH Formula.mp4 14MB
  59. 10 Bonus Tour de France Dashboard/104 INDEX, MATCH Multiple Array Formula.mp4 13MB
  60. 04 Display Principles/009 Highlighting Comparisons.mp4 13MB
  61. 07 Automating Your Dashboard/078 Auto Refresh PivotTables.mp4 13MB
  62. 02 Getting Your Data Ready/002 Ideal Data Formats.mp4 13MB
  63. 06 Analysing the Data/064 Supplementary Excel Lecture CHOOSE Function.mp4 13MB
  64. 04 Display Principles/006 Smoothing Data.mp4 12MB
  65. 08 Putting It All Together/085 Example Dashboard Tour.mp4 12MB
  66. 04 Display Principles/012 Target vs Variance Charts.mp4 12MB
  67. 07 Automating Your Dashboard/081 Supplementary Excel Lecture Assign a Macro to a Button or Shape.mp4 12MB
  68. 07 Automating Your Dashboard/083 Supplementary Excel Lecture How to Inspect and Modify a Macro.mp4 12MB
  69. 06 Analysing the Data/073 Supplementary Excel Lecture AVERAGEIF and AVERAGEIFS Formulas.mp4 11MB
  70. 09 Distributing Your Dashboard/094 Excel Web App - Introduction.mp4 11MB
  71. 04 Display Principles/013 Performance Against Target Range.mp4 11MB
  72. 05 Interactive Controls/030 Check Boxes.mp4 10MB
  73. 04 Display Principles/008 Formatting Tricks.mp4 10MB
  74. 05 Interactive Controls/034 Scroll Bar.mp4 10MB
  75. 06 Analysing the Data/072 Supplementary Excel Lecture SUMIF and SUMIFS Formulas.mp4 10MB
  76. 07 Automating Your Dashboard/079 Supplementary Excel Lecture Introduction to Macros.mp4 10MB
  77. 06 Analysing the Data/060 Supplementary Excel Lecture VLOOKUP Formula Sorted List.mp4 9MB
  78. 05 Interactive Controls/029 Form Controls Introduction.mp4 8MB
  79. 07 Automating Your Dashboard/082 Supplementary Excel Lecture Run a Macro Upon Opening a Workbook.mp4 8MB
  80. 06 Analysing the Data/058 Supplementary Excel Lecture Perform a Function in a Table.mp4 8MB
  81. 06 Analysing the Data/053 Supplementary Excel Lecture PivotTable Layout.mp4 8MB
  82. 05 Interactive Controls/035 Buttons.mp4 8MB
  83. 06 Analysing the Data/052 Supplementary Excel Lecture Choosing Fields.mp4 8MB
  84. 04 Display Principles/028 Supplementary Excel Lecture Excel 2013 Combo Charts.mp4 8MB
  85. 05 Interactive Controls/045 Supplementary Excel Lecture Inserting Drop Down Lists.mp4 7MB
  86. 09 Distributing Your Dashboard/100 Supplementary Excel Lecture Unlocking Cells.mp4 7MB
  87. 05 Interactive Controls/033 Group Boxes.mp4 7MB
  88. 06 Analysing the Data/068 Supplementary Excel Lecture IF AND Formula.mp4 7MB
  89. 04 Display Principles/017 Dynamic Labels.mp4 6MB
  90. 09 Distributing Your Dashboard/098 Supplementary Excel Lecture Workbook Passwords.mp4 6MB
  91. 06 Analysing the Data/062 Supplementary Excel Lecture HLOOKUP Formula Sorted List.mp4 6MB
  92. 06 Analysing the Data/056 Supplementary Excel Lecture Insert a Table and Style Options.mp4 6MB
  93. 06 Analysing the Data/069 Supplementary Excel Lecture IF OR Formula.mp4 6MB
  94. 06 Analysing the Data/051 Supplementary Excel Lecture Creating PivotTables.mp4 6MB
  95. 06 Analysing the Data/059 Supplementary Excel Lecture Summarize a Table with a PivotTable.mp4 6MB
  96. 04 Display Principles/020 Charts Referencing Non-contiguous Ranges.mp4 6MB
  97. 06 Analysing the Data/071 Supplementary Excel Lecture IFERROR Function.mp4 5MB
  98. 03 Design Principles/003 Getting Your Design Right.mp4 5MB
  99. 06 Analysing the Data/057 Supplementary Excel Lecture Add Rows and Columns to a Table.mp4 5MB
  100. 04 Display Principles/005 Secondary Axis.mp4 5MB
  101. 06 Analysing the Data/070 Supplementary Excel Lecture IF NOT Formula.mp4 5MB
  102. 09 Distributing Your Dashboard/099 Supplementary Excel Lecture Protecting Workbooks.mp4 5MB
  103. 09 Distributing Your Dashboard/093 Checking and Publishing.mp4 4MB
  104. 08 Putting It All Together/084 Quick Re-cap.mp4 4MB
  105. 06 Analysing the Data/054 Supplementary Excel Lecture Filtering PivotTables.mp4 3MB
  106. 06 Analysing the Data/055 Supplementary Excel Lecture Modifying PivotTable Data.mp4 3MB
  107. 06 Analysing the Data/063 Supplementary Excel Lecture HLOOKUP Formula Exact Match.mp4 3MB