Download Udmey - Beginner to Pro in Excel: Financial Modeling and Valuation [TP} Torrent

Torrent Contents Size: 4.72 GB

Udmey - Beginner to Pro in Excel: Financial Modeling and Valuation [TP}

▼ show more 843 files

1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!

1. What does the course cover.mp4	MP4	8.94 MB
1. What does the course cover.vtt	VTT	3.11 KB
1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf	PDF	19.03 MB
2. Bonus! Welcome gift.html	HTML	164 B
3. Welcome gift number 2.html	HTML	164 B
4. The best way to take this course.mp4	MP4	20.16 MB
4. The best way to take this course.vtt	VTT	2.48 KB
5. Download all course materials.html	HTML	775 B

1. Excel best practices - Welcome lecture.mp4	MP4	2.13 MB
1. Excel best practices - Welcome lecture.vtt	VTT	1.02 KB
10. Learn how to organize your data with Text to Columns.html	HTML	160 B
11. Learn how to use the Wrap Text button.mp4	MP4	2.15 MB
11. Learn how to use the Wrap Text button.vtt	VTT	869 B
11.1 24. Wrap-Text-Exercise - Solved.xlsx.xlsx	XLSX	10.2 KB
11.2 24. Wrap-text-Lecture - Solved.xlsx.xlsx	XLSX	9.61 KB
11.3 24. Wrap-Text-Exercise - Unsolved.xlsx.xlsx	XLSX	10.17 KB
11.4 24. Wrap-text-Lecture - Unsolved.xlsx.xlsx	XLSX	9.61 KB
11.5 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
12. Create easily printable documents in Excel by using Set Print Area.mp4	MP4	4.74 MB
12. Create easily printable documents in Excel by using Set Print Area.vtt	VTT	1.5 KB
12.1 25. Set-Print-Area-Lecture - Unsolved.xlsx.xlsx	XLSX	11.42 KB
12.2 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx	XLSX	11.22 KB
12.3 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
13. Find and select special types of cells with Select Special (F5).mp4	MP4	9.78 MB
13. Find and select special types of cells with Select Special (F5).vtt	VTT	1.83 KB
13.1 26. Select-Special-Lecture.xlsx.xlsx	XLSX	10.56 KB
13.2 26. Select-Special-F5-Exercise - Solved.xlsx.xlsx	XLSX	22.27 KB
13.3 26. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx	XLSX	21.59 KB
13.4 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
14. Select Special.html	HTML	160 B
15. Learn how to assign dynamic names within a financial model.mp4	MP4	7.32 MB
15. Learn how to assign dynamic names within a financial model.vtt	VTT	1.56 KB
15.1 27. Dynamic-Naming-Lecture - Unsolved.xlsx.xlsx	XLSX	13.54 KB
15.2 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
15.3 27. Assigning-Dynamic-Names-Exercise - Solved.xlsx.xlsx	XLSX	11.73 KB
15.4 27. Dynamic-Naming-Lecture - Solved.xlsx.xlsx	XLSX	13.83 KB
15.5 27. Assigning-Dynamic-Names-Exercise - Unsolved.xlsx.xlsx	XLSX	11.23 KB
16. Assigning dynamic names.html	HTML	160 B
17. Define a named range in Excel.mp4	MP4	5.42 MB
17. Define a named range in Excel.vtt	VTT	1.62 KB
17.1 28. Defining-a-Named-Range-Exercise - Unsolved.xlsx.xlsx	XLSX	11.07 KB
17.2 28. Naming-ranges-Lecture - Unsolved.xlsx.xlsx	XLSX	8.79 KB
17.3 28. Naming-ranges-Lecture - Solved.xlsx.xlsx	XLSX	10.34 KB
17.4 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
17.5 28. Defining-a-Named-Range-Exercise - Solved.xlsx.xlsx	XLSX	11.65 KB
18. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4	MP4	5.41 MB
18. Assign custom formats to specific cells within a financial model (e.g Multiples).vtt	VTT	1.87 KB
18.1 29. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx	XLSX	11.35 KB
18.2 Useful-Tips-Tools.pdf.pdf	PDF	3.3 MB
18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx	XLSX	11.08 KB
19. Macros are a great timesaver! Here's why!.mp4	MP4	11.1 MB
19. Macros are a great timesaver! Here's why!.vtt	VTT	3.34 KB
19.1 Useful-Tips-Tools.pdf.pdf	PDF	3.3 MB
19.2 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx	XLSX	11.17 KB
19.3 30. Macros-Exercise - Solved.xlsx.xlsx	XLSX	145.02 KB
19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx	XLSX	9.66 KB
19.5 30. Macros-Exercise - Unsolved.xlsx.xlsx	XLSX	10.34 KB
2. Initial formatting of an Excel sheet to render it professional.mp4	MP4	7.99 MB
2. Initial formatting of an Excel sheet to render it professional.vtt	VTT	2.16 KB
2.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx	XLSX	10.63 KB
2.2 18. Formatting-a-Worksheet-Exercise - Solved.xlsx.xlsx	XLSX	10.76 KB
2.3 Useful-Tips-Tools.pdf.pdf	PDF	3.3 MB
2.4 18. Formatting-a-worksheet-Lecture - Solved.xlsx.xlsx	XLSX	9.56 KB
2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx	XLSX	8.98 KB
20. How to save macros and use them across several workbooks.mp4	MP4	12.78 MB
20. How to save macros and use them across several workbooks.vtt	VTT	1.72 KB
20.1 31. Another-file.xlsx.xlsx	XLSX	8.81 KB
20.2 31. How-to-save-macros-Lecture-before.xlsx.xlsx	XLSX	6.02 KB
20.3 31. How-to-save-macros-Lecture-after.xlsm.xlsm	XLSM	12.59 KB
21. Excel Macros - quiz.html	HTML	160 B
22. Create a drop-down list by using Data Validation.mp4	MP4	10.59 MB
22. Create a drop-down list by using Data Validation.vtt	VTT	2.1 KB
22.1 32. Data-Validation-Lecture - Solved.xlsx.xlsx	XLSX	10.84 KB
22.2 32. Drop-down-List-Exercise - Solved.xlsx.xlsx	XLSX	77.02 KB
22.3 32. Drop-down-List-Exercise - Unsolved.xlsx.xlsx	XLSX	11.34 KB
22.4 32. Data-Validation-Lecture - Unsolved.xlsx.xlsx	XLSX	10.84 KB
22.5 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
23. Using Custom-sort in order to sort multiple columns within a table.mp4	MP4	9.15 MB
23. Using Custom-sort in order to sort multiple columns within a table.vtt	VTT	1.59 KB
23.1 33. Custom-Sort-Exercise - Unsolved.xlsx.xlsx	XLSX	11.37 KB
23.2 33. Sort-data-Lecture - Solved.xlsx.xlsx	XLSX	145.65 KB
23.3 33. Sort-data-Lecture - Unsolved.xlsx.xlsx	XLSX	145.35 KB
23.4 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
23.5 33. Custom-Sort-Exercise - Solved.xlsx.xlsx	XLSX	11.46 KB
24. Create a great Index page at the beginning of your models - Hyperlinks.mp4	MP4	5.35 MB
24. Create a great Index page at the beginning of your models - Hyperlinks.vtt	VTT	1.51 KB
24.1 34. Hyperlinks-Exercise - Unsolved.xlsx.xlsx	XLSX	136.89 KB
24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx	XLSX	137.06 KB
24.3 Useful-Tips-Tools.pdf.pdf	PDF	3.3 MB
25. Fix the top row of your table with Freeze Panes.mp4	MP4	17.67 MB
25. Fix the top row of your table with Freeze Panes.vtt	VTT	1.42 KB
25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx	XLSX	643.87 KB
25.2 35. Freeze-Panes-Lecture - Solved.xlsx.xlsx	XLSX	643.94 KB
25.3 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
26. Filter by color - an excellent tool.mp4	MP4	9.88 MB
26. Filter by color - an excellent tool.vtt	VTT	1.99 KB
26.1 36. Exercise-Filter-by-Color-Unsolved.xlsx.xlsx	XLSX	20.47 KB
26.2 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx	XLSX	153.48 KB
27. Working with conditional formatting.mp4	MP4	15.08 MB
27. Working with conditional formatting.vtt	VTT	5.61 KB
27.1 Solution_Conditional Formatting.xlsx.xlsx	XLSX	51.52 KB
27.2 Exercise_Conditional Formatting.xlsx.xlsx	XLSX	12.88 KB
28. A neat trick - Multiply by 1.mp4	MP4	14.84 MB
28. A neat trick - Multiply by 1.vtt	VTT	1.64 KB
28.1 38. Multiply-by-1-Lecture-before.xlsx.xlsx	XLSX	16.47 KB
28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx	XLSX	17.21 KB
29. Useful tips and tools for your work in Excel - quiz.html	HTML	159 B
3. Fast scrolling through Excel sheets.mp4	MP4	22.16 MB
3. Fast scrolling through Excel sheets.vtt	VTT	1.73 KB
3.1 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
3.2 19. Fast-Scrolling-Exercise - Unsolved.xlsx.xlsx	XLSX	43.9 KB
3.3 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx	XLSX	44.35 KB
3.4 19. Fast-Scrolling - Lecture.xlsx.xlsx	XLSX	642.82 KB
30. Find and replace - references.mp4	MP4	24.04 MB
30. Find and replace - references.vtt	VTT	3.32 KB
30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx	XLSX	37.91 KB
30.2 39. Find-and-Replace-references-Lecture-before.xlsx.xlsx	XLSX	38.79 KB
31. Find and replace - formatting.mp4	MP4	13.78 MB
31. Find and replace - formatting.vtt	VTT	1.88 KB
31.1 40. Find-replace-Lecture-before.xlsx.xlsx	XLSX	17.19 KB
31.2 40. Find-replace-Lecture-after.xlsx.xlsx	XLSX	17.19 KB
32. Removing (automatic) green arrows.mp4	MP4	12.6 MB
32. Removing (automatic) green arrows.vtt	VTT	1.63 KB
32.1 41. Green-references-Lecture.xlsx.xlsx	XLSX	12 KB
33. Beauty saving - The professional way of saving files.mp4	MP4	14.02 MB
33. Beauty saving - The professional way of saving files.vtt	VTT	2.59 KB
33.1 42. Beauty-saving-Lecture-before.xlsx.xlsx	XLSX	17.17 KB
33.2 42. Beauty-saving-Lecture-after.xlsx.xlsx	XLSX	17.05 KB
34. Formula auditing with F2.mp4	MP4	17.74 MB
34. Formula auditing with F2.vtt	VTT	2.14 KB
34.1 43. F2-Lecture.xlsm.xlsm	XLSM	50.76 KB
4. Be even quicker F5 + Enter.mp4	MP4	19.78 MB
4. Be even quicker F5 + Enter.vtt	VTT	2.11 KB
4.1 20. F5-go-to - Lecture.xlsm.xlsm	XLSM	50.76 KB
5. Fast scrolling through Excel sheets.html	HTML	160 B
6. Introduction to fixing of cell references.mp4	MP4	20.37 MB
6. Introduction to fixing of cell references.vtt	VTT	2.53 KB
6.1 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
6.2 21. Fixing-Cells-Exercise - Unsolved.xlsx.xlsx	XLSX	10.67 KB
6.3 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx	XLSX	643.98 KB
6.4 21. Fixing-Cells-Exercise - Solved.xlsx.xlsx	XLSX	10.82 KB
6.5 21. Fixing-references-Lecture - Solved.xlsx.xlsx	XLSX	645.17 KB
7. Introduction to fixing of cell references.html	HTML	160 B
8. Using the 'Alt + Enter' combination.mp4	MP4	3.33 MB
8. Using the 'Alt + Enter' combination.vtt	VTT	1008 B
8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx	XLSX	11.12 KB
8.2 22. Alt-Enter- Lecture - Unsolved.xlsx.xlsx	XLSX	9.64 KB
8.3 22. Alt-Enter- Lecture - Solved.xlsx.xlsx	XLSX	9.65 KB
8.4 22. Alt-Enter-Exercise - Solved.xlsx.xlsx	XLSX	11.4 KB
9. Learn how to organize your data with Text to Columns.mp4	MP4	12.54 MB
9. Learn how to organize your data with Text to Columns.vtt	VTT	2.21 KB
9.1 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx	XLSX	11.3 KB
9.2 23. Text-to-Columns-Exercise - Unsolved.xlsx.xlsx	XLSX	10.57 KB
9.3 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx	XLSX	9.76 KB
9.4 Useful-Tips-Tools.pdf.pdf	PDF	3.31 MB
9.5 23.Text-to-columns-Lecture - Solved.xlsx.xlsx	XLSX	9.9 KB

