|
|
1. Welcome! Course Introduction
|
|
|
7
|
|
|
10. Microsoft Excel - Working with Pivot Tables in Excel
|
|
|
12. Modeling in Excel - Building a Complete 3-statement Model
|
|
|
14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model
|
|
|
15. Accounting - Introduction to Accounting & Bookkeeping
|
|
|
16. Accounting - Types of Revenues, Costs, Assets, and Liabilities
|
|
|
17. Accounting - Revenue Recognition
|
|
|
18. Accounting - Cost Recognition
|
|
|
19. Accounting - Understanding the Big Picture Why, What, When, and How Much
|
|
|
2. Microsoft Excel - Quick Introduction
|
|
1. Microsoft Excel The World's #1 Office Software.mp4
|
MP4
|
22.03 MB
|
|
|
1. Microsoft Excel The World's #1 Office Software.vtt
|
VTT
|
1.12 KB
|
|
|
1.1 Introduction to Excel's basic features.pdf.pdf
|
PDF
|
2.26 MB
|
|
|
10. A Beginner's Introduction to Excel Functions.mp4
|
MP4
|
21.92 MB
|
|
|
10. A Beginner's Introduction to Excel Functions.vtt
|
VTT
|
3.65 KB
|
|
|
10.1 6. Functions- Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
9.24 KB
|
|
|
10.2 6. Functions-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
13.26 KB
|
|
|
10.3 6. Functions- Exercise - Solved.xlsx.xlsx
|
XLSX
|
81.1 KB
|
|
|
10.4 6. Functions - Lecture -Solved.xlsx.xlsx
|
XLSX
|
9.34 KB
|
|
|
10.5 Introduction-to-Excels-basic-features.pdf.pdf
|
PDF
|
2.26 MB
|
|
|
11. Work Efficiently by Using Cut, Copy, and Paste.mp4
|
MP4
|
14.47 MB
|
|
|
11. Work Efficiently by Using Cut, Copy, and Paste.vtt
|
VTT
|
2.14 KB
|
|
|
11.1 7. Copy-Cut-Paste-Exercise - Solved.xlsx.xlsx
|
XLSX
|
12.56 KB
|
|
|
11.2 Introduction-to-Excels-basic-features.pdf.pdf
|
PDF
|
2.26 MB
|
|
|
11.3 7. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.34 KB
|
|
|
12. Work Efficiently by Using Cut, Copy, and Paste.html
|
HTML
|
147 B
|
|
|
13. Pasting Values, Formulas and Formats with Paste Special.mp4
|
MP4
|
10.97 MB
|
|
|
13. Pasting Values, Formulas and Formats with Paste Special.vtt
|
VTT
|
1.55 KB
|
|
|
13.1 Introduction-to-Excels-basic-features.pdf.pdf
|
PDF
|
2.26 MB
|
|
|
13.2 8. Paste-Special-Solved.xlsx.xlsx
|
XLSX
|
13.46 KB
|
|
|
13.3 8. Paste-Special-Exercise-Text.xlsx.xlsx
|
XLSX
|
13.47 KB
|
|
|
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.mp4
|
MP4
|
22.74 MB
|
|
|
2. Excel Made Easy A Beginner's Guide to Excel Spreadsheets.vtt
|
VTT
|
3.53 KB
|
|
|
2.1 1. Introduction to Excel.pdf.pdf
|
PDF
|
2.27 MB
|
|
|
2.2 1. Overview-of-Excel-Exercise-Solved.xlsx.xlsx
|
XLSX
|
10.88 KB
|
|
|
2.3 1. Overview-of-Excel-Exercise-Unsolved.xlsx.xlsx
|
XLSX
|
10.47 KB
|
|
|
3. Data Entry Techniques in Excel.mp4
|
MP4
|
17.35 MB
|
|
|
3. Data Entry Techniques in Excel.vtt
|
VTT
|
3.07 KB
|
|
|
3.1 2. Data-Entry-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
10.97 KB
|
|
|
3.2 2. Data-Entry - Lecture.xlsx.xlsx
|
XLSX
|
8.07 KB
|
|
|
3.3 2. Data-Entry- Exercise -Solved.xlsx.xlsx
|
XLSX
|
32.76 KB
|
|
|
4. How to Make Your Spreadsheets Look Professional.mp4
|
MP4
|
44.83 MB
|
|
|
4. How to Make Your Spreadsheets Look Professional.vtt
|
VTT
|
5.44 KB
|
|
|
4.1 3. Formatting- Exercise - Solved.xlsx.xlsx
|
XLSX
|
11.59 KB
|
|
|
4.2 3. Formatting - Lecture - Solved.xlsx.xlsx
|
XLSX
|
9.85 KB
|
|
|
4.3 3. Formatting- Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
8.91 KB
|
|
|
4.4 3. Formatting-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.61 KB
|
|
|
5. Data Entry Techniques in Excel.html
|
HTML
|
147 B
|
|
|
6. Inserting, Deleting, and Modifying Rows & Columns.mp4
|
MP4
|
12.35 MB
|
|
|
6. Inserting, Deleting, and Modifying Rows & Columns.vtt
|
VTT
|
1.68 KB
|
|
|
6.1 4. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.06 KB
|
|
|
6.2 4. Basic-Manipulations - Exercise - Solved.xlsx.xlsx
|
XLSX
|
32.43 KB
|
|
|
6.3 4. Data Entry - Lecture.xlsx.xlsx
|
XLSX
|
8.07 KB
|
|
|
7. Inserting, Deleting, and Modifying Rows & Columns.html
|
HTML
|
147 B
|
|
|
8. Excel Formulas for Beginners.mp4
|
MP4
|
14.46 MB
|
|
|
8. Excel Formulas for Beginners.vtt
|
VTT
|
2.89 KB
|
|
|
8.1 5. Formulas- Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
9.3 KB
|
|
|
8.2 5. Formulas- Exercise - Solved.xlsx.xlsx
|
XLSX
|
80.13 KB
|
|
|
8.3 5. Formulas- Lecture - Solved.xlsx.xlsx
|
XLSX
|
9.36 KB
|
|
|
8.4 5. Formulas - Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.72 KB
|
|
|
8.5 Introduction-to-Excels-basic-features.pdf.pdf
|
PDF
|
2.27 MB
|
|
|
9. Excel Formulas for Beginners.html
|
HTML
|
147 B
|
|
|
|
20. Accounting - The Core Principles of Accounting
|
|
|
3. Microsoft Excel - Useful Tools
|
|
|
11
|
|
|
13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios
|
|
|
21
|
|
|
21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand
|
|
|
22. Accounting - The Importance of Timing
|
|
|
23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis
|
|
|
23
|
|
|
24. Advanced Accounting - Trade Receivables
|
|
|
25. Advanced Accounting - Inventory
|
|
|
26. Advanced Accounting - Fixed Assets
|
|
|
27. Advanced Accounting - Trade Payables
|
|
|
28. Advanced Accounting - Financial Liabilities
|
|
|
29. Advanced Accounting - Leasing Liabilties
|
|
|
30. Advanced Accounting - Using Leverage
|
|
|
31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments
|
|
|
32. Financial Statement Analysis - An Introduction
|
|
|
33. Financial Statement Analysis - Subtleties
|
|
|
34
|
|
|
35. Financial Statement Analysis - Tesla Exercise
|
|
|
36. Working Capital Management
|
|
|
37. Fundamentals of Business & Financial Analysis
|
|
|
38. Finance 101 - The Time Value of Money and Interest Rate Components
|
|
|
39. Finance 101 - The Value of Cash Flows with Different Timing
|
|
|
4. Microsoft Excel - Best Practices That Will Make a Difference
|
|
|
40. Finance 101 - Loan Calculations
|
|
|
41. Capital Budgeting - Basic Notions
|
|
|
42. Capital Budgeting - A Complete Case Study
|
|
|
43. Tesla Practical Case Study - Building a Financial Planning Model
|
|
|
44. PowerPoint - Introduction to PowerPoint
|
|
|
45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User
|
|
|
46. Bonus Lecture
|
|
|
5. Microsoft Excel - Beginner, Intermediate & Advanced Functions
|
|
1. Key Excel Functions IF.mp4
|
MP4
|
16.66 MB
|
|
|
1. Key Excel Functions IF.vtt
|
VTT
|
2.7 KB
|
|
|
1.1 37. IF-function--Lecture-before.xlsm.xlsm
|
XLSM
|
17 KB
|
|
|
1.2 Functions - English to Spanish.pdf.pdf
|
PDF
|
102.37 KB
|
|
|
1.3 Functions - English to German.pdf.pdf
|
PDF
|
102.32 KB
|
|
|
1.4 Functions - English to Portuguese.pdf.pdf
|
PDF
|
146.09 KB
|
|
|
1.5 37. IF-function-Lecture-after.xlsm.xlsm
|
XLSM
|
17.94 KB
|
|
|
10. Find the Highest and Lowest Values in a Range Max & Min.mp4
|
MP4
|
7.55 MB
|
|
|
10. Find the Highest and Lowest Values in a Range Max & Min.vtt
|
VTT
|
1.02 KB
|
|
|
10.1 44. Excel-functions.xlsx.xlsx
|
XLSX
|
971.02 KB
|
|
|
10.2 44. MIN-MAX-Exercise - Solved.xlsx.xlsx
|
XLSX
|
14.8 KB
|
|
|
10.3 44. Max-min-Lecture - Solved.xlsx.xlsx
|
XLSX
|
9.23 KB
|
|
|
10.4 44. MIN-MAX-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
14.39 KB
|
|
|
10.5 44. Max-min-Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
8.95 KB
|
|
|
10.6 Excel-Functions.pdf.pdf
|
PDF
|
3.18 MB
|
|
|
11. = and + are Interchangeable When You Start Typing a Formula.mp4
|
MP4
|
5.8 MB
|
|
|
11. = and + are Interchangeable When You Start Typing a Formula.vtt
|
VTT
|
874 B
|
|
|
11.1 45. Show-that-and-are-interchangeable-Lecture-before.xlsm.xlsm
|
XLSM
|
17.01 KB
|
|
|
11.2 45. Show-that-and-are-interchangeable-Lecture-after.xlsm.xlsm
|
XLSM
|
17.04 KB
|
|
|
12. Use ROUND in Your Financial Models.mp4
|
MP4
|
5.21 MB
|
|
|
12. Use ROUND in Your Financial Models.vtt
|
VTT
|
1.17 KB
|
|
|
12.1 51. Excel-functions-Lecture.xlsx.xlsx
|
XLSX
|
889.91 KB
|
|
|
12.2 51. Round-Exercise - Solved.xlsx.xlsx
|
XLSX
|
11.71 KB
|
|
|
12.3 Excel-Functions.pdf.pdf
|
PDF
|
3.18 MB
|
|
|
12.4 51. Round-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.34 KB
|
|
|
13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.mp4
|
MP4
|
60.26 MB
|
|
|
13. Excel's Lookup Functions VLOOKUP & HLOOKUP Made Easy.vtt
|
VTT
|
7.85 KB
|
|
|
13.1 47. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx
|
XLSX
|
11.13 KB
|
|
|
13.2 47. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx
|
XLSX
|
13.68 KB
|
|
|
13.3 47. Vlookup-Hlookup- Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
10.74 KB
|
|
|
13.4 47. Vlookup-Hlookup-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.95 KB
|
|
|
13.5 Excel-Functions.pdf.pdf
|
PDF
|
3.18 MB
|
|
|
14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.mp4
|
MP4
|
61.77 MB
|
|
|
14. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.vtt
|
VTT
|
7.67 KB
|
|
|
14.1 48. Index-Match-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.59 KB
|
|
|
14.2 48. Index-Match-Lecture - Solved.xlsx.xlsx
|
XLSX
|
11.7 KB
|
|
|
14.3 Excel-Functions.pdf.pdf
|
PDF
|
3.18 MB
|
|
|
14.4 48. Index-Match-Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
11.29 KB
|
|
|
14.5 48. Index-Match-Exercise - Solved.xlsx.xlsx
|
XLSX
|
12.08 KB
|
|
|
15. INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP.html
|
HTML
|
147 B
|
|
|
16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.mp4
|
MP4
|
11.75 MB
|
|
|
16. Using Excel's IFERROR Function to Trap Spreadsheet Errors.vtt
|
VTT
|
1.95 KB
|
|
|
16.1 54. Iferror - Lecture - Solved.xlsm.xlsm
|
XLSM
|
896.43 KB
|
|
|
16.2 54. Iferror-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
14.26 KB
|
|
|
16.3 Excel-Functions.pdf.pdf
|
PDF
|
3.19 MB
|
|
|
16.4 54. Iferror - Lecture - Unsolved.xlsm.xlsm
|
XLSM
|
897.26 KB
|
|
|
16.5 54. Iferror-Exercise - Solved.xlsx.xlsx
|
XLSX
|
15.37 KB
|
|
|
17. A Useful Tool for Financial Analysis - The RANK Function.mp4
|
MP4
|
23.24 MB
|
|
|
17. A Useful Tool for Financial Analysis - The RANK Function.vtt
|
VTT
|
2.82 KB
|
|
|
17.1 50. Rank-function-Lecture-after.xlsx.xlsx
|
XLSX
|
12.61 KB
|
|
|
17.2 50. Rank-function-Lecture-before.xlsx.xlsx
|
XLSX
|
12.27 KB
|
|
|
18. Create Flexible Financial Models with CHOOSE.mp4
|
MP4
|
19.85 MB
|
|
|
18. Create Flexible Financial Models with CHOOSE.vtt
|
VTT
|
2.54 KB
|
|
|
18.1 51. Choose-Exercise-Solved.xlsx.xlsx
|
XLSX
|
11.73 KB
|
|
|
18.2 Excel-Functions.pdf.pdf
|
PDF
|
3.18 MB
|
|
|
18.3 51. Choose-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.32 KB
|
|
|
18.4 51. Choose-Lecture - Solved.xlsx.xlsx
|
XLSX
|
9.69 KB
|
|
|
18.5 51. Choose-Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
9.33 KB
|
|
|
19. Goal Seek Will Help You Find the Result You Are Looking For.mp4
|
MP4
|
16.02 MB
|
|
|
19. Goal Seek Will Help You Find the Result You Are Looking For.vtt
|
VTT
|
2.44 KB
|
|
|
19.1 57. Goal-Seek-Exercise-Solved.xlsx.xlsx
|
XLSX
|
16.21 KB
|
|
|
19.2 57. Goal-Seek-Lecture - Solved.xlsx.xlsx
|
XLSX
|
9.17 KB
|
|
|
19.3 Excel-Functions.pdf.pdf
|
PDF
|
3.19 MB
|
|
|
19.4 57. Goal-Seek-Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
9.15 KB
|
|
|
19.5 57. Goal-Seek-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
16.09 KB
|
|
|
2. Enlarge the Formula Bar.mp4
|
MP4
|
6.26 MB
|
|
|
2. Enlarge the Formula Bar.vtt
|
VTT
|
1.27 KB
|
|
|
2.1 38. Enlarge-the-formula-bar-Lecture.xlsm.xlsm
|
XLSM
|
46.89 KB
|
|
|
20. Goal Seek Will Help You Find the Result You Are Looking For.html
|
HTML
|
147 B
|
|
|
21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp4
|
MP4
|
26.22 MB
|
|
|
21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.vtt
|
VTT
|
4.62 KB
|
|
|
21.1 58.Sensitivity-analysis-Exercise-Solved.xlsx.xlsx
|
XLSX
|
62.28 KB
|
|
|
21.2 58. Sensitivity analysis - Lecture - Solved.xlsm.xlsm
|
XLSM
|
897.3 KB
|
|
|
21.3 58.Sensitivity-analysis-Exercise_Unsolved.xlsx.xlsx
|
XLSX
|
61.9 KB
|
|
|
21.4 58. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm
|
XLSM
|
897.09 KB
|
|
|
22. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html
|
HTML
|
147 B
|
|
|
23. Quiz Number 2.html
|
HTML
|
147 B
|
|
|
3. Key Excel Functions SUM, SUMIF, SUMIFS.mp4
|
MP4
|
30.68 MB
|
|
|
3. Key Excel Functions SUM, SUMIF, SUMIFS.vtt
|
VTT
|
4.28 KB
|
|
|
3.1 39. Sum-Sumif-Sumifs-Exercise - Solved.xlsx.xlsx
|
XLSX
|
14.84 KB
|
|
|
3.2 39. Sum-Sumif-Sumifs-Exercise -Unsolved.xlsx.xlsx
|
XLSX
|
14.46 KB
|
|
|
3.3 39. Sum-Sumif-Sumifs-Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
12.93 KB
|
|
|
3.4 Excel-Functions.pdf.pdf
|
PDF
|
3.19 MB
|
|
|
3.5 39. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx
|
XLSX
|
13.01 KB
|
|
|
4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4
|
MP4
|
31.21 MB
|
|
|
4. Key Excel Functions COUNT, COUNTA, COUNTIF, COUNTIFS.vtt
|
VTT
|
4 KB
|
|
|
4.1 Lecture-Count-Countif-Countifs-Unsolved.xlsx.xlsx
|
XLSX
|
11.29 KB
|
|
|
4.2 40.Counts-Exercise-Solved.xlsx.xlsx
|
XLSX
|
16.07 KB
|
|
|
4.3 Excel-Functions.pdf.pdf
|
PDF
|
3.19 MB
|
|
|
4.4 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx
|
XLSX
|
11.68 KB
|
|
|
4.5 40.Counts-Exercise-Unsolved.xlsx.xlsx
|
XLSX
|
15.56 KB
|
|
|
5. Key Excel Functions AVERAGE & AVERAGEIF.mp4
|
MP4
|
15.12 MB
|
|
|
5. Key Excel Functions AVERAGE & AVERAGEIF.vtt
|
VTT
|
2.15 KB
|
|
|
5.1 41. Average-Averageif- Lecture - Solved.xlsx.xlsx
|
XLSX
|
9.4 KB
|
|
|
5.2 41. Average-AverageIF-Exercise - Solved.xlsx.xlsx
|
XLSX
|
15.02 KB
|
|
|
5.3 41. Average-Averageif- Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
9.03 KB
|
|
|
5.4 Excel-Functions.pdf.pdf
|
PDF
|
3.18 MB
|
|
|
5.5 41. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
14.6 KB
|
|
|
6. Key Excel Functions Average & Averageif.html
|
HTML
|
147 B
|
|
|
7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.mp4
|
MP4
|
30.41 MB
|
|
|
7. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.vtt
|
VTT
|
5.09 KB
|
|
|
7.1 47. Text-Functions- Lecture - Solved.xlsx.xlsx
|
XLSX
|
11.1 KB
|
|
|
7.2 47. Text functions - Exercise - Unsolved.xlsx.xlsx
|
XLSX
|
11.71 KB
|
|
|
7.3 47. Text-Functions- Lecture - Unsolved.xlsx.xlsx
|
XLSX
|
10.6 KB
|
|
|
7.4 47. Text functions - Exercise - Solved.xlsx.xlsx
|
XLSX
|
12.24 KB
|
|
|
8. Key Excel Functions LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &.html
|
HTML
|
147 B
|
|
|
9. Working with Text in Excel.mp4
|
MP4
|
16.02 MB
|
|
|
9. Working with Text in Excel.vtt
|
VTT
|
2.8 KB
|
|
|
9.1 43. Work-with-text-Lecture-after.xlsx.xlsx
|
XLSX
|
10.91 KB
|
|
|
9.2 43. Work-with-text-Lecture-before.xlsx.xlsx
|
XLSX
|
10.33 KB
|
|
|
Download Paid Udemy Courses For Free.url
|
URL
|
116 B
|
|
|
GetFreeCourses.Co.url
|
URL
|
116 B
|
|
|
How you can help GetFreeCourses.Co.txt
|
TXT
|
182 B
|
|
|
|
6. Microsoft Excel - Financial Functions in Excel
|
|
|
8. Microsoft Excel - Building Professional Charts in Excel
|
|
|
9. Microsoft Excel - Creating Complete Professional Charts from Scratch
|
|
|
Download Paid Udemy Courses For Free.url
|
URL
|
116 B
|
|
|
GetFreeCourses.Co.url
|
URL
|
116 B
|
|
|
How you can help GetFreeCourses.Co.txt
|
TXT
|
182 B
|