Event details

What are the benefits?

• This course explains how to re-use data in other places by linking and also covers how to convert data to a Table to give extra functionality.
• Delegates will understand how to format numbers and how to do calculations with dates and times.
• The course covers Pivots to enable delegates to summarise large amounts of data.

Topics covered include:

Working across multiple worksheets and workbooks
• Linking across worksheets / workbooks
• Working in Group mode

Working with Tables
• Creating Tables
• Formatting Tables
• Using Slicers with Tables

Formatting Numbers

Working with Dates and Times

Pivot Tables and Charts
• Creating a Pivot Table
• Formatting a Pivot
• Updating your Pivot (refresh and source)
• Creating Pivot Charts

Who should attend?

This course is aimed at those who have a good knowledge of MS Excel and know how to create formulas such as sum, average, min, max, counta, countblank and countif. Delegates should also be able to work with named ranges, use lookups create charts and conditional formatting.