EXCEL EXPERT PRO

EXCEL EXPERT PRO

Course Syllabus

Formulas & Functions

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
  • Go rogue and design your own formula-based formatting rules
  • Join datasets from multiple sources in seconds with lookup, index & match functions
  • Pull real-time data from APIs directly into Excel (weather, stock quotes, directions etc.)
  • Automate tedious and time-consuming analytics tasks using cell formulas and functions in Excel

Data Analysis With Pivot

  • Skills to take you from ZERO to PRO with Excel's most powerful data analysis tools
  • How to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow

Charts & Graphs

  • Deep understanding of WHEN, WHY, and HOW to use charts in Excel
  • Automated dashboards, scrolling charts, dynamic formatting and more!
  • Fun, interactive and highly effective lessons

Financial Modeling & Valuation

  • Learn how to build sound Financial Models and stand out at your job
  • An in-depth understanding of the mechanics of Company Valuation
  • Build your files in a professional way
  • Demonstrate superior Excel skills at work
  • Be prepared for your investment Banking, Financial Advisory or Consulting job

Stock Fundamental Analysis With Excel

  • Understand main financial statements
  • Interpret financial and investment ratios
  • Define a company's cost of equity, debt and capital
  • Valuate a company's theoretical stock price
  • Calculate a company's stock option prices 

REGULAR BATCHES

 Duration : 45 Sessions 

ENQUIRE NOW