Excel Visualisation
Choose the Training Option That Works Best for You
We offer two convenient delivery methods to suit your needs:
In-House Training: Perfect for organisations with four or more participants offering a cost-effective and flexible option. Training is delivered at your location and tailored to your needs. Contact us today to learn more or request a quote.
Public Training: Ideal for individuals or smaller teams (typically one or two learners) our public training sessions are scheduled regularly and open for registration. Register online today to secure your place!
Data Cleansing and Visualizing with Excel
This practical course is designed for professionals, analysts, and Excel users who want to enhance their data cleaning and visualization skills using MS Excel enabling more accurate analysis and informed decision-making.
In this one-day session, you will learn essential data cleansing techniques in MS Excel, including removing duplicates, handling missing values, and standardizing formats.
You'll explore advanced functions like TRIM, CLEAN, and Power Query for efficient data transformation. Additionally, you'll master data visualization by creating dynamic charts, pivot tables, and interactive dashboards to present insights effectively.
Through hands-on exercises, you'll gain practical experience in cleaning and visualizing real-world datasets for better decision-making.
Learning Outcomes
By the end of the course, you will have an understanding of the following topic areas:
|
Basic Data Cleansing Removing duplicates Find & Replace Filling in missing values UPPER, LOWER, PROPER Date and number formatting Data Validation Advanced Data Cleansing Techniques TRIM, CLEAN LEFT, RIGHT, MID, SUBSTITUTE IFERROR & ISERROR Text to Columns, Flash Fill CONCATENATE / TEXTJOIN Power Query for data transformation |
Data Visualization Conditional formatting Types of charts and when to use them Creating Interactive Dashboards Pivot Tables & Pivot Charts Slicers and Timelines Creating a mini-dashboard
Introduction to Power BI Power BI Interface & Data Import Creating Basic Visualizations Publishing & Sharing Reports
|
Is it for me?
If you wish to develop your skills in cleaning, organizing, and visualizing information efficiently, then this course is for you. If you frequently deal with messy data or need to present insights visually, then yes—this course is perfect for you!
Those wishing to progress to learn the more about Power BI should look at Mastering Data Insights: A One-Day Power BI Beginner Bootcamp training course.
.png)
.jpg)
Whether you're looking to develop a single team or roll out training organisation-wide we’ll work with you to ensure the programme/course(s) deliver maximum impact.
Interested? Contact us today to discuss in-house options.
-
LouiseLouise is an IT professional with over 22 years' experience in IT and telecommunications. During her career she has worked in IT consultancy, project management and as an in-house trainer.
Louise is an Associate with AKU Training and provides specialist IT training in Belfast including MS Excel, MS Word, MS Access, MS Project and marketing through Twitter and LinkedIn training.
Louise also runs her own IT consultancy in Belfast through which she operates as an IT consultant, mentor and IT trainer. She is an Accredited Microsoft Master Instructor and an accredited ECDL and Advanced ECDL Tester. She has worked as an Associate Lecturer with the Open University and a part-time lecturer with Castlereagh College and EDIFHE.
To register your interest in this course please click here
Please note that the cancellation policy for our public training courses is as follows:
NON-ACCREDITED TRAINING
More than 3 weeks prior to the course start date - No cancellation fee payable.
Less than 3 weeks prior to the course start date - 100% of total fees payable or free transfer.
ACCREDITED TRAINING
More than 6 weeks prior to the course start date - No cancellation fee payable.
Less than 6 weeks prior to the course start date - 100% of total fees payable or free transfer.
Substitute delegates will be accepted at any time at no cost.
Full joining instructions for the course will be emailed to you at least five working days prior to the course. In the meantime, if you have any queries please contact a member of our team on 028 9016 0587 or via email kate@aku.training.
Download a copy of our standard Terms and Conditions for course bookings.
