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-
Volatility Trading – Euan SinclairVolatility Trading – Euan SinclairUpdate 13 Dec 2022All LevelsDOWNLOAD
Euan Sinclair walks traders through the fundamentals of option pricing, measurement, hedging, money management, and trade assessment in an easy-to-understand manner. Second Edition includes treatment of the numerous new options available in VIX futures, ETNs, and leveraged ETFs.
Add to wishlist -
Wyckoff Upthrust – Dr. Gary Dayton – Trading Psychology EdgeWyckoff Upthrust – Dr. Gary Dayton – Trading Psychology EdgeUpdate 28 Nov 2022All LevelsDOWNLOAD
The Wyckoff Upthrust by Dr. Gary Dayton on the Trading Psychology Edge deep dives into upthrusts and its use in real trades. Detailed walkthroughs are combined with illustrated case studies and examples, hence you can better understand the frameworks.
Add to wishlist -
NY 7 – Matching Personality to Process – Tristan EdwardsNY 7 – Matching Personality to Process – Tristan EdwardsUpdate 09 Nov 2022All LevelsDOWNLOAD
Matching Personality to Process by Tristan Edwards shows you how to identify your go-to comfort zones for consistent flows of guaranteed profits.
Add to wishlist -
Active day trader – Swinging for the FencesActive day trader – Swinging for the FencesUpdate 06 Nov 2022BeginnerDOWNLOAD
Active day traders’ Swinging for the Fences course will teach you all you need to know about trading from the ground up. You will learn from a professional trader with over 20 years of expertise in the field through this course.
Add to wishlist -
Trading with the Time Factor – vol.1 – Frank BarillaroTrading with the Time Factor – vol.1 – Frank BarillaroUpdate 09 Nov 2022All LevelsDOWNLOAD
Volume 1 of Frank Barillaro’s Trading with the Time Factor course will reveal the best concealed secrets for predicting future market peaks and bottoms years in advance.
Add to wishlist -
Daily Price Action Course – Justin BennettDaily Price Action Course – Justin BennettUpdate 07 Nov 2022AdvancedDOWNLOAD
This 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.