Excel Databases can be extremely useful...

...not just for lists but as a way of analysing our data to drive the business forward.

Excel Pivot tables are an excellent way of looking at the data in different ways and breaking down data into the packets that businesses need to analyse.  It could be that data needs to be compared region by region, product by product, sales person by sales person or any combination of.

By using a Pivot table and the tools data can be broken down into the areas that help you and your business.

Watch Intro Video

Find out more!

Play this short video

Who is this course for?

  • Compiling Reports

    If you have to compile reports from Excel database

  • Newly Promoted

    If you have recently been promoted to a position where data needs to be analysed

  • Creating Clarity

    If you have to present figures to colleagues/customers in a clear concise way

In more detail

Let's look at the Aims and Outcomes

The aim of this course is to:

Increase your knowledge and confidence in creating and using Excel Pivot Tables


Outcomes

By the end of the course you will be able to:

Create a pivot table and use features to analyse and present the data

  1. Define the database and format it correctly to ensure all data is captured
  2. Create a pivot table
  3. Manipulate the data
  4. Add and work with slicers and timelines
  5. Add and format a chart to visualise your data

Course Outline

    1. Welcome

    2. What will you be able to achieve?

    1. 1.1 Video Overview for Exercise 1

    2. 1.2 Excel workbook for your exercises

    3. 1.3 Instruction for Exercise 1

    1. 2.1 Video overview for exercise 2

    2. 2.2 Instructions for exercise 2

    1. 3.1 Video overview for exercise 3

    2. 3.2 Instructions for exercise 3

    1. 4.1 Video overview for exercise 4

    2. 4.2 Instructions for exercise 4

    1. And finally...

    2. How to 'GET YOUR CERTIFICATE'

About this course

  • £120.00
  • 13 lessons
  • 1 hour of video content

Price

Instructor Bio

Debbie Fagan

Debbie Fagan

Aspire Course Creator

Debbie has worked in the Software Training sector for 20 years and this has given her a vast range of skills and experience. Delivering high quality, tutor led training courses is a passion. She specialises in the Microsoft Office Suite including 365 and Excel. Over the years she has developed her own courses that allow the delegates to build their skills step by step and have developed her own after training course manuals. For further information about DEBBIE check out the 'COURSE CREATORS' page

Additional Courses

View more courses