589689.xyz

[ ] Excel - Tracking Data Easily and Efficiently (2023)

  • 收录时间:2023-12-01 22:21:58
  • 文件大小:660MB
  • 下载次数:1
  • 最近下载:2023-12-01 22:21:58
  • 磁力链接:
立即下载 复制链接

文件列表

  1. ~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/01 - Power Query overview.mp4 36MB
  2. ~Get Your Files Here !/12 - 11. Get Hands On/04 - Solution Building a tracker 2.mp4 35MB
  3. ~Get Your Files Here !/09 - 8. PivotTable Basics/01 - What is a PivotTable.mp4 28MB
  4. ~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/04 - Unpivot and fill-down.mp4 26MB
  5. ~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/03 - Append in Power Query.mp4 26MB
  6. ~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/02 - Dynamic Arrays FILTER, UNIQUE, SORT.mp4 26MB
  7. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/01 - Using dropdown lists for accuracy and consistency.mp4 24MB
  8. ~Get Your Files Here !/09 - 8. PivotTable Basics/02 - Preparing and connecting a PivotTable to your data.mp4 23MB
  9. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/02 - Incorporating charts into your tracker.mp4 22MB
  10. ~Get Your Files Here !/09 - 8. PivotTable Basics/03 - Building and using a PivotTable.mp4 21MB
  11. ~Get Your Files Here !/11 - 10. Pretty It Up!/04 - Conditional formatting to warn of deadlines.mp4 20MB
  12. ~Get Your Files Here !/02 - 1. Planning Your Data Tracker/02 - Key features of an effective data tracker.mp4 20MB
  13. ~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.mp4 19MB
  14. ~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/02 - Splitting columns.mp4 18MB
  15. ~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/01 - Protecting cells and sheets.mp4 18MB
  16. ~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/01 - Dynamic Arrays One formula, many results.mp4 18MB
  17. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/01 - Thinking about input, storage, and output.mp4 17MB
  18. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/03 - Using cross-footing as a check for data quality.mp4 16MB
  19. ~Get Your Files Here !/06 - 5. Midterm Building a Tracker/02 - Solution Building a data tracker for event details.mp4 16MB
  20. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/05 - Summary pages and dashboards.mp4 16MB
  21. ~Get Your Files Here !/11 - 10. Pretty It Up!/02 - Connecting a value to a shape.mp4 15MB
  22. ~Get Your Files Here !/12 - 11. Get Hands On/02 - Solution Building a tracker 1.mp4 14MB
  23. ~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/03 - Merging data with XLOOKUP.mp4 14MB
  24. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/04 - Data validation for reasonable values.mp4 14MB
  25. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/06 - Ad hoc vs. at-a-glance needs.mp4 14MB
  26. ~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/01 - VLOOKUP.mp4 13MB
  27. ~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/03 - Hidden columns and rows.mp4 13MB
  28. ~Get Your Files Here !/02 - 1. Planning Your Data Tracker/01 - Introducing tables.mp4 12MB
  29. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/04 - Using Slicers to filter for details.mp4 11MB
  30. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/02 - Applying formula triggers to prevent inaccurate results.mp4 10MB
  31. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/03 - Adding helper columns.mp4 10MB
  32. ~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/02 - Categorizing bonuses with VLOOKUP.mp4 10MB
  33. ~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/04 - Categorizing bonuses with XLOOKUP.mp4 9MB
  34. ~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/02 - Hidden sheets.mp4 8MB
  35. ~Get Your Files Here !/12 - 11. Get Hands On/03 - Challenge Building a tracker 2.mp4 7MB
  36. ~Get Your Files Here !/11 - 10. Pretty It Up!/03 - Hiding zeroes.mp4 7MB
  37. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/05 - Times Checking data quality.mp4 6MB
  38. ~Get Your Files Here !/11 - 10. Pretty It Up!/01 - Data bars for easy visual comparison.mp4 5MB
  39. ~Get Your Files Here !/06 - 5. Midterm Building a Tracker/01 - Challenge Building a data tracker for event details.mp4 5MB
  40. ~Get Your Files Here !/13 - Conclusion/01 - Continue your data tracking journey in Excel.mp4 5MB
  41. ~Get Your Files Here !/01 - Introduction/01 - Efficient data tracking in Excel.mp4 4MB
  42. ~Get Your Files Here !/12 - 11. Get Hands On/01 - Challenge Building a tracker 1.mp4 4MB
  43. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Input Storage Output.xlsx 633KB
  44. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/Splitting Columns.xlsx 630KB
  45. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Using Helper Columns.xlsx 546KB
  46. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/Categorizing bonuses with VLOOKUP.xlsx 419KB
  47. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Data validation for reasonable values.xlsx 399KB
  48. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/XLOOKUP.xlsx 264KB
  49. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/VLOOKUP.xlsx 264KB
  50. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Slicers.xlsx 158KB
  51. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/Tracker - Skydiving FINAL.xlsx 155KB
  52. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/Tracker - Skydiving.xlsx 153KB
  53. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 06/Dynamic Arrays TOCOL.xlsx 129KB
  54. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/Unpivot - Fill Down.xlsx 113KB
  55. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 06/Dynamic Arrays - FILTER SORT.xlsx 93KB
  56. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 06/Dynamic Arrays - 1 formula many results.xlsx 86KB
  57. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/Build a Tracker - Dropdown List FINAL.xlsx 71KB
  58. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/Build a Tracker - Dropdown List.xlsx 67KB
  59. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Summaries.xlsx 33KB
  60. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 03/Hiding Worksheets.xlsx 29KB
  61. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 01/Features of an effective data tracker.xlsx 28KB
  62. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Integrating charts.xlsx 28KB
  63. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Ad hoc vs at-a-glance needs.xlsx 28KB
  64. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 03/Protecting cells, sheets and formulas.xlsx 27KB
  65. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 03/Hiding rows and columns.xlsx 21KB
  66. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Crossfooting.xlsx 20KB
  67. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/Append.xlsx 18KB
  68. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/Hiding Zeros.xlsx 15KB
  69. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/Power Query Overview.xlsx 15KB
  70. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 05/Building an event tracker - FINAL.xlsx 15KB
  71. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 08/Prepping data for a Pivot Table.xlsx 14KB
  72. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 08/Building and Using a Pivot Table.xlsx 14KB
  73. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 08/What is a Pivot Table.xlsx 14KB
  74. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/Connecting a Value to a Shape.xlsx 14KB
  75. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 05/Building an event tracker.xlsx 14KB
  76. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Formula Triggers.xlsx 13KB
  77. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Dropdown Lists.xlsx 13KB
  78. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/CF to warn of deadlines.xlsx 13KB
  79. ~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/01 - Power Query overview.srt 12KB
  80. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/Categorizing data with XLOOKUP.xlsx 12KB
  81. ~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/03 - Append in Power Query.srt 11KB
  82. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Checking Times.xlsx 11KB
  83. ~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/04 - Unpivot and fill-down.srt 11KB
  84. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/01 - Using dropdown lists for accuracy and consistency.srt 11KB
  85. ~Get Your Files Here !/09 - 8. PivotTable Basics/01 - What is a PivotTable.srt 11KB
  86. ~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/02 - Dynamic Arrays FILTER, UNIQUE, SORT.srt 11KB
  87. ~Get Your Files Here !/12 - 11. Get Hands On/04 - Solution Building a tracker 2.srt 10KB
  88. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 01/Introducing tables.xlsx 10KB
  89. ~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/Data Bars.xlsx 10KB
  90. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/02 - Incorporating charts into your tracker.srt 9KB
  91. ~Get Your Files Here !/11 - 10. Pretty It Up!/04 - Conditional formatting to warn of deadlines.srt 8KB
  92. ~Get Your Files Here !/09 - 8. PivotTable Basics/02 - Preparing and connecting a PivotTable to your data.srt 8KB
  93. ~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/02 - Splitting columns.srt 8KB
  94. ~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/01 - Protecting cells and sheets.srt 8KB
  95. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/01 - Thinking about input, storage, and output.srt 8KB
  96. ~Get Your Files Here !/09 - 8. PivotTable Basics/03 - Building and using a PivotTable.srt 8KB
  97. ~Get Your Files Here !/02 - 1. Planning Your Data Tracker/02 - Key features of an effective data tracker.srt 7KB
  98. ~Get Your Files Here !/06 - 5. Midterm Building a Tracker/02 - Solution Building a data tracker for event details.srt 7KB
  99. ~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.srt 7KB
  100. ~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/01 - Dynamic Arrays One formula, many results.srt 7KB
  101. ~Get Your Files Here !/02 - 1. Planning Your Data Tracker/01 - Introducing tables.srt 7KB
  102. ~Get Your Files Here !/11 - 10. Pretty It Up!/02 - Connecting a value to a shape.srt 6KB
  103. ~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/03 - Hidden columns and rows.srt 6KB
  104. ~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/03 - Merging data with XLOOKUP.srt 6KB
  105. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/04 - Data validation for reasonable values.srt 6KB
  106. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/05 - Summary pages and dashboards.srt 5KB
  107. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/06 - Ad hoc vs. at-a-glance needs.srt 5KB
  108. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/02 - Applying formula triggers to prevent inaccurate results.srt 5KB
  109. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/03 - Using cross-footing as a check for data quality.srt 5KB
  110. ~Get Your Files Here !/12 - 11. Get Hands On/02 - Solution Building a tracker 1.srt 5KB
  111. ~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/01 - VLOOKUP.srt 5KB
  112. ~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/04 - Categorizing bonuses with XLOOKUP.srt 5KB
  113. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/04 - Using Slicers to filter for details.srt 4KB
  114. ~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/02 - Hidden sheets.srt 4KB
  115. ~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/03 - Adding helper columns.srt 4KB
  116. ~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/02 - Categorizing bonuses with VLOOKUP.srt 3KB
  117. ~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/05 - Times Checking data quality.srt 3KB
  118. ~Get Your Files Here !/12 - 11. Get Hands On/03 - Challenge Building a tracker 2.srt 3KB
  119. ~Get Your Files Here !/11 - 10. Pretty It Up!/03 - Hiding zeroes.srt 3KB
  120. ~Get Your Files Here !/11 - 10. Pretty It Up!/01 - Data bars for easy visual comparison.srt 3KB
  121. ~Get Your Files Here !/06 - 5. Midterm Building a Tracker/01 - Challenge Building a data tracker for event details.srt 2KB
  122. ~Get Your Files Here !/12 - 11. Get Hands On/01 - Challenge Building a tracker 1.srt 1KB
  123. ~Get Your Files Here !/13 - Conclusion/01 - Continue your data tracking journey in Excel.srt 1KB
  124. ~Get Your Files Here !/01 - Introduction/01 - Efficient data tracking in Excel.srt 1KB
  125. ~Get Your Files Here !/Bonus Resources.txt 386B
  126. Get Bonus Downloads Here.url 181B