Topic 4: Managing Data in Excel Video Presentations
| Site: | QMplus - The Online Learning Environment of Queen Mary University of London |
| Module: | SEF PGT Welcome Week and Pre-Sessional - January 2025 |
| Book: | Topic 4: Managing Data in Excel Video Presentations |
| Printed by: | Guest user |
| Date: | Sunday, 1 June 2025, 11:38 AM |
Description
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.
1. Excel 4.1 Conditional Formatting
Transcript: Slides
Watch a video in which Claudio Vallar explains how to apply conditional formatting rules.
2. Excel 4.2 Vlookup Function
Transcript: Slides
View this video in which Claudio Vallar explains Excel’s Vlookup function.
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.
4. Excel 4.4 Pivot Tables Applications
Transcript: Slides
Watch a video in which Claudio Vallar shows an example of Pivot Tables in Microsoft Excel.