Training at Blue Novation

 

 

Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.

Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.

Excel Pivot Tables: Get a Handle on your Data

Excel’s Pivot Tables enable you to quickly create concise reports from large data sets, spot trends by consolidating information and display results for multiple variable questions ‐ plus you can easily create Pivot Charts to visually represent your data. Stop writing complicated formulas, creating multiple worksheets, and using Sort and Filter commands ‐ and make Pivot Tables do the work for you!

Course Topics

 analysing data using pivot tables
 creating pivot tables from worksheet data
 recommended pivot tables
  using the pivot table wizard
 using the pivot table toolbar
 managing pivot tables
 modifying a pivot table
 filtering & sorting pivot table
 using slicers to filter pivot table data
 adding sparklines to a pivot table
 adding calculated fields to a pivot table
 creating a chart from a pivot table
 showing/hiding pivot table data

Course Dates

Course Dates

Book two places on the same workshop and get the second place half price!

4th Dec 2019 – Spaces available
22nd Jan 2020 – Spaces available

Course Duration

90-minutes

Scheduled Course Fee

£49 + VAT

Course Timings

13.30-15:00

Location

Ipswich

Prerequisites

Delegates should be regular users of Excel and have a good understanding of formulas, navigation techniques, and formatting.

Training Formats

Scheduled course · private course · tailored · 1 to 1 (all instructor led)

Manuals

A comprehensive course manual provides support throughout the course and upon your return to the office.

Not found the course you are looking for?

 

We can create a tailored workshop to suit your
specific business requirements. Get in touch to find out more.

BlueNovation_logo_WA

 

 

Address: Contact us on:
NG7 Columba House, Adastral Park, 0345 11 88 150Call now
Martlesham Heath, Ipswich, IP5 3RE Email usinfo@bluenovation.co.uk