June 2024 Course Releases
This article contains a summary of the content released in June 2024.
| Title |
Program |
What You'll Learn |
Financial Planning & Analysis Specialization Program
- Two Prep Courses (Optional)
- 18 Core Courses
|
FP&A |
How to use quantitative and qualitative analysis to evaluate a company’s financial progress, develop clear, well-formatted Excel financial models, and use modern data tools like Power Query and Power BI to boost productivity and visualize your analysis. |
| Workflow Best Practices for Analysts |
FMVA® BIDA® |
Upon completing this course, you will be able to:
- Use best practice file date conventions to improve organization and collaboration.
- Produce best-in-class documentation and audit trails for your models and data links.
- Understand why Excel is superior to Google Sheets for financial modeling.
- Explore best-in-class model formatting with a financial modeling expert.
- Implement basic automation to manage data and chart connections between Excel and PowerPoint effectively.
- Identify tools to enhance efficiency and double your productivity.
|
| AI-Powered Scenario Analysis |
FMVA® |
Upon completing this course, you will be able to:
- Understand the key components and importance of scenario analysis in corporate finance.
- Recognize the revolutionary impact and benefits of AI in scenario analysis
- Learn how to use ChatGPT for data analysis and scenario modeling
- Perform scenario analysis using ChatGPT through a hands-on case study
- Explore the relationship between scenario analysis and risk assessment
- Discover emerging trends and future applications of AI in finance and accounting
- Develop strategies for staying updated with AI developments in the field
|
| Professional Model Roll-Forward and Analysis |
FP&A |
Upon completing this course, you will be able to:
- Analyze monthly data to determine whether adjustments are needed to financial forecasts.
- Compare actual results to financial forecasts and budget estimates on a monthly basis.
- Understand best practices for rolling monthly financial models forward for a new fiscal year.
|
Stay tuned for next month's update!