Passer au contenu principal

Logiciel BIS Sécurité Canada

BIS Safety Software

Excel en 30 minutes – Mise en forme conditionnelle

This course is suitable for individuals with a basic understanding of Microsoft® Windows® who aspire to learn essential Excel 2019 skills for the creation and modification of spreadsheets. Upon completion of this course, participants will have acquired the ability to utilize Conditional Formatting and Comparative Analysis Formatting for effective data reading and analysis. Additionally, they will be able to access and create templates for predefined formatting.

Excel in 30 Minutes – Conditional Formatting

APERÇU DU COURS

The world can be divided into two categories: Those who are Excel gurus, and those who yearn to be.

When you become proficient in Excel, you gain one of the most sought-after and versatile skillsets in today’s business world.

Our Excel in 30 Minutes Series is designed to help you get there. The ‘Excel in 30 Minutes – Conditional Formatting’ course is part of this 10-course series.

At the end of this course, you will be proficient in utilizing Conditional Formatting and Comparative Analysis Formatting for efficient data reading and analysis. In addition, you’ll learn how to access and create templates for predefined formatting.

Upon course completion, you will have the ability to:

  • Utilize Conditional Formatting for streamlined data reading and analysis.
  • Apply Conditional Formatting to Text and Dates to effortlessly highlight specific values or duplicates
  • Implement Comparative Analysis Formatting to introduce Data Bars, Color Scales, and Icon Sets to your worksheets
  • Access pre-existing Templates and create your own Custom Templates for predefined formatting


SUJETS DU COURS

This course incorporates the following topics:

  • Implementing Conditional Formatting to Numbers
  • Applying Conditional Formatting to Text and Dates
  • Using Comparative Analysis Formatting
  • Working with Templates
DURÉE DU COURS EN LIGNE

Environ 30 minutes

Note de passage

Tests conducted throughout this online course aim to reinforce the information provided. A minimum score of 80% is required to pass this course. Participants have the opportunity to attempt the course three times to achieve the pass mark.

CERTIFICAT DE RÉALISATION

Upon successful completion of this online course, a certificate of completion will be readily available for download and printing.

APERÇU DU COURS

Détails du cours

Durée du cours

Ce cours durera environ 30 minutes

Note de passage

Pour réussir cette formation, vous devez obtenir 80% ou version supérieure au quiz

Certificat

À l'issue de la réussite de ce cours, un certificat à votre nom sera stocké sur votre profil et disponible à l'impression

Cours de formation supplémentaires

Team Excellence COVID Edition – The Secret to Achieving High Performance

L'équipe d'excellence, édition COVID – Le secret pour atteindre la haute performance

Ce cours est une version spécialisée du cours Team Excellence - Le secret pour atteindre la haute performance, avec un accent particulier sur les équipes de l'ère COVID...

Camiones Industriales Motorizados

Chariots élévateurs

Ce cours se concentrera sur la sécurité de l'opérateur et celle des personnes qui l'entourent lors de l'utilisation d'un chariot élévateur.

Cold Stress

Cold Stress

This digital course offers comprehensive instruction for individuals who spend extensive time in chilly work conditions.