Provider
Topic
Level
College & Adult
Price
Free
Monthly
Add-ons available
Common Core
Yes
No
Images
No items found.
Financial modeling in Excel is extremely useful to forecast and make key business decisions for your company. Learn this career-boosting skill in this Excel financial modeling course online, through proven methodologies and tools to help you construct a financial model step by step. The training covers financial statement theory and how they link together, building on the best practices and Excel functions covered in the Financial Modeling Basics course. Examples are provided throughout so that you can apply the practical knowledge you learn through hands-on application in Excel.
Highlights:
- 59 practical tutorials.
- Understand the different financial statement types and their key line items.
- Link the three financial statements together and add them to the model.
- Recognize the importance control accounts play in balancing the model.
- How to add the checks worksheet system to keep your model error-free.
- How to model revenue and working capital adjustments.
- Highlight the differences between the four different input methods.
- How to input COGS, OPEX and CAPEX into the financial statement.
- Calculate the control account for debt and interest payable.
- How to calculate tax components including tax expense, depreciation and losses.
- How to calculate Net Operating Cashflow using the Indirect Cashflow method.
Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how a GoSkills Excel certification can boost your career.
If you are a beginner and want to start with the basic concepts and functions of preparing a financial model, then check out the Financial Modeling Basics course first.
Want to be a more efficient Excel user? Start learning 200 of the best Excel shortcuts for PC and Mac.
Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.
Posted
Aug 2023
This resource has religious influence.
Similar resources
Our unique approach to learning
As pioneers of microlearning, we’ve been creating bite-sized courses since 2013. Our unique ‘GoSkills format’ includes a 3-5 minute video, an exercise to apply your knowledge, and a short quiz for every lesson.
This data-backed approach works, increasing retention rates by 20% and learning speeds by 28%. GoSkills also has one of the highest completion rates in the industry.
Here’s what our customers say:
“Perfect bite-size lessons that were brief and to-the-point, well thought out to build on key skills, with great exercises to build "muscle" memory, and solid quizzes that hone important points.”
“Love the bite sized modules! Easy to squeeze one or two in when I have time.”
“I liked that the lessons covered one thought at a time, in small bites.”
Our simple and easy-to-use online training platform empowers managers to create bite-sized and interactive learning programs for their teams, so they can achieve the same results.
We help individuals grow their career
Our subscribers have access to over 100 bite-sized courses taught by leading industry experts. By learning the most sought after business and technical skills, we help individuals stand out in the job market and find confidence at every stage of their career.
Introduction to Tableau
College & Adult
Illustrator - Advanced
College & Adult
Illustrator - Basic
College & Adult
Photoshop - Advanced
College & Adult
Photoshop for Beginners
College & Adult
Intro To C# Programming
College & Adult