Excel Data Analysis and Visualisation in Excel
Learn how to analyse your data.
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.
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
Similar courses
WordPress: Create Websites & Blogs
Learn how to create a website or blog in WordPress
SketchUp for Web
Step into the world of 3D modelling with SketchUp, the ultimate user-friendly tool for modelli...
Premiere Rush - Quick and easy Video editing
Learn the essentials of editing clips, adding audio, titles and more.
PowerPoint: create presentations with professionalism and impact
Join our engaging short course to learn the fundamentals of PowerPoint.
Photoshop Visualisation Skills
During this course, we will provide you with the right tools to help you to present your archi...
Photoshop for Social Media
Learn how to compose eye-catching banners, design stunning social media graphics and more.
Photoshop for Photographers
Optimise your images for professional results.
Photoshop for Interior Design
This course introduces step-by-step techniques for interior designers to successfully use Adob...
Photoshop for absolute beginners
Develop essential skills in image editing on this Adobe Photoshop course for beginners.
Make Essay & Dissertation writing Easier using MS Word
Master Microsoft Word for writing dissertations and essays with this comprehensive course! Learn to ...
Introduction to Blender for 3D Modelling, Animation and Visualisation
Discover the basics of Blender.
Getting started with Adobe Photoshop
Take your first steps into the world of image editing and creation.
Getting started with Adobe InDesign
Learn all the basics on our Adobe InDesign Level 1 course.
Getting started with Adobe Illustrator
Explore the basic concepts and functions of Adobe Illustrator
Getting started with Adobe
Discover Adobe and explore which applications you want to master.
Get designing with Adobe Photoshop, InDesign and Illustrator
Creatively use Photoshop, Illustrator and InDesign together.
From Beginner to Master: Premiere Pro
This series of Premiere Pro courses will enhance your digital skills in the competitive jo...
From Beginner to Master: Photoshop
This series of Photoshop courses will enhance your digital skills in the competitive job m...
From Beginner to Master: InDesign
This series of InDesign courses will enhance your digital skills in the competitive job ma...
From Beginner to Master: Illustrator
This series of Illustrator courses will enhance your digital skills in the competitive job...