Excel For Finance Intermediate Course Bundle by Investopedia covers many practical tips for using the features of Excel to manage the database. Also, you can learn to draw more valuable insights from analysis!
Course Overview
Excel For Finance Intermediate Course Bundle by Investopedia includes practical techniques and real case studies of using Excel for database management and analysis. Instead of being confused about the meanings behind numbers, superior features of Excel can help you bring clarity to hidden messages.
Course Outline
Welcome
- Mac Shortcuts
- Goal Setting
Case Study: Visa Income Statement
- Visa Income Statement Model and Scenario Workbook
- Visa FY Estimates
- Introduction to Visa Income Statement
- Visa Reuters Estimates
- Visa Y Charts Estimates
- Walkthrough
- Creating the Operating Scenario
- Validating Information
- Base Case and Best Case
- Blended Case
- Feeding the Model
- Bull Scenario
- Bear Scenario
- Introduction to Waterfall Charts
- Setting Up the Data
- Creating the Chart
- Visa Income Statement Model and Scenario (Answers)
Case Study: Apple Data Mining
- Apple Data Mining Chart
- Introduction to Apple Dynamic Data Mining
- Finding Release Dates
- Backward Return
- Forward Return Part 1
- Forward Return Part 2
- Populating Dates
- Preparing Data for Infographic
- Building the Infographic
- Review
What Will You Learn?
- More insights into the applications of Excel formulas through real-world practices used by professionals serving Fortune 100s.
- Creating complicated financial models for simultaneous analysis of multiple scenarios.
- Applying industry best practices to guarantee that your work is easily auditable by executives, stakeholders, and colleagues.
- Unfolding actionable ideas by mining data like an expert analyst.
- Presenting your findings clearly in beautifully designed charts and speakable databases.
Who Is This Course For?
The course is a great assistance for those who have known the fundamentals of Excel and want to level their skills up.
Please Login/Register if you want to leave us some feedback to help us improve our services and products.
RELATED COURSES
VIEW ALL
-
The Chinese Banking Industry – Yuanyuan PengDOWNLOAD -
The New Fibonacci Trader Workbook – Robert FisherDOWNLOADThe New Fibonacci Trader Workbook – Robert FisherUpdate 12 Nov 2022All LevelsDOWNLOADThe New Fibonacci Trader Workbook by Robert Fisher shares techniques and strategies based on the New Fibonacci models. You can learn the details in real case studies and examples.
Add to wishlist -
Selling Premium Class 2018 -Theo TradeDOWNLOADSelling Premium Class 2018 -Theo TradeUpdate 13 Nov 2022All LevelsDOWNLOADSelling Premium Class 2018 by Theo Trade teaches a profitable framework of how to earn high profits and join risk-free trades through coherent instructions and real case studies.
Add to wishlist -
The Traders Mindset Course (the-traders-mindset.com) – Chris MathewsDOWNLOADThe Traders Mindset Course (the-traders-mindset.com) – Chris MathewsUpdate 15 Nov 2022IntermediateDOWNLOADThis The Traders Mindset Course (the-traders-mindset.com) by Chris Mathews can bring a clear trader psychology system that can simply integrate with whatever system they are trading and allow them to trade their system in accordance with their trading strategy.
Add to wishlist -
The Seesaw Strategy Pro – Simpler TradingDOWNLOADThe Seesaw Strategy Pro – Simpler TradingUpdate 09 Nov 2022All LevelsDOWNLOADThe Seesaw Strategy Pro – Simpler Trading shares with you the comprehensive guideline to master the ‘Seesaw Strategy’ Bruce used to achieve 12-winners in a row in a brutal choppy market.
Add to wishlist -
IBD’s Level 3 – Chart SchoolDOWNLOADIBD’s Level 3 – Chart SchoolUpdate 03 Nov 2022DOWNLOADThe IBD’s Level 3 course by Chart School (or The IBD Chart School) is jam-packed with lessons on how to improve positions, identify IPOs poised to break out, and comprehend charts at a deeper level.
Add to wishlist
Reviews
There are no reviews yet.