Excel nerd day intermediate

Short course

Inhouse

Price on request

Description

  • Type

    Short course

  • Level

    Intermediate

  • Methodology

    Inhouse

  • Duration

    1 Day

Participants practice using an Excel modeling toolkit for advanced financial models. Suitable for: Associate Training Program

About this course

None

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Participants practice using an Excel modeling toolkit for advanced financial models.
  • Use of advanced functions
  • Pivot tables
  • Building data tables and solving data table problems such as using data tables across sheets and calculation issues
  • Use graphs to present data.
  • Create a "floating bar chart" for valuation presentations
  • Save graph formatting to help maintain consistency
  • Use comments to document their models
  • Print comments on the spreadsheet and "move" them so they don''t cover used cells
  • Using conditional formatting features and data validation
  • How to build macros in models

Excel nerd day intermediate

Price on request