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
-
Readings for the Financial Risk Manager – Rene M.StulzDOWNLOADReadings for the Financial Risk Manager – Rene M.StulzUpdate 02 Feb 2023All LevelsDOWNLOADReinhold Ebertin is one of the most respected astrologers of the 20th century. Special attention is given to the favorable and unfavorable potential of each aspect to the natal planets. The cosmogram clearly defines transits and their evaluation, and discusses parallels.
Add to wishlist -
Read SEC Filings – Profit.lyDOWNLOADRead SEC Filings – Profit.lyUpdate 16 Dec 2022All LevelsDOWNLOADRead Sec Filings by Profit.ly deep dives into what SEC filings share for insights into the effective analysis of all-sized companies and market valuations. There are many aspects covered in the course with coherent instructions and illustrated case studies.
Add to wishlist -
Trading Tickers – Tim GrittaniDOWNLOADTrading Tickers – Tim GrittaniUpdate 09 Nov 2022All LevelsDOWNLOADTrading Tickers – Tim Grittani shares with you Millionaire Day Trader Tim Grittani’s entries, exits, successes, and failures in an attempt to turn you into a better trader with higher profitability.
Add to wishlist -
The Raptor 10 Momentum Methodology – Steven PrimoDOWNLOADThe Raptor 10 Momentum Methodology – Steven PrimoUpdate 06 Dec 2022All LevelsDOWNLOADThe Raptor 10 Momentum Methodology by Steven Primo guides the best practices of Raptor methods to decode price momentums. Hence, you can develop practical strategies to deal with market volatility to obtain high profits and undertake low risks.
Add to wishlist -
Workshop: High-Probability Breakout Trades – Base Camp TradingDOWNLOADWorkshop: High-Probability Breakout Trades – Base Camp TradingUpdate 09 Nov 2022All LevelsDOWNLOADWorkshop: High-Probability Breakout Trades by Base Camp Trading highlights timely entries and exits for optimal risk/reward ratios. Along with theory instructions, you will also learn effective frameworks through real case studies.
Add to wishlist -
Edges For Ledges – Trader DanteDOWNLOADEdges For Ledges – Trader DanteUpdate 07 Nov 2022IntermediateDOWNLOADEdges For Ledges by Trader Dante teaches you a comprehensive walkthrough of trading techniques and strategies based on insights into trend patterns.
Add to wishlist
Reviews
There are no reviews yet.