{"id":42405,"date":"2025-04-11T11:36:31","date_gmt":"2025-04-11T11:36:31","guid":{"rendered":"https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/"},"modified":"2025-08-13T05:34:33","modified_gmt":"2025-08-13T05:34:33","slug":"excel-in-30-minutes-conditional-formatting","status":"publish","type":"courses","link":"https:\/\/bissafety.ca\/fr\/courses\/excel-in-30-minutes-conditional-formatting\/","title":{"rendered":"Excel in 30 Minutes &#8211; Conditional Formatting"},"content":{"rendered":"<div class=\"title-bar\"><b>COURSE OVERVIEW<\/b><\/div>\n<p><\/p>\n<p><b>The world can be divided into two categories: Those who are Excel gurus, and those who yearn to be.<\/b><\/p>\n<p>When you become proficient in Excel, you gain one of the most sought-after and versatile skillsets in today&#8217;s business world.<\/p>\n<p>Our Excel in 30 Minutes Series is designed to help you get there. The &#8216;Excel in 30 Minutes &#8211; Conditional Formatting&#8217; course is part of this 10-course series.<\/p>\n<p>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&#8217;ll learn how to access and create templates for predefined formatting.<\/p>\n<p><\/p>\n<p><b>Upon course completion, you will have the ability to:<\/b><\/p>\n<ul>\n<li>Utilize Conditional Formatting for streamlined data reading and analysis.<\/li>\n<p><\/p>\n<li>Apply Conditional Formatting to Text and Dates to effortlessly highlight specific values or duplicates<\/li>\n<p><\/p>\n<li>Implement Comparative Analysis Formatting to introduce Data Bars, Color Scales, and Icon Sets to your worksheets<\/li>\n<p><\/p>\n<li>Access pre-existing Templates and create your own Custom Templates for predefined formatting<\/li>\n<p><\/ul>\n<p><b><br \/><\/b><\/p>\n<div class=\"title-bar\"><b>COURSE TOPICS<\/b><\/div>\n<p><\/p>\n<p><span><b>This course incorporates the following topics:<\/b><\/span><\/p>\n<ul>\n<li>Implementing Conditional Formatting to Numbers<\/li>\n<li>Applying Conditional Formatting to Text and Dates<\/li>\n<li>Using Comparative Analysis Formatting<\/li>\n<li>Working with Templates<\/li>\n<p><\/ul>\n<div class=\"title-bar\"><b>ONLINE COURSE DURATION<\/b><\/div>\n<p><\/p>\n<p><b>Approximately 30 minutes<\/b><\/p>\n<p><\/p>\n<div class=\"title-bar\"><b>PASS MARK<\/b><\/div>\n<p><\/p>\n<p>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. <\/p>\n<p><\/p>\n<div class=\"title-bar\"><b>CERTIFICATE OF COMPLETION<\/b><\/div>\n<p><\/p>\n<p>Upon successful completion of this online course, a certificate of completion will be readily available for download and printing.<\/p>\n<p><\/p>\n<div class=\"title-bar\"><b>COURSE PREVIEW<\/b><\/div>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>This course is suitable for individuals with a basic understanding of Microsoft\u00ae Windows\u00ae 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.<\/p>","protected":false},"featured_media":42406,"template":"","meta":{"_acf_changed":false,"content-type":""},"course-category":[331],"class_list":["post-42405","courses","type-courses","status-publish","has-post-thumbnail","hentry","course-category-soft-skills"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.8 (Yoast SEO v27.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Excel in 30 Minutes - Conditional Formatting \u2014 BIS Safety Software<\/title>\n<meta name=\"description\" content=\"Master Excel&#039;s conditional formatting in just 30 minutes, learning to apply rules, color scales, and data bars for effective data visualization.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bissafety.ca\/fr\/courses\/excel-in-30-minutes-conditional-formatting\/\" \/>\n<meta property=\"og:locale\" content=\"fr_CA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel in 30 Minutes - Conditional Formatting\" \/>\n<meta property=\"og:description\" content=\"Master Excel&#039;s conditional formatting in just 30 minutes, learning to apply rules, color scales, and data bars for effective data visualization.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bissafety.ca\/fr\/courses\/excel-in-30-minutes-conditional-formatting\/\" \/>\n<meta property=\"og:site_name\" content=\"BIS Safety Software Canada\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BIS.Safety.Software\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-13T05:34:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/4FFB501622730D8EDF123C6A6917B09D.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"320\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@BISTraining\" \/>\n<meta name=\"twitter:label1\" content=\"Estimation du temps de lecture\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-in-30-minutes-conditional-formatting\\\/\",\"url\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-in-30-minutes-conditional-formatting\\\/\",\"name\":\"Excel in 30 Minutes - Conditional Formatting \u2014 BIS Safety Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-in-30-minutes-conditional-formatting\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-in-30-minutes-conditional-formatting\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bissafety.ca\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/4FFB501622730D8EDF123C6A6917B09D.jpg\",\"datePublished\":\"2025-04-11T11:36:31+00:00\",\"dateModified\":\"2025-08-13T05:34:33+00:00\",\"description\":\"Master Excel's conditional formatting in just 30 minutes, learning to apply rules, color scales, and data bars for effective data visualization.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-in-30-minutes-conditional-formatting\\\/#breadcrumb\"},\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-in-30-minutes-conditional-formatting\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-in-30-minutes-conditional-formatting\\\/#primaryimage\",\"url\":\"https:\\\/\\\/bissafety.ca\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/4FFB501622730D8EDF123C6A6917B09D.jpg\",\"contentUrl\":\"https:\\\/\\\/bissafety.ca\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/4FFB501622730D8EDF123C6A6917B09D.jpg\",\"width\":1920,\"height\":320},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-in-30-minutes-conditional-formatting\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bissafety.ca\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Courses\",\"item\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel in 30 Minutes &#8211; Conditional Formatting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bissafety.ca\\\/#website\",\"url\":\"https:\\\/\\\/bissafety.ca\\\/\",\"name\":\"BIS Safety Software\",\"description\":\"EHS Software for the Safety Professional\",\"publisher\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bissafety.ca\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-CA\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/bissafety.ca\\\/#organization\",\"name\":\"BIS Safety Software\",\"url\":\"https:\\\/\\\/bissafety.ca\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/bissafety.ca\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/bissafety.ca\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/BIS_Signature_ColourLogo_BlackFont.png.webp\",\"contentUrl\":\"https:\\\/\\\/bissafety.ca\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/BIS_Signature_ColourLogo_BlackFont.png.webp\",\"width\":2000,\"height\":412,\"caption\":\"BIS Safety Software\"},\"image\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/BIS.Safety.Software\\\/\",\"https:\\\/\\\/x.com\\\/BISTraining\",\"https:\\\/\\\/www.instagram.com\\\/bis_safety_software\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/bis-safety-software\\\/\",\"https:\\\/\\\/ca.pinterest.com\\\/bissafetysoftwarecanada\\\/\",\"https:\\\/\\\/gab.com\\\/bissafetysoftwarecanada\",\"https:\\\/\\\/www.youtube.com\\\/@BIS-SafetySoftware\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel in 30 Minutes - Conditional Formatting \u2014 BIS Safety Software","description":"Master Excel's conditional formatting in just 30 minutes, learning to apply rules, color scales, and data bars for effective data visualization.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bissafety.ca\/fr\/courses\/excel-in-30-minutes-conditional-formatting\/","og_locale":"fr_CA","og_type":"article","og_title":"Excel in 30 Minutes - Conditional Formatting","og_description":"Master Excel's conditional formatting in just 30 minutes, learning to apply rules, color scales, and data bars for effective data visualization.","og_url":"https:\/\/bissafety.ca\/fr\/courses\/excel-in-30-minutes-conditional-formatting\/","og_site_name":"BIS Safety Software Canada","article_publisher":"https:\/\/www.facebook.com\/BIS.Safety.Software\/","article_modified_time":"2025-08-13T05:34:33+00:00","og_image":[{"width":1920,"height":320,"url":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/4FFB501622730D8EDF123C6A6917B09D.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@BISTraining","twitter_misc":{"Estimation du temps de lecture":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/","url":"https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/","name":"Excel in 30 Minutes - Conditional Formatting \u2014 BIS Safety Software","isPartOf":{"@id":"https:\/\/bissafety.ca\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/#primaryimage"},"image":{"@id":"https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/#primaryimage"},"thumbnailUrl":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/4FFB501622730D8EDF123C6A6917B09D.jpg","datePublished":"2025-04-11T11:36:31+00:00","dateModified":"2025-08-13T05:34:33+00:00","description":"Master Excel's conditional formatting in just 30 minutes, learning to apply rules, color scales, and data bars for effective data visualization.","breadcrumb":{"@id":"https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/#breadcrumb"},"inLanguage":"fr-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/"]}]},{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/#primaryimage","url":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/4FFB501622730D8EDF123C6A6917B09D.jpg","contentUrl":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/4FFB501622730D8EDF123C6A6917B09D.jpg","width":1920,"height":320},{"@type":"BreadcrumbList","@id":"https:\/\/bissafety.ca\/courses\/excel-in-30-minutes-conditional-formatting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bissafety.ca\/"},{"@type":"ListItem","position":2,"name":"Courses","item":"https:\/\/bissafety.ca\/courses\/"},{"@type":"ListItem","position":3,"name":"Excel in 30 Minutes &#8211; Conditional Formatting"}]},{"@type":"WebSite","@id":"https:\/\/bissafety.ca\/#website","url":"https:\/\/bissafety.ca\/","name":"Logiciel de s\u00e9curit\u00e9 BIS","description":"EHS Software for the Safety Professional","publisher":{"@id":"https:\/\/bissafety.ca\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bissafety.ca\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-CA"},{"@type":"Organization","@id":"https:\/\/bissafety.ca\/#organization","name":"Logiciel de s\u00e9curit\u00e9 BIS","url":"https:\/\/bissafety.ca\/","logo":{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/bissafety.ca\/#\/schema\/logo\/image\/","url":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/02\/BIS_Signature_ColourLogo_BlackFont.png.webp","contentUrl":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/02\/BIS_Signature_ColourLogo_BlackFont.png.webp","width":2000,"height":412,"caption":"BIS Safety Software"},"image":{"@id":"https:\/\/bissafety.ca\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BIS.Safety.Software\/","https:\/\/x.com\/BISTraining","https:\/\/www.instagram.com\/bis_safety_software\/","https:\/\/www.linkedin.com\/company\/bis-safety-software\/","https:\/\/ca.pinterest.com\/bissafetysoftwarecanada\/","https:\/\/gab.com\/bissafetysoftwarecanada","https:\/\/www.youtube.com\/@BIS-SafetySoftware"]}]}},"_links":{"self":[{"href":"https:\/\/bissafety.ca\/fr\/wp-json\/wp\/v2\/courses\/42405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bissafety.ca\/fr\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/bissafety.ca\/fr\/wp-json\/wp\/v2\/types\/courses"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bissafety.ca\/fr\/wp-json\/wp\/v2\/media\/42406"}],"wp:attachment":[{"href":"https:\/\/bissafety.ca\/fr\/wp-json\/wp\/v2\/media?parent=42405"}],"wp:term":[{"taxonomy":"course-category","embeddable":true,"href":"https:\/\/bissafety.ca\/fr\/wp-json\/wp\/v2\/course-category?post=42405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}