Navigate quickly

These are everyday tasks that we can all speed up on.

• Move around, select and freeze panes quickly.
• Trace formulas.
• See two different sheets side by side.
• Create range names for speeding up navigation.

Learn the most-useful formulas

Most of what you need formulas for can be done with this toolkit selection

• Enter formulas rapidly with absolute cell-addressing.
• SUM through sheets.
• Calculate stats with AVERAGE, MIN, MAX, COUNT, COUNTA.
• Use IF to avoid #DIV/0!
• For complex criteria, use AND and OR.
• Use VLOOKUP to return a product description and price.
• Use SUMIFS

Place tables of data into Excel Tables

Tables prevent a number of common errors and speed up certain tasks

• Understand the benefits of Tables.
• Discover the filtering options.
• Add a Table Slicer to filter and show what is filtered.

Build PivotTables to report on imported data

If you work with tables of data, PivotTables should be part of your essential toolkit

• Create and format a PivotTable.
• Refresh a PivotTable.
• Rearrange a PivotTable.

Create and amend charts

Learn charts to clearly communicate data

• Create a column chart.
• Discover the different parts of a chart.
• Understand how to format the different parts.

Discover great tips

There are many great tips imparted throughout, but here's more

• Display zeros as dashes.
• Make sure option for parentheses around negatives is there.

• 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.