{"id":39902,"date":"2021-05-06T19:51:28","date_gmt":"2021-05-06T19:51:28","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=39902"},"modified":"2024-05-09T09:00:14","modified_gmt":"2024-05-09T09:00:14","slug":"microsoft-excel-expert-excel-and-excel-2019-mo-201","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/","title":{"rendered":"Microsoft Excel Expert (Excel and Excel 2019) MO-201"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/C_AR_INT_13-SAP-Certified-Application-Associate-Ariba-Integration-750x400.png\" alt=\"Microsoft Excel Expert (Excel and Excel 2019) MO-201 study guide\" class=\"wp-image-40041\"\/><\/figure>\n<\/div>\n\n\n<p>The Microsoft Excel Expert (Excel and Excel 2019) examination is designed to demonstrate the correct application of the principal features of Excel at an expert level and can complete tasks independently. The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Knowledge Required for the Exam<\/strong><\/h4>\n\n\n\n<p>After completion of this certification which includes approximately 150 hours of instruction and hands-on experience with the product, you will be ready to enter into the job market.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Overview<\/strong><\/h3>\n\n\n\n<p>The Microsoft Excel Expert (Excel and Excel 2019) MO-201 examination consists primarily of multiple-choice questions, but you might also encounter build a tree, reorder, or simulation questions. Furthermore, the cost of the examination is $100 and you need to get at least a score of &nbsp;700\/1000 to clear the examination. You are approximately given 90 minutes to complete the examination but Microsoft does not disclose the exam\u2019s time limit. Furthermore, it is available in the English language only.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/C_AR_INT_13-SAP-Certified-Application-Associate-Ariba-Integration-1-750x400.png\" alt=\" Microsoft Excel Expert (Excel and Excel 2019) MO-201 exam overview\" class=\"wp-image-40043\"\/><\/figure>\n<\/div>\n\n\n<p><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Registration<\/strong><\/h3>\n\n\n\n<p>For Registering yourself for the <strong>Microsoft Excel Expert (Excel and Excel 2019) MO-201<\/strong> examination, follow the following steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the official website and click on the schedule now option.<\/li>\n\n\n\n<li>You will be redirected to the <a href=\"https:\/\/www.certiport.com\/locator\" target=\"_blank\" rel=\"noreferrer noopener\">Certiport <\/a>registration page.<\/li>\n\n\n\n<li>Follow the steps and complete your registration.<\/li>\n\n\n\n<li>Furthermore, you will be receiving a confirmation mail once you have made your payment.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Policies for Microsoft Excel Expert (Excel and Excel 2019) MO-201<\/strong><\/h3>\n\n\n\n<p>The candidate is recommended to read these policies so as to avoid any kind of confusion in the future. These <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/certification-exam-policies\" target=\"_blank\">policies<\/a> contain information about registration options, learning credits, etc.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Retake Policy<\/strong><\/h4>\n\n\n\n<p>If the candidate failed to achieve the passing score, then he\/she has to wait for 24 hours before reapplying to the examination. The candidate can go to their certificate dashboard and reschedule the exam themselves. The candidate can reappear for the examination only five times. Failure in the second attempt will result in a waiting time of 14 days before rescheduling your third attempt. The waiting period for the fourth and the fifth attempts will also be 14 days.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Cancellation Policy<\/strong><\/h4>\n\n\n\n<p>Microsoft offers candidates to cancel or reschedule their exams within a minimum of 24 hours prior to the exam date. However, to prevent any cancellation fee, you must cancel or reschedule your exam, at least 6 business days prior to the date scheduled for your exam. Also, if you fail to appear in the exam, then you will not receive any refund of the exam fee.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Recertification Policy<\/strong><\/h4>\n\n\n\n<p>Microsoft certification is expected to expire when the products are out of mainstream support although the person`s certification will be recognized. Officially, the certification will never expire.<\/p>\n\n\n\n<p>You can read the full <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\">policies <\/a> on the official website of Microsoft.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>For more information, click on <a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201-faq\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Excel Expert (Excel and Excel 2019) MO-201 FAQ<\/a>.<\/strong><\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201-faq\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/C_AR_INT_13-SAP-Certified-Application-Associate-Ariba-Integration-2-1.png\" alt=\"Microsoft Excel Expert (Excel and Excel 2019) MO-201 faq\" class=\"wp-image-40045\"\/><\/a><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Course Outline <\/strong><\/h3>\n\n\n\n<p>The Microsoft Excel Expert (Excel and Excel 2019) MO-201 examination covers the following topics:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>&nbsp;Manage workbook options and settings (15-20%)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Manage workbooks\n<ul class=\"wp-block-list\">\n<li>copy macros between workbooks <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/copy-a-macro-module-to-another-workbook-13c0938b-8432-4259-9177-a71f7e626de0#:~:text=Open%20both%20the%20workbook%20that,open%20the%20Visual%20Basic%20Editor.&amp;text=%2C%20or%20press%20CTRL%2BR%20.,copy%20to%20the%20destination%20workbook.\" target=\"_blank\" rel=\"noreferrer noopener\">Copy a macro module to another workbook<\/a>)<\/li>\n\n\n\n<li>reference data in other workbooks<\/li>\n\n\n\n<li>enable macros in a workbook <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6\" target=\"_blank\" rel=\"noreferrer noopener\">Enable or disable macros in Microsoft 365 files<\/a>)<\/li>\n\n\n\n<li>manage workbook versions <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/view-previous-versions-of-office-files-5c1e076f-a9c9-41b8-8ace-f77b9642e2c2\" target=\"_blank\" rel=\"noreferrer noopener\">View previous versions of Office files<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Prepare workbooks for collaboration\n<ul class=\"wp-block-list\">\n<li> restrict editing <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/video-restrict-changes-to-files-505ac90e-bdb8-4dbe-9220-861feb1d6403\" target=\"_blank\" rel=\"noreferrer noopener\">Restrict changes to files<\/a>)<\/li>\n\n\n\n<li>protect worksheets and cell ranges <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6#:~:text=On%20the%20Review%20tab%2C%20select,to%20be%20able%20to%20change.&amp;text=Move%20the%20pointer%20to%20cells,allowed%20to%20select%20locked%20cells.\" target=\"_blank\" rel=\"noreferrer noopener\">Protect a worksheet<\/a>)<\/li>\n\n\n\n<li> protect workbook structure <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/protect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517\" target=\"_blank\" rel=\"noreferrer noopener\">Protect a workbook<\/a>)<\/li>\n\n\n\n<li>configure formula calculation options<\/li>\n\n\n\n<li> manage comments <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/insert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8#:~:text=If%20you%20need%20to%20edit%20the%20note%2C%20right%2Dclick%20the,cell%20and%20choose%20Delete%20Comment.\" target=\"_blank\" rel=\"noreferrer noopener\">Insert comments and notes in Excel<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use and configure language options\n<ul class=\"wp-block-list\">\n<li>configure editing and display languages <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/change-the-language-office-uses-in-its-menus-and-proofing-tools-f5c54ff9-a6fa-4348-a43c-760e7ef148f8\" target=\"_blank\" rel=\"noreferrer noopener\">Change the language Office uses in its menus and proofing tools<\/a>)<\/li>\n\n\n\n<li> use language-specific features <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/excel\/concepts\/language-specific-properties-methods-and-functions\" target=\"_blank\" rel=\"noreferrer noopener\">Language-specific Properties, Methods, and Functions<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong> Manage and format data (20-25%)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fill cells based on existing data\n<ul class=\"wp-block-list\">\n<li> and then fill cells by using Flash <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7\" target=\"_blank\" rel=\"noreferrer noopener\">Fill Using Flash Fill in Excel<\/a>)<\/li>\n\n\n\n<li> fill cells by using advanced <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db\" target=\"_blank\" rel=\"noreferrer noopener\">Fill Series options Fill data automatically in worksheet cells<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Format and validate data\n<ul class=\"wp-block-list\">\n<li> create custom number formats <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-and-apply-a-custom-number-format-6c308025-35da-4047-9481-c146a12063df\" target=\"_blank\" rel=\"noreferrer noopener\">Create and apply a custom number format<\/a>)<\/li>\n\n\n\n<li> configure data validation <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249\" target=\"_blank\" rel=\"noreferrer noopener\">Apply data validation to cells<\/a>)<\/li>\n\n\n\n<li> group and ungroup data <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/outline-group-data-in-a-worksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff#:~:text=for%20the%20group%2C%20and%20then,%3E%20Outline%20%3E%20Ungroup%20%3E%20Ungroup.\" target=\"_blank\" rel=\"noreferrer noopener\">Outline (group) data in a worksheet<\/a>)<\/li>\n\n\n\n<li> calculate data by inserting subtotals and totals <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/insert-subtotals-in-a-list-of-data-in-a-worksheet-7881d256-b4fa-4f81-b71e-b0a3d4a52b3a\" target=\"_blank\" rel=\"noreferrer noopener\">Insert subtotals in a list of data in a worksheet<\/a>)<\/li>\n\n\n\n<li> remove duplicate records&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Apply advanced conditional formatting and filtering\n<ul class=\"wp-block-list\">\n<li> create custom conditional formatting rules <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/highlight-patterns-and-trends-with-conditional-formatting-eea152f5-2a7d-4c1a-a2da-c5f893adb621\" target=\"_blank\" rel=\"noreferrer noopener\">Highlight patterns and trends with conditional formatting<\/a>)<\/li>\n\n\n\n<li> create conditional formatting rules that use formulas <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/video-use-formulas-to-apply-conditional-formatting-35f92fc6-10fc-46bf-958d-90ec64facfc8#:~:text=I%20select%20the%20cells%20I%20want%20to%20apply%20a%20rule,formula%20%3DB2%3E%3D90.\" target=\"_blank\" rel=\"noreferrer noopener\">Use formulas<\/a>)<\/li>\n\n\n\n<li> manage conditional formatting rules<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Create advanced formulas and macros (30-35%)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Perform logical operations in formulas\n<ul class=\"wp-block-list\">\n<li>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<\/li>\n\n\n\n<li>Look up data by using functions <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/lookup-function-446d94af-663b-451d-8251-369d5e3864cb\" target=\"_blank\" rel=\"noreferrer noopener\">LOOKUP function<\/a>)<\/li>\n\n\n\n<li> look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/look-up-values-with-vlookup-index-or-match-68297403-7c3c-4150-9e3c-4d348188976b\" target=\"_blank\" rel=\"noreferrer noopener\">Look up values with VLOOKUP, INDEX, or MATCH<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use advanced date and time functions\n<ul class=\"wp-block-list\">\n<li> reference date and time by using the NOW() and TODAY() functions <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/insert-the-current-date-and-time-in-a-cell-b5663451-10b0-40ab-9e71-6b0ce5768138\" target=\"_blank\" rel=\"noreferrer noopener\">Insert the current date and time in a cell<\/a>)<\/li>\n\n\n\n<li> calculate dates by using the WEEKDAY() and WORKDAY() functions <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33\" target=\"_blank\" rel=\"noreferrer noopener\">WORKDAY function<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/weekday-function-60e44483-2ed1-439f-8bd0-e404c190949a\" target=\"_blank\" rel=\"noreferrer noopener\">WEEKDAY function<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Perform data analysis\n<ul class=\"wp-block-list\">\n<li> summarize data from multiple ranges by using the Consolidate Feature <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/consolidate-data-in-multiple-worksheets-007ce8f4-2fae-4fea-9ee5-a0b2c9e36d9b\" target=\"_blank\" rel=\"noreferrer noopener\">Consolidate data in multiple worksheets<\/a>)<\/li>\n\n\n\n<li> perform what-if analysis by using Goal Seek and Scenario Manager<\/li>\n\n\n\n<li> forecast data by using the AND(), IF(), and NPER() functions <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/nper-function-240535b5-6653-4d2d-bfcf-b6a38151d815\" target=\"_blank\" rel=\"noreferrer noopener\">NPER function<\/a>)<\/li>\n\n\n\n<li> calculate financial data by using the PMT() function <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/pmt-function-0214da64-9a63-4996-bc20-214433fa6441#:~:text=PMT%2C%20one%20of%20the%20financial,PMT%20function%20in%20a%20formula.\" target=\"_blank\" rel=\"noreferrer noopener\">PMT function<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Troubleshoot formulas\n<ul class=\"wp-block-list\">\n<li> trace precedence and dependence <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/display-the-relationships-between-formulas-and-cells-a59bef2b-3701-46bf-8ff1-d3518771d507\" target=\"_blank\" rel=\"noreferrer noopener\">Display the relationships between formulas and cells<\/a>)<\/li>\n\n\n\n<li> monitor cells and formulas by using the Watch Window<\/li>\n\n\n\n<li> validate formulas by using error checking rules <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/detect-errors-in-formulas-3a8acca5-1d61-4702-80e0-99a36a2822c1\" target=\"_blank\" rel=\"noreferrer noopener\">Detect errors in formulas<\/a>)<\/li>\n\n\n\n<li> evaluate formulas<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create and modify simple macros\n<ul class=\"wp-block-list\">\n<li> record simple macros <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-or-run-a-macro-c6b99036-905c-49a6-818a-dfb98b7c3c9c\" target=\"_blank\" rel=\"noreferrer noopener\">Create or run a macro<\/a>)<\/li>\n\n\n\n<li> name simple macros<\/li>\n\n\n\n<li> edit simple macros <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/edit-a-macro-ed9e8c3d-58fd-47a1-83eb-bdee680376bb\" target=\"_blank\" rel=\"noreferrer noopener\">Edit a macro<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Manage advanced charts and tables (25-30%)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create and modify advanced charts\n<ul class=\"wp-block-list\">\n<li> Firstly, create and modify dual axis charts <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-or-remove-a-secondary-axis-in-a-chart-in-excel-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9\" target=\"_blank\" rel=\"noreferrer noopener\">Add or remove a secondary axis in a chart in Excel<\/a>)<\/li>\n\n\n\n<li> Secondly, create and modify charts including Box &amp; Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-box-and-whisker-chart-62f4219f-db4b-4754-aca8-4743f6190f0d\" target=\"_blank\" rel=\"noreferrer noopener\">Create a box and whisker chart<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create and modify PivotTables\n<ul class=\"wp-block-list\">\n<li> create PivotTables <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576\" target=\"_blank\" rel=\"noreferrer noopener\">Create a PivotTable to analyze worksheet data<\/a>)<\/li>\n\n\n\n<li> modify field selections and options<\/li>\n\n\n\n<li> create slicers <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d\" target=\"_blank\" rel=\"noreferrer noopener\">Use slicers to filter data<\/a>)<\/li>\n\n\n\n<li> group PivotTable data <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/group-or-ungroup-data-in-a-pivottable-c9d1ddd0-6580-47d1-82bc-c84a5a340725#:~:text=Group%20data,a%20value%20and%20select%20Group.\" target=\"_blank\" rel=\"noreferrer noopener\">Group or ungroup data in a PivotTable<\/a>)<\/li>\n\n\n\n<li> add calculated fields<\/li>\n\n\n\n<li> format data<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create and modify PivotCharts\n<ul class=\"wp-block-list\">\n<li> create PivotCharts <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-pivotchart-c1b1e057-6990-4c38-b52b-8255538e7b1c\" target=\"_blank\" rel=\"noreferrer noopener\">Create a PivotChart<\/a>)<\/li>\n\n\n\n<li> manipulate options in existing PivotCharts <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/overview-of-pivottables-and-pivotcharts-527c8fa3-02c0-445a-a2db-7794676bce96\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of PivotTables and PivotCharts<\/a>)<\/li>\n\n\n\n<li> apply styles to PivotCharts<\/li>\n\n\n\n<li> drill down into PivotChart details<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Preparatory Guide for Microsoft Excel Expert (Excel and Excel 2019) MO-201<\/strong><\/h3>\n\n\n\n<p>Whenever it comes to any examination a student needs to prepare thoroughly for it. Similarly for the Microsoft Excel Expert (Excel and Excel 2019) MO-201 examination you need a proper structured guide and study plan which will help you to ace the examination. It necessary to have an in-depth knowledge of the topics and other important aspects of the examination. To help you in your preparation, we have curated a preparatory guide. Therefore, let&#8217;s get started:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"2000\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/CIS-Cloud-Management.png\" alt=\"Preparatory Guide for Microsoft Excel Expert (Excel and Excel 2019) MO-201\" class=\"wp-image-40047\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/CIS-Cloud-Management.png 800w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/CIS-Cloud-Management-160x400.png 160w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><strong>Refer the Exam Guide<\/strong><\/h4>\n\n\n\n<p>It is important to know the topics beforehand. Significantly, this is the most important step in the preparation guide. Furthermore, exam objectives are very important when it comes to preparing the exam strategy. So, let\u2019s take a quick look:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Manage workbook options and settings (15-20%)<\/li>\n\n\n\n<li>Manage and format data (20-25%)<\/li>\n\n\n\n<li>Create advanced formulas and macros (30-35%)<\/li>\n\n\n\n<li>&nbsp;Manage advanced charts and tables (25-30%)<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Books<\/strong><\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignright size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"317\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/41mmurOAZUL._SX393_BO1204203200_-317x400.jpg\" alt=\"MOS Study Guide for Microsoft Excel Expert Exam MO-201 by Paul McFedries\" class=\"wp-image-40039\" style=\"width:168px;height:212px\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/41mmurOAZUL._SX393_BO1204203200_-317x400.jpg 317w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/41mmurOAZUL._SX393_BO1204203200_.jpg 395w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/figure>\n<\/div>\n\n\n<p>Microsoft provides reference books that can be helpful while studying for the exam. Furthermore, these books contain various useful resources that can be used while studying. Visit&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoftpressstore.com\/search\/index.aspx?query=Windows+Operating+System+Fundamentals\" target=\"_blank\"><strong>Microsoft Press books<\/strong><\/a>, to find relevant books to get a deeper insight into the exam objectives, and hence crack the test, and earn your certification. You can also buy these books from Amazon. These books will help you prepare for the examination in a structural way.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MOS Study Guide for Microsoft Excel Expert Exam MO-201 by Paul McFedries<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Join Microsoft Community<\/strong><\/h4>\n\n\n\n<p>A healthy discussion is always beneficial, no matter where it is done. The prospects of getting resolutions to an issue increase steeply when a greater number of people are involved. These discussions make the studies more comprehensive.  Forums work really well to build a community that is essential for understanding others.&nbsp;Interacting with people with the same goal puts you one step forward in achieving those goals. Furthermore, it is suggested that you should join Microsoft Community.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Evaluate yourself with Practice Test<\/strong><\/h4>\n\n\n\n<p>It is very important to practice what you have learned so that you are in a position to analyze your practice. Furthermore, by practicing you will be able to improve your answering skills that will result in saving a lot of time. Moreover, the best way to start doing practice tests is after completing one full topic. It will work as a revision part for you. Furthermore, practicing you will be able to improve your answering skills that will result in saving a lot of time. Moreover, the best way to start doing practice tests is after completing one full topic as this will work as a revision part for you. Moreover, the best way to start doing practice tests is after completing one full topic. Furthermore, it will work as a revision part for you.&nbsp;Start practicing now!<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Salesforce-Heroku-Architecture-Designer-1.png\" alt=\"Microsoft Excel Expert (Excel and Excel 2019) MO-201 free practice test\" class=\"wp-image-40046\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Salesforce-Heroku-Architecture-Designer-1.png 960w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Salesforce-Heroku-Architecture-Designer-1-750x117.png 750w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The Microsoft Excel Expert (Excel and Excel 2019) examination is designed to demonstrate the correct application of the principal features of Excel at an expert level and can complete tasks independently. The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":40041,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[1226],"tags":[5338,5339,5340],"class_list":["post-39902","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","tag-microsoft-excel-expert-excel-and-excel-2019-mo-201-exam-guide","tag-microsoft-excel-expert-excel-and-excel-2019-mo-201-exam-tutorial","tag-microsoft-excel-expert-excel-and-excel-2019-mo-201-online-guide"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Excel Expert (Excel and Excel 2019) MO-201 - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn and enhance your knowledge. Become Certified Microsoft Excel Expert (Excel and Excel 2019) MO-201 expert now! Try free practice test papers.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel Expert (Excel and Excel 2019) MO-201 - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn and enhance your knowledge. Become Certified Microsoft Excel Expert (Excel and Excel 2019) MO-201 expert now! Try free practice test papers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-09T09:00:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/C_AR_INT_13-SAP-Certified-Application-Associate-Ariba-Integration.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/\",\"name\":\"Microsoft Excel Expert (Excel and Excel 2019) MO-201 - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-05-06T19:51:28+00:00\",\"dateModified\":\"2024-05-09T09:00:14+00:00\",\"description\":\"Learn and enhance your knowledge. Become Certified Microsoft Excel Expert (Excel and Excel 2019) MO-201 expert now! Try free practice test papers.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel Expert (Excel and Excel 2019) MO-201\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Excel Expert (Excel and Excel 2019) MO-201 - Testprep Training Tutorials","description":"Learn and enhance your knowledge. Become Certified Microsoft Excel Expert (Excel and Excel 2019) MO-201 expert now! Try free practice test papers.","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:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel Expert (Excel and Excel 2019) MO-201 - Testprep Training Tutorials","og_description":"Learn and enhance your knowledge. Become Certified Microsoft Excel Expert (Excel and Excel 2019) MO-201 expert now! Try free practice test papers.","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2024-05-09T09:00:14+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/C_AR_INT_13-SAP-Certified-Application-Associate-Ariba-Integration.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/","name":"Microsoft Excel Expert (Excel and Excel 2019) MO-201 - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-05-06T19:51:28+00:00","dateModified":"2024-05-09T09:00:14+00:00","description":"Learn and enhance your knowledge. Become Certified Microsoft Excel Expert (Excel and Excel 2019) MO-201 expert now! Try free practice test papers.","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-excel-expert-excel-and-excel-2019-mo-201\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Microsoft Excel Expert (Excel and Excel 2019) MO-201"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/39902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=39902"}],"version-history":[{"count":6,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/39902\/revisions"}],"predecessor-version":[{"id":62651,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/39902\/revisions\/62651"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/40041"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=39902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=39902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=39902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}