Breadcrumb

ActivitatsDetall

Excel: Conditional Formats

Description
This online Excel course focuses on conditional formatting, a key tool for managing data efficiently and visually. Designed for users with an intermediate level of Excel, it covers concepts such as data bars, color scales, and icon sets. With a structured and easy-to-follow syllabus, this course will help you enhance your professional skills and master advanced functions in this essential tool.
Content

OBJECTIVES

  • Understand the basic concepts of conditional formatting in Excel: identify its utility, the available types, and complementary tools
  • Apply basic and advanced conditional formats: master techniques like data bars, color scales, and icon sets to visually and effectively represent data
  • Design and manage custom rules: create new rules to adapt conditional formats to specific needs and optimize data analysis

SYLLABUS

  1. Introduction and creation of basic conditional formats
    • Definition and utility of conditional formatting
    • Types of conditional formatting
    • Other available tools
    • Creation of basic conditional formats
  2. Creation and management of advanced conditional formats
    • Data bars
    • Color scales
    • Icon sets
    • Creation of new rules

Other Excel courses:

Check the available courses


Teachers
FERRER MARTÍNEZ, ENRIC
Driving
Enric Ferrer

Calendar

Days and times
Venue
Language of instruction
Registration
Online
1 Jul, 2025
30 Sep, 2025
Language of instruction:Catalan
I want to sign up →

Find out more

Learn at your own pace
Online training is self-training, quarterly and you can register at any time.
Enjoy learning from wherever you want, at your own pace and without schedules.

Access
The activities are available at the Virtual Campus of Barcelona Activa 

Certificate
To obtain the certificate of completion, the final questionnaire of the course must be completed. Once passed, you can download it in the Personal Area 

ActivitatsAnnexos