It’s time to explore our campus to find out about studying at Chichester College.
Why choose this course?
This practical and interactive course provides delegates with the essential skills needed to use Microsoft Excel confidently and efficiently in the workplace. Participants will learn how to create, save, and manage spreadsheets, perform basic calculations, and use formulas and functions to automate and simplify tasks. The course also covers key spreadsheet management techniques, including adjusting column widths, adding comments, using absolute cell references, and copying formulas to improve accuracy and productivity.
Further information
Delegates will develop their skills in formatting and organising data to create professional-looking spreadsheets. Topics include formatting cells, applying currency formats, adding borders and shading, using Autofill, and managing rows and columns. In addition, participants will learn how to sort data, move and copy information efficiently, and use features such as Freeze Panes and Split Panes to navigate larger worksheets with ease. By the end of the course, delegates will be able to create, organise, and manage spreadsheets more effectively, improving both accuracy and efficiency in their day-to-day work.
- Getting started with Excel — understanding workbooks, worksheets, rows, columns and cells.
- Entering and formatting data — typing information, changing fonts, colours, borders, alignment and number formats.
- Basic formulas — using calculations such as +, -, *, / and understanding how formulas work.
- Common functions — including SUM, AVERAGE, MIN, MAX and COUNT
- Cell references — understanding relative and absolute references, such as A1 and $A$1.
- Sorting and filtering — organising large lists and finding specific information
- Creating tables — turning data into structured, easy-to-manage tables.
- Charts and graphs — creating simple visualisations from your data
- Working with rows and columns — inserting, deleting, resizing and freezing panes.
- Basic data management — copying, pasting, filling series and using Excel efficiently
Continue your Excel journey with our Intermediate course.
No formal assessment – just practical, hands-on learning
All delegates will receive a course manual, notepad and pen.