Excel for Finance Beginner Course Bundle

A self-paced, online step-by-step guide in using Excel like top financial professionals

Led by CFA charterholder Daniel Jassy View Instructor Bio

See what other students are saying
$49.95 $49.95 USD
Lifetime Access
  • 24/7 access: all you need is internet
  • One-time payment: no additional fees
  • Money back guarantee
FAQs
Excel for Finance Beginner Course Bundle

Course Description

This online course is for beginners to get started using Excel to format, calculate and model data like financial professionals. You’ll

  • Benefit from expert advice, in simple language, from an accomplished financial analyst
  • Save hours every week by mastering keyboard shortcuts for formatting and navigation
  • Learn formatting best practices to share quality, easy-to-follow work with colleagues
  • Discover which Excel functions financial experts use daily (and which ones they don’t)
  • Create charts and dashboards to make financial info easily understood

Course Curriculum

Welcome
  • Mac Shortcuts
  • Goal Setting
  • Welcome
Navigation & Data
  • Navigation and Data Workbook
  • Introduction to NAvigation & Data
  • A Glimpse into Your Life as an Excel Pro
  • Navigation, Arrow Keys, SHIFT & CTRL
  • Inserting & Editing Cells, Rows and Columns
  • Deleting Cells & Commenting
  • Freezing Rows & Splitting the Screen
  • Special Paste: Your New Best Friend
  • Sorting 
  • Filtering
  • Conclusion to Navigation & Data
Formatting & Style
  • Formatting and Style Workbook
  • Introduction to Formatting & Style
  • Formatting Walkthrough 
  • The Five Rules for Financial Modeling
  • Cell Dimensions
  • Styling Fundamentals 
  • Styling Practice
  • Special Paste Review
  • Applying Special Paste to the Model
  • Best Practices for Number Formatting
  • Forward Multiples
  • Negative Numbers & Percentages
  • Go To Special 
  • Grouping Data
  • Conclusion to Formatting & Style
  • Formatting and Styling Workbook (Answers)
Formulas & Conditionals
  • Formulas and Conditionals Workbook
  • Introduction to Formulas & Conditionals 
  • Best Practices for Formulas and Conditionals 
  • Relative and Absolute Values Part 1
  • Relative and Absolute Values Part 2
  • Sum, Max, Min, Average
  • Median, Rank, Percentile, Bonus
  • Concatenation Part 1
  • Concatenation Part 2
  • IF
  • Asking IF Twice
  • Formula Error
  • AND
  • OR
  • SMALL
  • SUMIF
  • SUMPRODUCT
  • COUNT, COUNTA, COUNTIF
  • COUNTIFS
  • INDIRECT
  • INDEX
  • MATCH
  • INDEX and MATCH
  • Cell Color
  • Custom Formulas
  • Hidden Values
  • Test
  • Formulas and Conditionals Exercises
  • Conclusion to Formulas & Conditionals
  • Formulas and Conditionals (Answers) 
Charts
  • Charts Workbook
  • Introduction to Charts
  • Best Practices for Charts
  • The Basics
  • Selecting Data In Column Cahrts
  • Customize Your Chart Part 1
  • Customize Your Chart Part 2
  • Line
  • Columns
  • Football Field Part 1
  • Football Field Part 2
  • Charts Exercises
  • Conclusion to Charts
  • Charts (Answers)
Follow up Survey
  • Follow up Survey

About the Instructor

Daniel Jassy
Daniel Jassy CFA®

Daniel 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.