- Price
- £95.00
- Start Date:
- 4th December 2025
- Duration
- 1 day 9am - 4.00pm
Course Sheets
Who the course is for
The course is aimed at both new and existing employees whose role includes the use of spreadsheets. If you have had a career break and are looking to retrain within spreadsheets, this is also a great stepping stone.
What you will learn
The course will involve a wide variety of tasks within spreadsheets including Financial Functions, Lookup Functions, Database Functions, Named Ranges, Cell Formatting, Selection Techniques, Manipulating Rows and Columns
How you will learn
This one-day session will encompass learning through both theoretical and practical activity. This course is delivered in person at The Isle of Wight College.
Progression
Completion of this course will lead to greater skills for using Excel and some of its more complex functions which can then lead onto the advanced spreadsheets course.
What will I learn? (in detail)?
The course will involve a wide variety of tasks including:
Formulas
- Creating Formulas
- Copying Formulas
- Operators
- Using Operators in Formulas
- Formula Error Messages
- Relative Cell Referencing
- Absolute Cell Referencing
Functions
- Sum Function
- Average Function
- Max Function
- Min Function
- Count Function
- The Counta Function
- The Countblank Function
- Using the If Function
Selection Techniques
- Selecting a Cell, cell range, row & column.
Manipulating Rows and Columns
- Inserting Rows & Columns
- Deleting Rows& Columns
- Column Widths
- Row Heights