589689.xyz

[ ] Udemy - Essential Excel for Business Analysts and Consultants

  • 收录时间:2021-12-01 14:10:41
  • 文件大小:2GB
  • 下载次数:1
  • 最近下载:2021-12-01 14:10:41
  • 磁力链接:
立即下载 复制链接

文件列表

  1. ~Get Your Files Here !/8. Examples of analyses/7. Expansion strategy into other countries – Which function to use.mp4 55MB
  2. ~Get Your Files Here !/7. Other useful functions and tools in Excel/10. Using solver – Planning the flow of finished goods – Excel - First Option.mp4 50MB
  3. ~Get Your Files Here !/2. How to merge data from different sources/14. How to assign categories using SUMIFS function – Basic Usage.mp4 47MB
  4. ~Get Your Files Here !/8. Examples of analyses/8. Expansion strategy into other countries – Solution in Excel.mp4 45MB
  5. ~Get Your Files Here !/2. How to merge data from different sources/5. Basic VLOOKUP usage.mp4 42MB
  6. ~Get Your Files Here !/7. Other useful functions and tools in Excel/13. When can I retire – No passive income – Excel Basic.mp4 40MB
  7. ~Get Your Files Here !/8. Examples of analyses/6. Expansion strategy into other countries – Data for the case study.mp4 39MB
  8. ~Get Your Files Here !/2. How to merge data from different sources/21. INDEX & MATCH function – Exercise – Case Solution.mp4 38MB
  9. ~Get Your Files Here !/4. Cleaning and unifying data/10. Saturating existing markets – Concept & Space.mp4 38MB
  10. ~Get Your Files Here !/2. How to merge data from different sources/17. Assigning customers to segments – Solution.mp4 37MB
  11. ~Get Your Files Here !/7. Other useful functions and tools in Excel/17. What will be the effect of the price increase – Solution – Impact on coffee only.mp4 35MB
  12. ~Get Your Files Here !/7. Other useful functions and tools in Excel/8. How to use SUMPRODUCT function.mp4 35MB
  13. ~Get Your Files Here !/4. Cleaning and unifying data/9. Saturating existing markets – Stores by concepts.mp4 33MB
  14. ~Get Your Files Here !/4. Cleaning and unifying data/8. Saturating existing markets – Number of Stores.mp4 32MB
  15. ~Get Your Files Here !/2. How to merge data from different sources/7. How to assign categories using VLOOKUP.mp4 29MB
  16. ~Get Your Files Here !/4. Cleaning and unifying data/7. Saturating existing markets – Data for the case study.mp4 28MB
  17. ~Get Your Files Here !/10. Essential Excel shortcuts/10. Grouping rows and columns.mp4 25MB
  18. ~Get Your Files Here !/10. Essential Excel shortcuts/6. How to format cells using shortcuts – Numbers.mp4 25MB
  19. ~Get Your Files Here !/4. Cleaning and unifying data/12. Saturating existing markets – WaterFall Graph.mp4 25MB
  20. ~Get Your Files Here !/8. Examples of analyses/10. How to create a waterfall chart.mp4 25MB
  21. ~Get Your Files Here !/2. How to merge data from different sources/6. Some comments on basic VLOOKUP.mp4 25MB
  22. ~Get Your Files Here !/7. Other useful functions and tools in Excel/11. Using solver – Planning the flow of finished goods – Excel - Second Option.mp4 24MB
  23. ~Get Your Files Here !/9. Basic VBA usage - example/3. Logistic system simulation - final solution.mp4 24MB
  24. ~Get Your Files Here !/7. Other useful functions and tools in Excel/14. When can I retire – No passive income – Go seek function.mp4 24MB
  25. ~Get Your Files Here !/8. Examples of analyses/4. Model of E-commerce.mp4 23MB
  26. ~Get Your Files Here !/8. Examples of analyses/11. How to create scatter plot with Names.mp4 23MB
  27. ~Get Your Files Here !/2. How to merge data from different sources/19. INDEX & MATCH function – Introduction.mp4 22MB
  28. ~Get Your Files Here !/8. Examples of analyses/3. Efficiency of marketing activities.mp4 22MB
  29. ~Get Your Files Here !/10. Essential Excel shortcuts/8. Selecting rows and selecting columns.mp4 22MB
  30. ~Get Your Files Here !/7. Other useful functions and tools in Excel/18. What will be the effect of the price increase – Solution – Full impact.mp4 22MB
  31. ~Get Your Files Here !/9. Basic VBA usage - example/2. Logistic system simulation - tips how to do it.mp4 22MB
  32. ~Get Your Files Here !/10. Essential Excel shortcuts/7. Copying of cells with shortcuts.mp4 22MB
  33. ~Get Your Files Here !/10. Essential Excel shortcuts/11. How to preserve your results or go back to previous ones.mp4 21MB
  34. ~Get Your Files Here !/11. More advanced shortcuts/3. Hyperlinks.mp4 20MB
  35. ~Get Your Files Here !/10. Essential Excel shortcuts/12. Going fast around the Excel with shortcuts.mp4 20MB
  36. ~Get Your Files Here !/10. Essential Excel shortcuts/5. How to format cells using shortcuts – Text – Part 2.mp4 19MB
  37. ~Get Your Files Here !/7. Other useful functions and tools in Excel/15. When can I retire – With passive income.mp4 19MB
  38. ~Get Your Files Here !/11. More advanced shortcuts/2. Shortcuts hidden in Functional Keyboards.mp4 18MB
  39. ~Get Your Files Here !/2. How to merge data from different sources/2. VLOOKUP – Introduction.mp4 17MB
  40. ~Get Your Files Here !/3. Example of analysis requiring merging data/2. Fuel usage analysis using the vlookup function - tips.mp4 16MB
  41. ~Get Your Files Here !/11. More advanced shortcuts/6. How to reach the menu with shortcut.mp4 16MB
  42. ~Get Your Files Here !/10. Essential Excel shortcuts/9. Adding and removing rows and columns.mp4 16MB
  43. ~Get Your Files Here !/7. Other useful functions and tools in Excel/12. When can I retire – Introduction.mp4 15MB
  44. ~Get Your Files Here !/2. How to merge data from different sources/15. Assigning customers to segments – Case Introduction.mp4 15MB
  45. ~Get Your Files Here !/7. Other useful functions and tools in Excel/6. Regression - example.mp4 15MB
  46. ~Get Your Files Here !/10. Essential Excel shortcuts/4. How to format cells using shortcuts – Text – Part 1.mp4 14MB
  47. ~Get Your Files Here !/8. Examples of analyses/9. Expansion strategy into other countries – Solution in Power Point.mp4 14MB
  48. ~Get Your Files Here !/2. How to merge data from different sources/16. Assigning customers to segments – Data Available.mp4 14MB
  49. ~Get Your Files Here !/8. Examples of analyses/5. Expansion strategy into other countries – Case Introduction.mp4 14MB
  50. ~Get Your Files Here !/4. Cleaning and unifying data/5. How you can standarize data.mp4 13MB
  51. ~Get Your Files Here !/2. How to merge data from different sources/18. The logic of INDEX function.mp4 13MB
  52. ~Get Your Files Here !/2. How to merge data from different sources/13. How to assign categories based on 3 and more criteria using VLOOKUP.mp4 12MB
  53. ~Get Your Files Here !/6. Pivot Tables/2. How to use pivot tables.mp4 12MB
  54. ~Get Your Files Here !/7. Other useful functions and tools in Excel/16. What will be the effect of the price increase – Introduction.mp4 12MB
  55. ~Get Your Files Here !/2. How to merge data from different sources/10. Assigning categories based on 2 criteria using MATCH and VLOOKUP function.mp4 12MB
  56. ~Get Your Files Here !/7. Other useful functions and tools in Excel/2. Conditional Formating.mp4 12MB
  57. ~Get Your Files Here !/11. More advanced shortcuts/4. Working with data in a table.mp4 12MB
  58. ~Get Your Files Here !/9. Basic VBA usage - example/1. Logistics system simulation - introduction.mp4 11MB
  59. ~Get Your Files Here !/2. How to merge data from different sources/3. VLOOKUP with approximate match – Introduction.mp4 11MB
  60. ~Get Your Files Here !/4. Cleaning and unifying data/11. Saturating existing markets – Solution in Power Point.mp4 11MB
  61. ~Get Your Files Here !/4. Cleaning and unifying data/6. Example of unifying data - Saturating existing markets – Introduction.mp4 11MB
  62. ~Get Your Files Here !/2. How to merge data from different sources/12. Assigning categories based on 2 criteria using VLOOKUP only.mp4 10MB
  63. ~Get Your Files Here !/4. Cleaning and unifying data/2. How to assign categories using string related functions.mp4 10MB
  64. ~Get Your Files Here !/10. Essential Excel shortcuts/13. Selecting area with shortcuts.mp4 10MB
  65. ~Get Your Files Here !/1. Introduction/4. What to do if a blurry image appears.mp4 10MB
  66. ~Get Your Files Here !/2. How to merge data from different sources/8. How to use HLOOKUP.mp4 10MB
  67. ~Get Your Files Here !/4. Cleaning and unifying data/3. How to divide 1 data into 2.mp4 10MB
  68. ~Get Your Files Here !/2. How to merge data from different sources/9. The logic of MATCH function.mp4 10MB
  69. ~Get Your Files Here !/11. More advanced shortcuts/5. How to see formulas.mp4 10MB
  70. ~Get Your Files Here !/10. Essential Excel shortcuts/14. Search and replace data.mp4 9MB
  71. ~Get Your Files Here !/6. Pivot Tables/6. How to replace pivot tables with SUMIFS and COUNTIFS.mp4 9MB
  72. ~Get Your Files Here !/10. Essential Excel shortcuts/2. Essential shortcuts – Introduction.mp4 9MB
  73. ~Get Your Files Here !/7. Other useful functions and tools in Excel/3. How to use indirect function.mp4 9MB
  74. ~Get Your Files Here !/3. Example of analysis requiring merging data/3. Fuel usage analysis using the vlookup function - solution.mp4 9MB
  75. ~Get Your Files Here !/7. Other useful functions and tools in Excel/4. Histograms.mp4 9MB
  76. ~Get Your Files Here !/8. Examples of analyses/2. Sales channel analysis - case in FMCG.mp4 8MB
  77. ~Get Your Files Here !/3. Example of analysis requiring merging data/1. Fuel usage analysis using the vlookup function - intro.mp4 8MB
  78. ~Get Your Files Here !/2. How to merge data from different sources/11. Assigning categories based on 2 criteria using HLOOKUP and VLOOKUP function.mp4 8MB
  79. ~Get Your Files Here !/1. Introduction/5. How to find additional resources.mp4 8MB
  80. ~Get Your Files Here !/5. How to use IF function and what you can do instead/3. How to use VLOOKUP instead of IF function.mp4 8MB
  81. ~Get Your Files Here !/2. How to merge data from different sources/1.1 Essential Excel full v21 - upload version.pdf 8MB
  82. ~Get Your Files Here !/7. Other useful functions and tools in Excel/1. Other useful functions and tools in Excel.mp4 7MB
  83. ~Get Your Files Here !/10. Essential Excel shortcuts/3. No mouse rule.mp4 7MB
  84. ~Get Your Files Here !/1. Introduction/1. Introduction.mp4 7MB
  85. ~Get Your Files Here !/5. How to use IF function and what you can do instead/5. How to use MAX and MIN instead of IF function.mp4 7MB
  86. ~Get Your Files Here !/2. How to merge data from different sources/20. INDEX & MATCH function – Exercise – Case Introduction.mp4 7MB
  87. ~Get Your Files Here !/7. Other useful functions and tools in Excel/7. Data validation.mp4 7MB
  88. ~Get Your Files Here !/6. Pivot Tables/3. How to use pivot charts.mp4 6MB
  89. ~Get Your Files Here !/8. Examples of analyses/1. Examples of analyses in Excel.mp4 6MB
  90. ~Get Your Files Here !/6. Pivot Tables/8. Example of analyses using pivot tables- Analysis of sales channels for FMCG.mp4 6MB
  91. ~Get Your Files Here !/10. Essential Excel shortcuts/1. Excel shortcuts - Why it makes sense to learn them.mp4 6MB
  92. ~Get Your Files Here !/5. How to use IF function and what you can do instead/4. How to use IFERROR function.mp4 5MB
  93. ~Get Your Files Here !/6. Pivot Tables/7. Going from general to specific with pivots.mp4 5MB
  94. ~Get Your Files Here !/6. Pivot Tables/4. How to combine pivot tables with regular calculations.mp4 5MB
  95. ~Get Your Files Here !/6. Pivot Tables/5. How to use slicers.mp4 5MB
  96. ~Get Your Files Here !/1. Introduction/3. How to make the most out of the course.mp4 4MB
  97. ~Get Your Files Here !/4. Cleaning and unifying data/4. How to join 2 data into 1.mp4 4MB
  98. ~Get Your Files Here !/7. Other useful functions and tools in Excel/9. Using solver – Planning the flow of finished goods – Introduction.mp4 4MB
  99. ~Get Your Files Here !/7. Other useful functions and tools in Excel/5. Regression - introduction.mp4 4MB
  100. ~Get Your Files Here !/4. Cleaning and unifying data/1. What problems you may face with data.mp4 4MB
  101. ~Get Your Files Here !/5. How to use IF function and what you can do instead/2. How to use IF function.mp4 4MB
  102. ~Get Your Files Here !/11. More advanced shortcuts/1. More advanced shortcuts – Introduction.mp4 3MB
  103. ~Get Your Files Here !/5. How to use IF function and what you can do instead/1. Why NOT to use IF function.mp4 3MB
  104. ~Get Your Files Here !/1. Introduction/2. About Me.mp4 3MB
  105. ~Get Your Files Here !/2. How to merge data from different sources/4. What you can use the VLOOKUP for.mp4 3MB
  106. ~Get Your Files Here !/6. Pivot Tables/1. Pivot tables - introduction.mp4 2MB
  107. ~Get Your Files Here !/2. How to merge data from different sources/1. How to merge data from different sources.mp4 2MB
  108. ~Get Your Files Here !/7. Other useful functions and tools in Excel/11.1 Planning the flows using Solver - Option 2 - Solution.xlsx 1MB
  109. ~Get Your Files Here !/7. Other useful functions and tools in Excel/10.1 Planning the flows using Solver - Option 1.xlsx 1MB
  110. ~Get Your Files Here !/7. Other useful functions and tools in Excel/11.2 Planning the flows using Solver - Option 2.xlsx 1MB
  111. ~Get Your Files Here !/6. Pivot Tables/7.2 Sales desnsity analysisv5 - General to specific - Solution.xlsx 491KB
  112. ~Get Your Files Here !/6. Pivot Tables/7.1 Sales desnsity analysisv5 - General to specific - Empty.xlsx 485KB
  113. ~Get Your Files Here !/6. Pivot Tables/5.2 Sales desnsity analysisv5 - Slicer - Solution.xlsx 485KB
  114. ~Get Your Files Here !/6. Pivot Tables/4.2 Sales desnsity analysisv5 - Add Calculation - Solution.xlsx 484KB
  115. ~Get Your Files Here !/6. Pivot Tables/5.1 Sales desnsity analysisv5 - Slicer - Empty.xlsx 478KB
  116. ~Get Your Files Here !/6. Pivot Tables/6.1 Sales desnsity analysisv5 - Sumifs - Empty.xlsx 469KB
  117. ~Get Your Files Here !/6. Pivot Tables/6.2 Sales desnsity analysisv5 - Sumifs - Solution.xlsx 469KB
  118. ~Get Your Files Here !/6. Pivot Tables/3.2 Sales desnsity analysisv5 - Pivot Charts - Solution.xlsx 466KB
  119. ~Get Your Files Here !/6. Pivot Tables/4.1 Sales desnsity analysisv5 - Add Calculation - Empty.xlsx 466KB
  120. ~Get Your Files Here !/7. Other useful functions and tools in Excel/4.2 Histogram - Solution.xlsx 462KB
  121. ~Get Your Files Here !/7. Other useful functions and tools in Excel/2.2 Conditional formating - Solution.xlsx 460KB
  122. ~Get Your Files Here !/7. Other useful functions and tools in Excel/2.1 Conditional formating - Empty.xlsx 459KB
  123. ~Get Your Files Here !/7. Other useful functions and tools in Excel/4.1 Histogram - Empty.xlsx 455KB
  124. ~Get Your Files Here !/6. Pivot Tables/2.2 Sales desnsity analysisv5 - Solution.xlsx 455KB
  125. ~Get Your Files Here !/6. Pivot Tables/3.1 Sales desnsity analysisv5 - Pivot Charts - Empty.xlsx 455KB
  126. ~Get Your Files Here !/6. Pivot Tables/2.1 Sales desnsity analysisv5 - Empty.xlsx 446KB
  127. ~Get Your Files Here !/6. Pivot Tables/3.3 Sales desnsity analysisv5 Pivot Charts Solution - Mac.xlsx 433KB
  128. ~Get Your Files Here !/7. Other useful functions and tools in Excel/6.2 Sales analysis regression-Solution.xlsx 406KB
  129. ~Get Your Files Here !/7. Other useful functions and tools in Excel/6.1 Sales analysis regression-Emtpy.xlsx 387KB
  130. ~Get Your Files Here !/4. Cleaning and unifying data/12.1 Saturation-point-analysis-v4 with a waterfall.xlsx 363KB
  131. ~Get Your Files Here !/4. Cleaning and unifying data/8.1 Saturation point analysis v4.xlsx 354KB
  132. ~Get Your Files Here !/8. Examples of analyses/10.1 Saturation point analysis v4.xlsx 354KB
  133. ~Get Your Files Here !/4. Cleaning and unifying data/7.1 Saturation point analysis v4 - Empty with structure.xlsx 231KB
  134. ~Get Your Files Here !/3. Example of analysis requiring merging data/3.1 Fuel consumption - solution with Slicer and charts.xlsx 194KB
  135. ~Get Your Files Here !/4. Cleaning and unifying data/2.1 Assign categories using string function Solutionv2.xlsx 172KB
  136. ~Get Your Files Here !/2. How to merge data from different sources/7.2 How to assign categories using VLOOKUP - Solution.xlsx 114KB
  137. ~Get Your Files Here !/2. How to merge data from different sources/8.1 How to use HLOOKUP - Empty.xlsx 114KB
  138. ~Get Your Files Here !/2. How to merge data from different sources/8.2 How to use HLOOKUP - Solution.xlsx 114KB
  139. ~Get Your Files Here !/3. Example of analysis requiring merging data/3.2 Fuel consumption - solution.xlsx 110KB
  140. ~Get Your Files Here !/2. How to merge data from different sources/7.1 How to assign categories using VLOOKUP - Empty.xlsx 108KB
  141. ~Get Your Files Here !/2. How to merge data from different sources/5.2 Basic vlookup -Solution.xlsx 108KB
  142. ~Get Your Files Here !/2. How to merge data from different sources/6.2 Some comments on vlookup - Solution.xlsx 108KB
  143. ~Get Your Files Here !/4. Cleaning and unifying data/6.1 Saturation point analysis v4 Empty.xlsx 107KB
  144. ~Get Your Files Here !/4. Cleaning and unifying data/7.2 Saturation point analysis v4 Empty.xlsx 107KB
  145. ~Get Your Files Here !/2. How to merge data from different sources/5.1 Basic vlookup - Empty.xlsx 106KB
  146. ~Get Your Files Here !/2. How to merge data from different sources/6.1 Some comments on vlookup - Empty.xlsx 106KB
  147. ~Get Your Files Here !/2. How to merge data from different sources/17.1 Segmentation using Sumifs - Solution v2.xlsx 93KB
  148. ~Get Your Files Here !/2. How to merge data from different sources/16.1 Segmentation using Sumifs - Empty.xlsx 80KB
  149. ~Get Your Files Here !/3. Example of analysis requiring merging data/3.3 Selected slide - fuel usage.pptx 73KB
  150. ~Get Your Files Here !/8. Examples of analyses/7.1 Expansion ranking of countriesv4.xlsx 72KB
  151. ~Get Your Files Here !/8. Examples of analyses/8.1 Expansion ranking of countriesv4.xlsx 72KB
  152. ~Get Your Files Here !/8. Examples of analyses/9.1 Expansion ranking of countriesv4.xlsx 72KB
  153. ~Get Your Files Here !/2. How to merge data from different sources/14.1 SUMIF for many criteria - Solution.xlsx 71KB
  154. ~Get Your Files Here !/2. How to merge data from different sources/14.2 SUMIFS for many criteria - Empty.xlsx 71KB
  155. ~Get Your Files Here !/7. Other useful functions and tools in Excel/3.1 Indirect - Hours - empty.xlsx 68KB
  156. ~Get Your Files Here !/7. Other useful functions and tools in Excel/3.2 Indirect - Hours - solutionv2.xlsx 67KB
  157. ~Get Your Files Here !/3. Example of analysis requiring merging data/1.1 Fuel consumption - empty.xlsx 67KB
  158. ~Get Your Files Here !/9. Basic VBA usage - example/2.1 distribution system simulation-partial result v2.xlsm 59KB
  159. ~Get Your Files Here !/9. Basic VBA usage - example/3.1 distribution system simulation-final solutionv3.xlsm 58KB
  160. ~Get Your Files Here !/8. Examples of analyses/6.1 Expansion ranking of countriesv4 Empty.xlsx 56KB
  161. ~Get Your Files Here !/10. Essential Excel shortcuts/10.1 Marketing efficiencyv2 - empty.xlsx 53KB
  162. ~Get Your Files Here !/10. Essential Excel shortcuts/11.1 Marketing efficiencyv2 - empty.xlsx 53KB
  163. ~Get Your Files Here !/10. Essential Excel shortcuts/12.1 Marketing efficiencyv2 - empty.xlsx 53KB
  164. ~Get Your Files Here !/10. Essential Excel shortcuts/13.1 Marketing efficiencyv2 - empty.xlsx 53KB
  165. ~Get Your Files Here !/10. Essential Excel shortcuts/14.1 Marketing efficiencyv2 - empty.xlsx 53KB
  166. ~Get Your Files Here !/10. Essential Excel shortcuts/4.1 Marketing efficiencyv2 - empty.xlsx 53KB
  167. ~Get Your Files Here !/10. Essential Excel shortcuts/5.1 Marketing efficiencyv2 - empty.xlsx 53KB
  168. ~Get Your Files Here !/10. Essential Excel shortcuts/6.1 Marketing efficiencyv2 - empty.xlsx 53KB
  169. ~Get Your Files Here !/10. Essential Excel shortcuts/7.1 Marketing efficiencyv2 - empty.xlsx 53KB
  170. ~Get Your Files Here !/10. Essential Excel shortcuts/8.1 Marketing efficiencyv2 - empty.xlsx 53KB
  171. ~Get Your Files Here !/10. Essential Excel shortcuts/9.1 Marketing efficiencyv2 - empty.xlsx 53KB
  172. ~Get Your Files Here !/11. More advanced shortcuts/1.1 Marketing efficiencyv2 - empty.xlsx 53KB
  173. ~Get Your Files Here !/11. More advanced shortcuts/2.1 Marketing efficiencyv2 - empty.xlsx 53KB
  174. ~Get Your Files Here !/11. More advanced shortcuts/3.1 Marketing efficiencyv2 - empty.xlsx 53KB
  175. ~Get Your Files Here !/11. More advanced shortcuts/4.1 Marketing efficiencyv2 - empty.xlsx 53KB
  176. ~Get Your Files Here !/11. More advanced shortcuts/5.1 Marketing efficiencyv2 - empty.xlsx 53KB
  177. ~Get Your Files Here !/11. More advanced shortcuts/6.2 Marketing efficiencyv2 - empty.xlsx 53KB
  178. ~Get Your Files Here !/10. Essential Excel shortcuts/10.2 Marketing efficiencyv2 - ready.xlsx 53KB
  179. ~Get Your Files Here !/10. Essential Excel shortcuts/14.2 Marketing efficiencyv2 - ready.xlsx 53KB
  180. ~Get Your Files Here !/10. Essential Excel shortcuts/4.2 Marketing efficiencyv2 - ready.xlsx 53KB
  181. ~Get Your Files Here !/10. Essential Excel shortcuts/5.2 Marketing efficiencyv2 - ready.xlsx 53KB
  182. ~Get Your Files Here !/10. Essential Excel shortcuts/6.2 Marketing efficiencyv2 - ready.xlsx 53KB
  183. ~Get Your Files Here !/10. Essential Excel shortcuts/7.2 Marketing efficiencyv2 - ready.xlsx 53KB
  184. ~Get Your Files Here !/10. Essential Excel shortcuts/8.2 Marketing efficiencyv2 - ready.xlsx 53KB
  185. ~Get Your Files Here !/10. Essential Excel shortcuts/9.2 Marketing efficiencyv2 - ready.xlsx 53KB
  186. ~Get Your Files Here !/11. More advanced shortcuts/6.3 Marketing efficiencyv2 - ready.xlsx 53KB
  187. ~Get Your Files Here !/8. Examples of analyses/4.1 e-commerce_EN.xlsx 53KB
  188. ~Get Your Files Here !/8. Examples of analyses/3.3 Marketing efficiencyv2.xlsx 52KB
  189. ~Get Your Files Here !/7. Other useful functions and tools in Excel/8.1 Sumproduct function - Empty.xlsx 51KB
  190. ~Get Your Files Here !/7. Other useful functions and tools in Excel/8.2 Sumproduct function - Solution.xlsx 50KB
  191. ~Get Your Files Here !/6. Pivot Tables/8.1 Sales channel FMCGv2.xlsx 49KB
  192. ~Get Your Files Here !/8. Examples of analyses/2.4 Sales channel FMCGv2.xlsx 49KB
  193. ~Get Your Files Here !/4. Cleaning and unifying data/5.2 Standardize data-Solutionv2.xlsx 49KB
  194. ~Get Your Files Here !/7. Other useful functions and tools in Excel/17.1 Coffee shop - price increasev2.xlsx 47KB
  195. ~Get Your Files Here !/7. Other useful functions and tools in Excel/18.1 Coffee shop - price increasev2.xlsx 47KB
  196. ~Get Your Files Here !/8. Examples of analyses/11.2 Ranking of new product for developmentv2 - with scatter chart.xlsx 47KB
  197. ~Get Your Files Here !/4. Cleaning and unifying data/5.1 Standardize data-Empty.xlsx 46KB
  198. ~Get Your Files Here !/2. How to merge data from different sources/21.1 Index function v2.xlsx 45KB
  199. ~Get Your Files Here !/2. How to merge data from different sources/20.1 Index function v2 - Empty.xlsx 45KB
  200. ~Get Your Files Here !/2. How to merge data from different sources/13.2 Startup advisor many criteria - Solution.xlsx 44KB
  201. ~Get Your Files Here !/2. How to merge data from different sources/13.1 Startup advisor many criteria - Empty.xlsx 43KB
  202. ~Get Your Files Here !/7. Other useful functions and tools in Excel/13.1 Retiringv2.xlsx 42KB
  203. ~Get Your Files Here !/7. Other useful functions and tools in Excel/14.1 Retiringv2.xlsx 42KB
  204. ~Get Your Files Here !/7. Other useful functions and tools in Excel/15.2 Retiringv2.xlsx 42KB
  205. ~Get Your Files Here !/2. How to merge data from different sources/12.2 Startup advisor 2 criteria only VLOOKUP- Solution.xlsx 41KB
  206. ~Get Your Files Here !/8. Examples of analyses/11.3 Ranking of new product for developmentv2.xlsx 41KB
  207. ~Get Your Files Here !/2. How to merge data from different sources/12.1 Startup advisor 2 criteria only VLOOKUP- Empty.xlsx 41KB
  208. ~Get Your Files Here !/5. How to use IF function and what you can do instead/5.2 Motivation system without Max and Min - Solution.xlsx 41KB
  209. ~Get Your Files Here !/5. How to use IF function and what you can do instead/5.1 Motivation system without Max and Min - Empty.xlsx 41KB
  210. ~Get Your Files Here !/5. How to use IF function and what you can do instead/4.2 Motivation system IFERROR -Solution.xlsx 41KB
  211. ~Get Your Files Here !/5. How to use IF function and what you can do instead/3.2 Motivation system VLOOKUP instead of IF - Solution.xlsx 41KB
  212. ~Get Your Files Here !/5. How to use IF function and what you can do instead/3.1 Motivation system VLOOKUP instead of IF - Empty.xlsx 41KB
  213. ~Get Your Files Here !/5. How to use IF function and what you can do instead/4.1 Motivation system IFERROR -Empty.xlsx 41KB
  214. ~Get Your Files Here !/5. How to use IF function and what you can do instead/2.1 Motivation system with IFs.xlsx 41KB
  215. ~Get Your Files Here !/4. Cleaning and unifying data/3.2 Dividing - Solution.xlsx 40KB
  216. ~Get Your Files Here !/4. Cleaning and unifying data/4.2 Join-Solution.xlsx 40KB
  217. ~Get Your Files Here !/4. Cleaning and unifying data/4.1 Join-Empty.xlsx 39KB
  218. ~Get Your Files Here !/2. How to merge data from different sources/11.2 Startup advisor 2 criteria HLOOKUP - Solution.xlsx 39KB
  219. ~Get Your Files Here !/2. How to merge data from different sources/11.1 Startup advisor 2 criteria HLOOKUP - Empty.xlsx 39KB
  220. ~Get Your Files Here !/2. How to merge data from different sources/10.2 Startup advisor 2 criteria with Match - Solution.xlsx 39KB
  221. ~Get Your Files Here !/2. How to merge data from different sources/10.1 Startup advisor 2 criteria with Match - Empty.xlsx 39KB
  222. ~Get Your Files Here !/4. Cleaning and unifying data/3.1 Dividing - Empty.xlsx 38KB
  223. ~Get Your Files Here !/7. Other useful functions and tools in Excel/7.2 Data validation - Solution.xlsx 36KB
  224. ~Get Your Files Here !/7. Other useful functions and tools in Excel/7.1 Data validation - Empty.xlsx 36KB
  225. ~Get Your Files Here !/9. Basic VBA usage - example/1.2 distribution system simulation-empty.xlsm 29KB
  226. ~Get Your Files Here !/9. Basic VBA usage - example/1.1 Case 5 - Simulation - introduction and tasks.doc 28KB
  227. ~Get Your Files Here !/8. Examples of analyses/4. Model of E-commerce.srt 13KB
  228. ~Get Your Files Here !/9. Basic VBA usage - example/2. Logistic system simulation - tips how to do it.srt 13KB
  229. ~Get Your Files Here !/9. Basic VBA usage - example/3. Logistic system simulation - final solution.srt 13KB
  230. ~Get Your Files Here !/8. Examples of analyses/3. Efficiency of marketing activities.srt 11KB
  231. ~Get Your Files Here !/7. Other useful functions and tools in Excel/10. Using solver – Planning the flow of finished goods – Excel - First Option.srt 9KB
  232. ~Get Your Files Here !/7. Other useful functions and tools in Excel/8. How to use SUMPRODUCT function.srt 9KB
  233. ~Get Your Files Here !/3. Example of analysis requiring merging data/2. Fuel usage analysis using the vlookup function - tips.srt 8KB
  234. ~Get Your Files Here !/7. Other useful functions and tools in Excel/6. Regression - example.srt 8KB
  235. ~Get Your Files Here !/7. Other useful functions and tools in Excel/13. When can I retire – No passive income – Excel Basic.srt 8KB
  236. ~Get Your Files Here !/12. Conclusions/1. Bonus Lecture What's next for you.html 8KB
  237. ~Get Your Files Here !/8. Examples of analyses/7. Expansion strategy into other countries – Which function to use.srt 8KB
  238. ~Get Your Files Here !/2. How to merge data from different sources/21. INDEX & MATCH function – Exercise – Case Solution.srt 8KB
  239. ~Get Your Files Here !/6. Pivot Tables/2. How to use pivot tables.srt 7KB
  240. ~Get Your Files Here !/2. How to merge data from different sources/14. How to assign categories using SUMIFS function – Basic Usage.srt 7KB
  241. ~Get Your Files Here !/2. How to merge data from different sources/17. Assigning customers to segments – Solution.srt 7KB
  242. ~Get Your Files Here !/9. Basic VBA usage - example/1. Logistics system simulation - introduction.srt 7KB
  243. ~Get Your Files Here !/2. How to merge data from different sources/13. How to assign categories based on 3 and more criteria using VLOOKUP.srt 6KB
  244. ~Get Your Files Here !/4. Cleaning and unifying data/12. Saturating existing markets – WaterFall Graph.srt 6KB
  245. ~Get Your Files Here !/7. Other useful functions and tools in Excel/2. Conditional Formating.srt 6KB
  246. ~Get Your Files Here !/7. Other useful functions and tools in Excel/17. What will be the effect of the price increase – Solution – Impact on coffee only.srt 6KB
  247. ~Get Your Files Here !/8. Examples of analyses/10. How to create a waterfall chart.srt 6KB
  248. ~Get Your Files Here !/8. Examples of analyses/6. Expansion strategy into other countries – Data for the case study.srt 6KB
  249. ~Get Your Files Here !/2. How to merge data from different sources/19. INDEX & MATCH function – Introduction.srt 6KB
  250. ~Get Your Files Here !/8. Examples of analyses/8. Expansion strategy into other countries – Solution in Excel.srt 6KB
  251. ~Get Your Files Here !/1. Introduction/1. Introduction.srt 6KB
  252. ~Get Your Files Here !/2. How to merge data from different sources/2. VLOOKUP – Introduction.srt 5KB
  253. ~Get Your Files Here !/2. How to merge data from different sources/12. Assigning categories based on 2 criteria using VLOOKUP only.srt 5KB
  254. ~Get Your Files Here !/4. Cleaning and unifying data/10. Saturating existing markets – Concept & Space.srt 5KB
  255. ~Get Your Files Here !/2. How to merge data from different sources/10. Assigning categories based on 2 criteria using MATCH and VLOOKUP function.srt 5KB
  256. ~Get Your Files Here !/8. Examples of analyses/11. How to create scatter plot with Names.srt 5KB
  257. ~Get Your Files Here !/5. How to use IF function and what you can do instead/5. How to use MAX and MIN instead of IF function.srt 5KB
  258. ~Get Your Files Here !/3. Example of analysis requiring merging data/1. Fuel usage analysis using the vlookup function - intro.srt 5KB
  259. ~Get Your Files Here !/4. Cleaning and unifying data/8. Saturating existing markets – Number of Stores.srt 5KB
  260. ~Get Your Files Here !/4. Cleaning and unifying data/7. Saturating existing markets – Data for the case study.srt 5KB
  261. ~Get Your Files Here !/10. Essential Excel shortcuts/10. Grouping rows and columns.srt 5KB
  262. ~Get Your Files Here !/7. Other useful functions and tools in Excel/14. When can I retire – No passive income – Go seek function.srt 5KB
  263. ~Get Your Files Here !/4. Cleaning and unifying data/5. How you can standarize data.srt 5KB
  264. ~Get Your Files Here !/2. How to merge data from different sources/15. Assigning customers to segments – Case Introduction.srt 5KB
  265. ~Get Your Files Here !/10. Essential Excel shortcuts/6. How to format cells using shortcuts – Numbers.srt 5KB
  266. ~Get Your Files Here !/4. Cleaning and unifying data/9. Saturating existing markets – Stores by concepts.srt 5KB
  267. ~Get Your Files Here !/6. Pivot Tables/6. How to replace pivot tables with SUMIFS and COUNTIFS.srt 5KB
  268. ~Get Your Files Here !/5. How to use IF function and what you can do instead/3. How to use VLOOKUP instead of IF function.srt 5KB
  269. ~Get Your Files Here !/2. How to merge data from different sources/5. Basic VLOOKUP usage.srt 4KB
  270. ~Get Your Files Here !/8. Examples of analyses/2. Sales channel analysis - case in FMCG.srt 4KB
  271. ~Get Your Files Here !/6. Pivot Tables/8. Example of analyses using pivot tables- Analysis of sales channels for FMCG.srt 4KB
  272. ~Get Your Files Here !/10. Essential Excel shortcuts/11. How to preserve your results or go back to previous ones.srt 4KB
  273. ~Get Your Files Here !/7. Other useful functions and tools in Excel/11. Using solver – Planning the flow of finished goods – Excel - Second Option.srt 4KB
  274. ~Get Your Files Here !/7. Other useful functions and tools in Excel/3. How to use indirect function.srt 4KB
  275. ~Get Your Files Here !/4. Cleaning and unifying data/2. How to assign categories using string related functions.srt 4KB
  276. ~Get Your Files Here !/7. Other useful functions and tools in Excel/7. Data validation.srt 4KB
  277. ~Get Your Files Here !/3. Example of analysis requiring merging data/3. Fuel usage analysis using the vlookup function - solution.srt 4KB
  278. ~Get Your Files Here !/8. Examples of analyses/9. Expansion strategy into other countries – Solution in Power Point.srt 4KB
  279. ~Get Your Files Here !/7. Other useful functions and tools in Excel/18. What will be the effect of the price increase – Solution – Full impact.srt 4KB
  280. ~Get Your Files Here !/4. Cleaning and unifying data/3. How to divide 1 data into 2.srt 4KB
  281. ~Get Your Files Here !/2. How to merge data from different sources/7. How to assign categories using VLOOKUP.srt 4KB
  282. ~Get Your Files Here !/8. Examples of analyses/5. Expansion strategy into other countries – Case Introduction.srt 4KB
  283. ~Get Your Files Here !/2. How to merge data from different sources/18. The logic of INDEX function.srt 4KB
  284. ~Get Your Files Here !/7. Other useful functions and tools in Excel/5. Regression - introduction.srt 4KB
  285. ~Get Your Files Here !/10. Essential Excel shortcuts/8. Selecting rows and selecting columns.srt 4KB
  286. ~Get Your Files Here !/10. Essential Excel shortcuts/7. Copying of cells with shortcuts.srt 4KB
  287. ~Get Your Files Here !/2. How to merge data from different sources/11. Assigning categories based on 2 criteria using HLOOKUP and VLOOKUP function.srt 4KB
  288. ~Get Your Files Here !/7. Other useful functions and tools in Excel/4. Histograms.srt 4KB
  289. ~Get Your Files Here !/2. How to merge data from different sources/3. VLOOKUP with approximate match – Introduction.srt 3KB
  290. ~Get Your Files Here !/10. Essential Excel shortcuts/12. Going fast around the Excel with shortcuts.srt 3KB
  291. ~Get Your Files Here !/10. Essential Excel shortcuts/5. How to format cells using shortcuts – Text – Part 2.srt 3KB
  292. ~Get Your Files Here !/7. Other useful functions and tools in Excel/15. When can I retire – With passive income.srt 3KB
  293. ~Get Your Files Here !/2. How to merge data from different sources/9. The logic of MATCH function.srt 3KB
  294. ~Get Your Files Here !/6. Pivot Tables/3. How to use pivot charts.srt 3KB
  295. ~Get Your Files Here !/7. Other useful functions and tools in Excel/16. What will be the effect of the price increase – Introduction.srt 3KB
  296. ~Get Your Files Here !/10. Essential Excel shortcuts/9. Adding and removing rows and columns.srt 3KB
  297. ~Get Your Files Here !/4. Cleaning and unifying data/11. Saturating existing markets – Solution in Power Point.srt 3KB
  298. ~Get Your Files Here !/4. Cleaning and unifying data/1. What problems you may face with data.srt 3KB
  299. ~Get Your Files Here !/6. Pivot Tables/4. How to combine pivot tables with regular calculations.srt 3KB
  300. ~Get Your Files Here !/5. How to use IF function and what you can do instead/4. How to use IFERROR function.srt 3KB
  301. ~Get Your Files Here !/11. More advanced shortcuts/2. Shortcuts hidden in Functional Keyboards.srt 3KB
  302. ~Get Your Files Here !/2. How to merge data from different sources/16. Assigning customers to segments – Data Available.srt 3KB
  303. ~Get Your Files Here !/10. Essential Excel shortcuts/2. Essential shortcuts – Introduction.srt 3KB
  304. ~Get Your Files Here !/2. How to merge data from different sources/6. Some comments on basic VLOOKUP.srt 3KB
  305. ~Get Your Files Here !/1. Introduction/4. What to do if a blurry image appears.srt 3KB
  306. ~Get Your Files Here !/7. Other useful functions and tools in Excel/1. Other useful functions and tools in Excel.srt 3KB
  307. ~Get Your Files Here !/1. Introduction/2. About Me.srt 3KB
  308. ~Get Your Files Here !/11. More advanced shortcuts/3. Hyperlinks.srt 3KB
  309. ~Get Your Files Here !/6. Pivot Tables/5. How to use slicers.srt 3KB
  310. ~Get Your Files Here !/10. Essential Excel shortcuts/4. How to format cells using shortcuts – Text – Part 1.srt 3KB
  311. ~Get Your Files Here !/5. How to use IF function and what you can do instead/2. How to use IF function.srt 3KB
  312. ~Get Your Files Here !/5. How to use IF function and what you can do instead/1. Why NOT to use IF function.srt 2KB
  313. ~Get Your Files Here !/10. Essential Excel shortcuts/3. No mouse rule.srt 2KB
  314. ~Get Your Files Here !/6. Pivot Tables/7. Going from general to specific with pivots.srt 2KB
  315. ~Get Your Files Here !/1. Introduction/3. How to make the most out of the course.srt 2KB
  316. ~Get Your Files Here !/11. More advanced shortcuts/6. How to reach the menu with shortcut.srt 2KB
  317. ~Get Your Files Here !/8. Examples of analyses/1. Examples of analyses in Excel.srt 2KB
  318. ~Get Your Files Here !/2. How to merge data from different sources/8. How to use HLOOKUP.srt 2KB
  319. ~Get Your Files Here !/10. Essential Excel shortcuts/13. Selecting area with shortcuts.srt 2KB
  320. ~Get Your Files Here !/2. How to merge data from different sources/1. How to merge data from different sources.srt 2KB
  321. ~Get Your Files Here !/2. How to merge data from different sources/4. What you can use the VLOOKUP for.srt 2KB
  322. ~Get Your Files Here !/11. More advanced shortcuts/4. Working with data in a table.srt 2KB
  323. ~Get Your Files Here !/4. Cleaning and unifying data/6. Example of unifying data - Saturating existing markets – Introduction.srt 2KB
  324. ~Get Your Files Here !/6. Pivot Tables/1. Pivot tables - introduction.srt 2KB
  325. ~Get Your Files Here !/1. Introduction/5. How to find additional resources.srt 2KB
  326. ~Get Your Files Here !/7. Other useful functions and tools in Excel/12. When can I retire – Introduction.srt 2KB
  327. ~Get Your Files Here !/10. Essential Excel shortcuts/1. Excel shortcuts - Why it makes sense to learn them.srt 2KB
  328. ~Get Your Files Here !/4. Cleaning and unifying data/4. How to join 2 data into 1.srt 2KB
  329. ~Get Your Files Here !/11. More advanced shortcuts/5. How to see formulas.srt 1KB
  330. ~Get Your Files Here !/10. Essential Excel shortcuts/14. Search and replace data.srt 1KB
  331. ~Get Your Files Here !/2. How to merge data from different sources/20. INDEX & MATCH function – Exercise – Case Introduction.srt 1KB
  332. ~Get Your Files Here !/11. More advanced shortcuts/1. More advanced shortcuts – Introduction.srt 1KB
  333. ~Get Your Files Here !/7. Other useful functions and tools in Excel/9. Using solver – Planning the flow of finished goods – Introduction.srt 841B
  334. ~Get Your Files Here !/Bonus Resources.txt 357B
  335. ~Get Your Files Here !/10. Essential Excel shortcuts/15. Shortcuts test.html 204B
  336. ~Get Your Files Here !/11. More advanced shortcuts/7. Shortcut Test 2.html 204B
  337. ~Get Your Files Here !/8. Examples of analyses/4.2 Financial Analysis for Management Consultants & Analysts.html 184B
  338. Get Bonus Downloads Here.url 180B
  339. ~Get Your Files Here !/8. Examples of analyses/1.1 Essential Finance & Accounting for Management Consultants and Business Analysts.html 176B
  340. ~Get Your Files Here !/9. Basic VBA usage - example/3.2 How to improve the cash flow of the firm.html 174B
  341. ~Get Your Files Here !/7. Other useful functions and tools in Excel/18.3 Sales and Marketing for Management Consultants.html 162B
  342. ~Get Your Files Here !/8. Examples of analyses/2.2 Examples of other sales analysis.html 162B
  343. ~Get Your Files Here !/8. Examples of analyses/3.1 Examples of other sales analysis.html 162B
  344. ~Get Your Files Here !/8. Examples of analyses/3.2 Examples of sales analysis for Management Consultants.html 162B
  345. ~Get Your Files Here !/8. Examples of analyses/2.1 Essential Sales Forecasting.html 161B
  346. ~Get Your Files Here !/7. Other useful functions and tools in Excel/18.2 Management Consulting Frameworks.html 160B
  347. ~Get Your Files Here !/12. Conclusions/1.1 How to set up and run Project Management Office (PMO).html 156B
  348. ~Get Your Files Here !/7. Other useful functions and tools in Excel/16.1 Essential Concepts in Pricing.html 156B
  349. ~Get Your Files Here !/12. Conclusions/1.2 Pricing for Management Consultants & Business Analysts.html 151B
  350. ~Get Your Files Here !/7. Other useful functions and tools in Excel/12.1 How to solve problems using management consulting tool, techniques & frameworks.html 148B
  351. ~Get Your Files Here !/7. Other useful functions and tools in Excel/15.1 How to solve problems using management consulting tool, techniques & frameworks.html 148B
  352. ~Get Your Files Here !/8. Examples of analyses/11.1 How to come up with a business idea.html 141B
  353. ~Get Your Files Here !/1. Introduction/3.1 How to become word class Business Analyst.html 140B
  354. ~Get Your Files Here !/8. Examples of analyses/2.3 How to become world class business analyst.html 140B
  355. ~Get Your Files Here !/8. Examples of analyses/4.4 On-line business models.html 140B
  356. ~Get Your Files Here !/1. Introduction/2.6 My YouTube channel.html 136B
  357. ~Get Your Files Here !/1. Introduction/5.1 All resources for the course.html 134B
  358. ~Get Your Files Here !/11. More advanced shortcuts/6.1 All resources for the course.html 134B
  359. ~Get Your Files Here !/8. Examples of analyses/4.3 Low cost business models - overview.html 132B
  360. ~Get Your Files Here !/1. Introduction/1.4 My YouTube channel.html 117B
  361. ~Get Your Files Here !/1. Introduction/1.1 My Linkedin Profile.html 108B
  362. ~Get Your Files Here !/1. Introduction/1.2 My Quora profile.html 102B
  363. ~Get Your Files Here !/1. Introduction/2.3 My Quora profile.html 102B
  364. ~Get Your Files Here !/1. Introduction/3.2 Main function in Excel translated into other languages.html 100B
  365. ~Get Your Files Here !/1. Introduction/2.5 My Udemy profile.html 99B
  366. ~Get Your Files Here !/1. Introduction/2.2 My Linkedin Profile.html 98B
  367. ~Get Your Files Here !/1. Introduction/2.4 My Slideshare profile.html 98B
  368. ~Get Your Files Here !/1. Introduction/1.3 My Slideshare profile.html 97B
  369. ~Get Your Files Here !/1. Introduction/2.1 My Blog - Badass Consultants.html 91B
  370. ~Get Your Files Here !/2. How to merge data from different sources/10.3 The Excel tool in the form of a web application.html 91B
  371. ~Get Your Files Here !/2. How to merge data from different sources/13.3 The Excel tool in the form of a web application.html 91B