Executive Reporting Using Dynamic And Interactive Excel Dashboards by NTUC LearningHub

Essential Built-in Functions

• Index
• Match
• Named Ranges

Developers Form Control Tools

• Combo box
• Scrolling bar
• Spin button
• Check box
• Option button

Additional Excel Tools

• Multiple-dependent drop-down lists (data validation)
• Protect worksheet with specified unlocked cells
• Show/hide gridlines, formula bar, headings
• Create a hyperlink to a location in the current document
• Nested if functions
• Conditional formatting

Charting Management

• Locking aspect ratio
• Prevent chart resizing with cells
• Categories in reverse order