[ CourseHulu.com ] Udemy - Essential Excel for Business Analysts and Consultants
大小1.71 GB
文件数371
Info Hash:2EE68C099E99ABD72928E9126FB0EF26FB341AF3
收录时间2026-02-10 20:39:24
更新时间2026-02-10 20:39:24
文件列表 (371)
Get Bonus Downloads Here.url
180 B
~Get Your Files Here !/1. Introduction/1. Introduction.mp4
7.23 MB
~Get Your Files Here !/1. Introduction/1. Introduction.srt
5.53 KB
~Get Your Files Here !/1. Introduction/1.1 My Linkedin Profile.html
108 B
~Get Your Files Here !/1. Introduction/1.2 My Quora profile.html
102 B
~Get Your Files Here !/1. Introduction/1.3 My Slideshare profile.html
97 B
~Get Your Files Here !/1. Introduction/1.4 My YouTube channel.html
117 B
~Get Your Files Here !/1. Introduction/2. About Me.mp4
2.93 MB
~Get Your Files Here !/1. Introduction/2. About Me.srt
2.68 KB
~Get Your Files Here !/1. Introduction/2.1 My Blog - Badass Consultants.html
91 B
~Get Your Files Here !/1. Introduction/2.2 My Linkedin Profile.html
98 B
~Get Your Files Here !/1. Introduction/2.3 My Quora profile.html
102 B
~Get Your Files Here !/1. Introduction/2.4 My Slideshare profile.html
98 B
~Get Your Files Here !/1. Introduction/2.5 My Udemy profile.html
99 B
~Get Your Files Here !/1. Introduction/2.6 My YouTube channel.html
136 B
~Get Your Files Here !/1. Introduction/3. How to make the most out of the course.mp4
4.26 MB
~Get Your Files Here !/1. Introduction/3. How to make the most out of the course.srt
2.35 KB
~Get Your Files Here !/1. Introduction/3.1 How to become word class Business Analyst.html
140 B
~Get Your Files Here !/1. Introduction/3.2 Main function in Excel translated into other languages.html
100 B
~Get Your Files Here !/1. Introduction/4. What to do if a blurry image appears.mp4
10.06 MB
~Get Your Files Here !/1. Introduction/4. What to do if a blurry image appears.srt
2.8 KB
~Get Your Files Here !/1. Introduction/5. How to find additional resources.mp4
7.78 MB
~Get Your Files Here !/1. Introduction/5. How to find additional resources.srt
1.79 KB
~Get Your Files Here !/1. Introduction/5.1 All resources for the course.html
134 B
~Get Your Files Here !/10. Essential Excel shortcuts/1. Excel shortcuts - Why it makes sense to learn them.mp4
5.63 MB
~Get Your Files Here !/10. Essential Excel shortcuts/1. Excel shortcuts - Why it makes sense to learn them.srt
1.68 KB
~Get Your Files Here !/10. Essential Excel shortcuts/10. Grouping rows and columns.mp4
25.4 MB
~Get Your Files Here !/10. Essential Excel shortcuts/10. Grouping rows and columns.srt
4.83 KB
~Get Your Files Here !/10. Essential Excel shortcuts/10.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/10.2 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/10. Essential Excel shortcuts/11. How to preserve your results or go back to previous ones.mp4
21.19 MB
~Get Your Files Here !/10. Essential Excel shortcuts/11. How to preserve your results or go back to previous ones.srt
4.17 KB
~Get Your Files Here !/10. Essential Excel shortcuts/11.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/12. Going fast around the Excel with shortcuts.mp4
19.82 MB
~Get Your Files Here !/10. Essential Excel shortcuts/12. Going fast around the Excel with shortcuts.srt
3.42 KB
~Get Your Files Here !/10. Essential Excel shortcuts/12.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/13. Selecting area with shortcuts.mp4
10.25 MB
~Get Your Files Here !/10. Essential Excel shortcuts/13. Selecting area with shortcuts.srt
2.06 KB
~Get Your Files Here !/10. Essential Excel shortcuts/13.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/14. Search and replace data.mp4
9.31 MB
~Get Your Files Here !/10. Essential Excel shortcuts/14. Search and replace data.srt
1.43 KB
~Get Your Files Here !/10. Essential Excel shortcuts/14.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/14.2 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/10. Essential Excel shortcuts/15. Shortcuts test.html
204 B
~Get Your Files Here !/10. Essential Excel shortcuts/2. Essential shortcuts – Introduction.mp4
9.26 MB
~Get Your Files Here !/10. Essential Excel shortcuts/2. Essential shortcuts – Introduction.srt
2.81 KB
~Get Your Files Here !/10. Essential Excel shortcuts/3. No mouse rule.mp4
7.27 MB
~Get Your Files Here !/10. Essential Excel shortcuts/3. No mouse rule.srt
2.46 KB
~Get Your Files Here !/10. Essential Excel shortcuts/4. How to format cells using shortcuts – Text – Part 1.mp4
14.44 MB
~Get Your Files Here !/10. Essential Excel shortcuts/4. How to format cells using shortcuts – Text – Part 1.srt
2.6 KB
~Get Your Files Here !/10. Essential Excel shortcuts/4.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/4.2 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/10. Essential Excel shortcuts/5. How to format cells using shortcuts – Text – Part 2.mp4
19.31 MB
~Get Your Files Here !/10. Essential Excel shortcuts/5. How to format cells using shortcuts – Text – Part 2.srt
3.42 KB
~Get Your Files Here !/10. Essential Excel shortcuts/5.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/5.2 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/10. Essential Excel shortcuts/6. How to format cells using shortcuts – Numbers.mp4
25.18 MB
~Get Your Files Here !/10. Essential Excel shortcuts/6. How to format cells using shortcuts – Numbers.srt
4.62 KB
~Get Your Files Here !/10. Essential Excel shortcuts/6.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/6.2 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/10. Essential Excel shortcuts/7. Copying of cells with shortcuts.mp4
21.5 MB
~Get Your Files Here !/10. Essential Excel shortcuts/7. Copying of cells with shortcuts.srt
3.64 KB
~Get Your Files Here !/10. Essential Excel shortcuts/7.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/7.2 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/10. Essential Excel shortcuts/8. Selecting rows and selecting columns.mp4
22.27 MB
~Get Your Files Here !/10. Essential Excel shortcuts/8. Selecting rows and selecting columns.srt
3.64 KB
~Get Your Files Here !/10. Essential Excel shortcuts/8.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/8.2 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/10. Essential Excel shortcuts/9. Adding and removing rows and columns.mp4
15.58 MB
~Get Your Files Here !/10. Essential Excel shortcuts/9. Adding and removing rows and columns.srt
3.24 KB
~Get Your Files Here !/10. Essential Excel shortcuts/9.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/10. Essential Excel shortcuts/9.2 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/11. More advanced shortcuts/1. More advanced shortcuts – Introduction.mp4
3.38 MB
~Get Your Files Here !/11. More advanced shortcuts/1. More advanced shortcuts – Introduction.srt
1.3 KB
~Get Your Files Here !/11. More advanced shortcuts/1.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/11. More advanced shortcuts/2. Shortcuts hidden in Functional Keyboards.mp4
17.85 MB
~Get Your Files Here !/11. More advanced shortcuts/2. Shortcuts hidden in Functional Keyboards.srt
2.82 KB
~Get Your Files Here !/11. More advanced shortcuts/2.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/11. More advanced shortcuts/3. Hyperlinks.mp4
20.13 MB
~Get Your Files Here !/11. More advanced shortcuts/3. Hyperlinks.srt
2.68 KB
~Get Your Files Here !/11. More advanced shortcuts/3.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/11. More advanced shortcuts/4. Working with data in a table.mp4
11.53 MB
~Get Your Files Here !/11. More advanced shortcuts/4. Working with data in a table.srt
1.97 KB
~Get Your Files Here !/11. More advanced shortcuts/4.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/11. More advanced shortcuts/5. How to see formulas.mp4
9.51 MB
~Get Your Files Here !/11. More advanced shortcuts/5. How to see formulas.srt
1.43 KB
~Get Your Files Here !/11. More advanced shortcuts/5.1 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/11. More advanced shortcuts/6. How to reach the menu with shortcut.mp4
15.81 MB
~Get Your Files Here !/11. More advanced shortcuts/6. How to reach the menu with shortcut.srt
2.24 KB
~Get Your Files Here !/11. More advanced shortcuts/6.1 All resources for the course.html
134 B
~Get Your Files Here !/11. More advanced shortcuts/6.2 Marketing efficiencyv2 - empty.xlsx
53.21 KB
~Get Your Files Here !/11. More advanced shortcuts/6.3 Marketing efficiencyv2 - ready.xlsx
53.17 KB
~Get Your Files Here !/11. More advanced shortcuts/7. Shortcut Test 2.html
204 B
~Get Your Files Here !/12. Conclusions/1. Bonus Lecture What's next for you.html
7.93 KB
~Get Your Files Here !/12. Conclusions/1.1 How to set up and run Project Management Office (PMO).html
156 B
~Get Your Files Here !/12. Conclusions/1.2 Pricing for Management Consultants & Business Analysts.html
151 B
~Get Your Files Here !/2. How to merge data from different sources/1. How to merge data from different sources.mp4
2.06 MB
~Get Your Files Here !/2. How to merge data from different sources/1. How to merge data from different sources.srt
2.05 KB
~Get Your Files Here !/2. How to merge data from different sources/1.1 Essential Excel full v21 - upload version.pdf
7.54 MB
~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
11.86 MB
~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
5.33 KB
~Get Your Files Here !/2. How to merge data from different sources/10.1 Startup advisor 2 criteria with Match - Empty.xlsx
38.74 KB
~Get Your Files Here !/2. How to merge data from different sources/10.2 Startup advisor 2 criteria with Match - Solution.xlsx
38.75 KB
~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
91 B
~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
8 MB
~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
3.63 KB
~Get Your Files Here !/2. How to merge data from different sources/11.1 Startup advisor 2 criteria HLOOKUP - Empty.xlsx
38.76 KB
~Get Your Files Here !/2. How to merge data from different sources/11.2 Startup advisor 2 criteria HLOOKUP - Solution.xlsx
38.79 KB
~Get Your Files Here !/2. How to merge data from different sources/12. Assigning categories based on 2 criteria using VLOOKUP only.mp4
10.44 MB
~Get Your Files Here !/2. How to merge data from different sources/12. Assigning categories based on 2 criteria using VLOOKUP only.srt
5.4 KB
~Get Your Files Here !/2. How to merge data from different sources/12.1 Startup advisor 2 criteria only VLOOKUP- Empty.xlsx
40.85 KB
~Get Your Files Here !/2. How to merge data from different sources/12.2 Startup advisor 2 criteria only VLOOKUP- Solution.xlsx
41.15 KB
~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
12.45 MB
~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
6.48 KB
~Get Your Files Here !/2. How to merge data from different sources/13.1 Startup advisor many criteria - Empty.xlsx
43.02 KB
~Get Your Files Here !/2. How to merge data from different sources/13.2 Startup advisor many criteria - Solution.xlsx
43.69 KB
~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
91 B
~Get Your Files Here !/2. How to merge data from different sources/14. How to assign categories using SUMIFS function – Basic Usage.mp4
46.65 MB
~Get Your Files Here !/2. How to merge data from different sources/14. How to assign categories using SUMIFS function – Basic Usage.srt
7.22 KB
~Get Your Files Here !/2. How to merge data from different sources/14.1 SUMIF for many criteria - Solution.xlsx
71.31 KB
~Get Your Files Here !/2. How to merge data from different sources/14.2 SUMIFS for many criteria - Empty.xlsx
70.97 KB
~Get Your Files Here !/2. How to merge data from different sources/15. Assigning customers to segments – Case Introduction.mp4
14.81 MB
~Get Your Files Here !/2. How to merge data from different sources/15. Assigning customers to segments – Case Introduction.srt
4.73 KB
~Get Your Files Here !/2. How to merge data from different sources/16. Assigning customers to segments – Data Available.mp4
14.12 MB
~Get Your Files Here !/2. How to merge data from different sources/16. Assigning customers to segments – Data Available.srt
2.81 KB
~Get Your Files Here !/2. How to merge data from different sources/16.1 Segmentation using Sumifs - Empty.xlsx
79.55 KB
~Get Your Files Here !/2. How to merge data from different sources/17. Assigning customers to segments – Solution.mp4
36.82 MB
~Get Your Files Here !/2. How to merge data from different sources/17. Assigning customers to segments – Solution.srt
6.78 KB
~Get Your Files Here !/2. How to merge data from different sources/17.1 Segmentation using Sumifs - Solution v2.xlsx
93.26 KB
~Get Your Files Here !/2. How to merge data from different sources/18. The logic of INDEX function.mp4
13.13 MB
~Get Your Files Here !/2. How to merge data from different sources/18. The logic of INDEX function.srt
3.66 KB
~Get Your Files Here !/2. How to merge data from different sources/19. INDEX & MATCH function – Introduction.mp4
22.41 MB
~Get Your Files Here !/2. How to merge data from different sources/19. INDEX & MATCH function – Introduction.srt
5.61 KB
~Get Your Files Here !/2. How to merge data from different sources/2. VLOOKUP – Introduction.mp4
16.96 MB
~Get Your Files Here !/2. How to merge data from different sources/2. VLOOKUP – Introduction.srt
5.41 KB
~Get Your Files Here !/2. How to merge data from different sources/20. INDEX & MATCH function – Exercise – Case Introduction.mp4
6.82 MB
~Get Your Files Here !/2. How to merge data from different sources/20. INDEX & MATCH function – Exercise – Case Introduction.srt
1.42 KB
~Get Your Files Here !/2. How to merge data from different sources/20.1 Index function v2 - Empty.xlsx
44.87 KB
~Get Your Files Here !/2. How to merge data from different sources/21. INDEX & MATCH function – Exercise – Case Solution.mp4
38.12 MB
~Get Your Files Here !/2. How to merge data from different sources/21. INDEX & MATCH function – Exercise – Case Solution.srt
7.53 KB
~Get Your Files Here !/2. How to merge data from different sources/21.1 Index function v2.xlsx
45.02 KB
~Get Your Files Here !/2. How to merge data from different sources/3. VLOOKUP with approximate match – Introduction.mp4
11.33 MB
~Get Your Files Here !/2. How to merge data from different sources/3. VLOOKUP with approximate match – Introduction.srt
3.46 KB
~Get Your Files Here !/2. How to merge data from different sources/4. What you can use the VLOOKUP for.mp4
2.59 MB
~Get Your Files Here !/2. How to merge data from different sources/4. What you can use the VLOOKUP for.srt
2 KB
~Get Your Files Here !/2. How to merge data from different sources/5. Basic VLOOKUP usage.mp4
41.58 MB
~Get Your Files Here !/2. How to merge data from different sources/5. Basic VLOOKUP usage.srt
4.45 KB
~Get Your Files Here !/2. How to merge data from different sources/5.1 Basic vlookup - Empty.xlsx
105.52 KB
~Get Your Files Here !/2. How to merge data from different sources/5.2 Basic vlookup -Solution.xlsx
108.27 KB
~Get Your Files Here !/2. How to merge data from different sources/6. Some comments on basic VLOOKUP.mp4
24.67 MB
~Get Your Files Here !/2. How to merge data from different sources/6. Some comments on basic VLOOKUP.srt
2.8 KB
~Get Your Files Here !/2. How to merge data from different sources/6.1 Some comments on vlookup - Empty.xlsx
105.52 KB
~Get Your Files Here !/2. How to merge data from different sources/6.2 Some comments on vlookup - Solution.xlsx
108.27 KB
~Get Your Files Here !/2. How to merge data from different sources/7. How to assign categories using VLOOKUP.mp4
29.15 MB
~Get Your Files Here !/2. How to merge data from different sources/7. How to assign categories using VLOOKUP.srt
3.73 KB
~Get Your Files Here !/2. How to merge data from different sources/7.1 How to assign categories using VLOOKUP - Empty.xlsx
108.28 KB
~Get Your Files Here !/2. How to merge data from different sources/7.2 How to assign categories using VLOOKUP - Solution.xlsx
113.76 KB
~Get Your Files Here !/2. How to merge data from different sources/8. How to use HLOOKUP.mp4
10.01 MB
~Get Your Files Here !/2. How to merge data from different sources/8. How to use HLOOKUP.srt
2.07 KB
~Get Your Files Here !/2. How to merge data from different sources/8.1 How to use HLOOKUP - Empty.xlsx
113.76 KB
~Get Your Files Here !/2. How to merge data from different sources/8.2 How to use HLOOKUP - Solution.xlsx
113.76 KB
~Get Your Files Here !/2. How to merge data from different sources/9. The logic of MATCH function.mp4
9.76 MB
~Get Your Files Here !/2. How to merge data from different sources/9. The logic of MATCH function.srt
3.37 KB
~Get Your Files Here !/3. Example of analysis requiring merging data/1. Fuel usage analysis using the vlookup function - intro.mp4
8.26 MB
~Get Your Files Here !/3. Example of analysis requiring merging data/1. Fuel usage analysis using the vlookup function - intro.srt
5.1 KB
~Get Your Files Here !/3. Example of analysis requiring merging data/1.1 Fuel consumption - empty.xlsx
67.05 KB
~Get Your Files Here !/3. Example of analysis requiring merging data/2. Fuel usage analysis using the vlookup function - tips.mp4
15.92 MB
~Get Your Files Here !/3. Example of analysis requiring merging data/2. Fuel usage analysis using the vlookup function - tips.srt
8.06 KB
~Get Your Files Here !/3. Example of analysis requiring merging data/3. Fuel usage analysis using the vlookup function - solution.mp4
8.92 MB
~Get Your Files Here !/3. Example of analysis requiring merging data/3. Fuel usage analysis using the vlookup function - solution.srt
3.88 KB
~Get Your Files Here !/3. Example of analysis requiring merging data/3.1 Fuel consumption - solution with Slicer and charts.xlsx
193.61 KB
~Get Your Files Here !/3. Example of analysis requiring merging data/3.2 Fuel consumption - solution.xlsx
109.78 KB
~Get Your Files Here !/3. Example of analysis requiring merging data/3.3 Selected slide - fuel usage.pptx
73.1 KB
~Get Your Files Here !/4. Cleaning and unifying data/1. What problems you may face with data.mp4
3.82 MB
~Get Your Files Here !/4. Cleaning and unifying data/1. What problems you may face with data.srt
3 KB
~Get Your Files Here !/4. Cleaning and unifying data/10. Saturating existing markets – Concept & Space.mp4
37.57 MB
~Get Your Files Here !/4. Cleaning and unifying data/10. Saturating existing markets – Concept & Space.srt
5.4 KB
~Get Your Files Here !/4. Cleaning and unifying data/11. Saturating existing markets – Solution in Power Point.mp4
10.87 MB
~Get Your Files Here !/4. Cleaning and unifying data/11. Saturating existing markets – Solution in Power Point.srt
3.01 KB
~Get Your Files Here !/4. Cleaning and unifying data/12. Saturating existing markets – WaterFall Graph.mp4
24.85 MB
~Get Your Files Here !/4. Cleaning and unifying data/12. Saturating existing markets – WaterFall Graph.srt
6.15 KB
~Get Your Files Here !/4. Cleaning and unifying data/12.1 Saturation-point-analysis-v4 with a waterfall.xlsx
362.51 KB
~Get Your Files Here !/4. Cleaning and unifying data/2. How to assign categories using string related functions.mp4
10.25 MB
~Get Your Files Here !/4. Cleaning and unifying data/2. How to assign categories using string related functions.srt
3.9 KB
~Get Your Files Here !/4. Cleaning and unifying data/2.1 Assign categories using string function Solutionv2.xlsx
171.79 KB
~Get Your Files Here !/4. Cleaning and unifying data/3. How to divide 1 data into 2.mp4
9.99 MB
~Get Your Files Here !/4. Cleaning and unifying data/3. How to divide 1 data into 2.srt
3.74 KB
~Get Your Files Here !/4. Cleaning and unifying data/3.1 Dividing - Empty.xlsx
38.15 KB
~Get Your Files Here !/4. Cleaning and unifying data/3.2 Dividing - Solution.xlsx
39.83 KB
~Get Your Files Here !/4. Cleaning and unifying data/4. How to join 2 data into 1.mp4
4.24 MB
~Get Your Files Here !/4. Cleaning and unifying data/4. How to join 2 data into 1.srt
1.56 KB
~Get Your Files Here !/4. Cleaning and unifying data/4.1 Join-Empty.xlsx
39.32 KB
~Get Your Files Here !/4. Cleaning and unifying data/4.2 Join-Solution.xlsx
39.75 KB
~Get Your Files Here !/4. Cleaning and unifying data/5. How you can standarize data.mp4
13.33 MB
~Get Your Files Here !/4. Cleaning and unifying data/5. How you can standarize data.srt
4.75 KB
~Get Your Files Here !/4. Cleaning and unifying data/5.1 Standardize data-Empty.xlsx
45.9 KB
~Get Your Files Here !/4. Cleaning and unifying data/5.2 Standardize data-Solutionv2.xlsx
48.91 KB
~Get Your Files Here !/4. Cleaning and unifying data/6. Example of unifying data - Saturating existing markets – Introduction.mp4
10.71 MB
~Get Your Files Here !/4. Cleaning and unifying data/6. Example of unifying data - Saturating existing markets – Introduction.srt
1.89 KB
~Get Your Files Here !/4. Cleaning and unifying data/6.1 Saturation point analysis v4 Empty.xlsx
106.64 KB
~Get Your Files Here !/4. Cleaning and unifying data/7. Saturating existing markets – Data for the case study.mp4
28.13 MB
~Get Your Files Here !/4. Cleaning and unifying data/7. Saturating existing markets – Data for the case study.srt
4.94 KB
~Get Your Files Here !/4. Cleaning and unifying data/7.1 Saturation point analysis v4 - Empty with structure.xlsx
231.24 KB
~Get Your Files Here !/4. Cleaning and unifying data/7.2 Saturation point analysis v4 Empty.xlsx
106.64 KB
~Get Your Files Here !/4. Cleaning and unifying data/8. Saturating existing markets – Number of Stores.mp4
31.53 MB
~Get Your Files Here !/4. Cleaning and unifying data/8. Saturating existing markets – Number of Stores.srt
5.03 KB
~Get Your Files Here !/4. Cleaning and unifying data/8.1 Saturation point analysis v4.xlsx
354.04 KB
~Get Your Files Here !/4. Cleaning and unifying data/9. Saturating existing markets – Stores by concepts.mp4
33.16 MB
~Get Your Files Here !/4. Cleaning and unifying data/9. Saturating existing markets – Stores by concepts.srt
4.56 KB
~Get Your Files Here !/5. How to use IF function and what you can do instead/1. Why NOT to use IF function.mp4
3.21 MB
~Get Your Files Here !/5. How to use IF function and what you can do instead/1. Why NOT to use IF function.srt
2.49 KB
~Get Your Files Here !/5. How to use IF function and what you can do instead/2. How to use IF function.mp4
3.77 MB
~Get Your Files Here !/5. How to use IF function and what you can do instead/2. How to use IF function.srt
2.53 KB
~Get Your Files Here !/5. How to use IF function and what you can do instead/2.1 Motivation system with IFs.xlsx
40.68 KB
~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
7.56 MB
~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
4.54 KB
~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
40.73 KB
~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
40.76 KB
~Get Your Files Here !/5. How to use IF function and what you can do instead/4. How to use IFERROR function.mp4
5.27 MB
~Get Your Files Here !/5. How to use IF function and what you can do instead/4. How to use IFERROR function.srt
2.84 KB
~Get Your Files Here !/5. How to use IF function and what you can do instead/4.1 Motivation system IFERROR -Empty.xlsx
40.72 KB
~Get Your Files Here !/5. How to use IF function and what you can do instead/4.2 Motivation system IFERROR -Solution.xlsx
40.77 KB
~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
7.13 MB
~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
5.11 KB
~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
40.77 KB
~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
40.82 KB
~Get Your Files Here !/6. Pivot Tables/1. Pivot tables - introduction.mp4
2.21 MB
~Get Your Files Here !/6. Pivot Tables/1. Pivot tables - introduction.srt
1.88 KB
~Get Your Files Here !/6. Pivot Tables/2. How to use pivot tables.mp4
12.06 MB
~Get Your Files Here !/6. Pivot Tables/2. How to use pivot tables.srt
7.29 KB
~Get Your Files Here !/6. Pivot Tables/2.1 Sales desnsity analysisv5 - Empty.xlsx
446.14 KB
~Get Your Files Here !/6. Pivot Tables/2.2 Sales desnsity analysisv5 - Solution.xlsx
454.55 KB
~Get Your Files Here !/6. Pivot Tables/3. How to use pivot charts.mp4
6.08 MB
~Get Your Files Here !/6. Pivot Tables/3. How to use pivot charts.srt
3.29 KB
~Get Your Files Here !/6. Pivot Tables/3.1 Sales desnsity analysisv5 - Pivot Charts - Empty.xlsx
454.55 KB
~Get Your Files Here !/6. Pivot Tables/3.2 Sales desnsity analysisv5 - Pivot Charts - Solution.xlsx
465.95 KB
~Get Your Files Here !/6. Pivot Tables/3.3 Sales desnsity analysisv5 Pivot Charts Solution - Mac.xlsx
432.85 KB
~Get Your Files Here !/6. Pivot Tables/4. How to combine pivot tables with regular calculations.mp4
4.73 MB
~Get Your Files Here !/6. Pivot Tables/4. How to combine pivot tables with regular calculations.srt
2.9 KB
~Get Your Files Here !/6. Pivot Tables/4.1 Sales desnsity analysisv5 - Add Calculation - Empty.xlsx
465.95 KB
~Get Your Files Here !/6. Pivot Tables/4.2 Sales desnsity analysisv5 - Add Calculation - Solution.xlsx
484.38 KB
~Get Your Files Here !/6. Pivot Tables/5. How to use slicers.mp4
4.55 MB
~Get Your Files Here !/6. Pivot Tables/5. How to use slicers.srt
2.65 KB
~Get Your Files Here !/6. Pivot Tables/5.1 Sales desnsity analysisv5 - Slicer - Empty.xlsx
477.68 KB
~Get Your Files Here !/6. Pivot Tables/5.2 Sales desnsity analysisv5 - Slicer - Solution.xlsx
484.61 KB
~Get Your Files Here !/6. Pivot Tables/6. How to replace pivot tables with SUMIFS and COUNTIFS.mp4
9.28 MB
~Get Your Files Here !/6. Pivot Tables/6. How to replace pivot tables with SUMIFS and COUNTIFS.srt
4.55 KB
~Get Your Files Here !/6. Pivot Tables/6.1 Sales desnsity analysisv5 - Sumifs - Empty.xlsx
469.18 KB
~Get Your Files Here !/6. Pivot Tables/6.2 Sales desnsity analysisv5 - Sumifs - Solution.xlsx
468.53 KB
~Get Your Files Here !/6. Pivot Tables/7. Going from general to specific with pivots.mp4
4.93 MB
~Get Your Files Here !/6. Pivot Tables/7. Going from general to specific with pivots.srt
2.43 KB
~Get Your Files Here !/6. Pivot Tables/7.1 Sales desnsity analysisv5 - General to specific - Empty.xlsx
485.36 KB
~Get Your Files Here !/6. Pivot Tables/7.2 Sales desnsity analysisv5 - General to specific - Solution.xlsx
490.61 KB
~Get Your Files Here !/6. Pivot Tables/8. Example of analyses using pivot tables- Analysis of sales channels for FMCG.mp4
5.9 MB
~Get Your Files Here !/6. Pivot Tables/8. Example of analyses using pivot tables- Analysis of sales channels for FMCG.srt
4.34 KB
~Get Your Files Here !/6. Pivot Tables/8.1 Sales channel FMCGv2.xlsx
49.07 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/1. Other useful functions and tools in Excel.mp4
7.32 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/1. Other useful functions and tools in Excel.srt
2.75 KB
~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
50.46 MB
~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
9.3 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/10.1 Planning the flows using Solver - Option 1.xlsx
1.09 MB
~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
24.47 MB
~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
4.09 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/11.1 Planning the flows using Solver - Option 2 - Solution.xlsx
1.09 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/11.2 Planning the flows using Solver - Option 2.xlsx
1.09 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/12. When can I retire – Introduction.mp4
14.86 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/12. When can I retire – Introduction.srt
1.77 KB
~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
148 B
~Get Your Files Here !/7. Other useful functions and tools in Excel/13. When can I retire – No passive income – Excel Basic.mp4
40.09 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/13. When can I retire – No passive income – Excel Basic.srt
7.94 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/13.1 Retiringv2.xlsx
41.6 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/14. When can I retire – No passive income – Go seek function.mp4
23.8 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/14. When can I retire – No passive income – Go seek function.srt
4.76 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/14.1 Retiringv2.xlsx
41.6 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/15. When can I retire – With passive income.mp4
19.26 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/15. When can I retire – With passive income.srt
3.39 KB
~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
148 B
~Get Your Files Here !/7. Other useful functions and tools in Excel/15.2 Retiringv2.xlsx
41.6 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/16. What will be the effect of the price increase – Introduction.mp4
11.92 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/16. What will be the effect of the price increase – Introduction.srt
3.24 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/16.1 Essential Concepts in Pricing.html
156 B
~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
34.73 MB
~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
5.91 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/17.1 Coffee shop - price increasev2.xlsx
46.88 KB
~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
22.27 MB
~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
3.82 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/18.1 Coffee shop - price increasev2.xlsx
46.88 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/18.2 Management Consulting Frameworks.html
160 B
~Get Your Files Here !/7. Other useful functions and tools in Excel/18.3 Sales and Marketing for Management Consultants.html
162 B
~Get Your Files Here !/7. Other useful functions and tools in Excel/2. Conditional Formating.mp4
11.67 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/2. Conditional Formating.srt
6.12 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/2.1 Conditional formating - Empty.xlsx
459.35 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/2.2 Conditional formating - Solution.xlsx
459.94 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/3. How to use indirect function.mp4
8.97 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/3. How to use indirect function.srt
3.98 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/3.1 Indirect - Hours - empty.xlsx
68.08 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/3.2 Indirect - Hours - solutionv2.xlsx
67.29 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/4. Histograms.mp4
8.65 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/4. Histograms.srt
3.6 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/4.1 Histogram - Empty.xlsx
454.72 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/4.2 Histogram - Solution.xlsx
461.68 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/5. Regression - introduction.mp4
4.17 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/5. Regression - introduction.srt
3.66 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/6. Regression - example.mp4
14.75 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/6. Regression - example.srt
7.99 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/6.1 Sales analysis regression-Emtpy.xlsx
387 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/6.2 Sales analysis regression-Solution.xlsx
405.7 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/7. Data validation.mp4
6.65 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/7. Data validation.srt
3.9 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/7.1 Data validation - Empty.xlsx
35.95 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/7.2 Data validation - Solution.xlsx
35.99 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/8. How to use SUMPRODUCT function.mp4
34.62 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/8. How to use SUMPRODUCT function.srt
8.65 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/8.1 Sumproduct function - Empty.xlsx
51.27 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/8.2 Sumproduct function - Solution.xlsx
50.37 KB
~Get Your Files Here !/7. Other useful functions and tools in Excel/9. Using solver – Planning the flow of finished goods – Introduction.mp4
4.17 MB
~Get Your Files Here !/7. Other useful functions and tools in Excel/9. Using solver – Planning the flow of finished goods – Introduction.srt
841 B
~Get Your Files Here !/8. Examples of analyses/1. Examples of analyses in Excel.mp4
5.92 MB
~Get Your Files Here !/8. Examples of analyses/1. Examples of analyses in Excel.srt
2.19 KB
~Get Your Files Here !/8. Examples of analyses/1.1 Essential Finance & Accounting for Management Consultants and Business Analysts.html
176 B
~Get Your Files Here !/8. Examples of analyses/10. How to create a waterfall chart.mp4
24.85 MB
~Get Your Files Here !/8. Examples of analyses/10. How to create a waterfall chart.srt
5.77 KB
~Get Your Files Here !/8. Examples of analyses/10.1 Saturation point analysis v4.xlsx
354.04 KB
~Get Your Files Here !/8. Examples of analyses/11. How to create scatter plot with Names.mp4
22.83 MB
~Get Your Files Here !/8. Examples of analyses/11. How to create scatter plot with Names.srt
5.27 KB
~Get Your Files Here !/8. Examples of analyses/11.1 How to come up with a business idea.html
141 B
~Get Your Files Here !/8. Examples of analyses/11.2 Ranking of new product for developmentv2 - with scatter chart.xlsx
46.56 KB
~Get Your Files Here !/8. Examples of analyses/11.3 Ranking of new product for developmentv2.xlsx
40.91 KB
~Get Your Files Here !/8. Examples of analyses/2. Sales channel analysis - case in FMCG.mp4
8.39 MB
~Get Your Files Here !/8. Examples of analyses/2. Sales channel analysis - case in FMCG.srt
4.35 KB
~Get Your Files Here !/8. Examples of analyses/2.1 Essential Sales Forecasting.html
161 B
~Get Your Files Here !/8. Examples of analyses/2.2 Examples of other sales analysis.html
162 B
~Get Your Files Here !/8. Examples of analyses/2.3 How to become world class business analyst.html
140 B
~Get Your Files Here !/8. Examples of analyses/2.4 Sales channel FMCGv2.xlsx
49.07 KB
~Get Your Files Here !/8. Examples of analyses/3. Efficiency of marketing activities.mp4
22.31 MB
~Get Your Files Here !/8. Examples of analyses/3. Efficiency of marketing activities.srt
11.5 KB
~Get Your Files Here !/8. Examples of analyses/3.1 Examples of other sales analysis.html
162 B
~Get Your Files Here !/8. Examples of analyses/3.2 Examples of sales analysis for Management Consultants.html
162 B
~Get Your Files Here !/8. Examples of analyses/3.3 Marketing efficiencyv2.xlsx
52.48 KB
~Get Your Files Here !/8. Examples of analyses/4. Model of E-commerce.mp4
23.14 MB
~Get Your Files Here !/8. Examples of analyses/4. Model of E-commerce.srt
13.01 KB
~Get Your Files Here !/8. Examples of analyses/4.1 e-commerce_EN.xlsx
52.92 KB
~Get Your Files Here !/8. Examples of analyses/4.2 Financial Analysis for Management Consultants & Analysts.html
184 B
~Get Your Files Here !/8. Examples of analyses/4.3 Low cost business models - overview.html
132 B
~Get Your Files Here !/8. Examples of analyses/4.4 On-line business models.html
140 B
~Get Your Files Here !/8. Examples of analyses/5. Expansion strategy into other countries – Case Introduction.mp4
13.96 MB
~Get Your Files Here !/8. Examples of analyses/5. Expansion strategy into other countries – Case Introduction.srt
3.71 KB
~Get Your Files Here !/8. Examples of analyses/6. Expansion strategy into other countries – Data for the case study.mp4
39.11 MB
~Get Your Files Here !/8. Examples of analyses/6. Expansion strategy into other countries – Data for the case study.srt
5.74 KB
~Get Your Files Here !/8. Examples of analyses/6.1 Expansion ranking of countriesv4 Empty.xlsx
55.84 KB
~Get Your Files Here !/8. Examples of analyses/7. Expansion strategy into other countries – Which function to use.mp4
54.81 MB
~Get Your Files Here !/8. Examples of analyses/7. Expansion strategy into other countries – Which function to use.srt
7.54 KB
~Get Your Files Here !/8. Examples of analyses/7.1 Expansion ranking of countriesv4.xlsx
72.35 KB
~Get Your Files Here !/8. Examples of analyses/8. Expansion strategy into other countries – Solution in Excel.mp4
45.1 MB
~Get Your Files Here !/8. Examples of analyses/8. Expansion strategy into other countries – Solution in Excel.srt
5.58 KB
~Get Your Files Here !/8. Examples of analyses/8.1 Expansion ranking of countriesv4.xlsx
72.35 KB
~Get Your Files Here !/8. Examples of analyses/9. Expansion strategy into other countries – Solution in Power Point.mp4
14.17 MB
~Get Your Files Here !/8. Examples of analyses/9. Expansion strategy into other countries – Solution in Power Point.srt
3.84 KB
~Get Your Files Here !/8. Examples of analyses/9.1 Expansion ranking of countriesv4.xlsx
72.35 KB
~Get Your Files Here !/9. Basic VBA usage - example/1. Logistics system simulation - introduction.mp4
11.35 MB
~Get Your Files Here !/9. Basic VBA usage - example/1. Logistics system simulation - introduction.srt
6.73 KB
~Get Your Files Here !/9. Basic VBA usage - example/1.1 Case 5 - Simulation - introduction and tasks.doc
28.5 KB
~Get Your Files Here !/9. Basic VBA usage - example/1.2 distribution system simulation-empty.xlsm
28.78 KB
~Get Your Files Here !/9. Basic VBA usage - example/2. Logistic system simulation - tips how to do it.mp4
21.95 MB
~Get Your Files Here !/9. Basic VBA usage - example/2. Logistic system simulation - tips how to do it.srt
12.66 KB
~Get Your Files Here !/9. Basic VBA usage - example/2.1 distribution system simulation-partial result v2.xlsm
59.2 KB
~Get Your Files Here !/9. Basic VBA usage - example/3. Logistic system simulation - final solution.mp4
23.97 MB
~Get Your Files Here !/9. Basic VBA usage - example/3. Logistic system simulation - final solution.srt
12.64 KB
~Get Your Files Here !/9. Basic VBA usage - example/3.1 distribution system simulation-final solutionv3.xlsm
58.41 KB
~Get Your Files Here !/9. Basic VBA usage - example/3.2 How to improve the cash flow of the firm.html