Advanced Excel

Categories: Ofiice Management
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

Text Formulas

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

Student Ratings & Reviews

No Review Yet
No Review Yet