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.
Get Download Investopedia – EXCEL FOR FINANCE INTERMEDIATE COURSE BUNDLE at Offimc.click Now!
Delivery Information
- Upon ordering the product, a delivery email with download instructions will be sent immediately to you so that you may download your files. If you log in (or create an account) prior to purchase you will also be able to access your downloads from your account dashboard.
- It is a digital download, so please download the order items and save them to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link to you.
- If you don't receive the download link, please don’t worry about that. We will update and notify you as soon as possible from 8:00 AM – 8:00 PM (UTC+8).
- Please Contact Us if there are any further questions or concerns you may have. We are always happy to assist!
8 reviews for EXCEL FOR FINANCE INTERMEDIATE COURSE BUNDLE – Investopedia
There are no reviews yet.