[ WebToolTip.com ] Udemy - MO-230 exam prep - Microsoft Excel for Business Finance

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4

51 MB

~Get Your Files Here !/1 - Introduction/2 - Welcome to Udemy.html

916 B

~Get Your Files Here !/1 - Introduction/3 - Do you want auto-translated subtitles in more languages.html

2.7 kB

~Get Your Files Here !/1 - Introduction/3 - How to get the best out of your Udemy course.mp4

34 MB

~Get Your Files Here !/1 - Introduction/4 - Do you want auto-translated subtitles in more languages.html

2.7 kB

~Get Your Files Here !/1 - Introduction/4 - Resources.html

240 B

~Get Your Files Here !/1 - Introduction/5 - Curriculum.mp4

59 MB

~Get Your Files Here !/1 - Introduction/6 - Resources - BusinessFinanceDataStartSection5.xlsx

30 kB

~Get Your Files Here !/1 - Introduction/6 - Resources - MO-230ExamRequirements251013.pdf

132 kB

~Get Your Files Here !/1 - Introduction/6 - Resources - MO-230Notes251007.pdf

278 kB

~Get Your Files Here !/1 - Introduction/6 - Resources - PracticeTransactions1.txt

8.2 kB

~Get Your Files Here !/1 - Introduction/6 - Resources - PracticeTransactions2.csv

7.4 kB

~Get Your Files Here !/1 - Introduction/6 - Resources - TransactionsCSV.csv

1020 B

~Get Your Files Here !/1 - Introduction/6 - Resources - TransactionsFixed.txt

1.1 kB

~Get Your Files Here !/1 - Introduction/6 - Resources - TransactionsTab.txt

808 B

~Get Your Files Here !/1 - Introduction/6 - Resources.html

240 B

~Get Your Files Here !/10 - Create Financial Forecasts/1 - 27, 28. Analyze historical data using formulas and create a Forecast Sheet - BusinessFinanceDataSection10Start.xlsx

112 kB

~Get Your Files Here !/10 - Create Financial Forecasts/1 - 27, 28. Analyze historical data using formulas and create a Forecast Sheet.mp4

65 MB

~Get Your Files Here !/10 - Create Financial Forecasts/2 - 28. More options when creating a Forecast Sheet, and Paste - Transpose.mp4

28 MB

~Get Your Files Here !/10 - Create Financial Forecasts/3 - 27, 29. Calculate historic growth rates and Apply growth rates.mp4

56 MB

~Get Your Files Here !/10 - Create Financial Forecasts/4 - 30, 32. Project interest payments and cash budgets.mp4

52 MB

~Get Your Files Here !/11 - Well done for finishing the Excel course/1 - What's Next.mp4

14 MB

~Get Your Files Here !/11 - Well done for finishing the Excel course/2 - Congratulations for finishing the Excel course.mp4

24 MB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/1 - Microsoft Excel - a quick tour.mp4

68 MB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/2 - Inserting data and moving the cursor.mp4

48 MB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/3 - 2. Save and export workbooks in various file formats.mp4

40 MB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/4 - 1. Import data from various sources.mp4

64 MB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/5 - Moving data using cut, copy and paste.mp4

35 MB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/6 - 3, 4. Remove duplicate data, and deletehideresize rows, columns and cells.mp4

94 MB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/7 - 5. Format cells for consistency.mp4

118 MB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/8 - Practice Activity Number 1 - PracticeTransactions1.txt

8.2 kB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/8 - Practice Activity Number 1.html

2.1 kB

~Get Your Files Here !/2 - Importingexporting data, and cleaning accounting data/9 - Practice Activity Number 1 - The Solution.mp4

118 MB

~Get Your Files Here !/3 - Verify accounting data integrity, and transform accounting data/1 - 6. Apply Data Validation rules to restrict input.mp4

93 MB

~Get Your Files Here !/3 - Verify accounting data integrity, and transform accounting data/2 - 7. Identify data outside defined standards or expected values.mp4

77 MB

~Get Your Files Here !/3 - Verify accounting data integrity, and transform accounting data/3 - 8. Protect workbooks, worksheets, and cells.mp4

64 MB

~Get Your Files Here !/3 - Verify accounting data integrity, and transform accounting data/4 - 9. Split a single data column into multiple columns.mp4

46 MB

~Get Your Files Here !/3 - Verify accounting data integrity, and transform accounting data/5 - 12. Use Fill features to extend series and patterns.mp4

62 MB

~Get Your Files Here !/3 - Verify accounting data integrity, and transform accounting data/6 - Practice Activity Number 2.html