1. Excel's key functions - Welcome lecture.mp4	MP4	2.31 MB
1. Excel's key functions - Welcome lecture.vtt	VTT	1.09 KB
10. Working with text in Excel.mp4	MP4	16.01 MB
10. Working with text in Excel.vtt	VTT	3.03 KB
10.1 53. Work-with-text-Lecture-after.xlsx.xlsx	XLSX	10.91 KB
10.2 53. Work-with-text-Lecture-before.xlsx.xlsx	XLSX	10.33 KB
11. Find the minimum or maximum value in a range of cells in Excel.mp4	MP4	5.91 MB
11. Find the minimum or maximum value in a range of cells in Excel.vtt	VTT	1.09 KB
11.1 54. Max-min-Lecture - Unsolved.xlsx.xlsx	XLSX	8.95 KB
11.2 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx	XLSX	14.39 KB
11.3 54. Max-min-Lecture - Solved.xlsx.xlsx	XLSX	9.23 KB
11.4 54. MIN-MAX-Exercise - Solved.xlsx.xlsx	XLSX	14.8 KB
12. Include ROUND in your financial models.mp4	MP4	3.13 MB
12. Include ROUND in your financial models.vtt	VTT	1.14 KB
12.1 Excel-Functions.pdf.pdf	PDF	3.18 MB
12.2 55. Excel-functions-Lecture.xlsx.xlsx	XLSX	889.91 KB
12.3 55. Round-Exercise - Unsolved.xlsx.xlsx	XLSX	11.34 KB
12.4 55. Round-Exercise - Solved.xlsx.xlsx	XLSX	11.71 KB
13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp4	MP4	34.59 MB
13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.vtt	VTT	8.45 KB
13.1 56. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx	XLSX	10.74 KB
13.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx	XLSX	11.13 KB
13.3 Excel-Functions.pdf.pdf	PDF	3.19 MB
13.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx	XLSX	13.68 KB
13.5 56. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx	XLSX	11.95 KB
14. How to enlarge the formula bar.mp4	MP4	6.26 MB
14. How to enlarge the formula bar.vtt	VTT	1.37 KB
14.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm	XLSM	46.89 KB
15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp4	MP4	38.95 MB
15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.vtt	VTT	8.22 KB
15.1 58. Index-Match-Lecture - Solved.xlsx.xlsx	XLSX	11.7 KB
15.2 Excel-Functions.pdf.pdf	PDF	3.18 MB
15.3 58. Index-Match-Exercise - Solved.xlsx.xlsx	XLSX	12.08 KB
15.4 58. Index-Match-Lecture - Unsolved.xlsx.xlsx	XLSX	11.29 KB
15.5 58. Index-Match-Exercise - Unsolved.xlsx.xlsx	XLSX	11.59 KB
16. A great Excel technique INDEX, MATCH, MATCH.mp4	MP4	11.76 MB
16. A great Excel technique INDEX, MATCH, MATCH.vtt	VTT	5.27 KB
16.1 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx	XLSX	12.21 KB
16.2 59. Exercise-Index-Match-Match-Unsolved.xlsx.xlsx	XLSX	11.58 KB
17. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html	HTML	160 B
18. Using Excel's IFERROR function to trap spreadsheet errors.mp4	MP4	7.52 MB
18. Using Excel's IFERROR function to trap spreadsheet errors.vtt	VTT	2.05 KB
18.1 60. Iferror - Lecture - Unsolved.xlsm.xlsm	XLSM	897.26 KB
18.2 60. Iferror-Exercise - Solved.xlsx.xlsx	XLSX	15.37 KB
18.3 60. Iferror-Exercise - Unsolved.xlsx.xlsx	XLSX	14.26 KB
18.4 Excel-Functions.pdf.pdf	PDF	3.19 MB
18.5 60. Iferror - Lecture - Solved.xlsm.xlsm	XLSM	896.43 KB
19. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4	MP4	23.24 MB
19. RANK is a valuable tool when using Excel for Financial and Business analysis.vtt	VTT	2.82 KB
19.1 61. Rank-function-Lecture-after.xlsx.xlsx	XLSX	12.61 KB
19.2 61. Rank-function-Lecture-before.xlsx.xlsx	XLSX	12.27 KB
2. Key functions in Excel IF.mp4	MP4	16.65 MB
2. Key functions in Excel IF.vtt	VTT	2.87 KB
2.1 47. IF-function--Lecture-before.xlsm.xlsm	XLSM	17 KB
2.2 Functions - English to German.pdf.pdf	PDF	102.32 KB
2.3 Key functions - Excel.pdf.pdf	PDF	8.46 MB
2.4 47. IF-function-Lecture-after.xlsm.xlsm	XLSM	17.94 KB
2.5 Functions - English to Spanish.pdf.pdf	PDF	102.37 KB
2.6 Functions - English to Portuguese.pdf.pdf	PDF	146.09 KB
20. Learn how to render your models flexible with CHOOSE.mp4	MP4	8.98 MB
20. Learn how to render your models flexible with CHOOSE.vtt	VTT	2.64 KB
20.1 62. Choose-Lecture - Unsolved.xlsx.xlsx	XLSX	9.33 KB
20.2 62. Choose-Lecture - Solved.xlsx.xlsx	XLSX	9.69 KB
20.3 62. Choose-Exercise-Solved.xlsx.xlsx	XLSX	11.73 KB
20.4 Excel-Functions.pdf.pdf	PDF	3.19 MB
20.5 62. Choose-Exercise - Unsolved.xlsx.xlsx	XLSX	11.32 KB
21. Use Goal Seek to find the result that you are looking for.mp4	MP4	7.86 MB
21. Use Goal Seek to find the result that you are looking for.vtt	VTT	2.56 KB
21.1 63. Goal-Seek-Exercise - Unsolved.xlsx.xlsx	XLSX	16.09 KB
21.2 Excel-Functions.pdf.pdf	PDF	3.19 MB
21.3 63. Goal-Seek-Exercise-Solved.xlsx.xlsx	XLSX	16.21 KB
21.4 63. Goal-Seek-Lecture - Solved.xlsx.xlsx	XLSX	9.17 KB
21.5 63. Goal-Seek-Lecture - Unsolved.xlsx.xlsx	XLSX	9.15 KB
22. Use Goal Seek in order to find the result that you are looking for.html	HTML	160 B
23. Include sensitivity analysis in your models through Data Tables.mp4	MP4	14.29 MB
23. Include sensitivity analysis in your models through Data Tables.vtt	VTT	4.65 KB
23.1 64. Sensitivity analysis - Lecture - Solved.xlsm.xlsm	XLSM	897.3 KB
23.2 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm	XLSM	66.82 KB
23.3 64. Sensitivity-analysis-Exercise-Solved.xlsm.xlsm	XLSM	63.87 KB
23.4 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm	XLSM	897.09 KB
24. Include sensitivity analysis in your models through Data Tables.html	HTML	160 B
25. Excel's dynamic and interactive tables Pivot tables.mp4	MP4	16.59 MB
25. Excel's dynamic and interactive tables Pivot tables.vtt	VTT	2.58 KB
25.1 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm	XLSM	687.83 KB
25.2 65. Pivot Tables - Exercise - Unsolved.xlsx.xlsx	XLSX	152.17 KB
25.3 65. Pivot tables - Lecture - Solved.xlsm.xlsm	XLSM	897.26 KB
25.4 65. Pivot Tables - Exercise - Solved.xlsx.xlsx	XLSX	190.47 KB
26. Excel's key functions and functionalities made easy.html	HTML	159 B
3. Key Excel functions SUM, SUMIF and SUMIFS.mp4	MP4	19.32 MB
3. Key Excel functions SUM, SUMIF and SUMIFS.vtt	VTT	4.92 KB
3.1 48. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx	XLSX	12.93 KB
3.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx	XLSX	13.01 KB
3.3 48. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx	XLSX	14.46 KB
3.4 Excel-Functions.pdf.pdf	PDF	3.18 MB
3.5 48. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx	XLSX	14.84 KB
4. = and + are interchangeable when you start typing a formula.mp4	MP4	5.79 MB
4. = and + are interchangeable when you start typing a formula.vtt	VTT	975 B
4.1 49. = and + are interchangeable -after.xlsm.xlsm	XLSM	17.04 KB
4.2 49. = and + are interchangeable - before.xlsm.xlsm	XLSM	17.01 KB
5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4	MP4	16.99 MB
5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.vtt	VTT	4.48 KB
5.1 50.Counts-Exercise-Solved.xlsx.xlsx	XLSX	16.07 KB
5.2 Excel-Functions.pdf.pdf	PDF	3.18 MB
5.3 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx	XLSX	11.68 KB
5.4 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx	XLSX	11.29 KB
5.5 50.Counts-Exercise-Unsolved.xlsx.xlsx	XLSX	15.56 KB
6. Key Excel functions AVERAGE and AVERAGEIF.mp4	MP4	7.86 MB
6. Key Excel functions AVERAGE and AVERAGEIF.vtt	VTT	2.24 KB
6.1 Excel-Functions.pdf.pdf	PDF	3.18 MB
6.2 51. Average-AverageIF-Exercise - Solved.xlsx.xlsx	XLSX	15.02 KB
6.3 51. Average-Averageif- Lecture - Unsolved.xlsx.xlsx	XLSX	9.03 KB
6.4 51. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx	XLSX	14.6 KB
6.5 51. Average-Averageif- Lecture - Solved.xlsx.xlsx	XLSX	9.4 KB
7. Key Excel functions AVERAGE and AVERAGEIF.html	HTML	160 B
8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4	MP4	16.8 MB
8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.vtt	VTT	5.3 KB
8.1 52. Text-Functions- Lecture - Solved.xlsx.xlsx	XLSX	11.1 KB
8.2 52. Text functions - Exercise - Unsolved.xlsx.xlsx	XLSX	11.71 KB
8.3 52. Text functions - Exercise - Solved.xlsx.xlsx	XLSX	12.24 KB
8.4 52. Text-Functions- Lecture - Unsolved.xlsx.xlsx	XLSX	10.6 KB
9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.html	HTML	160 B

