Ms Excel
Data Validation and Conditional Formatting
Restricting cell input and applying rule-based visual formatting
2 CPD credits on completion
Enrol Now
Certificate on completion
Downloadable resources
Self-paced learning
About This Course
Course Information
This course covers the use of data validation and conditional formatting. It is divided into two sessions. The first session covers how to apply data validation, whereas the second session explains the use of conditional formatting.
Certificate on Completion
This course is made up of videos, questions and additional reading materials and accounts for 2 units of CPD. One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 2 units.
Course Sections
This Course is made up of the following sections:
- Data Validation and Conditional Formatting – Part 1(Video and Quiz)
- Data Validation and Conditional Formatting – Part 2 (Video and Quiz)
- Additional Reading Materials
What You Will Learn
- Apply data validation rules to restrict cell input to specific values, ranges, or lists
- Describe how conditional formatting changes cell appearance based on rules you define
- Explain the difference between data validation (controlling input) and conditional formatting (controlling display)
- Identify common use cases for each feature in financial reporting and data entry
- Apply colour scales, icon sets, or custom rules to flag cells that meet specific conditions
Who This Course Is For
- Accountants who build templates that other people will fill in, and need to prevent incorrect data entry
- Finance professionals who want to visually flag figures (e.g. overdue amounts, threshold breaches) automatically
- Excel users who want to make spreadsheets more reliable and easier to interpret at a glance
Prerequisites
- Basic Excel skills including entering data and simple formatting
- No prior experience with data validation or conditional formatting is required
Frequently Asked Questions
Course Details
CPD Credits2
CertificateYes
Pricing
Pricing
Invest in your professional development with flexible payment options.
Everything included in your subscription:
CPD certificate on completion
Downloadable resources
Self-paced learning
Expert-led content
24/7 access
Mobile friendly
Ready to Start Learning?
Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.
Enrol Now