Learn the skills for the new MO-230 Excel certification. Use Data Validation, Formula Auditing, create charts and more!
What you'll learn
Prepare Financial Data for Analysis
Perform Financial Analysis
Perform Loan and Investment Analysis
Create Financial Forecasts
Requirements
Before beginning, you will need to know how to use a Windows computer, including a mouse.
It would be good if you have used Microsoft Excel before, but this is not essential.
You should have MS Excel (or Office) 2021 or later installed on your PC computer. This program is also known as a Microsoft 365 App.
Description
The Microsoft MO-230 certification is the new certification for Excel for Financial analysis. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel for Business Finance Associate certification.In this course, we will look at all of the topics in the MO-230 certification.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.I will not be able to comment on financial analysis regarding your specific situation, as they can vary from country to country and from state to state. If you want any comments about financial analysis for your specific situation, please contact an financial professional near you.Nothing in this course should be taken as being a commentary on any company's financial statements or analysis.In this MO-230 exam preparation course:We'll start by preparing data for analysis. We'll import and export data, clean data, verify data integrity, and transform data.We'll then Perform Financial Analysis. We'll analyze financial statements, including calculating variances, metrics and financial ratios, and identify and correct errors in financial formulas. We'll also present this data using charts in a dashboard.Finally, we'll perform loan and investment analysis and create financial forecasts. We'll create loan amortization schedules, analyze loan scenarios, perform time value of money calculations, and analyze bond prices and yields and create stock valuation models. We'll also create a Forecast Sheet and prepare financial projections, including using What-If Analysis.No prior knowledge is required.Once you have completed this course, you will have an expanded knowledge of Microsoft Excel. With some practice, you could even take the official Microsoft MO-230 exam, which gives you the "Microsoft Office Specialist: Excel for Business Finance Associate" certificate. This would look good on your CV or resume.
Who this course is for
This course is for you if you want to develop your Microsoft Excel skills with regards to financial data.
This course will use the latest version of Excel, but is also for you if you use any modern version - Excel 2007, 2010, 2013, 2016 or 2019.
This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist for financial analysis, if you wish to do so.
You will cover the content tested in the Microsoft Office Specialist Exam MO-230 "Excel for Business Finance Associate"
This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

https://rapidgator.net/file/5080399c3a5c2f5a9ce78948986e9a50/MO-230_exam_prep_Microsoft_Excel_for_Business_Finance.part1.rar.html
https://rapidgator.net/file/5a3b1e739baa651393445ac80fdc6e9d/MO-230_exam_prep_Microsoft_Excel_for_Business_Finance.part2.rar.html
https://rapidgator.net/file/4ee1674c8302d4714a538a63d06c8340/MO-230_exam_prep_Microsoft_Excel_for_Business_Finance.part3.rar.html
https://rapidgator.net/file/257d563367ea7ff0690bf7f66f23f67e/MO-230_exam_prep_Microsoft_Excel_for_Business_Finance.part4.rar.html