Updated on: 05-08-2024
Excel - Introduction (half day)
Topics covered
Getting Started
- Entering text and numbers
- Data entry techniques
- Data entry keyboard shortcuts
- Editing data
- Worksheet navigation shortcuts
- Data selection techniques
Formatting
- Changing fonts, size and applying colour
- Changing number style and decimal points
- Exploring cell formatting
- Formatting rows and columns
Sorting and Filtering
- Using Sort and Custom Sort options
- Applying Filters
- Using filters to analyse data
Simple formulae
- Using Auto calculate
- Using Excel like a Calculator
- Using the Autosum function
Printing
- Hassle free 1-2-3 printing rules
- Print Preview
- Page Setup
- Printing part of a worksheet
Online training will be delivered via MS Teams. You will receive joining instructions the day before your selected session
At the end of the session all delegates will:
On successful completion of this course you will be able to:
- Review spreadsheets and navigate a worksheet
- Select and format columns, rows and cells
- Use data entry techniques
- Add and edit formulae including Autosum and calculator functions
- Print and adjust page setup functions
About the course
| Course Code | MLCSU-TR0085 |
|---|---|
| Intended Audience | Newcomers to Excel or those who require a refresher |
| Delivery Method | Online |
| Required Experience / Training | No previous experience required Quiet room with access to MS Teams and headset or headphones |
| Duration of Training | 2 - 2.5 hours |
Premium Content
This course requires a paid subscription to access. Please login to see if your organisation has a subscription.