Topic 1: Excel Foundations 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 1: Excel Foundations Video Presentations |
| Printed by: | Guest user |
| Date: | Sunday, 1 June 2025, 10:25 AM |
Description
Now view the complete set of Excel Foundations video presentations which take you through formatting cells, organising data, viewing data, keyboard short cuts and Excel applications.
1. Excel 1.1 The Worksheet
Transcript: Slides
Watch a video which introduces the Microsoft Excel software and some useful terminology.
2. Excel 1.2 Formatting Cells
Transcript: Slides
Watch a video which explains how to format cells in Excel.
3. Excel 1.3 Organising Data
Transcript: Slides
Watch a video which introduces how to organise data with the help of the Sort, Filter, find and Replace tools.
4. Excel 1.4 Data Visualisation
Transcript: Slides
This video introduces an easy way to improve the data view by applying commands such as freeze panes, group rows or columns and hide/unhide.
5. Excel 1.5 Shortcuts
Transcript: Slides
Watch a video which introduces keyboard shortcuts and the advantages of using them during data analysis.
View and download an Excel Shortcuts PDF Guide.
6. Excel 1.6 Application and Example
Watch a video which shows an example in Excel using the skills developed in this session.