Microsoft Excel: Structure, Analyse and Pivot your Data in Excel
Duration 1 day
Team Professional Development
Microsoft Excel: Structure, Analyse and Pivot your Data in Excel

Learning Outcomes:

At the completion of this course you should be able to:

  • Sort data
  • Assign data validation including creating drop-downs
  • Use a range of find and replace techniques
  • Filter data in a table
  • Use advanced filters to analyse data in a list
  • Apply conditional formatting to ranges in a worksheet
  • Utilise text functions
  • Understand and create simple PivotTable reports
  • Construct and operate PivotTables using some of the more advanced techniques
  • Create and edit a PivotChart


The course is designed for participants who have attended the “Microsoft Excel – Essentials” course or have a good working knowledge of Microsoft Excel.

To participate in this session you will need to have the latest version of Microsoft Office installed on your device before the session starts. If you are unsure if you have the latest version please see the Install Office Updates web page.  This session will focus on the Windows version of Microsoft Office.

If you require support please see the IT Service Desk web page for more help as technical support cannot be offered by the course leader.


Course Leader input, demonstrations, and hands-on practical sessions.

You are required to attend the whole of the course, this is not a "drop in" session.

LocationStart DateAll DatesTimesPlaces AvailableBook
University Park30 July 202430 July 20249:30am - 4:30pm17
Online Course27 August 202427 August 20249:30am - 4:30pm12