Udemy - MO-230 exam prep - Microsoft Excel for Business Finance

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 - Introduction.mp4 (51.0 MB)
• 2 - Welcome to Udemy.html (0.9 KB)
• 3 - Do you want auto-translated subtitles in more languages.html (2.7 KB)
• 3 - How to get the best out of your Udemy course.mp4 (34.5 MB)
• 4 - Do you want auto-translated subtitles in more languages.html (2.7 KB)
• 4 - Resources.html (0.2 KB)
• 5 - Curriculum.mp4 (59.2 MB)
• 6 - Resources - BusinessFinanceDataStartSection5.xlsx (30.1 KB)
• 6 - Resources - MO-230ExamRequirements251013.pdf (131.6 KB)
• 6 - Resources - MO-230Notes251007.pdf (277.8 KB)
• 6 - Resources - PracticeTransactions1.txt (8.2 KB)
• 6 - Resources - PracticeTransactions2.csv (7.4 KB)
• 6 - Resources - TransactionsCSV.csv (1.0 KB)
• 6 - Resources - TransactionsFixed.txt (1.1 KB)
• 6 - Resources - TransactionsTab.txt (0.8 KB)
• 6 - Resources.html (0.2 KB)
10 - Create Financial Forecasts
• 1 - 27, 28. Analyze historical data using formulas and create a Forecast Sheet - BusinessFinanceDataSection10Start.xlsx (112.3 KB)
• 1 - 27, 28. Analyze historical data using formulas and create a Forecast Sheet.mp4 (64.6 MB)
• 2 - 28. More options when creating a Forecast Sheet, and Paste - Transpose.mp4 (28.2 MB)
• 3 - 27, 29. Calculate historic growth rates and Apply growth rates.mp4 (55.6 MB)
• 4 - 30, 32. Project interest payments and cash budgets.mp4 (51.5 MB)
11 - Well done for finishing the Excel course
• 1 - What's Next.mp4 (13.8 MB)
• 2 - Congratulations for finishing the Excel course.mp4 (24.1 MB)
2 - Importingexporting data, and cleaning accounting data
• 1 - Microsoft Excel - a quick tour.mp4 (68.4 MB)
• 2 - Inserting data and moving the cursor.mp4 (47.6 MB)
• 3 - 2. Save and export workbooks in various file formats.mp4 (40.2 MB)
• 4 - 1. Import data from various sources.mp4 (64.3 MB)
• 5 - Moving data using cut, copy and paste.mp4 (35.1 MB)
• 6 - 3, 4. Remove duplicate data, and deletehideresize rows, columns and cells.mp4 (94.2 MB)
• 7 - 5. Format cells for consistency.mp4 (117.8 MB)
• 8 - Practice Activity Number 1 - PracticeTransactions1.txt (8.2 KB)
• 8 - Practice Activity Number 1.html (2.1 KB)
• 9 - Practice Activity Number 1 - The Solution.mp4 (117.6 MB)
3 - Verify accounting data integrity, and transform accounting data
• 1 - 6. Apply Data Validation rules to restrict input.mp4 (92.7 MB)
• 2 - 7. Identify data outside defined standards or expected values.mp4 (77.0 MB)
• 3 - 8. Protect workbooks, worksheets, and cells.mp4 (63.5 MB)
• 4 - 9. Split a single data column into multiple columns.mp4 (46.1 MB)
• 5 - 12. Use Fill features to extend series and patterns.mp4 (61.9 MB)
• 6 - Practice Activity Number 2.html (1.6 KB)
• 7 - Practice Activity Number 2 - The Solution.mp4 (91.9 MB)
4 - Using text and date functions
• 1 - 10. Using the & to combine values, and copying formulas to other cells.mp4 (73.2 MB)
• 2 - 10. Using text functions to combine values.mp4 (94.0 MB)
• 3 - 10. Using text functions to extract values.mp4 (107.5 MB)
• 4 - 11. Use date functions to transform transaction dates.mp4 (66.5 MB)
• 5 - Practice Activity 3.html (1.4 KB)
5 - Analyze financial statements to calculate variances in Excel
• 1 - 13. Perform horizontal analysis - BusinessFinanceDataStartSection5.xlsx (30.1 KB)
• 1 - 13. Perform horizontal analysis.mp4 (88.5 MB)
• 2 - 14. Perform vertical analysis, and creating aggregations.mp4 (94.2 MB)
• 3 - 15, 16. Calculate budget versus actual variance and compare against benchmarks.mp4 (82.7 MB)
• 4 - Using the dollar sign in formulas.mp4 (34.6 MB)
6 - Analyze financial statements using Excel formulas and identifycorrect errors
• 1 - 17. Prepare financial metrics and pricing analysis, including SUBTOTAL function - BusinessFinanceDataSection6Start.xlsx (43.3 KB)
• 1 - 17. Prepare financial metrics and pricing analysis, including SUBTOTAL function.mp4 (104.9 MB)
• 2 - 18. Calculate financial ratios and Freezing Panes.mp4 (102.1 MB)
• 3 - 20, 21. Identify and report formula errors, including using Formula Auditing.mp4 (91.0 MB)
7 - Present financial information visually in Excel
• 1 - 33. Create dashboards - BusinessFinanceDataSection7Start.xlsx (47.9 KB)
• 1 - 33. Create dashboards.mp4 (73.2 MB)
• 2 - 33. Using the Page Layout options.mp4 (60.7 MB)
• 3 - 33. Create charts.mp4 (61.8 MB)
• 4 - 33, 34. Formatting charts and Identify and correct errors in charts.mp4 (67.0 MB)
• 5 - 35. Evaluate and improve accessibility and usability.mp4 (37.8 MB)
8 - Loan Analysis
• 1 - 22, 30. Calculate loan values using financial functions - BusinessFinanceDataSection8Start.xlsx (55.7 KB)
• 1 - 22, 30. Calculate loan values using financial functions.mp4 (51.4 MB)
• 2 - 23. Create loan amortization schedules.mp4 (88.7 MB)
• 3 - 19. Performing time value of money calculations.mp4 (55.0 MB)
• 4 - 24, 31. Using Scenario Manager to create different loan scenarios.mp4 (95.2 MB)
• 5 - 24, 31. Applying What-if Analysis to investigate different loan variables.mp4 (72.0 MB)
9 - Investment Analysis
• 1 - 25. Calculate bond prices and yields.mp4 (54.1 MB)
• 2 - 31. Applying two What-If Analysis calcuations to bond calculations.mp4 (70.4 MB)
• 3 - 26. Create stock valuation models.mp4 (49.5 MB)
• Bonus Resources.txt (0.1 KB)