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

Prequisites:

The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheets users. It is designed for users who do use (or will use) Excel on a semi-regular basis, and are comfortable with using its basic tools and functions. At minimum, it is assumed that participants will know how to: · Navigate confidently in Excel · Create and use simple formulas · Link between workbooks