Advanced Excel

Categories: Basic Knowledge
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

What you’ll learn

  • Differentiate yourself at work. Quickly and dramatically
  • Get hired in Finance – financial modeling skills are the critical edge you need at interviews
  • Take your career to the next level!
  • Get a certificate of completion
  • Build financial models from scratch (shown step-by-step)
  • Format sheets and charts professionally
  • Learn new keyboard shortcuts and be even faster in Excel
  • Understand advanced Excel functions
  • Build nested functions
  • Use Excel’s financial functions and understand concepts like: Present Value, Future Value, Discounted Cash Flows, Net Present Value, and IRR
  • Build flexible Excel models
  • Use Cell Styles and format spreadsheets easier and faster
  • Learn several hidden Excel tips and tricks
  • Understand the core principles of financial modeling
  • Learn financial modeling best practices
  • Design principles for good model building
  • Build integrated financial models
  • Forecast financials and use scenario analysis tools
Show More

Course Content

Basic Of Excel

Mathematical Functions
SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT

Student Ratings & Reviews

No Review Yet
No Review Yet