Due to the unfolding Coronavirus (COVID-19) pandemic, we will be temporarily suspending all training at our premises in Cambridge. Following the latest guidance from the government the measures will last for three weeks from 23 March, before being reviewed. When the time is right, we look forward to welcoming you back at the sun house
Roem Ltd - software training and support - Microsoft Excel Tables - Manage and summarise your data
The primary objective of this half-day course is to understand how to prepare your data, so that you can benefit from the powerful Table Tools to present data and communicate results with ease.
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.
The primary objective of this half-day course is to understand how to prepare your data, so that you can benefit from the powerful Table Tools to present data and communicate results with ease. This practical course allows you to appreciate the full potential of tables and will save countless hours in calculating and recalculating information. By the end of the course you will be competent with the following skills:
- 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
- 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.
This course is aimed at anyone who has some experience of Excel and wishes to manage and analyse data in a worksheet.
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
Highly respected computer software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.