Investopedia – EXCEL FOR FINANCE INTERMEDIATE COURSE BUNDLE
COURSE DESCRIPTIONTHIS ONLINE COURSE IS FOR INTERMEDIATE USERS WHO WANT TO TAKE EXCEL SKILLS TO THE NEXT LEVEL USING REAL-WORLD, PROFESSIONAL CASE STUDIES. YOU’LL
- Benefit from real-world practices used by professionals serving Fortune 100s
- Create complex financial models that analyze multiple scenarios simultaneously
- Employ industry best practices to ensure your work is easily auditable by executives, stakeholders, and colleagues
- Discover actionable ideas by mining data like an expert analyst
- Display your findings clearly in beautifully designed charts
COURSE CURRICULUM
WELCOME
- Mac Shortcuts
- Goal Setting
CASE STUDY: VISA INCOME STATEMENT
- Visa Income Statement Model and Scenatio Workbook
- Visa FY Estimates
- Introduction to Visa Income Statement
- Visa Reuters Estimates
- Visa Y Charts Estimates
- Walkthrough
- Creating the Operating Scenatio
- 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
ABOUT THE INSTRUCTOR

DANIEL JASSY
CFADaniel Jassy, CFA, worked on idea generation, due diligence and modeling as a portfolio manager for a long-only equity fund. He attended the Charles W. Lamden School of Accountancy at San Diego State University. Daniel was awarded the Chartered Financial Analyst® designation in August of 2016 after passing levels I, II and III of the CFA ® exam. He currently designs and develops trading-analysis software, which provides an edge to portfolio managers by lowering execution costs.
11 reviews for Investopedia – EXCEL FOR FINANCE INTERMEDIATE COURSE BUNDLE
There are no reviews yet.