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
-
Trading with the Time Factor – vol.1 – Frank BarillaroDOWNLOADTrading with the Time Factor – vol.1 – Frank BarillaroUpdate 09 Nov 2022All LevelsDOWNLOADVolume 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 -
The Economics of Financial Markets – R.E.BaileyDOWNLOADThe Economics of Financial Markets – R.E.BaileyUpdate 08 Dec 2022All LevelsDOWNLOADThe Economics of Financial Markets by R.E. Bailey is a great book for both advanced undergraduates and beginning graduate students in financial economics. There are many aspects covered in the course such as an overview of capital markets and the underlying economic principles.
Add to wishlist -
How to Trade the Bull and Bear Opportunities in Expanded Flats – Elliott Wave InternationalDOWNLOADHow to Trade the Bull and Bear Opportunities in Expanded Flats – Elliott Wave InternationalUpdate 06 Dec 2022AdvancedDOWNLOADHow to Trade the Bull and Bear Opportunities in Expanded Flats by Elliott Wave International illuminates practical strategies to deal with both bull and bear markets. Thus, you can learn effective frameworks and how to apply them to real-world trading market for consistent profits.
Add to wishlist -
Asset Prices, Booms, and Recessions – Willi SemmlerDOWNLOADAsset Prices, Booms, and Recessions – Willi SemmlerUpdate 30 Nov 2022All LevelsDOWNLOADThe Asset Prices, Booms, and Recessions by Willi Semmler shed light on effective frameworks used by economists, practitioners, and policymakers to forecast the markets. Then, they can come up with effective strategies to adjust the situation for the best sake.
Add to wishlist -
Heard on the Street: Quantitative Questions from Wall Street Job Interviews by Timothy Falcon CrackDOWNLOADHeard on the Street: Quantitative Questions from Wall Street Job Interviews by Timothy Falcon CrackUpdate 21 Nov 2022All LevelsDOWNLOADHeard on the Street by Timothy Falcon Crack sheds light on the quantitative questions from Wall Street Job interviews. So, you can better prepare for the interview and realize your dream of becoming a wolf of Wall Street.
Add to wishlist -
Nicolas Darvas Trading Secrets Home Study Course – Jim CoxDOWNLOADNicolas Darvas Trading Secrets Home Study Course – Jim CoxUpdate 02 Feb 2023All LevelsDOWNLOADA new trading course teaches how Nicolas Darvas made $2 million in the market. “How a Full-Time Dancer Increased His Trading Account From $25,000 to $2 Million Dollars, and How You Can Do The Same In Just 15 Minutes Per Day”.
Add to wishlist
Reviews
There are no reviews yet.