Two male students seated while looking at a laptop

Fundamentals of Excel for the Workplace

Learn the basics or brush up on your MS Excel skillset.

Key details

Location

Online

Course duration

2 days

Course overview

This full-day beginners’ course is for those who want to learn Excel fundamentals. It covers everything from navigating the interface to adding, editing and formatting data and from importing data to using tables, charts and basic formulas.

This course is Ideal for getting started and gaining confidence with Excel.

Tuition fees per individual: £150*

Available courses

Online:

21 & 28 November 18.00 - 21:00
5 & 12 February 13:00 - 16:00
13 June, 09:00 - 16:00

Book course

*If you're a student or staff different fees apply. Please visit our dedicated student and staff areas for specific information.

Course details

What you'll learn

Explore the Interface: Get comfortable with Excel's layout and features.
Workbooks and Worksheets: Learn to navigate and manage your files efficiently.
Adding and Editing Data: Master the essential skills of data entry and modification.
Formatting and Conditional Formatting: Discover how to make your data visually appealing and easier to understand.
Simple Formulas: Start calculating with basic formulas to streamline your tasks.

Importing Data: Seamlessly bring in data from various sources.
Text-Based Formulas: Manipulate text within your cells for better insights.
The 'If' Formula: Introduce logic into your spreadsheets for smarter data management.
Creating Tables, Filtering, Sorting, and Searching: Leverage slicers for more intuitive data exploration.
References: Understand how to reference data across your workbooks.
Creating and Modifying Charts: Visualise your data with professional-quality charts.

How you'll learn

Our online courses are delivered through Microsoft Teams, ensuring a seamless learning experience. Each session starts with a live broadcast from the tutor to introduce the topic and guide you through the resources. Our courses include various learning methods such as videos, quizzes and exercises. The tutor remains available online for real-time support, making learning effective and enjoyable. Our blended teaching approach combines live and pre-recorded content, providing flexibility to learn at your own pace.

Matthew Abbott - Course Lead

Matthew is a digital skills trainer at Falmouth, specialising in Microsoft Office 365 and Adobe Premiere Pro. He delivers a range of Adobe and Microsoft Courses including Microsoft Office Specialist (MOS) and Adobe Certified Professional (ACP) courses. He holds a degree in sustainable product design and a PCET teaching certificate and have taught as a Senior Technician at Falmouth University for over 20 years.

Find out more

Read our short course terms & conditions