Excel Data Analysis and Visualisation in Excel

Learn how to analyse your data.

Key details

Location

Online

Course overview

Elevate your Excel skills with this course, designed for those eager to master data analysis and visualisation.

Learn to import and clean data efficiently, speed up data processing, and utilise referencing and data validation. Unlock the power of PivotTables and XLOOKUP to streamline your data handling.

This course is ideal for enhancing your existing Excel knowledge, empowering you to tackle complex data tasks with ease.

Tuition fees per individual: £85*

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

How to apply

See course dates below that are available to book.

Upcoming Short Courses

Person sat at a computer looking at data

Excel

Wed 26 Mar 2025

18:00 - 21:00 | Price: £85

Short Course: Excel Data Analysis and Visualisation in Excel | March 2025

Online

Elevate your Excel skills with this course, designed for those eager to master data analysis and vis...

Short Course: Excel Data Analysis and Visualisation in Excel | March 2025

If no upcoming Short Courses are displayed above, get in touch with us for more information.

Course details

This course is designed for individuals with basic Excel skills who wish to deepen their knowledge of data analysis and visualisation.

You’ll learn how to import and clean data efficiently, streamline data processing, and apply referencing and data validation techniques to ensure accuracy.

Additionally, we’ll explore PivotTables and the XLOOKUP function, equipping you to analyse and manipulate data effectively within your Excel worksheets. By the end of the course, you’ll have the confidence to work with data more efficiently and accurately.

How you'll learn

Our online courses are delivered via Microsoft Teams, ensuring a seamless learning experience. Each session begins with a live broadcast from the tutor, introducing the topic and guiding you through the resources. Our courses incorporate various learning methods, including videos, quizzes, and exercises. The tutor remains available online for real-time support, making learning both effective and enjoyable. Our blended teaching approach combines live and pre-recorded content, offering flexibility to learn at your own pace.

What you'll learn

Harness the powerful capabilities of Power Query for seamless data import and cleaning, ensuring accuracy and efficiency.
Elevate your formula game by mastering Named Ranges, making calculations more intuitive and error-free.
Optimise references with relative, absolute, and mixed types to enhance formula flexibility and precision.
Implement robust data validation techniques to maintain dataset integrity.
Utilise PivotTables for advanced data analysis, unlocking deeper insights and trends.
Speed up your workflow with the Ctrl + E shortcut, making repetitive tasks a breeze.
Get acquainted with Excel’s newest lookup function, XLOOKUP, the advanced successor to VLOOKUP, to streamline data retrieval processes like never before.

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) qualifications. He holds a degree in Sustainable Product Design and a PCET teaching certificate, and has served as a Senior Technician at Falmouth University for over 20 years.

Find out more

Engaging content
A variety of different ways to learn
Clear guidelines to work through the practice exercises
Constructive feedback from tutors on your submitted work
Technical assistance from your tutors

Access to full working subscription of Office 365. The desktop application of Excel will be required.

Read our short course terms & conditions

Terms and Conditions for Non-Credit Bearing Short Courses (284.08 KB)

How to apply

Tuition fees per individual	£85*

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

To apply for this course, make your selection from the available dates below, this will take you to an event page where you will be able to book yourself onto the course via the Book now link.