Learn important, powerful formulas

• Avoid #DIV/0! errors with IF.
• Employ AND and OR to create complex tests for IF.
• SUM through sheets rather than create a formula that refers to a cell on each sheet.
• Use VLOOKUP to search for a matching code and return a value from a table.
• Use SUMIF and criteria to total certain values of a table.
• Understand how Excel stores dates and times.
• Calculate with dates and times.

Format conditionally

• Colour cells according to the band they fall within.
• Colour entire rows according to the band they fall within.

Sort and filter

• Sort in Excel 2007 and earlier versions.
• Apply a filter to view just the data that meets certain criteria.

Create charts to communicate results clearly

• Create simple charts.
• Customise charts.
• Add pie charts to your data-display diet.

Design clear reports

• Pick up conventions that make reports clear, professional and consistent.
• Learn to structure sheets for ease of navigation and minimisation of errors.
• Use the GenieMini add-in to rapidly build workbooks that have standard layouts.

Discover other useful features (optional topics)

• Document certain entries with Comments.
• Use ROUND to make totals reconcile with items totalled.
• Use Excel tools to trace formulas references.

Prerequisites

Excel users who can already create basic SUM and arithmetic formulas. Prior attendance at the Best-practice essentials course is not mandatory, though it would be useful. For those who want to: (i) master commonly-used powerful formulas; (ii) present results in a clear, professional and confidence-inspiring way.

• Be assured the advice you get is well-proven and utilised.
• Feel free to ask questions.
• Get time away from the office and constant interruptions.
• Enjoy a friendly environment where you don’t feel you’re holding others up.
• Instantly apply what you’ve learned on return to work.