Learn from home - we offer this course as a live instructor-led virtual session delivered by the same expert trainers as our classroom courses
High quality training courses
We'll match like-for-like prices*
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
Date Visualised and Data Formatting Outline
- 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
This course includes:
- Training from an experienced Microsoft trainer
- Computer / Laptop to use for the duration of the course
- Detailed course notes and sample exercises
- Officeskills full colour course manual (if available)
- Free online Excel training videos
Course Key Points
Duration: 1 day
Practice Exam(s): N/A
Type: Available as Classroom, Virtual Live and In-house
Save time and money by letting our expert trainers come to your offices.
Enter your onsite training requirements below and a member of our team will be in contact with you to discuss them further.
Looking to book 4 or more delegates onto a single course?
Enter your group training requirements below and a member of our team will be in contact with you to discuss them further.
Learn new skills from our expert instructors in your own time and at your own pace.
Can’t find the course dates or training location you are looking for? We’ll try our best to accommodate.
Enter your training requirements below and a member of our team will be in contact with you to discuss them further.