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 Ultimate Systems Trader – Trading with RaynerDOWNLOADThe Ultimate Systems Trader – Trading with RaynerUpdate 13 Dec 2022All LevelsDOWNLOADThe Ultimate Systems Trader by Trading with Rayner deep dives into tried-and-true trading systems that could help you earn consistent profits amid market volatility. There are various aspects covered with details and illustrated case studies for you to grasp practical adaptation to real trades.
Add to wishlist -
Hector Deville (HectorTrader) Forex Trading Course – Hector TraderDOWNLOADHector Deville (HectorTrader) Forex Trading Course – Hector TraderUpdate 08 Dec 2022All LevelsDOWNLOADHector Trader’s 3SMA Forex trading methods is a trend-following system, which makes it incredibly simple to use. Hector Trader also offers a proprietary trend scanner for users to assist them detect and benefit from trends.
Add to wishlist -
Piptastic – Damon ElliottDOWNLOADPiptastic – Damon ElliottUpdate 22 Dec 2022BeginnerDOWNLOADFinancial markets expert teaches you how to trade the financial markets from the ground up. The Piptastic course includes a pdf download of real course content that can be used as a reference guide and printed out. This is backed by a live trading room and a membership site, so learning does not stop once the course is paid.
Add to wishlist -
Self-Managed Trading with Stochastics – George LaneDOWNLOADSelf-Managed Trading with Stochastics – George LaneUpdate 08 Dec 2022AdvancedDOWNLOADDVD Lecture by Mr. Lane, the originator of Stochastics is now available on DVD for the first time. Lecture has been presented at seminars all over the U.S. and abroad for prestigious groups like TAG, the Market Technicians Society, Futures International Seminars, and others.
Add to wishlist -
The Most Crucial Parts of a Trading Plan – Gregoire DupontDOWNLOADThe Most Crucial Parts of a Trading Plan – Gregoire DupontUpdate 06 Nov 2022IntermediateDOWNLOADThe Most Crucial Parts of a Trading Plan by Gregoire Dupont shares the effective methods and the proven process to build a plan. There are various case studies and examples for better understanding.
Add to wishlist -
Pyrapoint – D.E.HallDOWNLOADPyrapoint – D.E.HallUpdate 02 Feb 2023All LevelsDOWNLOADTrader W.D. Gann employed the pyrapoint system as a basis for his trading deals. “Reno” worked for Gann for six years, sharing tight trading desks, and reinforced Gann’s secretive demeanor. He said Gann carried a little piece of paper with him when he was in the “pit” for his most successful deals. Reno said that this paper was a small Pythagorean Cube.
Add to wishlist
Reviews
There are no reviews yet.