BASIC Excel Training - Online
Category
Work Processes
Audience
Anyone interested.
Duration
3 hours
Delegate rate
Approximately £100 per day per delegate. Charges depend on how many delegates book.
This course is designed to help delegates with a basic existing experience of Excel to gain a better understanding and increased confidence in using the software.
Excel shortcuts
- Tips, tricks and shortcuts for navigating in Excel
- Shortcuts for selecting data, and for working with worksheets, workbooks and ranges of cells
Working with Calculations
- Overview of formulas
- Overview of essential functions - SUM, MAX, MIN, AVERAGE and COUNT
- Cell references within Formulas and Functions
- Understanding absolute references
Formatting in Excel
- Formatting text
- Working with cell colours and borders
- Aligning and rotating text
- Merging cells
Working with lists of data
- Using Freeze Panes to fix headings in place
- Using the sort tools
- Using auto-filter
Creating charts in Excel
- Creating a basic column chart
- Changing chart options
- Formatting charts
- Creating pie charts
30 June 2026 at 09:30
Delivered online. You must attend all the sessions.
Please note you will be expected to use your camera and display your name on all training. If unable to comply, please ensure the trainer understands why and notes your name and authority for recording attendance.
9 spaces remaining