Excel nerd day intermediate
Short course
Inhouse
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
Reviews
Course programme
- 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