Modeling 101: Fundamentals of Modeling

Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint: Everything is Included!

Created by: 365 Careers
Creating opportunities for Data Science and Finance students

What Will I Learn?

• Work comfortably with Microsoft Excel
• Format spreadsheets professionally
• Perform routine tasks quicker
• Create professional charts in Microsoft Excel
• Efficiently work with vast amounts of data
• Understand accounting and bookkeeping principles
• Build a company’s P&L from scratch
• Create a company’s balance sheet
• Perform Financial statement analysis
• Understand the timing of revenue and cost recognition
• Calculate liquidity, solvency, profitability, and growth ratios to analyze a company’s performance
• Understand 10-K reports
• Assess whether a project is feasible via the net present value (NPV) technique
• Calculate a complete loan schedule
• Know the difference between variable and fixed interest rates
• Perform industry analysis
• Realize what drives a company’s value
• Know how to analyze a business
• Work comfortably with Microsoft PowerPoint
• Create professional company presentations in PowerPoint
• Become a successful Financial Analyst – if you follow the course entirely!

Requirements

• No experience is required. Start from the basics and progressively build your knowledge.
• You will need Microsoft Excel 2010, 2013, 2016, 2020, or Excel 365
• You will need Microsoft PowerPoint 2010, 2013, 2016, 2020, or PowerPoint 365

Target audience

• People who want a successful career in Finance
• Anyone who wants to learn the practical skills of Financial analysis
• People who are ambitious and want to learn faster than their peers