{"id":961,"date":"2025-05-27T05:47:41","date_gmt":"2025-05-27T05:47:41","guid":{"rendered":"https:\/\/www.skilr.com\/tutorial\/?page_id=961"},"modified":"2025-05-27T05:47:42","modified_gmt":"2025-05-27T05:47:42","slug":"exam-mo-201-microsoft-excel-expert-office-2019","status":"publish","type":"page","link":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/","title":{"rendered":"Exam MO-201: Microsoft Excel Expert (Office 2019)"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-1024x576.jpg\" alt=\"Exam MO-201: Microsoft Excel Expert (Office 2019)\" class=\"wp-image-966\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-1024x576.jpg 1024w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-300x169.jpg 300w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg 1000w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>The MO-201 certification is designed for individuals who can proficiently utilize the advanced features of Microsoft Excel 2019. This exam validates the ability to create, manage, and share complex spreadsheets tailored for a wide range of professional and specialized business scenarios. Candidates aiming for the Excel Expert certification are expected to work confidently with the following types of advanced workbooks:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Customized business templates<\/li>\n\n\n\n<li>Multi-axis financial charts<\/li>\n\n\n\n<li>Amortization schedules<\/li>\n\n\n\n<li>Inventory tracking sheets<\/li>\n<\/ul>\n\n\n\n<p>These examples represent the type of high-level tasks a certified Excel Expert should be capable of handling in a real-world setting.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>&#8211; Knowledge Area<\/strong><\/h3>\n\n\n\n<p>To succeed in this <a href=\"https:\/\/www.skilr.com\/microsoft-excel-expert-excel-and-excel-2019-mo-201-exam\" target=\"_blank\" rel=\"noreferrer noopener\">exam<\/a>, candidates should:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Possess around 150 hours of structured training and practical experience using Excel 2019.<\/li>\n\n\n\n<li>Demonstrate expert-level proficiency in applying Excel functionalities.<\/li>\n\n\n\n<li>Be adequately prepared to pursue or advance in professional roles that require in-depth Excel skills.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Exam Details<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"696\" height=\"399\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-27-105559.png\" alt=\"Exam MO-201: Microsoft Excel Expert (Office 2019)\" class=\"wp-image-967\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-27-105559.png 696w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-27-105559-300x172.png 300w\" sizes=\"auto, (max-width: 696px) 100vw, 696px\" \/><\/figure>\n<\/div>\n\n\n<p>The <a href=\"https:\/\/www.skilr.com\/microsoft-excel-expert-excel-and-excel-2019-mo-201-exam\" target=\"_blank\" rel=\"noreferrer noopener\">MO-201<\/a>: Microsoft Excel Expert (Office 2019) exam is an advanced-level certification designed for business professionals who use Excel in a specialized or high-level capacity. Candidates are given 50 minutes to complete the exam, which is proctored and strictly closed-book. The assessment may include interactive tasks that require hands-on application of Excel&#8217;s expert features. This certification exam is available in multiple languages to accommodate a global audience, including English, Spanish, French, German, Japanese, Korean, Simplified Chinese, and Traditional Chinese.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Course Outline<\/strong><\/h2>\n\n\n\n<p>This exam covers the following topics:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>1. Understand about managing 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>Copying macros between workbooks&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Referencing data in other workbooks<\/li>\n\n\n\n<li>Enabling macros in a workbook&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Managing workbook versions&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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\n\n\n<li>Prepare workbooks for collaboration\n<ul class=\"wp-block-list\">\n<li>Restricting editing&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Protecting worksheets and cell ranges&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Protecting workbook structure&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Configuring formula calculation options<\/li>\n\n\n\n<li>Managing comments&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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\n\n\n<li>Use and configure language options\n<ul class=\"wp-block-list\">\n<li>Configuring editing and display languages&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Using language-specific features&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>2. Learn how to 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>fill cells by using Flash&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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\n\n\n<li>Formatting and validating data\n<ul class=\"wp-block-list\">\n<li>Creating custom number formats&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Configuring data validation&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Grouping and ungrouping data&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Calculating data by inserting subtotals and totals&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Removing duplicate records&nbsp;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Applying advanced conditional formatting and filtering\n<ul class=\"wp-block-list\">\n<li>Creating custom conditional formatting rules&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Creating conditional formatting rules that use formulas&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Managing conditional formatting rules<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>3. Learn about creating advanced formulas and macros (30-35%)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Performing logical operations in formulas\n<ul class=\"wp-block-list\">\n<li>Performing 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&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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\n\n\n<li>Using advanced date and time functions\n<ul class=\"wp-block-list\">\n<li>Referencing date and time by using the NOW() and TODAY() functions&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Calculating dates by using the WEEKDAY() and WORKDAY() functions&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33\" target=\"_blank\" rel=\"noreferrer noopener\">WORKDAY function<\/a>,&nbsp;<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\n\n\n<li>Performing data analysis\n<ul class=\"wp-block-list\">\n<li>Summarizing data from multiple ranges by using the Consolidate Feature&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Performing what-if analysis by using Goal Seek and Scenario Manager<\/li>\n\n\n\n<li>Forecasting data by using the AND(), IF(), and NPER() functions&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Calculating financial data by using the PMT() function&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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\n\n\n<li>Troubleshooting formulas\n<ul class=\"wp-block-list\">\n<li>Tracing precedence and dependence&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Monitoring cells and formulas by using the Watch Window<\/li>\n\n\n\n<li>Validating formulas by using error checking rules&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Evaluating formulas<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.skilr.com\/microsoft-excel-expert-excel-and-excel-2019-mo-201-exam\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-2.jpg\" alt=\"Microsoft Excel Expert (Office 2019)\" class=\"wp-image-968\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-2.jpg 961w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-2-300x47.jpg 300w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Creating and modifying simple macros\n<ul class=\"wp-block-list\">\n<li>Recording simple macros&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>4. Understand how to manage advanced charts and tables (25-30%)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creating and modifying advanced charts\n<ul class=\"wp-block-list\">\n<li>Creating and modifying dual axis charts&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Creating and modifying charts including Box &amp; Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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\n\n\n<li>Creating and modifying PivotTables\n<ul class=\"wp-block-list\">\n<li>Creating PivotTables&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Modifying field selections and options<\/li>\n\n\n\n<li>Creating slicers&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Grouping PivotTable data&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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\n\n\n<li>Creating and modifying PivotCharts\n<ul class=\"wp-block-list\">\n<li>Creating PivotCharts&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Manipulating options in existing PivotCharts&nbsp;<strong>(Microsoft Documentation:<\/strong>&nbsp;<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>Applying styles to PivotCharts<\/li>\n\n\n\n<li>Drilling down into PivotChart details<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"ftoc-heading-12-2\"><strong>Microsoft MO-201 Exam FAQs<\/strong><\/h2>\n\n\n\n<p><strong><em><a href=\"https:\/\/www.skilr.com\/tutorial\/microsoft-mo-201-exam-faqs\/\" target=\"_blank\" rel=\"noreferrer noopener\">Click Here for FAQs!<\/a><\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.skilr.com\/tutorial\/microsoft-mo-201-exam-faqs\/\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-3-1024x576.jpg\" alt=\"FAQS: Microsoft Excel Expert (Office 2019)\" class=\"wp-image-969\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-3-1024x576.jpg 1024w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-3-300x169.jpg 300w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-3-scaled.jpg 1000w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><strong>Microsoft Certification Exam Policies<\/strong><\/h2>\n\n\n\n<p>To maintain the integrity and global recognition of its certification programs, Microsoft enforces standardized <a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\">testing policies<\/a> for both online and in-person exams.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>MOS Exam Retake Policy<\/strong>\n<ul class=\"wp-block-list\">\n<li>Candidates who fail a Microsoft Office Specialist (MOS) exam must wait 24 hours before retaking it. If the second attempt is unsuccessful, a 48-hour waiting period applies to all subsequent retakes. There is no limit to the number of attempts; however, retaking an exam that has already been passed is discouraged unless specifically required.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Rescheduling and Cancellation Policy<\/strong>\n<ul class=\"wp-block-list\">\n<li>Exam appointments can be rescheduled or canceled at no cost if the request is made at least six business days before the exam. Changes made within five business days may incur fees, while cancellations within 24 hours or no-shows result in the loss of the exam fee. Exceptions may be considered in the case of documented emergencies.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Microsoft MO-201 Exam Study Guide<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"1000\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-scaled.jpg\" alt=\"Exam MO-201: Microsoft Excel Expert (Office 2019)\" class=\"wp-image-970\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-scaled.jpg 667w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-200x300.jpg 200w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Understand the Exam Objectives<\/strong><\/h3>\n\n\n\n<p>Begin your preparation by thoroughly reviewing the official <a href=\"https:\/\/www.skilr.com\/microsoft-excel-expert-excel-and-excel-2019-mo-201-exam\" target=\"_blank\" rel=\"noreferrer noopener\">exam objectives<\/a> provided by Microsoft. These outline the specific skills and knowledge areas that will be tested. Topics typically include managing workbook options and settings, applying custom data formats and layouts, using advanced formulas and functions, and managing macros and forms. Understanding these objectives not only helps you identify your current skill level but also allows you to structure your study plan around areas where you need the most improvement. Visit the official Microsoft certification page to access the full list of domains and competencies covered in the exam.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Use Official Microsoft Training Resources<\/strong><\/h3>\n\n\n\n<p>Microsoft provides high-quality training materials through its <a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/mos-excel-expert-2019\/?practice-assessment-type=certification\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Learn<\/a> platform. These modules are free and tailored to the MO-201 exam, offering interactive lessons, guided exercises, and real-world scenarios that align with the exam content. Using official training resources ensures you&#8217;re learning in a format that closely reflects how Microsoft intends the content to be understood and applied. Supplement this with the Microsoft Office Specialist Program Study Guide for Excel Expert, which dives deeper into practical application and exam-level tasks.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Join Study Groups and Online Communities<\/strong><\/h3>\n\n\n\n<p>Collaborating with others preparing for the same exam can provide valuable insights and motivation. Join online study groups, forums, or social media communities where candidates share resources, solve problems together, and exchange tips for mastering difficult topics. Platforms like Reddit, LinkedIn groups, or specialized certification forums often host active discussions that can help clarify complex Excel features and introduce new study techniques.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Take Practice Exams Regularly<\/strong><\/h3>\n\n\n\n<p>Practice exams are an essential part of preparing for the MO-201 certification. They help you get familiar with the exam format, question styles, and time constraints. Regularly taking practice tests allows you to assess your progress, identify weak areas, and build confidence. Aim to use practice exams from reputable providers or Microsoft-authorized partners to ensure the quality and relevance of the content. Review your incorrect answers carefully to understand your mistakes and avoid repeating them in the real exam.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Apply What You Learn with Hands-On Practice<\/strong><\/h3>\n\n\n\n<p>The MO-201 exam tests theoretical knowledge and the ability to apply advanced Excel features in practical scenarios. Create your own workbooks to simulate real-world use cases, such as building financial models, designing pivot tables, creating macros, and using advanced functions like XLOOKUP, INDEX\/MATCH, or array formulas. This hands-on experience will reinforce your understanding and make you more comfortable performing tasks under exam conditions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 6: Create a Structured Study Plan and <strong>Review<\/strong><\/strong><\/h3>\n\n\n\n<p>Organize your preparation by setting a realistic timeline and breaking down your study into manageable sections. Allocate specific days to different exam topics, include time for revision and practice exams, and set milestones to track your progress. A well-structured plan helps reduce last-minute stress and ensures you cover all necessary material before exam day.<\/p>\n\n\n\n<p>Focus on revising key concepts, reviewing your notes, and re-taking practice questions. Avoid cramming new information and instead aim to reinforce your understanding of topics you\u2019ve already studied. Ensure you&#8217;re familiar with Excel\u2019s interface and comfortable navigating its features efficiently, as speed and accuracy are crucial during the timed exam.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.skilr.com\/microsoft-excel-expert-excel-and-excel-2019-mo-201-free-practice-test\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-1.jpg\" alt=\"Microsoft Excel Expert (Office 2019)\" class=\"wp-image-971\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-1.jpg 961w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-201-Microsoft-Excel-Expert-Office-2019-1-300x47.jpg 300w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The MO-201 certification is designed for individuals who can proficiently utilize the advanced features of Microsoft Excel 2019. This exam validates the ability to create, manage, and share complex spreadsheets tailored for a wide range of professional and specialized business scenarios. Candidates aiming for the Excel Expert certification are expected to work confidently with the&#8230;<\/p>\n","protected":false},"author":2,"featured_media":966,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[95],"tags":[516,514,370,517,367,368,371,383,364,70,60,365,518,513,515,452],"class_list":["post-961","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","tag-advanced-excel","tag-excel-2019","tag-excel-certification","tag-excel-expert-tutorial","tag-excel-formulas","tag-excel-functions","tag-excel-pivot-tables","tag-excel-training","tag-excel-tutorial","tag-m4f","tag-microsoft-certification","tag-microsoft-excel-expert","tag-microsoft-office","tag-mo-201","tag-mo-201-exam-prep","tag-office-2019"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Exam MO-201: Microsoft Excel Expert (Office 2019) - Skilr Tutorial<\/title>\n<meta name=\"description\" content=\"Master advanced Excel skills with this MO-201: Microsoft Excel Expert (Office 2019) tutorial \u2014 perfect for exam prep and professional growth.\" \/>\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.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam MO-201: Microsoft Excel Expert (Office 2019) - Skilr Tutorial\" \/>\n<meta property=\"og:description\" content=\"Master advanced Excel skills with this MO-201: Microsoft Excel Expert (Office 2019) tutorial \u2014 perfect for exam prep and professional growth.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Skilr Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-27T05:47:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/\",\"name\":\"Exam MO-201: Microsoft Excel Expert (Office 2019) - Skilr Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg\",\"datePublished\":\"2025-05-27T05:47:41+00:00\",\"dateModified\":\"2025-05-27T05:47:42+00:00\",\"description\":\"Master advanced Excel skills with this MO-201: Microsoft Excel Expert (Office 2019) tutorial \u2014 perfect for exam prep and professional growth.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#primaryimage\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg\",\"contentUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg\",\"width\":1000,\"height\":563,\"caption\":\"Exam MO-201: Microsoft Excel Expert (Office 2019)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.skilr.com\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam MO-201: Microsoft Excel Expert (Office 2019)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#website\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/\",\"name\":\"Skilr Tutorial\",\"description\":\"An Initiative By CTI Jabalpur\",\"publisher\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.skilr.com\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#organization\",\"name\":\"Skilr\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg\",\"contentUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg\",\"width\":330,\"height\":134,\"caption\":\"Skilr\"},\"image\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam MO-201: Microsoft Excel Expert (Office 2019) - Skilr Tutorial","description":"Master advanced Excel skills with this MO-201: Microsoft Excel Expert (Office 2019) tutorial \u2014 perfect for exam prep and professional growth.","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.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/","og_locale":"en_US","og_type":"article","og_title":"Exam MO-201: Microsoft Excel Expert (Office 2019) - Skilr Tutorial","og_description":"Master advanced Excel skills with this MO-201: Microsoft Excel Expert (Office 2019) tutorial \u2014 perfect for exam prep and professional growth.","og_url":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/","og_site_name":"Skilr Tutorial","article_modified_time":"2025-05-27T05:47:42+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/","url":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/","name":"Exam MO-201: Microsoft Excel Expert (Office 2019) - Skilr Tutorial","isPartOf":{"@id":"https:\/\/www.skilr.com\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg","datePublished":"2025-05-27T05:47:41+00:00","dateModified":"2025-05-27T05:47:42+00:00","description":"Master advanced Excel skills with this MO-201: Microsoft Excel Expert (Office 2019) tutorial \u2014 perfect for exam prep and professional growth.","breadcrumb":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#primaryimage","url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg","contentUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-101-Microsoft-Word-Expert-Office-2019-5-scaled.jpg","width":1000,"height":563,"caption":"Exam MO-201: Microsoft Excel Expert (Office 2019)"},{"@type":"BreadcrumbList","@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-201-microsoft-excel-expert-office-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skilr.com\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam MO-201: Microsoft Excel Expert (Office 2019)"}]},{"@type":"WebSite","@id":"https:\/\/www.skilr.com\/tutorial\/#website","url":"https:\/\/www.skilr.com\/tutorial\/","name":"Skilr Tutorial","description":"An Initiative By CTI Jabalpur","publisher":{"@id":"https:\/\/www.skilr.com\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skilr.com\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skilr.com\/tutorial\/#organization","name":"Skilr","url":"https:\/\/www.skilr.com\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg","contentUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg","width":330,"height":134,"caption":"Skilr"},"image":{"@id":"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/"}}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/comments?post=961"}],"version-history":[{"count":6,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/961\/revisions"}],"predecessor-version":[{"id":975,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/961\/revisions\/975"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/media\/966"}],"wp:attachment":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/media?parent=961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/categories?post=961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/tags?post=961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}