1. Case study - Build a P&L from scratch - Welcome lecture.mp4	MP4	3.14 MB
1. Case study - Build a P&L from scratch - Welcome lecture.vtt	VTT	1.53 KB
10. Use INDEX & MATCH as a substitute for VLOOKUP.mp4	MP4	49.58 MB
10. Use INDEX & MATCH as a substitute for VLOOKUP.vtt	VTT	4.24 KB
10.1 87. Index Match-Lecture-before.xlsm.xlsm	XLSM	41.04 KB
10.2 87. Index Match-Lecture-after.xlsm.xlsm	XLSM	13.86 MB
11. Mapping the rows in the Database sheet.mp4	MP4	32.48 MB
11. Mapping the rows in the Database sheet.vtt	VTT	2.66 KB
11.1 88. Mapping-Lecture-after.xlsm.xlsm	XLSM	50.24 KB
11.2 88. Mapping_before.xlsm.xlsm	XLSM	50.55 KB
12. In case you have any doubts about the Mapping exercise.mp4	MP4	38.56 MB
12. In case you have any doubts about the Mapping exercise.vtt	VTT	6.34 KB
12.1 89. Mapping-Lecture-Unsolved.xlsm.xlsm	XLSM	50.55 KB
12.2 89. Mapping-exercise-explained.pdf.pdf	PDF	243.03 KB
12.3 89. Mapping-Lecture-Solved.xlsx.xlsx	XLSX	47.5 KB
13. Building the structure of the P&L sheet.mp4	MP4	20.86 MB
13. Building the structure of the P&L sheet.vtt	VTT	2.19 KB
13.1 90. Building a P&L-Lecture-before.xlsm.xlsm	XLSM	50.24 KB
13.2 90. Building a P&L-Lecture-after.xlsm.xlsm	XLSM	51.83 KB
14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4	MP4	25.42 MB
14. Formatting sets You apart from the competition in Excel - A Practical Example.vtt	VTT	22.02 MB
14.1 91. Formatting a P&L-Lecture-before.xlsm.xlsm	XLSM	51.84 KB
14.2 91. Formatting the P&L-Lecture-after.xlsm.xlsm	XLSM	51.96 KB
15. Populate the P&L sheet with SUMIF.mp4	MP4	30.26 MB
15. Populate the P&L sheet with SUMIF.vtt	VTT	2.92 KB
15.1 92. Formatting the P&L-Lecture-after.xlsm.xlsm	XLSM	53.51 KB
15.2 92. Formatting the P&L-Lecture-before.xlsm.xlsm	XLSM	52 KB
16. Learn how to find mistakes with COUNTIF.mp4	MP4	27.87 MB
16. Learn how to find mistakes with COUNTIF.vtt	VTT	2.8 KB
16.1 93. Countif-Lecture-after.xlsm.xlsm	XLSM	54.78 KB
16.2 93. Countif-Lecture-before.xlsm.xlsm	XLSM	53.51 KB
17. Calculating year-on-year percentage variations the proper way.mp4	MP4	29.98 MB
17. Calculating year-on-year percentage variations the proper way.vtt	VTT	3.24 KB
17.1 94. Adding % variations-Lecture-after.xlsm.xlsm	XLSM	56.51 KB
17.2 94. Adding % variations-Lecture-before.xlsm.xlsm	XLSM	54.78 KB
17.3 Y-o-Y Function explanation.pdf.pdf	PDF	164.92 KB
2. Introduction to the case study.mp4	MP4	10.21 MB
2. Introduction to the case study.vtt	VTT	1.09 KB
3. Understand your data source before you start working on it.mp4	MP4	28.16 MB
3. Understand your data source before you start working on it.vtt	VTT	2.99 KB
3.1 80. Get to know the data source.xlsm.xlsm	XLSM	43.03 KB
4. Order the source worksheets.mp4	MP4	26.54 MB
4. Order the source worksheets.vtt	VTT	2.41 KB
4.1 81. Order a worksheet_before.xlsm.xlsm	XLSM	43.08 KB
4.2 81. Order a worksheet_after.xlsm.xlsm	XLSM	41.01 KB
5. Create a code the best way to organize your data and work efficiently with it.mp4	MP4	24.49 MB
5. Create a code the best way to organize your data and work efficiently with it.vtt	VTT	2.17 KB
5.1 82. Creating a code_before.xlsm.xlsm	XLSM	41.01 KB
5.2 82. Creating a code_after.xlsm.xlsm	XLSM	41.73 KB
6. Learn how to create a database.mp4	MP4	20.7 MB
6. Learn how to create a database.vtt	VTT	2.15 KB
6.1 83. Creating a database_after.xlsm.xlsm	XLSM	39.39 KB
6.2 83. Creating a database_before.xlsm.xlsm	XLSM	41.73 KB
7. Use VLOOKUP to fill the Database sheet.mp4	MP4	61.57 MB
7. Use VLOOKUP to fill the Database sheet.vtt	VTT	5.4 KB
7.1 84. Vlookup_before.xlsm.xlsm	XLSM	39.5 KB
7.2 84. Vlookup_after.xlsm.xlsm	XLSM	44.45 KB
8. 50% Completed!.mp4	MP4	4.31 MB
8. 50% Completed!.vtt	VTT	51 B
9. Use SUMIF to complete the Database sheet.mp4	MP4	47.94 MB
9. Use SUMIF to complete the Database sheet.vtt	VTT	4.17 KB
9.1 86. Sumif_after.xlsm.xlsm	XLSM	49.53 KB
9.2 86. Sumif_before.xlsm.xlsm	XLSM	44.45 KB

