Course content includes:

• Must-know Tools and Techniques
• Key points on upgrading from Excel 2003 to 2007 Absolute referencing, Named Ranges
• Time saving shortcuts
• Formulas you simply cant live without LOOKUP, VLOOKUP, HLOOKUP, Logical functions eg. IF, AND Aggregation functions eg. SUMIF, COUNTIF Financial Functions eg. NPV, IRR, PMT Formula Nesting
• Bullet-proofing your Model Protect data by locking cells Password Protection Restricting incorrect data entry with data validations
• Using worksheet protection to prevent entry Protecting your file using Read Only and password protectionCharting
• Creating and modifying a chart Making your charts look fabulous Charting tips, tricks and shortcuts
• Essential Advanced Tools Autofilters Goal Seek Macros Pivot Tables Array formulas
• Scenario Tools Scenario Manager Drop-down boxes -In cell drop-down boxes -Combo boxes Data Tables,
• Other Useful Stuff Spin buttons Hiding Working with dates Hyperlinking Conditional formatting

You will learn how to:

• Apply the key functions in Excel to your own models
• Select the most appropriate formula to achieve the desired outcome
• Create in-built error checks and variance alerts
• Prevent incorrect use of your model by protecting worksheets
• Validate data entry by setting data entry parameters
• Create a navigation page to help users find their way around your model
• Develop drop-down boxes which enable a model to produce a series of results depending on scenario variable selected