Course description
This half-day course includes how to work out the minimum, maximum and average in a range of cells also the importance of understanding how you should order which calculations correctly. You will learn how to centre headings, format numbers, and understand about fixing cells. It also covers viewing and amending page breaks. It shows participants how to manipulate worksheets, how to format multiple worksheets as well as perform calculations across them. Leaners will also learn how to perform calculations across workbooks.
Upcoming start dates
Suitability - Who should attend?
All staff. Ideal for those who are new to MS Excel and those who want to spend time practicing in the learning environment.
Training Course Content
By the end of the course, participants should be able to create a basic spreadsheet with simple calculations.
- Getting started
- The environment
- Terminology
- Creating, saving and closing workbooks
- Navigating
- The ribbon
- Mouse pointer
Working with data
- Entering data
- Today’s date
- Deleting versus clearing
- Selecting data
- Custom lists
Formulas and Functions
- Entering and editing formulae
- Add, subtract, multiply and divide
- Sum, min, max, average and count
- Order of calculation
- Relative and absolute references
- Displaying formulas
Why choose Reed Learning Limited
CIPD qualified tutors with strategic and practical HR experience
A dedicated personal adviser to support you throughout your programme
A flexible interest-free payment plan for all certificates and diplomas (up to 12 months)
Request info
Reed Learning Limited
Reed Learning is dedicated to delivering high-quality training and professional development for organisations. We make employee learning simple and effective with curated learning packages, a breadth of digital and in-person learning products, and tailored advice to help organisations find the...