10. Introduction to Excel charts

1. How to insert a chart in Excel.mp4	MP4	22.27 MB
1. How to insert a chart in Excel.vtt	VTT	2.57 KB
1.1 95. Inserting-Charts-Lecture.xlsm.xlsm	XLSM	11.45 MB
2. Editing Excel charts.mp4	MP4	26.05 MB
2. Editing Excel charts.vtt	VTT	2.9 KB
2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm	XLSM	11.45 MB
3. Excel chart formatting.mp4	MP4	32.74 MB
3. Excel chart formatting.vtt	VTT	3.4 KB
3.1 97. Modifying-a-Chart-Lecture.xlsm.xlsm	XLSM	11.4 MB
4. How to create a bridge chart in Excel.mp4	MP4	13.66 MB
4. How to create a bridge chart in Excel.vtt	VTT	1.92 KB
4.1 98. Bridge-Charts-Lecture.xlsx.xlsx	XLSX	13.1 KB
5. New ways to visualize your data - Treemap charts.mp4	MP4	11.49 MB
5. New ways to visualize your data - Treemap charts.vtt	VTT	1.67 KB
5.1 99. Treemap-Charts-Lecture.xlsx.xlsx	XLSX	12.62 KB
6. Sparklines.mp4	MP4	27.56 MB
6. Sparklines.vtt	VTT	4.17 KB
6.1 100. Sparklines-Lecture.xlsx.xlsx	XLSX	9.59 KB

1. Create professional and good-looking charts - Introduction.mp4	MP4	6.21 MB
1. Create professional and good-looking charts - Introduction.vtt	VTT	727 B
2. Build a column stacked chart with a secondary line axis in Excel.mp4	MP4	46.37 MB
2. Build a column stacked chart with a secondary line axis in Excel.vtt	VTT	5.63 KB
2.1 102. Column stacked chart-Lecture-before.xlsm.xlsm	XLSM	11.5 MB
2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm	XLSM	11.5 MB
3. Learn how to build effective doughnut charts in Excel.mp4	MP4	38 MB
3. Learn how to build effective doughnut charts in Excel.vtt	VTT	5.42 KB
3.1 103. Doughnut chart-Lecture-after.xlsm.xlsm	XLSM	11.51 MB
3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm	XLSM	11.52 MB
4. Learn how to build an area chart in Excel.mp4	MP4	28.58 MB
4. Learn how to build an area chart in Excel.vtt	VTT	3.48 KB
4.1 104. Area chart-Lecture-after.xlsm.xlsm	XLSM	11.52 MB
4.2 104. Area chart-Lecture-before.xlsm.xlsm	XLSM	11.51 MB
5. Learn how to create bridge charts.mp4	MP4	52.07 MB
5. Learn how to create bridge charts.vtt	VTT	7.45 KB
5.1 105. Bridge chart-Lecture-after.xlsm.xlsm	XLSM	11.54 MB
5.2 105. Bridge chart-Lecture-before.xlsm.xlsm	XLSM	11.52 MB
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4	MP4	136.12 MB
6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.vtt	VTT	11.75 KB
7. Case Study - Building a Complete P&L from scratch in Excel.html	HTML	159 B
8. Course Challenge - Apply your skills in practice!.mp4	MP4	7.92 MB
8. Course Challenge - Apply your skills in practice!.vtt	VTT	1.17 KB
8.1 107. Course-Challenge - Solved.xlsx.xlsx	XLSX	543.93 KB
8.2 107. Course-Challenge - Unsolved.xlsx.xlsx	XLSX	505.49 KB

12. Case Study - Building an FMCG Model from Scratch

1. Introduction to the Case Study.mp4	MP4	12.06 MB
1. Introduction to the Case Study.vtt	VTT	2.45 KB
1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx	XLSX	13.26 MB
10. Combining Slicers and GETPIVOTDATA The key to our success.mp4	MP4	17.84 MB
10. Combining Slicers and GETPIVOTDATA The key to our success.vtt	VTT	3.4 KB
10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx	XLSX	20.77 MB
11. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4	MP4	17.12 MB
11. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt	VTT	3.4 KB
11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx	XLSX	22.81 MB
12. This is how the report can be used in practice by high-level executives.mp4	MP4	19.81 MB
12. This is how the report can be used in practice by high-level executives.vtt	VTT	4.38 KB
12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx	XLSX	22.81 MB
13. Dynamic reporting with GETPIVOTDATA and slicers.html	HTML	163 B
2. Preliminary mapping of the data extraction.mp4	MP4	22.6 MB
2. Preliminary mapping of the data extraction.vtt	VTT	2.43 KB
2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx	XLSX	14.89 MB
3. Working with an SAP data extraction.mp4	MP4	21.95 MB
3. Working with an SAP data extraction.vtt	VTT	3.84 KB
4. Creating an output structure of the FMCG model.mp4	MP4	11.65 MB
4. Creating an output structure of the FMCG model.vtt	VTT	2.8 KB
4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx	XLSX	14.91 MB
5. Improving the layout and appearance of the FMCG report.mp4	MP4	13.5 MB
5. Improving the layout and appearance of the FMCG report.vtt	VTT	4.63 KB
5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx	XLSX	14.91 MB
6. Inserting formulas and automating calculations.mp4	MP4	8.84 MB
6. Inserting formulas and automating calculations.vtt	VTT	4.63 KB
6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx	XLSX	14.91 MB
7. Creating a Master Pivot Table The main data source for the FMCG report.mp4	MP4	13.83 MB
7. Creating a Master Pivot Table The main data source for the FMCG report.vtt	VTT	2.1 KB
7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx	XLSX	20.81 MB
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4	MP4	31.04 MB
8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt	VTT	6.68 KB
8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx	XLSX	20.81 MB
9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4	MP4	13.76 MB
9. A potential error with GETPIVOTDATA you might encounter and its fix.vtt	VTT	1.48 KB

13. Financial Modeling Fundamentals

1. Financial Modeling basics - Welcome lecture.mp4	MP4	2.1 MB
1. Financial Modeling basics - Welcome lecture.vtt	VTT	1.07 KB
10. Forecasting financials - Quiz.html	HTML	160 B
11. Building a complete model - Important considerations.mp4	MP4	6.44 MB
11. Building a complete model - Important considerations.vtt	VTT	2.72 KB
12. Modeling the Income statement.mp4	MP4	12.43 MB
12. Modeling the Income statement.vtt	VTT	7 KB
13. Modeling the Balance sheet - Part 1.mp4	MP4	5.22 MB
13. Modeling the Balance sheet - Part 1.vtt	VTT	3.18 KB
14. Modeling the Balance sheet - Part 2.mp4	MP4	9.38 MB
14. Modeling the Balance sheet - Part 2.vtt	VTT	5.72 KB
15. Building a financial model - Quiz.html	HTML	160 B
2. What is a financial model.mp4	MP4	4.59 MB
2. What is a financial model.vtt	VTT	2.35 KB
3. Why use financial models.mp4	MP4	7.69 MB
3. Why use financial models.vtt	VTT	3.11 KB
4. Financial modeling - worst practices - things you should avoid.mp4	MP4	19.91 MB
4. Financial modeling - worst practices - things you should avoid.vtt	VTT	6.86 KB
5. Financial modeling - best practices.mp4	MP4	17.22 MB
5. Financial modeling - best practices.vtt	VTT	5.69 KB
6. Financial modeling - The types of models that are built in practice.mp4	MP4	12.51 MB
6. Financial modeling - The types of models that are built in practice.vtt	VTT	5.49 KB
7. Financial modeling - Quiz.html	HTML	160 B
8. Financial modeling The right level of detail in a model.mp4	MP4	5.68 MB
8. Financial modeling The right level of detail in a model.vtt	VTT	2.93 KB
9. Financial modeling Forecasting guidelines.mp4	MP4	6.44 MB
9. Financial modeling Forecasting guidelines.vtt	VTT	3.34 KB

