Hands-on in-house Excel Tables and PivotTables training course


The primary objective of this half day Excel training course is to understand the benefits of the powerful Table Tools and learn how easy it is to create PivotTables to present and summarise your data.

Dates Friday, July 23, 2021 - Download as vCalendar
Event Times: 09:30 to 12:30
Venue sun house, 23 Queen Edith's Way, Cambridge CB1 7PH
Contact Name Karen Roem
Email karen@roem.co.uk
Contact Phone 01223214177
Website Event website

Event details:

Microsoft Excel Tables can be used to store and organise your data, any way you wish. You can use its powerful tools to quickly retrieve information and view and summarise it in numerous ways.

This training course allows you to appreciate the full potential of Pivot Table reports and will save countless hours in calculating and recalculating information.

What's included?

  • Self-study pack containing exercises and files to practise what you've learned at your own pace in your own time.
  • A month support on the topics covered.

By the end of the course you will be competent with the following skills:

Understanding tables

  • what is a table?
  • plan before you build
  • dos and don'ts when working with tables

Working with a table

  • set up a new table
  • format a table
  • ensure accurate data entry using data validation
  • add new data to an existing table
  • sort and filter the records of a table
  • specify a range of values as criteria for a filter
  • add totals to a table
  • preview and print tables

Summarising data in a table using PivotTables

  • what is a PivotTable?
  • produce summary reports using a PivotTable
  • reset the summary function
  • show totals as a percentage
  • insert a slicer to filter data interactively
  • present your information as a chart
  • preview and print reports and charts

Additional features

  • visually explore and analyse data using conditional formatting
  • create a dashboard using the DSUM and DAVERAGE functions
  • use a PivotTable to build a list of unique values
  • combine data from multiple worksheets using data consolidation
  • create conference labels, letters or emails using data in your table

This course outline is a guide. All our courses can be tailored to customer requirements.

Target audience
This course is aimed at anyone who has some experience of Excel and wishes to manage and analyse data in a worksheet.

Assumed knowledge
Delegates should be familiar with the basics of Excel, either from attending our Introduction or Getting Started Course or knowledge gained from their own experience

Price: £112.50 + VAT = £135
(10% discount for Cambridge Network members)
 

Book online or email karen@roem.co.uk or call Karen on 01223 214177

Once your booking is confirmed, the course is guaranteed to run.

Hello, I'm Karen and I help people get the most out of their computer software. Perhaps you're a scientist who needs to analyse your research data in Excel? Or a PA who wants to discover hidden features to tackle time-consuming and frustrating day-to-day tasks? Or a small business owner who wants to perfect a PowerPoint presentation?

Whatever your needs, I offer a training solution - from 60-minute webinars that easily fit into a busy schedule, to half-day and full-day hands-on training courses. Sessions can be held at your workplace or at my office in Cambridge. My hands-on courses can also be delivered online as a series of shorter virtual sessions, if necessary over a couple of days or weeks.