Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Days

* Price is exclusive of VAT.

Tell Me More






First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.

Excel training testimonials from Brentwood

Supply Chain Academy

"I would like to say a big thank you for Simon for all of his help. His training has helped to bring back some of my lost knowledge and also have expanded my knowledge too! Will definitely be recommending to others. Thank you so much once again."

Tusker Direct

"Thank you, Gary. The explanations/terminologies were very simple. The steps to follow were quite straightforward. Many thanks, I leant a lot of tricks and functionalities that will be important for me on a daily basis. "

Uniserve

"Really inciteful day, it helped explain a lot of what i have seen on previous spreadsheets. it has opened the door to other functions too and i would be really interested in the advanced training."

Uniserve

"Very informative and energetic. Definitely explained in a way which made sense."

Microsoft Excel Pivot Tables Training Course - Beginners Training in Brentwood

Brentwood Beginners Microsoft Excel Pivot Tables Course Overview

Microsoft Excel Pivot Tables Training Course Beginners training in Brentwood

Brentwood is a convenient Essex location for businesses looking for practical, instructor-led Microsoft Excel Pivot Tables Training Course training. We can deliver the course either at your premises or at a local venue, depending on what works best for your team.

The venue works well for PivotTables training because delegates have time to sort, summarise and analyse larger datasets without rushing through the practical exercises.

3 The Drive
Jubilee House
Great Warley
Brentwood
CM13 3FR
United Kingdom

The Brentwood venue is well placed for teams travelling from Essex and East London. That makes it particularly useful for teams who want to turn raw spreadsheet data into clearer reports and more useful summaries.

If you are also comparing other options, you can view our training courses in Brentwood.


Microsoft Excel Pivot Tables training for Brentwood teams

We can deliver Microsoft Excel Pivot Tables Beginners training for organisations in Brentwood and nearby areas such as Chelmsford, Billericay, Basildon, Romford, Shenfield and central Essex. Sessions can be run live online, at your premises, or at a local training venue where that suits your team better.

Access and venue details

The Brentwood venue at Jubilee House, Great Warley, works well for Essex and East London teams. It gives delegates a professional setting away from the office while still being practical for local road and rail travel.

Local training use cases

Microsoft Excel Pivot Tables training in Brentwood is useful for teams who want skills they can apply quickly in real work. The venue works well for PivotTables training because delegates have time to sort, summarise and analyse larger datasets without rushing through the practical exercises. That makes it particularly useful for teams who want to turn raw spreadsheet data into clearer reports and more useful summaries. It suits users who need practical reporting skills they can apply quickly in day-to-day spreadsheet work.

Brentwood is a strong setting for Microsoft Excel Pivot Tables Training Course Beginners training. The venue works well for PivotTables training because delegates have time to sort, summarise and analyse larger datasets without rushing through the practical exercises. It suits users who need practical reporting skills they can apply quickly in day-to-day spreadsheet work.

You need to get answers to questions and you need them quickly. How many people buy a certain product? In which month should we discount that product? If you've yet to embrace Pivot Tables, then you won't know how quickly you can get answers. Not only that but you can within minutes create effective summary tables and charts to be used in presentations and reports.

This course is designed specifically to look at Pivot Tables. You will learn how to correctly structure data, learning various Excel formulas and functions to enable you to do this. We will also take a look at the PowerPivot plugin in Excel, giving you an opportunity to use DAX with multiple data sources.

What You'll Learn

  • Quickly summarise large sets of data using powerful Pivot Tables.
  • Easily structure your data with Excel formulas like VLOOKUP, SUMIF, and INDEX MATCH.
  • Create interactive visual reports with Pivot Charts, Slicers, and Timelines.
  • Discover how PowerPivot and DAX calculations can connect multiple data sources.
  • Gain practical skills to prepare insightful presentations and reports in minutes.

Course Duration: 1 Days

Course Prerequisites for your training in Brentwood

To make the most out of this course, you should have:

  • Experience using Excel, including creating simple formulas.
  • A basic understanding of managing worksheets, such as adding rows and columns.

Complete Course Outline

Pivot Table Formulas

  • If Function
  • SUMIF
  • Flash Fill
  • VLookup
  • Index Match Function

Tables

  • Creating Tables
  • Using Functions with Tables
  • Sorting Data in Tables
  • Adding & Deleting Rows
  • Converting a Table back to a Range

Pivot Tables

  • Creating a Pivot Table from existing data in Excel
  • Formatting Pivot Table Data
  • Filtering and Sorting Data in Pivot Tables
  • Dates and Pivot Tables
  • Slicers and Timelines
  • Connecting Pivot tables using Slicers
  • Timelines
  • Pivot Charts

PowerPivot

  • Installing PowerPivot
  • Adding a Table to PowerPivot

Performing Basic DAX calculations

  • Inserting a column in PowerPivot
  • Creating a calculated column
  • Formatting data in columns
  • Adding data from a text file
  • Creating relationships
  • Pivot Tables the PowerPivot way
  • Date calculations in DAX
  • Setting a Date Order
  • Calculated Fields
  • Year to Date function in DAX
  • Viewing Sales from previous day
  • Using a Calendar Table

Location FAQs for Brentwood

Where can this training take place in Brentwood?

We can deliver this Pivot Tables training at your premises in or around Brentwood, live online, or at a suitable local training venue if you would prefer an external location.

Can you come to our office in Brentwood?

Yes. We regularly deliver on-site training for teams in Brentwood and can usually tailor the session to your team, your documents and the way you work.

Excel training centres near Brentwood

If Brentwood is not the most convenient option, we can also arrange instructor-led Excel training at nearby Computer Tutoring training centres.