14. Introduction to Company Valuation

1. The core theory behind Company Valuation.html

HTML

164 B

15. Introduction to Mergers & Acquisitions

1. Introduction to Mergers & Acquisitions.html

HTML

164 B

1. Valuation Case study - Welcome lecture.mp4	MP4	1.78 MB
1. Valuation Case study - Welcome lecture.vtt	VTT	869 B
10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp4	MP4	30.01 MB
10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt	VTT	2.92 KB
10.1 9. Interest expenses, taxes_before.xlsm.xlsm	XLSM	50.57 KB
10.2 9. Interest expenses, taxes_after.xlsm.xlsm	XLSM	50.89 KB
11. Forecasting Balance sheet items.mp4	MP4	4.66 MB
11. Forecasting Balance sheet items.vtt	VTT	914 B
11.1 10. Introduction to Balance sheet items.xlsm.xlsm	XLSM	51.02 KB
12. An introduction to the Days methodology.mp4	MP4	10.08 MB
12. An introduction to the Days methodology.vtt	VTT	1.77 KB
12.1 Working Capital Days.pptx.pptx	PPTX	94.77 KB
13. Calculation of DSO, DPO and DOI for the historical period.mp4	MP4	12.11 MB
13. Calculation of DSO, DPO and DOI for the historical period.vtt	VTT	1.36 KB
13.1 12. Days calculation_before.xlsm.xlsm	XLSM	51.2 KB
13.2 12. Days calculation_after.xlsm.xlsm	XLSM	51.47 KB
14. Forecasting DSO, DPO and DOI.mp4	MP4	20.86 MB
14. Forecasting DSO, DPO and DOI.vtt	VTT	2.73 KB
14.1 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm	XLSM	51.47 KB
14.2 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm	XLSM	51.98 KB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp4	MP4	22.63 MB
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt	VTT	2.6 KB
15.1 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm	XLSM	52.88 KB
15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm	XLSM	51.98 KB
16. Creating an output P&L sheet.mp4	MP4	18.8 MB
16. Creating an output P&L sheet.vtt	VTT	2.32 KB
16.1 15. P&L structure_after.xlsm.xlsm	XLSM	53.67 KB
16.2 15. P&L structure_before.xlsm.xlsm	XLSM	53.6 KB
17. Populating the output P&L sheet.mp4	MP4	25.53 MB
17. Populating the output P&L sheet.vtt	VTT	2.44 KB
17.1 16. Populating the P&L sheet_after.xlsm.xlsm	XLSM	55.32 KB
17.2 16. Populating the P&L sheet_before.xlsm.xlsm	XLSM	53.67 KB
18. Populating the output BS sheet.mp4	MP4	16.93 MB
18. Populating the output BS sheet.vtt	VTT	1.75 KB
18.1 17. Populating BS sheet_before.xlsm.xlsm	XLSM	55.32 KB
18.2 17. Populating BS sheet_after.xlsm.xlsm	XLSM	57.18 KB
19. Completing the output BS sheet for the historical period.mp4	MP4	38.03 MB
19. Completing the output BS sheet for the historical period.vtt	VTT	4.09 KB
19.1 18. Completing the Balance Sheet_after.xlsm.xlsm	XLSM	58.1 KB
19.2 18. Completing the Balance Sheet_before.xlsm.xlsm	XLSM	57.18 KB
2. Introduction to the DCF exercise.mp4	MP4	7.88 MB
2. Introduction to the DCF exercise.vtt	VTT	1.26 KB
20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp4	MP4	22.76 MB
20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt	VTT	3.23 KB
20.1 19. Cash flow structure_after.xlsm.xlsm	XLSM	58.58 KB
20.2 19. Cash flow structure_before.xlsm.xlsm	XLSM	58.48 KB
21. Bridging Unlevered free cash flow to Net cash flow.mp4	MP4	14.58 MB
21. Bridging Unlevered free cash flow to Net cash flow.vtt	VTT	2.11 KB
21.1 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm	XLSM	58.58 KB
21.2 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm	XLSM	58.7 KB
22. Calculating Unlevered free cash flow.mp4	MP4	59.72 MB
22. Calculating Unlevered free cash flow.vtt	VTT	6.63 KB
22.1 21. Calculating UFCF_after.xlsm.xlsm	XLSM	59.18 KB
22.2 21. Calculating UFCF_before.xlsm.xlsm	XLSM	58.66 KB
23. Calculating Net cash flow.mp4	MP4	37.9 MB
23. Calculating Net cash flow.vtt	VTT	4.23 KB
23.1 22. Calculating Net Cash Flow_before.xlsm.xlsm	XLSM	59.18 KB
23.2 Cash Flow Classification By Activities.xlsx	XLSX	55.95 KB
23.3 22. Calculating Net Cash Flow_after.xlsm.xlsm	XLSM	59.38 KB
24. Obtaining the rest of the cash flows through Find and Replace.mp4	MP4	46.73 MB
24. Obtaining the rest of the cash flows through Find and Replace.vtt	VTT	4.18 KB
24.1 23. Find and replace_after.xlsm.xlsm	XLSM	62.5 KB
24.2 23. Find and replace_before.xlsm.xlsm	XLSM	59.55 KB
25. Introducing Weighted average cost of capital and Perpetuity growth.mp4	MP4	13.21 MB
25. Introducing Weighted average cost of capital and Perpetuity growth.vtt	VTT	2.2 KB
25.1 24. Introducing WACC and g_before.xlsm.xlsm	XLSM	62.49 KB
25.2 24. Introducing WACC and g_after.xlsm.xlsm	XLSM	62.58 KB
26. Discounting Unlevered free cash flows to obtain their Present value.mp4	MP4	20.22 MB
26. Discounting Unlevered free cash flows to obtain their Present value.vtt	VTT	2.99 KB
26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm	XLSM	62.71 KB
26.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm	XLSM	62.58 KB
27. Calculating Continuing value and Enterprise value of the business.mp4	MP4	17.72 MB
27. Calculating Continuing value and Enterprise value of the business.vtt	VTT	2.33 KB
27.1 26. Calculating CV and EV_after.xlsm.xlsm	XLSM	63.1 KB
27.2 26. Calculating CV and EV_before.xlsm.xlsm	XLSM	62.71 KB
28. Calculating Equity value.mp4	MP4	12.2 MB
28. Calculating Equity value.vtt	VTT	1.66 KB
28.1 27. Calculating equity value_before.xlsm.xlsm	XLSM	63.1 KB
28.2 27. Calculating equity value_after.xlsm.xlsm	XLSM	63.27 KB
29. Sensitivity analysis for WACC and perpetuity growth.mp4	MP4	40.48 MB
29. Sensitivity analysis for WACC and perpetuity growth.vtt	VTT	4.56 KB
29.1 28. Sensitivity analysis_before.xlsm.xlsm	XLSM	63.27 KB
29.2 28. Sensitivity analysis_after.xlsm.xlsm	XLSM	64.83 KB
29.3 Sensitivity Analysis.xlsx	XLSX	60.81 KB
3. The stages of a complete DCF Valuation.mp4	MP4	49.24 MB
3. The stages of a complete DCF Valuation.vtt	VTT	6.61 KB
3.1 Valuation exercise.pdf.pdf	PDF	411.76 KB
30. A possible application of Goal seek.mp4	MP4	15.62 MB
30. A possible application of Goal seek.vtt	VTT	1.94 KB
30.1 29. Goal seek_before.xlsm.xlsm	XLSM	64.83 KB
30.2 29. Goal seek_ater.xlsm.xlsm	XLSM	64.84 KB
31. Using charts to summarize the results of the DCF model.mp4	MP4	32.88 MB
31.1 30. Charts.xlsm.xlsm	XLSM	101.22 KB
32. You made it!.mp4	MP4	11.27 MB
32. You made it!.vtt	VTT	2.9 KB
4. Description of the structure of the DCF model.mp4	MP4	18.53 MB
4. Description of the structure of the DCF model.vtt	VTT	3.06 KB
4.1 3. Structure of the DCF model.xlsm.xlsm	XLSM	47.9 KB
4.2 DCF Model structure.pdf.pdf	PDF	240.8 KB
5. A glimpse at the company we are valuing - Cheeseco.mp4	MP4	15.67 MB
5. A glimpse at the company we are valuing - Cheeseco.vtt	VTT	1.35 KB
5.1 Cheeseco.pptx.pptx	PPTX	80.09 KB
6. Modeling the top line.mp4	MP4	26.3 MB
6. Modeling the top line.vtt	VTT	3.88 KB
6.1 5. Modeling revenues_after.xlsm.xlsm	XLSM	48.16 KB
6.2 5. Modeling revenues_before.xlsm.xlsm	XLSM	47.85 KB
7. Introducing scenarios to the model with Choose.mp4	MP4	17.83 MB
7. Introducing scenarios to the model with Choose.vtt	VTT	2.49 KB
7.1 6. Choose_after.xlsm.xlsm	XLSM	48.36 KB
7.2 6. Choose_before.xlsm.xlsm	XLSM	48.16 KB
8. Modeling other items Other revenues and Cogs.mp4	MP4	44.56 MB
8. Modeling other items Other revenues and Cogs.vtt	VTT	4.5 KB
8.1 7. Other revenues and Cogs_after.xlsm.xlsm	XLSM	50.08 KB
8.2 7. Other revenues and Cogs_before.xlsm.xlsm	XLSM	48.36 KB
9. Modeling other items Operating expenses and D&A.mp4	MP4	26.33 MB
9. Modeling other items Operating expenses and D&A.vtt	VTT	2.53 KB
9.1 8. Opex and D&A_before.xlsm.xlsm	XLSM	50.08 KB
9.2 8. Opex and D&A_after.xlsm.xlsm	XLSM	50.57 KB