1.6 kB

~Get Your Files Here !/3 - Verify accounting data integrity, and transform accounting data/7 - Practice Activity Number 2 - The Solution.mp4

92 MB

~Get Your Files Here !/4 - Using text and date functions/1 - 10. Using the & to combine values, and copying formulas to other cells.mp4

73 MB

~Get Your Files Here !/4 - Using text and date functions/2 - 10. Using text functions to combine values.mp4

94 MB

~Get Your Files Here !/4 - Using text and date functions/3 - 10. Using text functions to extract values.mp4

108 MB

~Get Your Files Here !/4 - Using text and date functions/4 - 11. Use date functions to transform transaction dates.mp4

66 MB

~Get Your Files Here !/4 - Using text and date functions/5 - Practice Activity 3.html

1.4 kB

~Get Your Files Here !/5 - Analyze financial statements to calculate variances in Excel/1 - 13. Perform horizontal analysis - BusinessFinanceDataStartSection5.xlsx

30 kB

~Get Your Files Here !/5 - Analyze financial statements to calculate variances in Excel/1 - 13. Perform horizontal analysis.mp4

88 MB

~Get Your Files Here !/5 - Analyze financial statements to calculate variances in Excel/2 - 14. Perform vertical analysis, and creating aggregations.mp4

94 MB

~Get Your Files Here !/5 - Analyze financial statements to calculate variances in Excel/3 - 15, 16. Calculate budget versus actual variance and compare against benchmarks.mp4

83 MB

~Get Your Files Here !/5 - Analyze financial statements to calculate variances in Excel/4 - Using the dollar sign in formulas.mp4

35 MB

~Get Your Files Here !/6 - Analyze financial statements using Excel formulas and identifycorrect errors/1 - 17. Prepare financial metrics and pricing analysis, including SUBTOTAL function - BusinessFinanceDataSection6Start.xlsx

43 kB

~Get Your Files Here !/6 - Analyze financial statements using Excel formulas and identifycorrect errors/1 - 17. Prepare financial metrics and pricing analysis, including SUBTOTAL function.mp4

105 MB

~Get Your Files Here !/6 - Analyze financial statements using Excel formulas and identifycorrect errors/2 - 18. Calculate financial ratios and Freezing Panes.mp4

102 MB

~Get Your Files Here !/6 - Analyze financial statements using Excel formulas and identifycorrect errors/3 - 20, 21. Identify and report formula errors, including using Formula Auditing.mp4

91 MB

~Get Your Files Here !/7 - Present financial information visually in Excel/1 - 33. Create dashboards - BusinessFinanceDataSection7Start.xlsx

48 kB

~Get Your Files Here !/7 - Present financial information visually in Excel/1 - 33. Create dashboards.mp4

73 MB

~Get Your Files Here !/7 - Present financial information visually in Excel/2 - 33. Using the Page Layout options.mp4

61 MB

~Get Your Files Here !/7 - Present financial information visually in Excel/3 - 33. Create charts.mp4

62 MB

~Get Your Files Here !/7 - Present financial information visually in Excel/4 - 33, 34. Formatting charts and Identify and correct errors in charts.mp4

67 MB

~Get Your Files Here !/7 - Present financial information visually in Excel/5 - 35. Evaluate and improve accessibility and usability.mp4

38 MB

~Get Your Files Here !/8 - Loan Analysis/1 - 22, 30. Calculate loan values using financial functions - BusinessFinanceDataSection8Start.xlsx

56 kB

~Get Your Files Here !/8 - Loan Analysis/1 - 22, 30. Calculate loan values using financial functions.mp4

51 MB

~Get Your Files Here !/8 - Loan Analysis/2 - 23. Create loan amortization schedules.mp4

89 MB

~Get Your Files Here !/8 - Loan Analysis/3 - 19. Performing time value of money calculations.mp4

55 MB

~Get Your Files Here !/8 - Loan Analysis/4 - 24, 31. Using Scenario Manager to create different loan scenarios.mp4

95 MB

~Get Your Files Here !/8 - Loan Analysis/5 - 24, 31. Applying What-if Analysis to investigate different loan variables.mp4

72 MB

~Get Your Files Here !/9 - Investment Analysis/1 - 25. Calculate bond prices and yields.mp4

54 MB

~Get Your Files Here !/9 - Investment Analysis/2 - 31. Applying two What-If Analysis calcuations to bond calculations.mp4

70 MB

~Get Your Files Here !/9 - Investment Analysis/3 - 26. Create stock valuation models.mp4

50 MB

~Get Your Files Here !/Bonus Resources.txt

70 B