Topic 4: Managing Data in Excel Video Presentations
Completion requirements
To investigate the topic of Managing Data in more detail, now view the following video presentations which demonstrate Conditional Formatting Rules, using the Vlookup Function, Pivot Tables and examples of the application of Pivot Tables in Excel.
3. Excel 4.3 Pivot Tables
Transcript: Slides
Watch a video in which Claudio Vallar explains how to organise, filter, summarise and analyse data using Pivot Tables.