Microsoft Excel Data Visualised and Data Formatting
Level: Advanced, Intermediate
Learn with Wales leading Microsoft Office training provider
Courses available on all Microsoft Office applications
Microsoft certified trainers with 5 Star customer ratings
Classroom, Online, Onsite and Virtual courses available
Bespoke Microsoft Office training courses available
Welsh Government funding accepted
Course Overview
Duration:
1 day (9:30am-3:00pm)
Accredited:
Available upon request
Exams:
N/A
Funding:
ReAct
Type:
Classroom, Online, Onsite, Virtual
Company group booking discount available
Course Overview
Duration:
1 day (9:30am-3:00pm)
Accredited:
Available upon request
Exams:
N/A
Funding:
ReAct
Type:
Classroom, Online, Onsite, Virtual
Company group booking discount available
In this Microsoft Excel Data Visualised and Data Formatting training course, delegates will learn how to quickly interpret and analyse data sources using Excel.
After completing this course delegates will be able to:
- Apply conditional formatting rules
- Apply conditional formatting formulas
- Manage and delete formatting rules
- Adding and utilising Sparklines
In this Microsoft Excel Data Visualised and Data Formatting training course, delegates will learn how to quickly interpret and analyse data sources using Excel.
After completing this course delegates will be able to:
- Apply conditional formatting rules
- Apply conditional formatting formulas
- Manage and delete formatting rules
- Adding and utilising Sparklines
Microsoft Excel Data Visualised and Data Formatting
Conditional Formatting
- Highlight Cell Values i.e. Find Duplicates
- Top and Bottom Rules
- Data Bars
- Colour Scales
- Icon Sets
Conditional Formatting Formulas
- Sum Function
- Average Function
- And / OR Functions
- Formulas and Cell Referencing
Conditional Formatting Date Formulas
- Now Function
Managing and Deleting Conditional Formatting Rules
- Conditional Formatting and Data Validation
- Conditional Formatting and Paste Special
- Adding Conditional Formatting settings to empty cells
- Conditional Formatting and Linked Data
- Adding Sparklines
- Formatting and Modifying Sparklines
Microsoft Excel Data Visualised and Data Formatting
Conditional Formatting
- Highlight Cell Values i.e. Find Duplicates
- Top and Bottom Rules
- Data Bars
- Colour Scales
- Icon Sets
Conditional Formatting Formulas
- Sum Function
- Average Function
- And / OR Functions
- Formulas and Cell Referencing
Conditional Formatting Date Formulas
- Now Function
Managing and Deleting Conditional Formatting Rules
- Conditional Formatting and Data Validation
- Conditional Formatting and Paste Special
- Adding Conditional Formatting settings to empty cells
- Conditional Formatting and Linked Data
- Adding Sparklines
- Formatting and Modifying Sparklines
Microsoft Excel Data Visualised and Data Formatting
There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session. For accredited Microsoft Office training options please view our ICDL courses or contact us for further options.
Microsoft Excel Data Visualised and Data Formatting
There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session. For accredited Microsoft Office training options please view our ICDL courses or contact us for further options.
- 1-day training from NILC’s Microsoft certified trainers
- Practice files that will be used throughout the course
- PDF course manual with full step-by-step guide and images of each skill covered
- Recording from each training day (virtual-live courses only)
- Course completion certificate
- 1-day training from NILC’s Microsoft certified trainers
- Practice files that will be used throughout the course
- PDF course manual with full step-by-step guide and images of each skill covered
- Recording from each training day (virtual-live courses only)
- Course completion certificate
Are your Microsoft Excel courses accredited?
Our Microsoft Excel courses are focused around the key skills individuals and businesses require on a daily basis, so are not accredited. If you wanted an accredited course please contact us to discuss the options we have available.
Are your virtual Microsoft Excel courses recorded?
Yes all of our Microsoft Excel courses are recorded. Learners will receive a copy of the recording which was taken during their session at the end of the course.
What is included in the PDF course manual?
The PDF course manual is a full step-by-step guide with screenshots that covers each skill you will learn during the course.
Are your Microsoft Excel courses accredited?
Our Microsoft Excel courses are focused around the key skills individuals and businesses require on a daily basis, so are not accredited. If you wanted an accredited course please contact us to discuss the options we have available.
Are your virtual Microsoft Excel courses recorded?
Yes all of our Microsoft Excel courses are recorded. Learners will receive a copy of the recording which was taken during their session at the end of the course.
What is included in the PDF course manual?
The PDF course manual is a full step-by-step guide with screenshots that covers each skill you will learn during the course.
Dates & Prices
Live Instructor-Led Virtual
Spaces: Available
Start Date: Tue 15 September 2026
Live Instructor-Led Virtual
Spaces: Available
Start Date: Tue 20 October 2026
Live Instructor-Led Virtual
Spaces: Available
Start Date: Tue 17 November 2026
Live Instructor-Led Virtual
Spaces: Available
Start Date: Tue 15 December 2026
Microsoft Excel Bundle
Save £67.50
Course Includes:
Microsoft Excel Introduction
Microsoft Excel Intermediate
Microsoft Excel Advanced
Create your own
Looking to do 2 or more courses? Contact us to create your own bundle
Can't find the course dates, location or delivery type you are looking for?
Fill out the request dates form above and we'll try our best to accommodate or contact us directly.
"*" indicates required fields
How we deliver our courses
Virtual
Our virtual courses allow you to access live instructor-led training from the same expert instructors that deliver our classroom courses, without leaving the comfort of your home or office. All virtual courses are fully interactive, and learners can communicate with their trainer and peers at any time.
Many of our virtual courses are also recorded, so you can recap over the content you learnt as many time as you wish.
Classroom
Our classroom courses allow you to learn and interact face-to-face with our expert instructors in a comfortable and modern training environment. All of our classroom based courses take place at NILC centers, or high quality training facilities, and include all required IT and physical equipment.
We also limit our class sizes to help promote better discussions and to ensure your learning experience is comfortable as possible.
Onsite
Save time and hassle by arranging for one of our expert instructors to come to you. Our onsite courses allow you to learn in a location of your choosing, and you can train as many or as few people as you want – from a single person or team to whole departments. We can also fully customize the course content to the specific requirements of your business or project.
We offer onsite courses throughout the UK and it can be a great team building opportunity for colleagues to come together, bond and discuss.
Online
Our Online Self Paced courses allow you to learn new skills from our expert instructors, in your own time and at your own pace. Our flexible online learning platform allows you to access content on your computer, tablet or mobile device, whether you’re on the move or at home. All our online courses come with immediate access and you can start learning straight away, from any internet enabled compatible device.
We also offer online email support from our expert instructors, so they’re always on hand and happy to help you with any questions which may arise.
Why choose NILC for your training?
Award-Winning Training with Industry-Leading Customer Satisfaction
Trusted Training Partner by Colleges, Government Organisations and Businesses
UK-Based Trainers with Real-World Industry Experience
Family-Run Business with Customer Service at Its Core
Rated Excellent on Trustpilot with 950+ Customer Reviews
Our learners rate us 'Excellent' on Trustpilot
Microsoft Excel FAQ's
Our Microsoft Excel courses are focused around the key skills individuals and businesses require on a daily basis, so are not accredited. If you wanted an accredited course please contact us to discuss the options we have available.
Yes all of our Microsoft Excel courses are recorded. Learners will receive a copy of the recording which was taken during their session at the end of the course.
The PDF course manual is a full step-by-step guide with screenshots that covers each skill you will learn during the course.
Yes we can arrange for our trainers to deliver courses onsite at your business premises. Please contact us for onsite course pricing.
Yes all our Microsoft Office courses come with a course completion certificate. This will be emailed to you upon course completion.
Microsoft Excel FAQ's
Our Microsoft Excel courses are focused around the key skills individuals and businesses require on a daily basis, so are not accredited. If you wanted an accredited course please contact us to discuss the options we have available.
Yes all of our Microsoft Excel courses are recorded. Learners will receive a copy of the recording which was taken during their session at the end of the course.
The PDF course manual is a full step-by-step guide with screenshots that covers each skill you will learn during the course.
Yes we can arrange for our trainers to deliver courses onsite at your business premises. Please contact us for onsite course pricing.
Yes all our Microsoft Office courses come with a course completion certificate. This will be emailed to you upon course completion.
Trusted By
Related Courses
Microsoft Excel Pivot Tables and Advanced Filtering
Level: Advanced, Intermediate
1 day (9:30am-3:00pm)
Accredited: Available upon request
Funding: ReAct
Microsoft Excel Intermediate
Level: Intermediate
Duration: 1 day (9:30am-3:00pm)
Accredited: Available upon request
Funding: ReAct
Microsoft Excel Custom Training & Support
1 day (9:30am-3:00pm)
Accredited: Available upon request
Funding: ReAct
Microsoft Excel Introduction
Level: Foundation
1 day (9:30am-3:00pm)
Accredited: Available upon request
Funding: ReAct
Microsoft Excel Advanced
Level: Advanced
1 day (9:30am-3:00pm)
Accredited: Available upon request
Funding: ReAct
Power Query for Microsoft Excel
Level: Intermediate
1 day (9:30am-3:00pm)
Accredited: Available upon request
Funding: ReAct