This hands-on workshop will concentrate on summarising large amounts of data by creating quick automatic calculations and extracting subsets of data using criteria.
• Use conditional formatting
• Summarise data using subtotals
• Use advanced filters to analyse data in a list
• Create, modify and work with PivotTables to analyse and manipulate large sets of data
This event is only open to Abertay staff and students.