{"id":15957,"date":"2023-07-24T13:14:00","date_gmt":"2023-07-24T13:14:00","guid":{"rendered":"https:\/\/stage.cloudthat.com\/training\/?post_type=stm-courses&p=15957"},"modified":"2025-03-19T08:06:23","modified_gmt":"2025-03-19T08:06:23","slug":"mo-211-microsoft-excel-expert-microsoft-365-apps","status":"publish","type":"stm-courses","link":"https:\/\/stage.cloudthat.com\/training\/microsoft-office\/mo-211-microsoft-excel-expert-microsoft-365-apps","title":{"rendered":"MO-211: Microsoft Excel Expert (Microsoft 365 Apps)"},"content":{"rendered":"

MO-211<\/span> is a certification exam offered by Microsoft<\/span>. This<\/span> certification<\/span> assesses an individual\u2019s knowledge and skills <\/span>of<\/span> Excel (<\/span>Microsoft 365 apps<\/span>) for data management, <\/span>data <\/span>analysis, and visualization. <\/span>The <\/span>course will help in th<\/span>e ability of <\/span>candidates<\/span> to perform tasks such as managing worksheets and workbooks, managing data cells and ranges, working with tables, performing operations by using formulas and functions, and creating charts.<\/span>\u00a0<\/span><\/span>\u00a0<\/span> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

MO-211 is a certification exam offered by Microsoft. This certification assesses an individual\u2019s knowledge and skills of Excel (Microsoft 365 apps) for data management, data analysis, and visualization. The course will help in the ability of candidates to perform tasks such as managing worksheets and workbooks, managing data cells and ranges, working with tables, performing […]<\/p>\n","protected":false},"author":13,"featured_media":15528,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[123],"metadata":{"permalink_customizer_regenerate_status":["1"],"stm_lms_product_id":["15934"],"_edit_last":["2"],"_thumbnail_id":["15528"],"_wp_page_template":["default"],"apss_content_flag":["0"],"lsq_tracking":["a:2:{s:8:\"tracking\";s:0:\"\";s:5:\"score\";s:0:\"\";}"],"_wpb_vc_js_status":["true"],"sale_price_dates_start":[""],"sale_price_dates_end":[""],"scorm_package":[""],"curriculum":[""],"shareware":[""],"featured":["on"],"views":["1653"],"level":["fundamental"],"current_students":["0"],"duration_info":["2 Days"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["14900"],"sale_price":[""],"sale_price_dates":[""],"enterprise_price":[""],"not_membership":[""],"affiliate_course":[""],"affiliate_course_text":[""],"affiliate_course_link":[""],"expiration_course":[""],"end_time":[""],"drip_content":[""],"prerequisites":[""],"prerequisite_passing_level":[""],"announcement":[""],"faq":["[{\"question\":\"What are the prerequisites for taking up this Excel course? \",\"answer\":\"All you need is a good internet connection (for online Excel training) and basic computer operating skills, and you are good to go! \"},{\"question\":\"Will this course help me get a job? \",\"answer\":\"Becoming a certified Excel expert can help you get hired and can help you advance in your career. \\n\\n \"},{\"question\":\"What skills are measured in MO-211? \",\"answer\":\"Manage workbook options and settings \\n\\nManage and format data \\n\\nCreate advanced formulas and macros \\n\\nManage advanced charts and tables \"},{\"question\":\"Will this course cover VBA too? \",\"answer\":\"Yes. This course will cover basic steps like how to create and modify, delete macros. \"},{\"question\":\"Will this course cover most used features and functions? \",\"answer\":\"Yes. This course will cover commonly used features for Data analysis, Date and Time functions, Lookup Functions, If and Conditional IFS functions, Pivot table and Pivot charts etc. \\n\\nAfter going through this Excel course, you will understand: \\n\\nIntroduction to Excel \\n\\nReferencing in Formulas \\n\\nFormatting \\n\\nSorting and Filtering \\n\\nCharts \\n\\nEnsuring Security \\n\\nPivot Tables \\n\\nFunctions \\n\\nVBA Macros \\n\\nDashboard \"}]"],"course_files_pack":[""],"course_certificate":[""],"type":[""],"duration":[""],"preview":[""],"lesson_excerpt":[""],"lesson_video_poster":[""],"lesson_video_url":[""],"lesson_video":[""],"lesson_files_pack":[""],"stream_start_date":[""],"stream_start_time":[""],"stream_end_date":[""],"stream_end_time":[""],"timezone":[""],"stm_password":[""],"join_before_host":[""],"option_host_video":[""],"option_participants_video":[""],"option_mute_participants":[""],"option_enforce_login":[""],"questions":[""],"duration_measure":[""],"correct_answer":[""],"passing_grade":[""],"re_take_cut":[""],"random_questions":[""],"answers":[""],"question_explanation":[""],"review_course":[""],"review_user":[""],"review_mark":[""],"order":[""],"absolute":[""],"sticky":[""],"sticky_threshold":[""],"sticky_threshold_color":[""],"stm_agenda":[""],"stm_host":[""],"stm_date":[""],"stm_time":[""],"stm_timezone":[""],"stm_duration":[""],"stm_join_before_host":[""],"stm_host_join_start":[""],"stm_start_after_participants":[""],"stm_mute_participants":[""],"stm_enforce_login":[""],"stm_alternative_hosts":[""],"author_id":[""],"emails":[""],"try_num":[""],"start_time":[""],"editor_comment":[""],"assignment_id":[""],"student_id":[""],"course_id":[""],"_elementor_template_type":["wp-post"],"_elementor_version":["3.0.16"],"_duration":["field_5fa0f3f0c86eb"],"day_1":["19700101"],"_day_1":["field_5fce082f42f1e"],"time":[""],"_time":["field_5fce084742f1f"],"_day_2":["field_5fce085142f20"],"time_2":[""],"_time_2":["field_5fce089942f21"],"_day_3":["field_5fce08df42f22"],"time_3":[""],"_time_3":["field_5fce08f842f23"],"_elementor_data":["[{\"id\":\"5409aeea\",\"elType\":\"section\",\"settings\":[],\"elements\":[{\"id\":\"4f2e7f7b\",\"elType\":\"column\",\"settings\":{\"_column_size\":100},\"elements\":[{\"id\":\"690b101b\",\"elType\":\"widget\",\"settings\":{\"editor\":\"

AZ-500 course from CloudThat is designed to train IT professionals who plan to take up the Microsoft AZ-500 certification exam. Taking this course and passing the AZ-500 exam will meet all the requirements needed to become a Microsoft Certified Azure Security Engineer Associate.<\\\/p>\\n

In this course, students will gain the knowledge and skills needed to implement security controls, maintain the security posture, and identify and remediate vulnerabilities by using a variety of security tools. The course covers scripting and automation, virtualization, and cloud N-tier architecture.<\\\/p>\\n

As a Microsoft Azure security engineer, candidates often serve as part of a larger team dedicated to Cloud-based management and security and may also secure hybrid environments as part of an end-to-end infrastructure.<\\\/p>\\n

\\n

Who Should Attend this Course?<\\\/h4>\\n<\\\/div>\\n
\\n
Candidates with both technical and non-technical backgrounds.<\\\/div>\\n<\\\/div>\"},\"elements\":[],\"widgetType\":\"text-editor\"}],\"isInner\":false}],\"isInner\":false}]"],"quiz_style":[""],"stm_waiting_room":[""],"assignment_tries":[""],"assignment_files":[""],"course_mark_average":["5"],"course_marks":["a:1:{i:2;s:1:\"5\";}"],"_elementor_controls_usage":["a:3:{s:11:\"text-editor\";a:3:{s:5:\"count\";i:1;s:15:\"control_percent\";i:0;s:8:\"controls\";a:1:{s:7:\"content\";a:1:{s:14:\"section_editor\";a:1:{s:6:\"editor\";i:1;}}}}s:6:\"column\";a:3:{s:5:\"count\";i:1;s:15:\"control_percent\";i:0;s:8:\"controls\";a:0:{}}s:7:\"section\";a:3:{s:5:\"count\";i:1;s:15:\"control_percent\";i:0;s:8:\"controls\";a:0:{}}}"],"_price":["29900"],"_product_id":["1440"],"product_id":["1440"],"_wp_old_date":["2022-12-30","2023-07-20"],"day_2":[""],"day_3":[""],"after_completing_course":["5"],"_after_completing_course":["field_6103aae828228"],"key_features":["3"],"_key_features":["field_6103aaff28229"],"who_should_attend":["4"],"_who_should_attend":["field_6103ab0d2822a"],"certification":["1"],"_certification":["field_6103ab1a2822b"],"about_trainer":[""],"_about_trainer":["field_6103ab6c2822f"],"course_fee_list":[""],"_course_fee_list":["field_6103abb728234"],"brochure_pdf":[""],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"banner_description":["This Excel MO-211 certification training from CloudThat equips the aspirants with the required skills and knowledge. The exam and course cover the ability to customize Excel environments to meet project needs and to enhance productivity. This course will help in applying and using the principal features of Excel at an expert level and can complete tasks independently. "],"_banner_description":["field_612c733ed3564"],"after_completing_course_0_desciption":["Manage workbook options and settings \r\n\r\n\r\n"],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Manage and format data \r\n\r\n"],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Create advanced formulas and macros \r\n\r\n"],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"key_features_0_lists":["This course welcomes individuals curious to expand their knowledge of Excel, data analysis and visualization, regardless of their background or prior experience."],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["The training program is structured for data analysts aiming to develop proficiency in using Excel efficiently to improve productivity."],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["This course will help in gaining knowledge of using Excel effectively and choosing the right feature and function for problems to provide the correct solution along with the Study-Guides<\/a>."],"_key_features_2_lists":["field_6103ad559f5b3"],"who_should_attend_0_attend_lists":["This course is suitable for anyone who wants to learn advanced Excel. "],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_1_attend_lists":["This essential course is for all business professional, students, teacher, freelancer, Marketer, entrepreneur across the industry. "],"_who_should_attend_1_attend_lists":["field_6103adfb3f3e4"],"prerequisites_text":["

<\/p>\r\n

    \r\n
  • No pre-requisites are required for this course, but general IT knowledge or experience can be helpful. <\/li>\r\n<\/ul>"],"_prerequisites_text":["field_612c7498c4b84"],"certification_0_short_description":[""],"_certification_0_short_description":["field_6103ab2f2822c"],"certification_0_list_content":["
      \r\n
    • After clearing this certification participants can manage worksheets and workbooks, manage data cells and ranges, manage tables and table data, perform operations by using formulas and functions, manage advanced charts and tables, troubleshoot formulas, Create and modify Pivot table and Pivot charts. <\/li>\r\n
    • Successful completion of the Microsoft Expert Excel certification course will help you in demonstrating your advanced Excel capability skills and job readiness for roles requiring Excel expertise. <\/li>\r\n
    • Microsoft Excel certification is a globally recognized credential and very well accepted World-wide.\u202f <\/li>\r\n
    • On successful completion of MO-211 Training aspirants receive a Course Completion certificate from us. <\/li>\r\n"],"_certification_0_list_content":["field_6103ab4a2822d"],"certification_0_image":["15024"],"_certification_0_image":["field_6103ab5b2822e"],"course_section_0_module_title":["Manage workbook options and settings "],"_course_section_0_module_title":["field_612f5535940c3"],"course_section_0_module_description":[""],"_course_section_0_module_description":["field_612f564c921af"],"course_section_0_section_0_title":["Manage workbooks "],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["Copy macros between workbooks "],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["Reference data in other workbooks "],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["4"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_0_section":["3"],"_course_section_0_section":["field_612f51e6b0277"],"course_section_1_module_title":["Manage and format data "],"_course_section_1_module_title":["field_612f5535940c3"],"course_section_1_module_description":[""],"_course_section_1_module_description":["field_612f564c921af"],"course_section_1_section_0_title":["Fill cells based on existing data "],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Fill cells by using Flash Fill "],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_1_lession_title":["Fill cells by using advanced Fill Series options "],"_course_section_1_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["3"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["3"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Create advanced formulas and macros "],"_course_section_2_module_title":["field_612f5535940c3"],"course_section_2_module_description":[""],"_course_section_2_module_description":["field_612f564c921af"],"course_section_2_section_0_title":["Perform logical operations in formulas "],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Perform logical operations by using nested functions including the IF (), IFS (), SWITCH (), SUMIF (), AVERAGEIF (), COUNTIF (), SUMIFS (), AVERAGEIFS (), COUNTIFS (), MAXIFS (), MINIFS (), AND (), OR (), NOT (), and LET () functions "],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["1"],"_course_section_2_section_0_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["6"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["Manage advanced charts and tables\u00a0"],"_course_section_3_module_title":["field_612f5535940c3"],"course_section_3_module_description":[""],"_course_section_3_module_description":["field_612f564c921af"],"course_section_3_section_0_title":["Create and modify advanced charts "],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":["Create and modify dual axis charts "],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts "],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["2"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["3"],"_course_section_3_section":["field_612f51e6b0277"],"course_section":["4"],"_course_section":["field_612f4f27b0276"],"custom_permalink":["azure\/azure-security-technologies-az-500\/"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":["a:5:{i:0;s:4:\"1363\";i:1;s:4:\"2227\";i:2;s:5:\"15542\";i:3;s:5:\"15546\";i:4;s:5:\"15817\";}"],"_related_courses":["field_61c453ca6b2dd"],"status_dates_start":[""],"status_dates_end":[""],"_yoast_wpseo_estimated-reading-time-minutes":["1"],"_yoast_wpseo_content_score":["60"],"banner_image":["12472"],"_banner_image":["field_621873548f922"],"_yoast_wpseo_title":["MO-211: Microsoft Excel Expert (Microsoft 365 Apps - CloudThat"],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["123"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["2800"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["4.5"],"_average_review_count":["field_62b00367d2de6"],"_yoast_wpseo_canonical":["https:\/\/stage.cloudthat.com\/training\/microsoft-office\/mo-211-microsoft-excel-expert-microsoft-365-apps"],"_edit_lock":["1755841143:12"],"_yoast_wpseo_wordproof_timestamp":[""],"video_type":[""],"presto_player_idx":[""],"lesson_video_width":[""],"lesson_shortcode":[""],"lesson_embed_ctx":[""],"lesson_youtube_url":[""],"lesson_stream_url":[""],"lesson_vimeo_url":[""],"lesson_ext_link_url":[""],"question_view_type":[""],"stm_select_approved_denied":[""],"stm_multiselect_approved":[""],"stm_multiselect_denied":[""],"course_banner_image":[""],"_course_banner_image":["field_63c69a6b81cf1"],"banner_url":[""],"_banner_url":["field_63c69a9681cf2"],"mobile_banner_image":[""],"_mobile_banner_image":["field_63cf93896d207"],"banner_link":[""],"_banner_link":["field_63c69a9681cf2"],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"category_features_heading":[""],"_category_features_heading":["field_644b8ff35049c"],"category_features_features":[""],"_category_features_features":["field_644b90025049d"],"category_features_cta_text":[""],"_category_features_cta_text":["field_644b90285049f"],"category_features_cta_link":[""],"_category_features_cta_link":["field_644b902d504a0"],"category_features":[""],"_category_features":["field_644b8fe15049b"],"course_features_0_heading":["Why choose CloudThat as your training partner for MO-211: Microsoft Excel Expert?"],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list":["4"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features":["2"],"_course_features":["field_644a0fa10e67d"],"_yoast_wpseo_metadesc":["Unlock the full potential of Microsoft Excel and become an expert in the Microsoft 365 Apps suite with the MO 211 certification. Enroll now!!"],"overview_section_heading":["MO-211: Microsoft Excel Expert - Course Overview"],"_overview_section_heading":["field_64538867ffdd0"],"key_features_heading":["Key Features of MO 211 Course from CloudThat"],"_key_features_heading":["field_645388ceffdd1"],"who_should_attend_heading":["Who can participate in the MO 211: Microsoft Excel Expert (Microsoft 365 Apps) Certification Training?"],"_who_should_attend_heading":["field_645388faffdd2"],"prerequisites_heading":["Prerequisites of MO-211: Microsoft Excel Expert Course"],"_prerequisites_heading":["field_64538a51ffdd3"],"course_outline_heading":["MO:211 Course Outline"],"_course_outline_heading":["field_64538a8effdd4"],"certification_heading":[""],"_certification_heading":["field_64538bffffdd5"],"course_fee_heading":[""],"_course_fee_heading":["field_64538c1cffdd6"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"faq_heading":[""],"_faq_heading":["field_64538c59ffdd8"],"after_completing_course_heading":["After completing MO-211: Microsoft Excel Expert certification training, students will be able to: "],"_after_completing_course_heading":["field_645c78ade3f50"],"course_features_0_features_list_0_list":["CloudThat has successfully trained a vast number of professionals, approximately 6.5 lakh individuals, and provided training services to more than 100 corporate clients across the globe. "],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["We have well trained, experienced, and certified Subject matter experts and instructors to conduct these trainings. "],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["The course guides students through specific tasks and real-world challenges to help them understand the relevance, power, and usefulness of Microsoft Excel. "],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_1_heading":["Learning objective of MO-211: Microsoft Excel Expert Course"],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list_0_list":["After acquiring skill of Excel, Person will be well versed with use of Excel for Data Analysis, Chart creation and formatting of charts, Prepare Reports, visualize data etc. "],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"course_features_1_features_list_1_list":["Create, open, edit, and save workbooks; understand the interface; and navigate to workbook elements. Manage workbooks and worksheets, change the screen display, and customize the Quick Access Toolbar. "],"_course_features_1_features_list_1_list":["field_644a0fc80e680"],"course_features_1_features_list_2_list":["Format cells and numbers, align and wrap content, add and remove cell styles, and merge cells. "],"_course_features_1_features_list_2_list":["field_644a0fc80e680"],"course_features_1_features_list_3_list":["Format data as a table, work with table styles, create named tables, define range names, and filter and sort data. "],"_course_features_1_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list":["8"],"_course_features_1_features_list":["field_644a0fb70e67f"],"course_features_1_background_color":["a:1:{i:0;s:5:\"white\";}"],"_course_features_1_background_color":["field_644a0fde0e681"],"wpdocs-meta-bdt":["14900"],"wpdocs-meta-gbp":["349"],"wpdocs-meta-usd":["399"],"course_section_0_section_1_title":["Prepare workbooks for collaboration "],"_course_section_0_section_1_title":["field_612f5233b0278"],"course_section_0_section_1_lesson_list_0_lession_title":["Restrict editing "],"_course_section_0_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_1_lession_title":["Protect worksheets and cell ranges "],"_course_section_0_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_2_lession_title":["Protect workbook structure "],"_course_section_0_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list":["4"],"_course_section_0_section_1_lesson_list":["field_612f530a0ac40"],"course_section_0_section_2_title":["Use and configure language options "],"_course_section_0_section_2_title":["field_612f5233b0278"],"course_section_0_section_2_lesson_list_0_lession_title":["Configure editing and display languages "],"_course_section_0_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_2_lesson_list_1_lession_title":["Use language-specific features "],"_course_section_0_section_2_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_2_lesson_list":["2"],"_course_section_0_section_2_lesson_list":["field_612f530a0ac40"],"course_section_1_section_1_title":["Format and validate data"],"_course_section_1_section_1_title":["field_612f5233b0278"],"course_section_1_section_1_lesson_list_0_lession_title":["Create custom number formats "],"_course_section_1_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_1_lession_title":["Configure data validation "],"_course_section_1_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_2_lession_title":["Group and ungroup data"],"_course_section_1_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list":["5"],"_course_section_1_section_1_lesson_list":["field_612f530a0ac40"],"course_section_1_section_2_title":["Apply advanced conditional formatting and filtering"],"_course_section_1_section_2_title":["field_612f5233b0278"],"course_section_1_section_2_lesson_list_0_lession_title":["Create custom conditional formatting rules "],"_course_section_1_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list_1_lession_title":["Create conditional formatting rules that use formulas "],"_course_section_1_section_2_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list":["3"],"_course_section_1_section_2_lesson_list":["field_612f530a0ac40"],"course_section_2_section_1_title":["Look up data by using functions "],"_course_section_2_section_1_title":["field_612f5233b0278"],"course_section_2_section_1_lesson_list_0_lession_title":["Look up data by using the XLOOKUP (), VLOOKUP (), HLOOKUP (), MATCH (), and INDEX () functions "],"_course_section_2_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list":["1"],"_course_section_2_section_1_lesson_list":["field_612f530a0ac40"],"course_section_2_section_2_title":["Use advanced date and time functions "],"_course_section_2_section_2_title":["field_612f5233b0278"],"course_section_2_section_2_lesson_list_0_lession_title":["Reference date and time by using the NOW () and TODAY () functions "],"_course_section_2_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_2_lesson_list_1_lession_title":["Calculate dates by using the WEEKDAY () and WORKDAY () functions "],"_course_section_2_section_2_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_2_lesson_list":["2"],"_course_section_2_section_2_lesson_list":["field_612f530a0ac40"],"course_section_3_section_1_title":["Create and modify PivotTables "],"_course_section_3_section_1_title":["field_612f5233b0278"],"course_section_3_section_1_lesson_list_0_lession_title":["Create PivotTables "],"_course_section_3_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_1_lession_title":["Modify field selections and options"],"_course_section_3_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_2_lession_title":["Create slicers "],"_course_section_3_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list":["6"],"_course_section_3_section_1_lesson_list":["field_612f530a0ac40"],"course_section_0_section_0_lesson_list_2_lession_title":["Enable macros in a workbook "],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list_2_lession_title":["Manage conditional formatting rules "],"_course_section_1_section_2_lesson_list_2_lession_title":["field_612f533b0ac41"],"after_completing_course_3_desciption":["Will be able to use formulas and functions to perform calculations on data. \r\n\r\n"],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"after_completing_course_4_desciption":["Creation of charts and graphs, tables to visually represent their data and make it easier to analyze and visualize the data. "],"_after_completing_course_4_desciption":["field_6103ad2f9f5b2"],"who_should_attend_2_attend_lists":["This Excel course will help you take your Excel skills to the next level, and you will learn advanced features of Excel. "],"_who_should_attend_2_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_3_attend_lists":["Excel users who want to pass the MO-211 exam and obtain official certification by Microsoft. "],"_who_should_attend_3_attend_lists":["field_6103adfb3f3e4"],"course_section_0_section_0_lesson_list_3_lession_title":["Manage workbook versions "],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_features_1_features_list_4_list":["Create and display formulas, use references and common functions in formulas, and understand calculation operators and precedence. "],"_course_features_1_features_list_4_list":["field_644a0fc80e680"],"course_section_1_section_0_lesson_list_2_lession_title":["Generate numeric data by using RANDARRAY () "],"_course_section_1_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_3_lession_title":["Group PivotTable data "],"_course_section_3_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_features_0_features_list_3_list":["By becoming proficient in Excel, participants will develop Excel skills and will be more efficient and productive by choosing correct features and functions in Excel. "],"_course_features_0_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list_5_list":["Get data from other sources, fix text formatting by using text functions, and insert hyperlinks to related information. "],"_course_features_1_features_list_5_list":["field_644a0fc80e680"],"course_features_1_features_list_6_list":["Apply conditional formatting to data; create, edit, and format charts; create sparklines; and use the Quick Analysis feature to quickly analyze data."],"_course_features_1_features_list_6_list":["field_644a0fc80e680"],"course_features_1_features_list_7_list":["Create advanced formulas and record macros "],"_course_features_1_features_list_7_list":["field_644a0fc80e680"],"course_section_0_section_1_lesson_list_3_lession_title":["Configure formula calculation options "],"_course_section_0_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_3_lession_title":["Calculate data by inserting subtotals and totals "],"_course_section_1_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_4_lession_title":["Remove duplicate records "],"_course_section_1_section_1_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_title":["Perform data analysis "],"_course_section_2_section_3_title":["field_612f5233b0278"],"course_section_2_section_3_lesson_list_0_lession_title":["Summarize data from multiple ranges by using the Consolidate feature Perform what-if analysis by using Goal Seek and Scenario Manager "],"_course_section_2_section_3_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list_1_lession_title":["Forecast data by using the AND(), IF(), and NPER() functions "],"_course_section_2_section_3_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list_2_lession_title":["Calculate financial data by using the PMT() function "],"_course_section_2_section_3_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list_3_lession_title":["Filter data by using FILTER() "],"_course_section_2_section_3_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list_4_lession_title":["Sort data by using SORTBY() "],"_course_section_2_section_3_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list":["5"],"_course_section_2_section_3_lesson_list":["field_612f530a0ac40"],"course_section_2_section_4_title":["Troubleshoot formulas "],"_course_section_2_section_4_title":["field_612f5233b0278"],"course_section_2_section_4_lesson_list_0_lession_title":["Trace precedence and dependence "],"_course_section_2_section_4_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_4_lesson_list_1_lession_title":["Monitor cells and formulas by using the Watch Window "],"_course_section_2_section_4_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_4_lesson_list_2_lession_title":["Validate formulas by using error checking rules "],"_course_section_2_section_4_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_4_lesson_list_3_lession_title":["Evaluate formulas "],"_course_section_2_section_4_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_4_lesson_list":["4"],"_course_section_2_section_4_lesson_list":["field_612f530a0ac40"],"course_section_2_section_5_title":["Create and modify simple macros "],"_course_section_2_section_5_title":["field_612f5233b0278"],"course_section_2_section_5_lesson_list_0_lession_title":["Record simple macros"],"_course_section_2_section_5_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_5_lesson_list_1_lession_title":["Name simple macros "],"_course_section_2_section_5_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_5_lesson_list_2_lession_title":["Edit simple macros "],"_course_section_2_section_5_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_5_lesson_list":["3"],"_course_section_2_section_5_lesson_list":["field_612f530a0ac40"],"course_section_3_section_1_lesson_list_4_lession_title":["Add calculated fields "],"_course_section_3_section_1_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_5_lession_title":["Format data "],"_course_section_3_section_1_lesson_list_5_lession_title":["field_612f533b0ac41"],"course_section_3_section_2_title":["Create and modify Pivot Charts "],"_course_section_3_section_2_title":["field_612f5233b0278"],"course_section_3_section_2_lesson_list_0_lession_title":["Create Pivot Charts "],"_course_section_3_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_2_lesson_list_1_lession_title":["Manipulate options in existing Pivot Charts "],"_course_section_3_section_2_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_2_lesson_list_2_lession_title":["Apply styles to Pivot Charts "],"_course_section_3_section_2_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_2_lesson_list_3_lession_title":["Drill down into PivotChart detail "],"_course_section_3_section_2_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_2_lesson_list":["4"],"_course_section_3_section_2_lesson_list":["field_612f530a0ac40"],"permalink_customizer":["microsoft-office\/mo-211-microsoft-excel-expert-microsoft-365-apps"],"question_sets_details_heading":[""],"_question_sets_details_heading":["field_65d303841f38d"],"question_sets_details_description":[""],"_question_sets_details_description":["field_65d303841f38e"],"question_sets_details_button_text":[""],"_question_sets_details_button_text":["field_65d303841f38f"],"question_sets_details_question_sets":[""],"_question_sets_details_question_sets":["field_65d303841f390"],"question_sets_details":[""],"_question_sets_details":["field_65d303841f38c"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"_regular_price_wmcp":["{\"USD\":\"399\",\"GBP\":\"349\",\"BDT\":\"14900\"}"]},"acf":[],"_links":{"self":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/15957"}],"collection":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses"}],"about":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/types\/stm-courses"}],"author":[{"embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/users\/13"}],"version-history":[{"count":0,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/15957\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/15528"}],"wp:attachment":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=15957"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=15957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}