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

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.

View our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses

Contact us

Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:

• Email: [email protected]
• Phone: +44 (0)20 8152 6551

Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.

Thank you for visiting our website, and we look forward to hearing from you!