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.
IMPORTANT - You will need a current copy of Excel.
By “current” anything currently supported by Microsoft is fine – so Excel 2021 onwards or the version which comes with Microsoft 365 (used to be called Office 365). You will also require exercise files for the sessions, which can be downloaded from this link: https://theitservice.co.uk/resources/
Use the “Download Excel training files” button that downloads a Zip file, and you will need to extract / unzip those files to your Desktop or Documents folder or similar so that you’re able to make changes to the files.
To extract downloaded files: Note that the screenshots below were taken on Microsoft Edge. If you are using Chrome or a different browser, the appearance will be slightly different but the steps remain the same.
The files will download as a .zip file. If you cannot see the “Downloads” window within the browser, press CTRL-J to show this:
- click the downloaded file. The zip file will open, and show the contents within Windows Explorer. For the Excel courses, there’s a single folder called “Excel training.
- Drag the folder from the panel on the right to the location where you want to store them in the panel on the left. For example, you may wish to store them in Documents or Desktop for the duration of the course, and move them somewhere more permanent at a later date.
This will unzip the files ready for you to use during the course. Remember where you’ve put them!
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.
No spaces remaining
Book this
14 July 2026 at 09:30
Delivered online. You must attend all the sessions.
Online sessions include usual breaks. Link(s) are auto-sent from [email protected] a few days in advance of delivery. Full instructions and course handouts will also be sent in advance.
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.
3 spaces remaining