17. Tesla valuation - Complete practical exercise

1. Organizing external inputs in a 'Drivers' sheet.mp4	MP4	31.01 MB
1. Organizing external inputs in a 'Drivers' sheet.vtt	VTT	4.27 KB
1.1 Tesla 2017.pdf.pdf	PDF	2.51 MB
1.2 Tesla 2016.pdf.pdf	PDF	2.21 MB
1.3 0a. Drivers_before.xlsx.xlsx	XLSX	1.27 MB
1.4 Tesla 2018 Q2.pdf.pdf	PDF	635.07 KB
1.5 Tesla Company Valuation - Detailed walkthrough.pdf.pdf	PDF	5.08 MB
1.6 Tesla 2015.pdf.pdf	PDF	1.29 MB
1.7 0a. Drivers_after.xlsx.xlsx	XLSX	1.27 MB
10. Forecasting 'energy' and 'services' revenue.mp4	MP4	25.29 MB
10. Forecasting 'energy' and 'services' revenue.vtt	VTT	2.99 KB
10.1 6. Energy and Other revenue - Before.xlsx.xlsx	XLSX	1.34 MB
10.2 6. Energy and Other revenue - After.xlsx.xlsx	XLSX	1.34 MB
11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4	MP4	26.8 MB
11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt	VTT	2.36 KB
11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx	XLSX	1.35 MB
11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx	XLSX	1.35 MB
12. Forecasting operating expenses.mp4	MP4	34.91 MB
12. Forecasting operating expenses.vtt	VTT	5.15 KB
12.1 8. Opex - Before.xlsx.xlsx	XLSX	1.36 MB
12.2 8. Opex - After.xlsx.xlsx	XLSX	1.36 MB
13. Building a fixed asset roll forward estimating Capex.mp4	MP4	56.58 MB
13. Building a fixed asset roll forward estimating Capex.vtt	VTT	6.1 KB
13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx	XLSX	1.37 MB
13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx	XLSX	1.37 MB
14. Building a fixed asset roll forward D&A schedule.mp4	MP4	54.2 MB
14. Building a fixed asset roll forward D&A schedule.vtt	VTT	4.13 KB
14.1 10. PP&E schedule_after.xlsx.xlsx	XLSX	1.37 MB
14.2 10. PP&E schedule_before.xlsx.xlsx	XLSX	1.37 MB
15. Peer comparison D&A as a percentage of revenues.mp4	MP4	13.61 MB
15. Peer comparison D&A as a percentage of revenues.vtt	VTT	1.62 KB
15.1 10a. PP&E comparison.xlsx.xlsx	XLSX	1.37 MB
16. Calculating DSO, DIO, DPO.mp4	MP4	17.52 MB
16. Calculating DSO, DIO, DPO.vtt	VTT	2.03 KB
16.1 11. Working capital forecasting_before.xlsx.xlsx	XLSX	1.38 MB
16.2 11. Working capital forecasting_after.xlsx.xlsx	XLSX	1.52 MB
17. Producing a clean P&L output sheet.mp4	MP4	8.44 MB
17. Producing a clean P&L output sheet.vtt	VTT	1.54 KB
17.1 12. P&L.xlsx.xlsx	XLSX	1.39 MB
18. Fill in the P&L output sheet.mp4	MP4	18.34 MB
18. Fill in the P&L output sheet.vtt	VTT	1.74 KB
18.1 12a. P&L fill in_after.xlsx.xlsx	XLSX	1.39 MB
18.2 12a. P&L fill in_before.xlsx.xlsx	XLSX	1.39 MB
19. Calculating investments in working capital.mp4	MP4	19.03 MB
19. Calculating investments in working capital.vtt	VTT	2.09 KB
19.1 13. Calculating working capital_after.xlsx.xlsx	XLSX	1.4 MB
19.2 13. Calculating working capital_before.xlsx.xlsx	XLSX	1.4 MB
2. The input data we will work with.mp4	MP4	15.81 MB
2. The input data we will work with.vtt	VTT	1.58 KB
2.1 0aa. Inputs_before.xlsx.xlsx	XLSX	1.28 MB
2.2 0aa. Inputs_after.xlsx.xlsx	XLSX	1.28 MB
20. Forecasting Unlevered free cash flow.mp4	MP4	55.93 MB
20. Forecasting Unlevered free cash flow.vtt	VTT	5.79 KB
20.1 14. Cash flow - UFCF_after.xlsx.xlsx	XLSX	1.41 MB
20.2 14. Cash flow - UFCF_before.xlsx.xlsx	XLSX	1.41 MB
21. Forecasting other assets.mp4	MP4	45.24 MB
21. Forecasting other assets.vtt	VTT	4.33 KB
21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx	XLSX	1.41 MB
21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx	XLSX	1.41 MB
22. Forecasting other liabilities.mp4	MP4	21.97 MB
22. Forecasting other liabilities.vtt	VTT	2.39 KB
22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx	XLSX	1.42 MB
22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx	XLSX	1.41 MB
23. Completing Unlevered free cash flow.mp4	MP4	40.88 MB
23. Completing Unlevered free cash flow.vtt	VTT	3.35 KB
23.1 16a. Complete UFCF_after.xlsx.xlsx	XLSX	1.42 MB
23.2 16a. Complete UFCF_before.xlsx.xlsx	XLSX	1.42 MB
24. Modeling Tesla's financing needs in the forecast period.mp4	MP4	42.35 MB
24. Modeling Tesla's financing needs in the forecast period.vtt	VTT	5.04 KB
24.1 17. Financing_before.xlsx.xlsx	XLSX	1.43 MB
24.2 17. Financing_after.xlsx.xlsx	XLSX	1.43 MB
25. Calculating Net income.mp4	MP4	14.8 MB
25. Calculating Net income.vtt	VTT	1.29 KB
25.1 18. P&L complete_before.xlsx.xlsx	XLSX	1.43 MB
25.2 18. P&L complete_after.xlsx.xlsx	XLSX	1.43 MB
26. Bridging Unlevered free cash flow to Net cash flow.mp4	MP4	50.72 MB
26. Bridging Unlevered free cash flow to Net cash flow.vtt	VTT	4.17 KB
26.1 19. Cash flow_complete_after.xlsx.xlsx	XLSX	1.43 MB
26.2 19. Cash flow_complete_before.xlsx.xlsx	XLSX	1.43 MB
27. Balancing the Balance sheet.mp4	MP4	13.27 MB
27. Balancing the Balance sheet.vtt	VTT	1.12 KB
27.1 20. Complete the BS_before.xlsx.xlsx	XLSX	1.43 MB
27.2 20. Complete the BS_after.xlsx.xlsx	XLSX	1.43 MB
28. Estimating Weighted average cost of capital (WACC).mp4	MP4	44.27 MB
28. Estimating Weighted average cost of capital (WACC).vtt	VTT	6.36 KB
28.1 21. WACC_before.xlsx.xlsx	XLSX	1.43 MB
28.2 21. WACC_after.xlsx.xlsx	XLSX	1.43 MB
29. Performing discounted cash flow valuation (DCF).mp4	MP4	34.9 MB
29. Performing discounted cash flow valuation (DCF).vtt	VTT	3.83 KB
29.1 22. DCF_after.xlsx.xlsx	XLSX	1.44 MB
29.2 22. DCF_before.xlsx.xlsx	XLSX	1.52 MB
3. Forecasting Tesla's expected deliveries.mp4	MP4	114.9 MB
3. Forecasting Tesla's expected deliveries.vtt	VTT	14.38 KB
3.1 1. Deliveries_before.xlsx.xlsx	XLSX	1.29 MB
3.2 1. Deliveries_after.xlsx.xlsx	XLSX	1.29 MB
30. Calculating enterprise value, equity value, and price per share.mp4	MP4	22.55 MB
30. Calculating enterprise value, equity value, and price per share.vtt	VTT	2.01 KB
30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx	XLSX	1.44 MB
30.2 23. EV, Equity value, Price per share_after.xlsx.xlsx	XLSX	1.44 MB
31. Final comments.mp4	MP4	44.88 MB
31. Final comments.vtt	VTT	4.18 KB
4. Comparing delivery figures with the ones of industry peers.mp4	MP4	20.94 MB
4. Comparing delivery figures with the ones of industry peers.vtt	VTT	3.01 KB
4.1 1a. Deliveries development.xlsx.xlsx	XLSX	1.3 MB
5. Estimating an average selling price of Tesla vehicles.mp4	MP4	41.92 MB
5. Estimating an average selling price of Tesla vehicles.vtt	VTT	4.8 KB
5.1 2. Average price_before.xlsx.xlsx	XLSX	1.31 MB
5.2 2. Average price_after.xlsx.xlsx	XLSX	1.31 MB
6. Calculating automotive revenue.mp4	MP4	46.56 MB
6. Calculating automotive revenue.vtt	VTT	4.79 KB
6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx	XLSX	1.31 MB
6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx	XLSX	1.31 MB
7. Peer comparison Gross profit %.mp4	MP4	17.18 MB
7. Peer comparison Gross profit %.vtt	VTT	2.6 KB
7.1 4. Gross profit automotive.xlsx.xlsx	XLSX	1.32 MB
8. Calculating automotive gross profit.mp4	MP4	27.77 MB
8. Calculating automotive gross profit.vtt	VTT	2.83 KB
8.1 4a. Gross profit automotive - before.xlsx.xlsx	XLSX	1.51 MB
8.2 4a. Gross profit automotive - after.xlsx.xlsx	XLSX	1.32 MB
9. Calculating automotive cost of sales.mp4	MP4	17.49 MB
9. Calculating automotive cost of sales.vtt	VTT	2.14 KB
9.1 5. Cost of sales and chart.xlsx.xlsx	XLSX	1.34 MB

