{"id":43144,"date":"2025-04-11T13:16:00","date_gmt":"2025-04-11T13:16:00","guid":{"rendered":"https:\/\/bissafety.ca\/courses\/excel-data-analysis-with-pivot-tables\/"},"modified":"2025-08-13T08:58:20","modified_gmt":"2025-08-13T08:58:20","slug":"excel-data-analysis-with-pivot-tables","status":"publish","type":"courses","link":"https:\/\/bissafety.ca\/fr\/courses\/excel-data-analysis-with-pivot-tables\/","title":{"rendered":"Excel: Data Analysis with Pivot Tables"},"content":{"rendered":"<div class=\"title-bar\"><b>COURSE OVERVIEW<\/b><\/div>\n<p><\/p>\n<p>Excel: Data Analysis with Pivot Tables is a course designed to make you proficient in using Pivot Tables for data analysis in Excel. The course provides deep insights into how to summarize, visualize, and tabulate your data with Pivot Tables and is a must-have skill set for anyone using Excel for data storage and reporting. Led by Microsoft trainer Kathy Jones, this course will guide you on the effective use of Pivot Tables in Excel 2013 and 2016.<\/p>\n<p><\/p>\n<p><b>Upon completion of the course, you will be proficient in:<\/b><\/p>\n<ul>\n<li>Creating a pivot table from a local data source, multiple local data sources, and external sources<\/li>\n<li>Structuring data inside a pivot table<\/li>\n<li>Adjusting pivot table options <\/li>\n<\/ul>\n<p><b><br \/><\/b><\/p>\n<div class=\"title-bar\"><b>COURSE TOPICS<\/b><\/div>\n<p><\/p>\n<p><b><\/b><\/p>\n<p><span><\/span><\/p>\n<p><span><b>The course encompasses the following topics:<\/b><\/span><\/p>\n<ul>\n<li>Data Preparation and Pivot Table Creation<\/li>\n<li>Working with Local and External Data Sources<\/li>\n<li>Summarizing, Organizing, Filtering, and Formatting Pivot Tables<\/li>\n<li>Refreshing and Modifying Pivot Table Data<\/li>\n<li>Working with Pivot Charts<\/li>\n<p><\/ul>\n<div class=\"title-bar\"><b>ONLINE COURSE DURATION<\/b><\/div>\n<p><\/p>\n<p><b>Estimated completion time is 150 minutes<\/b><\/p>\n<p><\/p>\n<div class=\"title-bar\"><b>PASS MARK<\/b><\/div>\n<p><\/p>\n<p>The course includes various tests to reinforce the material presented. A minimum score of 80% is required to pass the course. Participants have the option to retake the course up to three times to achieve the passing score.\u00a0<\/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 available for you to download and print.<\/p>\n<p><\/p>\n<div class=\"title-bar\"><b>COURSE PREVIEW<\/b><\/div>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Excel: Data Analysis with Pivot Tables is a comprehensive guide to using Pivot Tables as a potent tool for the analysis of voluminous data in Excel. This course will equip you with skills to organize, visualize, and summarize your data effectively using Pivot Tables. Microsoft trainer, Kathy Jones, will be at the helm, guiding you through the intricacies of Excel 2013 and 2016.<\/p>","protected":false},"featured_media":43145,"template":"","meta":{"_acf_changed":false,"content-type":""},"course-category":[331],"class_list":["post-43144","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: Data Analysis with Pivot Tables \u2014 BIS Safety Software<\/title>\n<meta name=\"description\" content=\"Learn to create and modify PivotTables in Excel 2013 and 2016, summarizing and analyzing data from local and external sources.\" \/>\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-data-analysis-with-pivot-tables\/\" \/>\n<meta property=\"og:locale\" content=\"fr_CA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Data Analysis with Pivot Tables\" \/>\n<meta property=\"og:description\" content=\"Learn to create and modify PivotTables in Excel 2013 and 2016, summarizing and analyzing data from local and external sources.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bissafety.ca\/fr\/courses\/excel-data-analysis-with-pivot-tables\/\" \/>\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-13T08:58:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/DC8A8A5EC341978ADE4E35654442FF20.png\" \/>\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\/png\" \/>\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-data-analysis-with-pivot-tables\\\/\",\"url\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-data-analysis-with-pivot-tables\\\/\",\"name\":\"Excel: Data Analysis with Pivot Tables \u2014 BIS Safety Software\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-data-analysis-with-pivot-tables\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-data-analysis-with-pivot-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bissafety.ca\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/DC8A8A5EC341978ADE4E35654442FF20.png\",\"datePublished\":\"2025-04-11T13:16:00+00:00\",\"dateModified\":\"2025-08-13T08:58:20+00:00\",\"description\":\"Learn to create and modify PivotTables in Excel 2013 and 2016, summarizing and analyzing data from local and external sources.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-data-analysis-with-pivot-tables\\\/#breadcrumb\"},\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-data-analysis-with-pivot-tables\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-data-analysis-with-pivot-tables\\\/#primaryimage\",\"url\":\"https:\\\/\\\/bissafety.ca\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/DC8A8A5EC341978ADE4E35654442FF20.png\",\"contentUrl\":\"https:\\\/\\\/bissafety.ca\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/DC8A8A5EC341978ADE4E35654442FF20.png\",\"width\":1920,\"height\":320},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bissafety.ca\\\/courses\\\/excel-data-analysis-with-pivot-tables\\\/#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: Data Analysis with Pivot Tables\"}]},{\"@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: Data Analysis with Pivot Tables \u2014 BIS Safety Software","description":"Learn to create and modify PivotTables in Excel 2013 and 2016, summarizing and analyzing data from local and external sources.","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-data-analysis-with-pivot-tables\/","og_locale":"fr_CA","og_type":"article","og_title":"Excel: Data Analysis with Pivot Tables","og_description":"Learn to create and modify PivotTables in Excel 2013 and 2016, summarizing and analyzing data from local and external sources.","og_url":"https:\/\/bissafety.ca\/fr\/courses\/excel-data-analysis-with-pivot-tables\/","og_site_name":"BIS Safety Software Canada","article_publisher":"https:\/\/www.facebook.com\/BIS.Safety.Software\/","article_modified_time":"2025-08-13T08:58:20+00:00","og_image":[{"width":1920,"height":320,"url":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/DC8A8A5EC341978ADE4E35654442FF20.png","type":"image\/png"}],"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-data-analysis-with-pivot-tables\/","url":"https:\/\/bissafety.ca\/courses\/excel-data-analysis-with-pivot-tables\/","name":"Excel: Data Analysis with Pivot Tables \u2014 BIS Safety Software","isPartOf":{"@id":"https:\/\/bissafety.ca\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bissafety.ca\/courses\/excel-data-analysis-with-pivot-tables\/#primaryimage"},"image":{"@id":"https:\/\/bissafety.ca\/courses\/excel-data-analysis-with-pivot-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/DC8A8A5EC341978ADE4E35654442FF20.png","datePublished":"2025-04-11T13:16:00+00:00","dateModified":"2025-08-13T08:58:20+00:00","description":"Learn to create and modify PivotTables in Excel 2013 and 2016, summarizing and analyzing data from local and external sources.","breadcrumb":{"@id":"https:\/\/bissafety.ca\/courses\/excel-data-analysis-with-pivot-tables\/#breadcrumb"},"inLanguage":"fr-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bissafety.ca\/courses\/excel-data-analysis-with-pivot-tables\/"]}]},{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/bissafety.ca\/courses\/excel-data-analysis-with-pivot-tables\/#primaryimage","url":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/DC8A8A5EC341978ADE4E35654442FF20.png","contentUrl":"https:\/\/bissafety.ca\/wp-content\/uploads\/2025\/04\/DC8A8A5EC341978ADE4E35654442FF20.png","width":1920,"height":320},{"@type":"BreadcrumbList","@id":"https:\/\/bissafety.ca\/courses\/excel-data-analysis-with-pivot-tables\/#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: Data Analysis with Pivot Tables"}]},{"@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\/43144","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\/43145"}],"wp:attachment":[{"href":"https:\/\/bissafety.ca\/fr\/wp-json\/wp\/v2\/media?parent=43144"}],"wp:term":[{"taxonomy":"course-category","embeddable":true,"href":"https:\/\/bissafety.ca\/fr\/wp-json\/wp\/v2\/course-category?post=43144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}