Excel Data Analysis and Visualisation in Excel
Program start date | Application deadline |
2025-06-20 | - |
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.