{"id":15531,"date":"2023-07-06T13:42:50","date_gmt":"2023-07-06T13:42:50","guid":{"rendered":"https:\/\/stage.cloudthat.com\/training\/?post_type=stm-courses&p=15531"},"modified":"2025-03-19T08:11:26","modified_gmt":"2025-03-19T08:11:26","slug":"mo-201-microsoft-office-specialist-microsoft-excel-expert-office-2019","status":"publish","type":"stm-courses","link":"https:\/\/stage.cloudthat.com\/training\/microsoft-office\/mo-201-microsoft-office-specialist-microsoft-excel-expert-office-2019","title":{"rendered":"MO-201: Microsoft Office Specialist: Microsoft Excel Expert (Office 2019)"},"content":{"rendered":"

MO-<\/span>201<\/span> is a certification exam offered by Microsoft<\/span>, this certification<\/span> assesses an individual\u2019s knowledge and skills <\/span>of<\/span> Microsoft Excel (Excel 2019) 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><\/p>\n","protected":false},"excerpt":{"rendered":"

MO-201 is a certification exam offered by Microsoft, this certification assesses an individual\u2019s knowledge and skills of Microsoft Excel (Excel 2019) 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":["15533"],"_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":["2906"],"level":["fundamental"],"current_students":["0"],"duration_info":["2 Days"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["19900"],"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. \"},{\"question\":\"What skills are measured in Mo-201? \",\"answer\":\"Manage workbook options and settings.\\nManage and format data. \\nCreate advanced formulas and macros. \\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"],"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":["21729"],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"banner_description":["This Excel MO-201 certification training from CloudThat equips the aspirants with the required skills and knowledge. The exam and course covers the ability to customize Excel environments to meet project needs and to enhance productivity. This course will help in applying and using principal features of Excel at an expert-level and can complete tasks independently. \r\n\r\n"],"_banner_description":["field_612c733ed3564"],"after_completing_course_0_desciption":["Manage workbook options and settings. "],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Manage and format data. "],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Create advanced formulas and macros. "],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Will be able to use formulas and functions to perform calculations on data."],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"after_completing_course_4_desciption":["Creation of charts and graphs to visually represent their data and make it easier to analyze and visualize the data."],"_after_completing_course_4_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 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-201 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":["Import data into workbooks. "],"_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":["2"],"_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 (), and NOT () 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 "],"_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:3:{i:0;s:4:\"1363\";i:1;s:4:\"2227\";i:2;s:4:\"1422\";}"],"_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":["Microsoft PowerPoint Certification | MO-201: Microsoft Office Specialist"],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["123"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["2293"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["5"],"_average_review_count":["field_62b00367d2de6"],"_yoast_wpseo_canonical":["https:\/\/stage.cloudthat.com\/training\/microsoft-office\/mo-201-microsoft-office-specialist-microsoft-excel-expert-office-2019"],"_edit_lock":["1742371782:2"],"_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?"],"_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":["Validate your proficiency in Microsoft PowerPoint with the MO-201 certification. Demonstrate your expertise in creating, formatting, and delivering compelling presentations."],"overview_section_heading":["MO-201 - Microsoft Office Specialist: Microsoft Excel Expert (Office 2019) - Course Overview"],"_overview_section_heading":["field_64538867ffdd0"],"key_features_heading":["Key Features of MO-201 - Microsoft Office Specialist: Microsoft Excel Expert"],"_key_features_heading":["field_645388ceffdd1"],"who_should_attend_heading":["Who Should Attend: "],"_who_should_attend_heading":["field_645388faffdd2"],"prerequisites_heading":["Prerequisites of MO-201 - Microsoft Office Specialist: Microsoft Excel Expert"],"_prerequisites_heading":["field_64538a51ffdd3"],"course_outline_heading":[""],"_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 this course, 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_0_features_list_3_list":["By becoming proficient in Excel, participants will gain 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_heading":["Learning objective of 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_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_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. \r\n\r\n "],"_course_features_1_features_list_6_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":["19900"],"wpdocs-meta-gbp":["349"],"wpdocs-meta-usd":["499"],"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-201 exam and obtain official certification by Microsoft. "],"_who_should_attend_3_attend_lists":["field_6103adfb3f3e4"],"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":["5"],"_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_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_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 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_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":["4"],"_course_section_3_section_2_lesson_list":["field_612f530a0ac40"],"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_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_0_section_0_lesson_list_3_lession_title":["Manage workbook versions"],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"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_0_section_1_lesson_list_4_lession_title":["Manage comments"],"_course_section_0_section_1_lesson_list_4_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"],"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 "],"_course_section_2_section_3_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list_1_lession_title":["Perform what-if analysis by using Goal Seek and Scenario Manager "],"_course_section_2_section_3_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list_2_lession_title":["Forecast data by using the AND(), IF(), and NPER() functions"],"_course_section_2_section_3_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list_3_lession_title":["Calculate financial data by using the PMT() function"],"_course_section_2_section_3_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_3_lesson_list":["4"],"_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_3_lession_title":["Group PivotTable data "],"_course_section_3_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"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_lesson_list_3_lession_title":["Drill down into Pivot Chart detail "],"_course_section_3_section_2_lesson_list_3_lession_title":["field_612f533b0ac41"],"permalink_customizer":["microsoft-office\/mo-201-microsoft-office-specialist-microsoft-excel-expert-office-2019"],"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\":\"499\",\"GBP\":\"349\",\"BDT\":\"19900\"}"]},"acf":[],"_links":{"self":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/15531"}],"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\/15531\/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=15531"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=15531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}