Excel Nerd Day

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