18. Capital budgeting - The theory

1. Introduction to Capital budgeting.mp4	MP4	5.43 MB
1. Introduction to Capital budgeting.vtt	VTT	1.79 KB
2. Why we need Capital budgeting.mp4	MP4	6.89 MB
2. Why we need Capital budgeting.vtt	VTT	2.61 KB
3. The time value of money.mp4	MP4	6.7 MB
3. The time value of money.vtt	VTT	2.79 KB
4. Calculating future and present Value.mp4	MP4	13.08 MB
4. Calculating future and present Value.vtt	VTT	6.27 KB
5. Calculating cost of equity.mp4	MP4	19.21 MB
5. Calculating cost of equity.vtt	VTT	7.44 KB
6. Coming up with project-specific beta.mp4	MP4	9.01 MB
6. Coming up with project-specific beta.vtt	VTT	3.49 KB
7. Weighted average cost of capital (WACC).mp4	MP4	5.5 MB
7. Weighted average cost of capital (WACC).vtt	VTT	2.34 KB
8. The type of cash flows we will have in a project.mp4	MP4	9.34 MB
8. The type of cash flows we will have in a project.vtt	VTT	3.88 KB
9. Estimating the project's cash flows.mp4	MP4	18.79 MB
9. Estimating the project's cash flows.vtt	VTT	6.68 KB

19. Capital Budgeting - A Complete Case Study

1. Introduction to the Capital budgeting exercise.mp4	MP4	8.63 MB
1. Introduction to the Capital budgeting exercise.vtt	VTT	3.23 KB
10. Finding cost of equity.mp4	MP4	13.92 MB
10. Finding cost of equity.vtt	VTT	7.16 KB
10.1 8. WACC_unsolved.xlsx.xlsx	XLSX	35.93 KB
10.2 8. WACC.xlsx.xlsx	XLSX	38.03 KB
11. Discounting the project's cash flows and residual value.mp4	MP4	25.9 MB
11. Discounting the project's cash flows and residual value.vtt	VTT	3.51 KB
11.1 9. Discounted cash flow_unsolved.xlsx.xlsx	XLSX	38.72 KB
11.2 9. Discounted cash flow.xlsx.xlsx	XLSX	39.74 KB
12. Performing sensitivity analysis and completing the exercise.mp4	MP4	43.04 MB
12. Performing sensitivity analysis and completing the exercise.vtt	VTT	5.28 KB
12.1 10. Sensitivity analysis.xlsx.xlsx	XLSX	40.67 KB
12.2 10. Sensitivity analysis_unsolved.xlsx.xlsx	XLSX	39.7 KB
13. Build a complete capital budgeting model from scratch.html	HTML	163 B
14. Congratulations!!.mp4	MP4	2.3 MB
14. Congratulations!!.vtt	VTT	1.5 KB
2. Organizing an Inputs sheet.mp4	MP4	11.05 MB
2. Organizing an Inputs sheet.vtt	VTT	6.22 KB
2.1 1. Drivers.xlsx.xlsx	XLSX	11.5 KB
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp4	MP4	9.21 MB
3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt	VTT	4.12 KB
3.1 2. Savings Forecast.xlsx.xlsx	XLSX	16.58 KB
3.2 2. Savings Forecast_unsolved.xlsx.xlsx	XLSX	14.74 KB
4. Fixed asset rollforward.mp4	MP4	12.15 MB
4. Fixed asset rollforward.vtt	VTT	5.28 KB
4.1 3. Fixed Asset Rollforward_unsolved.xlsx.xlsx	XLSX	18.54 KB
4.2 3. Fixed Asset Rollforward.xlsx.xlsx	XLSX	19.66 KB
5. The impact of working capital.mp4	MP4	5.37 MB
5. The impact of working capital.vtt	VTT	2.85 KB
5.1 4. Working Capital.xlsx.xlsx	XLSX	21.93 KB
5.2 4. Working Capital_unsolved.xlsx.xlsx	XLSX	21.19 KB
6. Modeling debt financing.mp4	MP4	6.18 MB
6. Modeling debt financing.vtt	VTT	3.3 KB
6.1 5. Financing_unsolved.xlsx.xlsx	XLSX	29.99 KB
6.2 5. Financing.xlsx.xlsx	XLSX	30.97 KB
7. Adding a P&L sheet.mp4	MP4	4.88 MB
7. Adding a P&L sheet.vtt	VTT	2.12 KB
7.1 6. P&L.xlsx.xlsx	XLSX	31.03 KB
7.2 6. P&L_unsolved.xlsx.xlsx	XLSX	29.7 KB
8. Calculating project cash flows.mp4	MP4	10.15 MB
8. Calculating project cash flows.vtt	VTT	3.7 KB
8.1 7. Cash flow_unsolved.xlsx.xlsx	XLSX	29.64 KB
8.2 7. Cash flow.xlsx.xlsx	XLSX	31.36 KB
9. Estimating the weighted average cost of capital (WACC).mp4	MP4	5.59 MB
9. Estimating the weighted average cost of capital (WACC).vtt	VTT	3.26 KB
9.1 8. WACC.xlsx.xlsx	XLSX	38.03 KB
9.2 8. WACC_unsolved.xlsx.xlsx	XLSX	35.93 KB

2. Introduction to Excel

