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
-
Time Factors in the Stock Market – George BayerDOWNLOADTime Factors in the Stock Market – George BayerUpdate 13 Dec 2022All LevelsDOWNLOADTime Factors is a great introduction to George Bayer’s techniques. The author was famed in his day for his ability to predict the future of the markets. If you enjoy history and forecasting, this is a book you should have in your library.
Add to wishlist -
Divergent Swing Trading 2015 – EzeetraderDOWNLOADDivergent Swing Trading 2015 – EzeetraderUpdate 06 Nov 2022IntermediateDOWNLOADDivergent Swing Trading demonstrates a precise technique with full entry and exit criteria so that you can grab it and start trading right away.
Add to wishlist -
AllStarFX Pro Trader Complete FX Course – Chris LoriDOWNLOADAllStarFX Pro Trader Complete FX Course – Chris LoriUpdate 22 Dec 2022BeginnerDOWNLOADIf you want to succeed in Forex trading, you must enroll in this training AllStarFX Pro Trader Complete FX Course. This training is incredibly practical and easy to comprehend; any misunderstanding about trading profitably has been removed. The skill of regulating some powerful human emotions that were mostly responsible for many traders’ failures was also effectively taught.
Add to wishlist -
Curriculum for Wealth – Wealth FactoryDOWNLOADCurriculum for Wealth – Wealth FactoryUpdate 01 Dec 2022All LevelsDOWNLOADThe Curriculum for Wealth by Wealth Factory uncovers effective strategies and techniques to have stable income gains to achieve financial freedom. You will get detailed guides and illustrated case studies for practical insights and effective applications.
Add to wishlist -
Vertical Spreads. Strategy Intensive presented – Charles CottleDOWNLOADVertical Spreads. Strategy Intensive presented – Charles CottleUpdate 13 Nov 2022IntermediateDOWNLOADIn this Vertical Spreads & Strategy Intensive presented by Charles Cottle, we’ll cover important things to keep in mind when trading option spreads (for both credit spreads and debit spreads), as we approach the expiration date
Add to wishlist -
Daily Price Action Course – Justin BennettDOWNLOADDaily Price Action Course – Justin BennettUpdate 07 Nov 2022AdvancedDOWNLOADThis course shares a comprehensive guideline on chart reading. So, the improvement of strategy development and more valuable insights into price actions are obvious outcomes.
Add to wishlist
Reviews
There are no reviews yet.