Excel Module 2 - Data Analysis and Pivot Tables

Course overview

Duration: 1 day (6.5 hours)

Our Excel Module 2 – Data Analysis and Pivot Tables course looks at how to handle your data more efficiently. It looks at creating data to give a more visual appearance and shows tips and tricks for creating your own dashboards. It looks at how to manage large amounts of data and the best ways to handle and analyse data.

This course is aimed at existing users of Excel who want to increase their skills. Participants should be able to create and amend worksheets and build simple formulas.

Objectives 

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

• Manage worksheets and workbooks
• Link information between workbooks and worksheets
• Setup conditional formatting
• Create and manage data
• Filter and sort information
• Setup data validation
• Create and amend pivot tables
• Customise pivot tables

Content

Formula review and working with multiple worksheets 

• Building formulas and ordering calculations
• Absolute cell references
• Using functions
• Moving and copying worksheets
• Inserting and deleting worksheets
• Grouping worksheets
• Changing the worksheet tab colour

Transferring and linking data 

• Linking within a workbook
• Linking between workbooks
• Updating and managing links

Working with data 

• Organising data using Excel tables
• Table formatting
• Adding calculations into table columns
• Adding total rows
• Converting to an ordinary range

Sorting and filtering data 

• Sorting and filtering information
• Using date, number and text filters
• Using the search filter
• Adding slicers

Conditional formatting 

• Changing the cell format depending on set criteri
• Databars, Top/Bottom Rules, Colour Scales and Icon Sets
• Creating custom formula rules

Setting up data validation  

• Setting number and date validation
• Setting drop down list validation
• Setting custom validation

Analysing information using pivot tables

• Creating and modifying a Pivot Table
• Recalculating the Pivot Table
• Filtering the Pivot Table
• Searching the Pivot Table
• Drilling down to underlying data

Pivot table customisation

• Customising field names
• Changing field formatting
• Pivot Charts
• Using Slicers

Still have questions about this course?

Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Full Training Catalogue

We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.

Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.