1. Introduction to Excel - welcome lecture.mp4	MP4	1.99 MB
1. Introduction to Excel - welcome lecture.vtt	VTT	911 B
10. Introduction to Excel formulas.html	HTML	160 B
11. Introduction to Excel functions.mp4	MP4	12.05 MB
11. Introduction to Excel functions.vtt	VTT	4.36 KB
11.1 13. Functions- Exercise - Solved.xlsx.xlsx	XLSX	81.1 KB
11.2 13. Functions - Lecture -Solved.xlsx.xlsx	XLSX	9.34 KB
11.3 Introduction-to-Excels-basic-features.pdf.pdf	PDF	2.27 MB
11.4 13. Functions- Lecture - Unsolved.xlsx.xlsx	XLSX	9.24 KB
11.5 13. Functions-Exercise - Unsolved.xlsx.xlsx	XLSX	13.26 KB
12. Cut, copy, & paste.mp4	MP4	7.57 MB
12. Cut, copy, & paste.vtt	VTT	2.3 KB
12.1 Introduction-to-Excels-basic-features.pdf.pdf	PDF	2.27 MB
12.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx	XLSX	11.34 KB
12.3 14. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx	XLSX	12.56 KB
13. Cut, copy, & paste.html	HTML	160 B
14. Paste special.mp4	MP4	6.7 MB
14. Paste special.vtt	VTT	1.49 KB
14.1 15. Paste-Special-Exercise - Unsolved.xlsx.xlsx	XLSX	13.47 KB
14.2 15. Paste-Special-Exercise - Solved.xlsx.xlsx	XLSX	13.46 KB
14.3 Introduction-to-Excels-basic-features.pdf.pdf	PDF	2.27 MB
15. Basic operations in Excel - 38 pages.html	HTML	164 B
2. Overview of Excel.mp4	MP4	13.95 MB
2. Overview of Excel.vtt	VTT	3.87 KB
2.1 7. Introduction to Excel.pdf.pdf	PDF	2.26 MB
2.2 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx	XLSX	10.88 KB
2.3 7. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx	XLSX	10.47 KB
3. Overview of Excel.html	HTML	160 B
4. Basic manipulations with rows and columns.mp4	MP4	6.91 MB
4. Basic manipulations with rows and columns.vtt	VTT	1.96 KB
4.1 8. Basic manipulations - Lecture.xlsx.xlsx	XLSX	8.07 KB
4.2 8. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx	XLSX	11.06 KB
4.3 8. Basic-Manipulations - Exercise - Solved.xlsx.xlsx	XLSX	32.43 KB
5. Rows and columns.html	HTML	160 B
6. The Excel ribbon.mp4	MP4	8.81 MB
6. The Excel ribbon.vtt	VTT	2.99 KB
6.1 9. The-Ribbon-Exercise-Solved.xlsx.xlsx	XLSX	403.25 KB
6.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx	XLSX	12.09 KB
7. Data entry in Excel.mp4	MP4	10.39 MB
7. Data entry in Excel.vtt	VTT	3.32 KB
7.1 10. Data-Entry - Lecture.xlsx.xlsx	XLSX	8.07 KB
7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx	XLSX	10.97 KB
7.3 10. Data-Entry- Exercise -Solved.xlsx.xlsx	XLSX	32.76 KB
8. Introduction to formatting.mp4	MP4	24.75 MB
8. Introduction to formatting.vtt	VTT	6.14 KB
8.1 11. Formatting - Lecture - Solved.xlsx.xlsx	XLSX	9.85 KB
8.2 11. Formatting-Exercise - Unsolved.xlsx.xlsx	XLSX	11.61 KB
8.3 11. Formatting- Exercise - Solved.xlsx.xlsx	XLSX	11.59 KB
8.4 11. Formatting- Lecture - Unsolved.xlsx.xlsx	XLSX	8.91 KB
9. Introduction to Excel formulas.mp4	MP4	23.68 MB
9. Introduction to Excel formulas.vtt	VTT	4.09 KB
9.1 12. Formulas- Lecture - Solved.xlsx.xlsx	XLSX	9.36 KB
9.2 12. Formulas- Lecture - Unsolved.xlsx.xlsx	XLSX	9.3 KB
9.3 12. Formulas- Exercise - Solved.xlsx.xlsx	XLSX	80.13 KB
9.4 12. Formulas - Exercise - Unsolved.xlsx.xlsx	XLSX	11.72 KB
9.5 Introduction-to-Excels-basic-features.pdf.pdf	PDF	2.26 MB

20. Bonus lecture

1. Bonus lecture Next steps.html

HTML

2.13 KB

4. Keyboard shortcuts in Excel

1. Keyboard shortcuts Save LOTS of time in Excel.mp4	MP4	30.43 MB
1. Keyboard shortcuts Save LOTS of time in Excel.vtt	VTT	5.16 KB
2. Keyboard shortcuts in Excel.html	HTML	164 B

6. Update! SUMIFS - Exercise

1. Exercise - Excel's SUMIFS function - unsolved.html	HTML	164 B
2. Exercise - Excel's SUMIFS function - solved & explained.mp4	MP4	35.31 MB
2. Exercise - Excel's SUMIFS function - solved & explained.vtt	VTT	10.03 KB
2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx	XLSX	1.29 MB

7. Financial functions in Excel

1. Future and present values in Excel.mp4	MP4	14.96 MB
1. Future and present values in Excel.vtt	VTT	6.31 KB
1.1 68. FV and PV-Lecture.xlsx.xlsx	XLSX	10.64 KB
2. Calculating the rate of return of an investment with the IRR function.mp4	MP4	7.58 MB
2. Calculating the rate of return of an investment with the IRR function.vtt	VTT	3.28 KB
2.1 69. Exercise-IRR-Solved.xlsx.xlsx	XLSX	12.31 KB
2.2 69. IRR-Lecture.xlsx.xlsx	XLSX	11.2 KB
2.3 69. Exercise-IRR-Unsolved.xlsx.xlsx	XLSX	11.52 KB
3. Calculating a complete loan schedule in Excel.mp4	MP4	14.82 MB
3. Calculating a complete loan schedule in Excel.vtt	VTT	5.9 KB
3.1 70. Loan Schedule-Lecture.xlsx.xlsx	XLSX	20.17 KB
3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx	XLSX	22.68 KB
3.3 70. Exercise-Loan-Schedule-Unsolved.xlsx.xlsx	XLSX	15.81 KB
4. Date functions in Excel.mp4	MP4	11.35 MB
4. Date functions in Excel.vtt	VTT	5.51 KB
4.1 71. Date Functions-Exercise-Solved.xlsx.xlsx	XLSX	12.43 KB
4.2 71. Date Functions-Lecture.xlsx.xlsx	XLSX	12.25 KB
4.3 71. Date Functions-Exercise-Unsolved.xlsx.xlsx	XLSX	11.41 KB

8. Microsoft Excel's Pivot Tables in Depth

1. Introduction to Pivot Tables and the way they are applied.mp4	MP4	6 MB
1. Introduction to Pivot Tables and the way they are applied.vtt	VTT	1.99 KB
2. Creating Pivot Tables easily!.mp4	MP4	19.38 MB
2. Creating Pivot Tables easily!.vtt	VTT	4.01 KB
2.1 73. Creating-a-Pivot-Table - Lecture - after.xlsx.xlsx	XLSX	1.43 MB
2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx	XLSX	1.23 MB
3. Give your Excel Pivot Tables a makeover.mp4	MP4	11.28 MB
3. Give your Excel Pivot Tables a makeover.vtt	VTT	2.22 KB
3.1 74. Formatting-a-Pivot-Table - Lecture - after.xlsx.xlsx	XLSX	1.43 MB
3.2 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx	XLSX	1.43 MB
4. Modifying and pivoting fields to obtain the Pivot Table you need.mp4	MP4	23 MB
4. Modifying and pivoting fields to obtain the Pivot Table you need.vtt	VTT	4.28 KB
4.1 75. Working-with-Pivot-Tables - Lecture - before.xlsx.xlsx	XLSX	1.43 MB
4.2 75. Working-with-Pivot-Tables - Lecture - after.xlsx.xlsx	XLSX	1.88 MB
5. Learn more about GETPIVOTDATA - A very important Excel function.mp4	MP4	18.06 MB
5. Learn more about GETPIVOTDATA - A very important Excel function.vtt	VTT	3.77 KB
5.1 76. GetPivotData - Lecture - before.xlsx.xlsx	XLSX	1.88 MB
5.2 76. GetPivotData - Lecture – after.xlsx.xlsx	XLSX	1.88 MB
6. An introduction to slicers - The modern-day Pivot Table filters.mp4	MP4	22.17 MB
6. An introduction to slicers - The modern-day Pivot Table filters.vtt	VTT	4.42 KB
6.1 77. Slicers - Lecture - after.xlsx.xlsx	XLSX	1.88 MB
6.2 77. Slicers - Lecture - before.xlsx.xlsx	XLSX	1.88 MB

[Tutorialsplanet.NET].url

URL

128 B

Description

Show full description

Udmey - Beginner to Pro in Excel: Financial Modeling and Valuation [TP}

Torrent Contents Size: 4.72 GB

Description

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.internetwarriors.net:1337/announce
udp://tracker.opentrackr.org:1337/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://9.rarbg.to:2730/announce
udp://9.rarbg.to:2710/announce
udp://bt.xxx-tracker.com:2710/announce
udp://tracker.cyberia.is:6969/announce
udp://retracker.lanta-net.ru:2710/announce
udp://9.rarbg.to:2770/announce
udp://9.rarbg.me:2730/announce
udp://eddie4.nl:6969/announce
udp://tracker.mg64.net:6969/announce
udp://open.demonii.si:1337/announce
udp://tracker.zer0day.to:1337/announce
udp://tracker.tiny-vps.com:6969/announce
udp://ipv6.tracker.harry.lu:80/announce
udp://9.rarbg.me:2740/announce
udp://9.rarbg.me:2770/announce
udp://denis.stalker.upeer.me:6969/announce
udp://tracker.port443.xyz:6969/announce
udp://tracker.moeking.me:6969/announce
udp://exodus.desync.com:6969/announce
udp://9.rarbg.to:2740/announce
udp://9.rarbg.to:2720/announce
udp://tracker.justseed.it:1337/announce
udp://tracker.torrent.eu.org:451/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.open-internet.nl:6969/announce
udp://torrentclub.tech:6969/announce
udp://open.stealth.si:80/announce
http://tracker.tfile.co:80/announce