inline-defaultCreated with Sketch.

This website uses cookies to ensure you get the best experience on our website.

Students
Tuition Fee
GBP 85
Start Date
Medium of studying
Fully Online
Duration
Program Facts
Program Details
Degree
Courses
Major
Data Analysis | Data Analytics | Data Management
Area of study
Information and Communication Technologies
Education type
Fully Online
Course Language
English
Tuition Fee
Average International Tuition Fee
GBP 85
Intakes
Program start dateApplication deadline
2025-06-20-
About Program

Program Overview


Excel Data Analysis and Visualisation in Excel

Course Overview

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


Key Details

  • Location: Online
  • Tuition fees per individual: £85*

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.

Course Lead

Matthew Abbott 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.


What to Expect

  • 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

Computer Requirements

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

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.


Upcoming Short Courses

Excel


Fri 20 Jun 2025


10:00 - 13:00 | Price: £85


Short Course: Excel Data Analysis and Visualisation in Excel | June 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 | June 2025


See previous items See next items


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


SHOW MORE
Location
How can I help you today?