{"id":24429,"date":"2024-04-11T18:50:44","date_gmt":"2024-04-11T18:50:44","guid":{"rendered":"https:\/\/totbox.ca\/?post_type=lp_course&#038;p=24429"},"modified":"2025-09-08T12:32:25","modified_gmt":"2025-09-08T16:32:25","slug":"microsoft-excel-365-data-management-level-3","status":"publish","type":"lp_course","link":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/","title":{"rendered":"Microsoft Excel 365 (Level 3)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"24429\" class=\"elementor elementor-24429\" data-elementor-settings=\"{&quot;element_pack_global_tooltip_width&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_width_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_width_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_padding&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_padding_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_padding_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true}}\" data-elementor-post-type=\"lp_course\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4758566 e-flex e-con-boxed e-con e-parent\" data-id=\"4758566\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-54c8dc8 elementor-widget elementor-widget-heading\" data-id=\"54c8dc8\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;mdp_selection_scrolling_effect_enable&quot;:false}\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Microsoft Excel 365 (Level 3)<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a2e0cff e-flex e-con-boxed e-con e-parent\" data-id=\"a2e0cff\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-792dcd6 elementor-widget elementor-widget-text-editor\" data-id=\"792dcd6\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;mdp_selection_scrolling_effect_enable&quot;:false}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In this course, you will learn how to create tables in Excel, which are useful for organizing and storing your data. You will also learn how to sort and filter your data using different criteria and options. Moreover, you will discover how to use PivotTables, which are powerful tools for summarizing and analyzing your data in various ways. Finally, you will explore how to use database functions, which are formulas that can perform calculations on a specific range of cells that match certain conditions.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2a577c6 e-flex e-con-boxed e-con e-parent\" data-id=\"2a577c6\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-931f705 e-n-tabs-mobile elementor-widget elementor-widget-n-tabs\" data-id=\"931f705\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;horizontal_scroll&quot;:&quot;disable&quot;,&quot;mdp_selection_scrolling_effect_enable&quot;:false}\" data-widget_type=\"nested-tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"e-n-tabs\" data-widget-number=\"154269445\" aria-label=\"Tabs. Open items with Enter or Space, close with Escape and navigate using the Arrow keys.\">\n\t\t\t<div class=\"e-n-tabs-heading\" role=\"tablist\">\n\t\t\t\t\t<button id=\"e-n-tab-title-1542694451\" data-tab-title-id=\"e-n-tab-title-1542694451\" class=\"e-n-tab-title\" aria-selected=\"true\" data-tab-index=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"e-n-tab-content-1542694451\" style=\"--n-tabs-title-order: 1;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tCourse Objectives\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t<button id=\"e-n-tab-title-1542694452\" data-tab-title-id=\"e-n-tab-title-1542694452\" class=\"e-n-tab-title\" aria-selected=\"false\" data-tab-index=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"e-n-tab-content-1542694452\" style=\"--n-tabs-title-order: 2;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tCourse Content\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t<button id=\"e-n-tab-title-1542694453\" data-tab-title-id=\"e-n-tab-title-1542694453\" class=\"e-n-tab-title\" aria-selected=\"false\" data-tab-index=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"e-n-tab-content-1542694453\" style=\"--n-tabs-title-order: 3;\">\n\t\t\t\t\t\t<span class=\"e-n-tab-title-text\">\n\t\t\t\tCourse Brochure\t\t\t<\/span>\n\t\t<\/button>\n\t\t\t\t\t<\/div>\n\t\t\t<div class=\"e-n-tabs-content\">\n\t\t\t\t<div id=\"e-n-tab-content-1542694451\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1542694451\" data-tab-index=\"1\" style=\"--n-tabs-title-order: 1;\" class=\"e-active elementor-element elementor-element-e371b7c e-con-full e-flex e-con e-child\" data-id=\"e371b7c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-23339757 elementor-widget elementor-widget-text-editor\" data-id=\"23339757\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;mdp_selection_scrolling_effect_enable&quot;:false}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<table id=\"BookInfo\" cellspacing=\"0\"><tbody><tr valign=\"top\"><td><div style=\"text-align: left;\">Upon completion of the course, you&#8217;ll be able to:<\/div><div style=\"text-align: left;\">\u00a0<\/div><ul><li style=\"text-align: left;\"><span style=\"font-family: inherit; font-size: inherit;\">Create and use Excel tables.<\/span><\/li><li style=\"text-align: left;\"><span style=\"font-family: inherit; font-size: inherit;\">Add, edit and search for records in tables, and look up data.<\/span><\/li><li style=\"text-align: left;\"><span style=\"font-family: inherit; font-size: inherit;\">Sort records in a table using a variety of methods.<\/span><\/li><li style=\"text-align: left;\"><span style=\"font-family: inherit; font-size: inherit;\">Filter data in a table using a variety of methods.<\/span><\/li><li style=\"text-align: left;\"><span style=\"font-family: inherit; font-size: inherit;\">Create and work with subtotalled lists.<\/span><\/li><li style=\"text-align: left;\"><span style=\"font-family: inherit; font-size: inherit;\">Work with PivotTables, PivotCharts, and Slicers.<\/span><\/li><\/ul><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div id=\"e-n-tab-content-1542694452\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1542694452\" data-tab-index=\"2\" style=\"--n-tabs-title-order: 2;\" class=\" elementor-element elementor-element-60b8102 e-con-full e-flex e-con e-child\" data-id=\"60b8102\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-993b90c elementor-widget elementor-widget-edublink-accordion\" data-id=\"993b90c\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;mdp_selection_scrolling_effect_enable&quot;:false}\" data-widget_type=\"edublink-accordion.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t        <div class=\"eb-accordion header-default border-default style-radius-1\">\n                            <div class=\"eb-accordion-item default-active elementor-repeater-item-29284e6\">\n                    <h5 class=\"eb-accordion-header default-active\">\n                        Unit 1: Maintaining data                    <\/h5>\n                    <div class=\"eb-accordion-content\">\n                        <div class=\"eb-accordion-body default-active\">\n                            <ul><li><span class=\"SectionText\">Data List and Excel Table Concepts<\/span><\/li><li><span class=\"SectionText\">Working with Tables<\/span><\/li><li><span class=\"SectionText\">Using Lookup Tables<\/span><\/li><li><span class=\"SectionText\">Using Data Forms<\/span><\/li><\/ul>                        <\/div>\n                    <\/div>\n                <\/div>\n                            <div class=\"eb-accordion-item elementor-repeater-item-b1500c0\">\n                    <h5 class=\"eb-accordion-header\">\n                        Unit 2: Sorting Lists                    <\/h5>\n                    <div class=\"eb-accordion-content\">\n                        <div class=\"eb-accordion-body\">\n                            <ul><li><span class=\"SectionText\">Sorting Concepts<\/span><\/li><li><span class=\"SectionText\">Sorting Lists<\/span><\/li><li><span class=\"SectionText\">Custom Sort Orders<\/span><\/li><\/ul>                        <\/div>\n                    <\/div>\n                <\/div>\n                            <div class=\"eb-accordion-item elementor-repeater-item-972cd01\">\n                    <h5 class=\"eb-accordion-header\">\n                        Unit 3: Filtering Lists                    <\/h5>\n                    <div class=\"eb-accordion-content\">\n                        <div class=\"eb-accordion-body\">\n                            <ul><li><span class=\"SectionText\">Filtering Concepts<\/span><\/li><li><span class=\"SectionText\">Using AutoFilter<\/span><\/li><li><span class=\"SectionText\">Using Advanced Filters<\/span><\/li><li><span class=\"SectionText\">Working with Filtered Data<\/span><\/li><\/ul>                        <\/div>\n                    <\/div>\n                <\/div>\n                            <div class=\"eb-accordion-item elementor-repeater-item-863c217\">\n                    <h5 class=\"eb-accordion-header\">\n                        Unit 4: Summarizing Data                    <\/h5>\n                    <div class=\"eb-accordion-content\">\n                        <div class=\"eb-accordion-body\">\n                            <ul><li><span class=\"SectionText\">Automatic Subtotals<\/span><\/li><li><span class=\"SectionText\">Working with Subtotalled Lists<\/span><\/li><li><span class=\"SectionText\">Using Functions to Summarize Data<\/span><\/li><\/ul>                        <\/div>\n                    <\/div>\n                <\/div>\n                            <div class=\"eb-accordion-item elementor-repeater-item-6f8d8aa\">\n                    <h5 class=\"eb-accordion-header\">\n                        Unit 5: Working with PivotTables                    <\/h5>\n                    <div class=\"eb-accordion-content\">\n                        <div class=\"eb-accordion-body\">\n                            <ul><li><span class=\"SectionText\">PivotTable Concepts<\/span><\/li><li><span class=\"SectionText\">Creating PivotTables<\/span><\/li><li><span class=\"SectionText\">Modifying PivotTable Layouts<\/span><\/li><li><span class=\"SectionText\">Working with PivotTables<\/span><\/li><li><span class=\"SectionText\">PivotCharts<\/span><\/li><li><span class=\"SectionText\">Slicers<\/span><\/li><\/ul>                        <\/div>\n                    <\/div>\n                <\/div>\n                            <div class=\"eb-accordion-item elementor-repeater-item-f55c35c\">\n                    <h5 class=\"eb-accordion-header\">\n                        Unit 6: Supplemental - Dynamic Array Formulas                    <\/h5>\n                    <div class=\"eb-accordion-content\">\n                        <div class=\"eb-accordion-body\">\n                            <ul><li><span class=\"SectionText\">Dynamic Array Formula Concepts<\/span><\/li><li><span class=\"SectionText\">Creating Unique Dynamic Lists<\/span><\/li><li><span class=\"SectionText\">Sorting Dynamic Arrays<\/span><\/li><li><span class=\"SectionText\">Filtering Dynamic Arrays<\/span><\/li><\/ul>                        <\/div>\n                    <\/div>\n                <\/div>\n                    <\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div id=\"e-n-tab-content-1542694453\" role=\"tabpanel\" aria-labelledby=\"e-n-tab-title-1542694453\" data-tab-index=\"3\" style=\"--n-tabs-title-order: 3;\" class=\" elementor-element elementor-element-13e9f14 e-flex e-con-boxed e-con e-child\" data-id=\"13e9f14\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-abd9ec4 e-flex e-con-boxed e-con e-child\" data-id=\"abd9ec4\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-63ef6d8 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"63ef6d8\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;mdp_selection_scrolling_effect_enable&quot;:false}\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"#\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Download<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6137c51c e-flex e-con-boxed e-con e-parent\" data-id=\"6137c51c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bc22621 elementor-widget elementor-widget-ucaddon_blox_line_text_divider\" data-id=\"bc22621\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;mdp_selection_scrolling_effect_enable&quot;:false}\" data-widget_type=\"ucaddon_blox_line_text_divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n<!-- start Line Text Divider -->\n<style>\/* widget: Line Text Divider *\/\n\n#uc_blox_line_text_divider_elementor_bc22621 {\n  translate: 0 50%;\n}\n#uc_blox_line_text_divider_elementor_bc22621 div.blox_hr\n{\n  display:inline-block;\n  width:100%;\n  height: 1px;\n}\n#uc_blox_line_text_divider_elementor_bc22621 div.blox_hr_txt\n{\n  display: inline-block;\n  position: relative;\n  margin: 0;\n  text-align: center;\n  transform: translateY(calc(-50% + 0.5px));\n}\n\n<\/style>\n\n<div id=\"uc_blox_line_text_divider_elementor_bc22621\" style=\"text-align:center;\">\n  <div class=\"blox_hr\"><div class=\"blox_hr_txt\">UPCOMING SESSIONS<\/div><\/div>\n<\/div>\n<!-- end Line Text Divider -->\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6584151 e-flex e-con-boxed e-con e-parent\" data-id=\"6584151\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d8ffeea elementor-widget elementor-widget-global elementor-global-28883 elementor-widget-ucaddon_ue_scroll_to_top\" data-id=\"d8ffeea\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;mdp_selection_scrolling_effect_enable&quot;:false}\" data-widget_type=\"ucaddon_ue_scroll_to_top.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n<!-- start Scroll To Top -->\n\t\t<link id='font-awesome-css' href='https:\/\/totbox.ca\/wp-content\/plugins\/unlimited-elements-for-elementor-premium\/assets_libraries\/font-awesome6\/fontawesome-all.min.css' type='text\/css' rel='stylesheet' >\n\t\t<link id='font-awesome-4-shim-css' href='https:\/\/totbox.ca\/wp-content\/plugins\/unlimited-elements-for-elementor-premium\/assets_libraries\/font-awesome6\/fontawesome-v4-shims.min.css' type='text\/css' rel='stylesheet' >\n\n<style>\/* widget: Scroll To Top *\/\n\n#uc_ue_scroll_to_top_elementor_d8ffeea.ue-scroll-to {\n    display:none;\n   z-index: 9999;\n  \n}\n#uc_ue_scroll_to_top_elementor_d8ffeea .ue-scroll-to-cta {\n  cursor: pointer;\n  display: flex;\n  position: relative;\n  transition: all 400ms ease-in-out;\n  align-content:center;\n  justify-content:center;\n  flex-direction:column;\n  text-align:center;\n}\n#uc_ue_scroll_to_top_elementor_d8ffeea .ue-scroll-to-cta .ue-scroll-to-icon {\n  line-height:1em;\n  margin:0 auto;\n}\n\n#uc_ue_scroll_to_top_elementor_d8ffeea .ue-scroll-to-cta .ue-scroll-to-icon svg {\n  height:1em; \n  width:1em; \n}\n\n.ue-scroll-to-cta \n#uc_ue_scroll_to_top_elementor_d8ffeea .ue-scroll-to-icon {\n  position: relative;\n}\n\n#uc_ue_scroll_to_top_elementor_d8ffeea .ue-scroll-to-icon:hover {\n  cursor: pointer;\n}\n.ue-snap-v-middle{\n  top:50%;\n}\n.ue-scroll-to-text\n{\n  font-size:10px;\n}\n\n\t\n\t\t\n\t\n\t\n\t\n\t\n\t      #uc_ue_scroll_to_top_elementor_d8ffeea .ue-scroll-to-cta\n{\n  position:relative;\n}\n      #uc_ue_scroll_to_top_elementor_d8ffeea .ue-scroll-to-cta:after {\n          content: \"\";\n          position: absolute;\n          top: 0;\n          left: 0;\n          bottom: 0;\n          right: 0;\n          border-radius: 50%;\n          animation: ue-pulse 2s 1.3s ease-out infinite;\n      }\n\n      #uc_ue_scroll_to_top_elementor_d8ffeea .ue-scroll-to-cta:before {\n          content: \"\";\n          position: absolute;\n          top: 0;\n          left: 0;\n          bottom: 0;\n          right: 0;\n          border-radius: 50%;\n          animation: ue-pulse 2s .8s ease-out infinite;\n      }\n\n      @keyframes ue-pulse {\n          0% {\n              transform: scale(1);\n              box-shadow: 0 0 2px rgba(0, 0, 0, 0.40), inset 0 0 1px rgba(0, 0, 0, 0.40);\n          }\n\n          95% {\n              box-shadow: 0 0 50px transparent, inset 0 0 30px transparent;\n          }\n\n          100% {\n              transform: scale(2.25);\n          }\n      }\n\t\n\t\n\n<\/style>\n\n<div id=\"uc_ue_scroll_to_top_elementor_d8ffeea\" class=\"ue-scroll-to ue-snap-v-middle ue-snap-h-right\">\n      <div class=\"ue-scroll-to-cta ue-pulse\">\n          <div class=\"ue-scroll-to-icon\"><i class='fas fa-arrow-up'><\/i><\/div>\n                    <div class=\"ue-scroll-to-text\">TOP<\/div>\n          \t\n      <\/div>\n<\/div>\n<!-- end Scroll To Top -->\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel 365 (Level 3) In this course, you will learn how to create tables in Excel, which are useful&#8230;<\/p>\n","protected":false},"author":1,"featured_media":20757,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","inline_featured_image":false,"_price":"","_stock":"","_tribe_ticket_header":"","_tribe_default_ticket_provider":"","_tribe_ticket_capacity":"0","_ticket_start_date":"","_ticket_end_date":"","_tribe_ticket_show_description":"","_tribe_ticket_show_not_going":false,"_tribe_ticket_use_global_stock":"","_tribe_ticket_global_stock_level":"","_global_stock_mode":"","_global_stock_cap":"","_tribe_rsvp_for_event":"","_tribe_ticket_going_count":"","_tribe_ticket_not_going_count":"","_tribe_tickets_list":"[]","_tribe_ticket_has_attendee_info_fields":false,"_tec_slr_enabled":"","_tec_slr_layout":"","_links_to":"","_links_to_target":""},"course_category":[182],"course_tag":[],"class_list":["post-24429","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-microsoft-365-productivity","course"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Excel 365 (Level 3) - Totbox Productivity Solutions<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel 365 (Level 3) - Totbox Productivity Solutions\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel 365 (Level 3) In this course, you will learn how to create tables in Excel, which are useful&#8230;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Totbox Productivity Solutions\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-08T16:32:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/totbox.ca\/wp-content\/uploads\/2023\/03\/excel-pivottables.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\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:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/microsoft-excel-365-data-management-level-3\\\/\",\"url\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/microsoft-excel-365-data-management-level-3\\\/\",\"name\":\"Microsoft Excel 365 (Level 3) - Totbox Productivity Solutions\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/microsoft-excel-365-data-management-level-3\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/microsoft-excel-365-data-management-level-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/totbox.ca\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/excel-pivottables.jpg\",\"datePublished\":\"2024-04-11T18:50:44+00:00\",\"dateModified\":\"2025-09-08T16:32:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/microsoft-excel-365-data-management-level-3\\\/#breadcrumb\"},\"inLanguage\":\"en-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/microsoft-excel-365-data-management-level-3\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/microsoft-excel-365-data-management-level-3\\\/#primaryimage\",\"url\":\"https:\\\/\\\/totbox.ca\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/excel-pivottables.jpg\",\"contentUrl\":\"https:\\\/\\\/totbox.ca\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/excel-pivottables.jpg\",\"width\":1000,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/microsoft-excel-365-data-management-level-3\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Courses\",\"item\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/courses\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel 365 (Level 3)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/#website\",\"url\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/\",\"name\":\"Totbox Productivity Solutions\",\"description\":\"Unlock your productivity potential\",\"publisher\":{\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-CA\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/#organization\",\"name\":\"Totbox Productivity Solutions\",\"url\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/totbox.ca\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/TOTBOX-logo-for-website-orange.png\",\"contentUrl\":\"https:\\\/\\\/totbox.ca\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/TOTBOX-logo-for-website-orange.png\",\"width\":176,\"height\":57,\"caption\":\"Totbox Productivity Solutions\"},\"image\":{\"@id\":\"https:\\\/\\\/totbox.ca\\\/en_ca\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Excel 365 (Level 3) - Totbox Productivity Solutions","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:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel 365 (Level 3) - Totbox Productivity Solutions","og_description":"Microsoft Excel 365 (Level 3) In this course, you will learn how to create tables in Excel, which are useful&#8230;","og_url":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/","og_site_name":"Totbox Productivity Solutions","article_modified_time":"2025-09-08T16:32:25+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/totbox.ca\/wp-content\/uploads\/2023\/03\/excel-pivottables.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/","url":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/","name":"Microsoft Excel 365 (Level 3) - Totbox Productivity Solutions","isPartOf":{"@id":"https:\/\/totbox.ca\/en_ca\/#website"},"primaryImageOfPage":{"@id":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/#primaryimage"},"image":{"@id":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/#primaryimage"},"thumbnailUrl":"https:\/\/totbox.ca\/wp-content\/uploads\/2023\/03\/excel-pivottables.jpg","datePublished":"2024-04-11T18:50:44+00:00","dateModified":"2025-09-08T16:32:25+00:00","breadcrumb":{"@id":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/#breadcrumb"},"inLanguage":"en-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/#primaryimage","url":"https:\/\/totbox.ca\/wp-content\/uploads\/2023\/03\/excel-pivottables.jpg","contentUrl":"https:\/\/totbox.ca\/wp-content\/uploads\/2023\/03\/excel-pivottables.jpg","width":1000,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/totbox.ca\/en_ca\/courses\/microsoft-excel-365-data-management-level-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/totbox.ca\/en_ca\/"},{"@type":"ListItem","position":2,"name":"Courses","item":"https:\/\/totbox.ca\/en_ca\/courses\/"},{"@type":"ListItem","position":3,"name":"Microsoft Excel 365 (Level 3)"}]},{"@type":"WebSite","@id":"https:\/\/totbox.ca\/en_ca\/#website","url":"https:\/\/totbox.ca\/en_ca\/","name":"Totbox Productivity Solutions","description":"Unlock your productivity potential","publisher":{"@id":"https:\/\/totbox.ca\/en_ca\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/totbox.ca\/en_ca\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-CA"},{"@type":"Organization","@id":"https:\/\/totbox.ca\/en_ca\/#organization","name":"Totbox Productivity Solutions","url":"https:\/\/totbox.ca\/en_ca\/","logo":{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/totbox.ca\/en_ca\/#\/schema\/logo\/image\/","url":"https:\/\/totbox.ca\/wp-content\/uploads\/2024\/04\/TOTBOX-logo-for-website-orange.png","contentUrl":"https:\/\/totbox.ca\/wp-content\/uploads\/2024\/04\/TOTBOX-logo-for-website-orange.png","width":176,"height":57,"caption":"Totbox Productivity Solutions"},"image":{"@id":"https:\/\/totbox.ca\/en_ca\/#\/schema\/logo\/image\/"}}]}},"ticketed":false,"_links":{"self":[{"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/lp_course\/24429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/comments?post=24429"}],"version-history":[{"count":87,"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/lp_course\/24429\/revisions"}],"predecessor-version":[{"id":31458,"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/lp_course\/24429\/revisions\/31458"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/media\/20757"}],"wp:attachment":[{"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/media?parent=24429"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/course_category?post=24429"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/totbox.ca\/en_ca\/wp-json\/wp\/v2\/course_tag?post=24429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}