Microsoft Excel: Structure, Analyse and Pivot your Data in Excel
Duration 1 day
Training Points 2.0
Team Professional Development
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.

We recommend that you attend the half-day “Introduction to Database Design” course which will introduce participants to the concepts behind database design.

Course Leader input, demonstrations, and hands-on practical sessions.
LocationStart DateAll DatesTimesPlaces AvailableBook
Online Course14 June 202114 June 20219:30am - 4:30pm5
Online Course12 July 202112 July 20219:30am - 4:30pm16