{"id":2446,"date":"2024-01-09T06:04:21","date_gmt":"2024-01-09T06:04:21","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=2446"},"modified":"2024-01-09T09:47:08","modified_gmt":"2024-01-09T09:47:08","slug":"excel-matrix-functions","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions","title":{"rendered":"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">MS Excel is a powerhouse in spreadsheet software and isn&#8217;t just about tables &amp; charts. It has a range of innovative features, and among them, <strong>Excel matrix functions<\/strong> stand out for their expertise in data analysis. Matrix is one of the handy functions in Excel, it is a collection of numbers that are arranged into several columns and rows. Well, in this blog, we will delve into the world of matrix functions, practical uses, and how to create a matrix in Excel.<\/p>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<p>So, let\u2019s get started\u2026<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To repair corrupt Excel file, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h3 style=\"text-align: left;\"><strong>Quick Navigation:<\/strong><\/h3>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<ul>\n<li><strong><a href=\"#p1\">Part 1- What is Matrix Function in Excel?<\/a><\/strong><\/li>\n<li><strong><a href=\"#p2\">Part 2- What Are the Advantages of Using Matrix?<\/a><\/strong><\/li>\n<li><strong><a href=\"#p3\">Part 3- Types of Matrix Functions<\/a><\/strong><\/li>\n<li><strong><a href=\"#p4\">Part 4- How to Create a Matrix in Excel Easily?<\/a><\/strong><\/li>\n<li><strong><a href=\"#p5\">Part 5- How Do You Insert a Data Matrix in Excel?<\/a><\/strong><\/li>\n<\/ul>\n<\/div><\/div>\n<p><a name=\"p1\"><\/a><\/p>\n<h2><strong>What is Matrix Function in Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">A matrix function is a square or rectangular-shaped array of elements, that are arranged in columns and rows, that are used to show the placement of the concepts along with two axes. Excel offers useful templates, using which you can build your matrices according to your professional needs. In simple words, <strong>Matrix<\/strong> could contain complex numbers however we won&#8217;t see those numbers.<\/p>\n<p style=\"text-align: justify;\">For example, you can make use of a matrix to demonstrate four combinations of two concepts. By making use of a SmartArt graphic in Excel you will be able to create a matrix that you can include in your spreadsheet.<\/p>\n<p><a name=\"p2\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>What Are the Advantages of Using Matrix?<\/strong><\/h2>\n<p>In Excel, using matrices can offer numerous advantages, especially when dealing with large data sets and performing complex calculations. Here\u2019re some key advantages:<\/p>\n<ol>\n<li style=\"text-align: left;\"><strong>Data Manipulation:<\/strong> MS Excel offers various matrix functions &amp; tools that allow you to perform several operations on matrices efficiently, such as multiplying, transposing, etc.<\/li>\n<li style=\"text-align: left;\"><strong>Organized Data:<\/strong> Matrices offer a structured way to organize the rows &amp; columns in the spreadsheet, making it easier to understand.<\/li>\n<li style=\"text-align: left;\"><strong>Array Formulas:<\/strong> Matrix functions are often used with array formulas, allowing one to perform calculations on multiple items in an array.<\/li>\n<li style=\"text-align: left;\"><strong>Visual Representation:<\/strong> Microsoft Excel lets you visually represent matrices via conditional formatting &amp; data visualization tools.<\/li>\n<li style=\"text-align: left;\"><strong>Data Analysis:<\/strong> These Excel functions are vital for various data analysis techniques, including algebra operations.<\/li>\n<li style=\"text-align: left;\"><strong>Integration with Other Features:<\/strong> Matrices in Excel can be integrated easily with other features such as charts, Power Query, and pivot tables.<\/li>\n<\/ol>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/use-excel-iserror-function\">Unlock Excel Secrets: ISERROR Function in Excel Revealed for Beginners<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"p3\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>Types of Matrix Functions<\/strong><\/h2>\n<h3 style=\"text-align: left;\"><strong>1- MINVERSE Function in Excel<\/strong><\/h3>\n<p style=\"text-align: justify;\">The MINVERSE Matrix function means that it returns the inverse of the matrix of a given array formula. This is generally entered as an array function and so it must be entered by pressing <strong>Ctrl + Shift + Enter.<\/strong><br \/>\nNot all but some Square matrices have inverses. To verify that these facts are correct inverses you will have to multiply two matrices together.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2447 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/minverse.png\" alt=\"Excel Matrix Functions\" width=\"583\" height=\"220\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/minverse.png 583w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/minverse-300x113.png 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><br \/>\nA matrix with no inverse has a determinant of zero in it and it is said singular.<br \/>\nA square matrix with an inverse is said: &#8220;<strong>nonsingular<\/strong>&#8221; or &#8220;<strong>invertible<\/strong>&#8220;.<br \/>\nA square matrix with no inverse is said &#8220;<strong>singular<\/strong>&#8221; or &#8220;<strong>noninvertible<\/strong>&#8220;.<\/p>\n<h3 style=\"text-align: left;\"><strong>2- MMULT Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">The MMULT Matrix function is the one that returns the product of the two matrices. To multiply two matrices together there must be a common dimension in them. The number of columns in one should be equal to the number of rows in another. You can enter this function by pressing <strong>Ctrl + Shift + Enter.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2448\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mmult.png\" alt=\"\" width=\"736\" height=\"220\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mmult.png 736w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mmult-300x90.png 300w\" sizes=\"auto, (max-width: 736px) 100vw, 736px\" \/><\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>For example<\/strong><\/span>: If you multiply Matrix A with Matrix B the result will not be the same as when you multiply Matrix B with Matrix A.<\/p>\n<\/div><\/div>\n<h3 style=\"text-align: left;\"><strong>3- TRANSPOSE Excel Matrix Functions<\/strong><\/h3>\n<p style=\"text-align: justify;\">The TRANSPOSE Matrix function means that the new matrix is formed by interchanging columns and rows of the original matrix. Transposing of an array means converting columns into rows and rows into columns.<br \/>\nThis is generally entered as an array function and is thus entered as <strong>Ctrl + Shift + Enter<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2449 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/transpose-1.png\" alt=\"TRANSPOSE Function\" width=\"531\" height=\"220\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/transpose-1.png 531w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/transpose-1-300x124.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/p>\n<h3 style=\"text-align: left;\"><strong>4- MDETERM Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">The MDETERM Matrix function means that it returns the matrix determinant as an array formula. This function has an accuracy of only 16 digits so that a singular array returns a result that differs by 1E-16.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2451\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mdeterm.png\" alt=\"\" width=\"129\" height=\"93\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2450\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mdeterm-1.png\" alt=\"\" width=\"677\" height=\"237\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mdeterm-1.png 677w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mdeterm-1-300x105.png 300w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/underused-excel-functions\">7 Most Underrated Excel Functions You Must Try<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"p4\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>How to Create a Matrix in Excel Easily?<\/strong><\/h2>\n<p>Follow the below steps to create matrix in Excel:<\/p>\n<h3 style=\"text-align: justify;\"><strong>For 2016 and later versions:<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>Step 1-<\/strong> Click on <strong>Insert<\/strong> tab &gt;&gt; Select<strong> Illustrations<\/strong>\u00a0group and click\u00a0on <strong>SmartArt<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7796 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/SmartArt-Graphic-Command.png\" alt=\"How to Create a Matrix in Excel \" width=\"712\" height=\"191\" \/><\/p>\n<p>&nbsp;<\/p>\n<ol style=\"text-align: justify;\">\n<li>Choose a <strong>SmartArt Graphic\u00a0<\/strong>gallery, click\u00a0on <strong>Matrix<\/strong>, then click on a matrix layout and click\u00a0<strong>OK<\/strong>.<\/li>\n<li>To enter a text in the matrix, follow the steps:\n<ul>\n<li>Click\u00a0on <strong>[Text]<\/strong>\u00a0in Text pane and type the text.<\/li>\n<li>Copy the text from another program, click\u00a0on <strong>[Text]<\/strong>\u00a0in Text pane, and paste the text.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>Step 2-<\/strong> Click on a box in SmartArt graphic, and type the text.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7797 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/type-text.png\" alt=\"SmartArt graphic\" width=\"504\" height=\"302\" \/><\/p>\n<h3 style=\"text-align: left;\"><strong>For 2007, 2010 &amp; 2013 version:<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>Step 1-<\/strong> Click on <strong>Insert<\/strong> tab &gt;&gt; Select<strong> Illustrations<\/strong>\u00a0group and click\u00a0on <strong>SmartArt<\/strong>.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Choose a <strong>SmartArt Graphic\u00a0<\/strong>gallery, click\u00a0on <strong>Matrix<\/strong>, then click on a matrix layout and click\u00a0<strong>OK<\/strong>.<\/li>\n<li>To enter a text in the matrix, follow the steps:\n<ul>\n<li>Click\u00a0on <strong>[Text]<\/strong>\u00a0in Text pane and type the text.<\/li>\n<li>Copy the text from another program, click\u00a0on <strong>[Text]<\/strong>\u00a0in Text pane, and paste the text.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>Step 2-<\/strong> Click on a box in SmartArt graphic, and type the text.<\/p>\n<p style=\"text-align: justify;\"><strong> <img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7799 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/shape2-1.png\" alt=\"Excel Matrix Functions\" width=\"460\" height=\"313\" \/><\/strong><\/p>\n<p><a name=\"p5\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>How Do You Insert a Data Matrix in Excel?<\/strong><\/h2>\n<h3 style=\"text-align: left;\"><strong>How to Choose a Different Matrix Layout?<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li>Right-click on the matrix that needs to change the layout, and clicks on <strong>Change Layout<\/strong>.<\/li>\n<li>Click\u00a0on the <strong>Matrix<\/strong>, and choose:<\/li>\n<\/ol>\n<ul>\n<li style=\"text-align: justify;\"><strong>Basic Matrix<\/strong> to show whole quadrants in one.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2455\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/basic.png\" alt=\"\" width=\"214\" height=\"215\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/basic.png 214w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/basic-150x150.png 150w\" sizes=\"auto, (max-width: 214px) 100vw, 214px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>Titled Matrix <\/strong>to show four quadrants to the whole<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2456\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/titled.png\" alt=\"\" width=\"269\" height=\"220\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>Grid Matrix<\/strong> to emphasizes the quadrant instead of whole components<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2457\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/grid.png\" alt=\"\" width=\"214\" height=\"215\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/grid.png 214w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/grid-150x150.png 150w\" sizes=\"auto, (max-width: 214px) 100vw, 214px\" \/><\/p>\n<h3 style=\"text-align: left;\"><strong>Easy Steps- How to Move a Box in a Matrix?<\/strong><\/h3>\n<ul style=\"text-align: justify;\">\n<li>Click on the box that you want to move and drag it to the new location. <strong>OR<\/strong><\/li>\n<li>You can hold the <strong>CTRL<\/strong> key while pressing the arrow keys on the keyboard.<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>How to Apply SmartArt Style to the Matrix?<\/strong><\/h3>\n<p style=\"text-align: justify;\">A SmartArt Style comprises various effects like bevel, line style, or 3-D, that can apply to boxes in the SmartArt graphic for creating a professional and unique design look.<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Click on the SmartArt graphic that you want to make changes to it.<\/li>\n<li style=\"text-align: left;\">Under\u00a0the <strong>SmartArt Tools<\/strong>, on the <strong>Design<\/strong>\u00a0tab, in\u00a0<strong>SmartArt Styles<\/strong>\u00a0group, click on the SmartArt Style you want.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2454\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/change-color.png\" alt=\"\" width=\"384\" height=\"181\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/change-color.png 384w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/change-color-300x141.png 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/p>\n<p style=\"text-align: justify;\">3. Check out more SmartArt Styles by clicking on <strong>More<\/strong> button.<\/p>\n<p style=\"text-align: justify;\">By doing the above steps you can apply SmartArt style to your matrix.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/hlookup-vs-vlookup\">HLOOKUP Vs VLOOKUP: Clear Contrast Between Excel Lookup Functions<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is Matrix Used For?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tMatric functions are useful for describing differential equations or systems of linear, as well as representing the linear application in spreadsheet.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Can Excel Solve Matrices?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf are working with the linear equations, then you can quickly solve it by using Excel Matrix formulas.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What is the Formula for TRANSPOSE?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\t<strong>=TRANSPOSE(array)<\/strong> is the formula for TRANSPOSE function.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is an Example of Mmult in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe MMULT function in Excel takes 2 arguments, one is array1 and another is array2, both of are essential. For instance, you can multiply a <strong>2 x 3<\/strong> array by a <strong>3 x 2<\/strong> array to get a 2 x 2 array result.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is the Shortcut for Transpose in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tAfter copying the content, you can use paste special transpose shortcut: Ctrl + Alt + V.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is Matrix Used For?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Matric functions are useful for describing differential equations or systems of linear, as well as representing the linear application in spreadsheet.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Can Excel Solve Matrices?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If are working with the linear equations, then you can quickly solve it by using Excel Matrix formulas.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What is the Formula for TRANSPOSE?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<strong>=TRANSPOSE(array)<\/strong> is the formula for TRANSPOSE function.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is an Example of Mmult in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The MMULT function in Excel takes 2 arguments, one is array1 and another is array2, both of are essential. For instance, you can multiply a <strong>2 x 3<\/strong> array by a <strong>3 x 2<\/strong> array to get a 2 x 2 array result.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is the Shortcut for Transpose in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"After copying the content, you can use paste special transpose shortcut: Ctrl + Alt + V.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Wrapping Up<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>Excel matrix functions<\/strong> are daunting tools for anyone dealing with data analysis. But from now on, using matrices is not such a difficult task. By navigating this article, you can perform complex calculations more efficiently. So, explore and implement these functions in your worksheet to unlock the true potential of Microsoft Excel.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/minverse-function-11f55086-adde-4c9f-8eb9-59da2d72efc6\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/minverse-function-11f55086-adde-4c9f-8eb9-59da2d72efc6<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/mmult-function-40593ed7-a3cd-4b6b-b9a3-e4ad3c7245eb\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/mmult-function-40593ed7-a3cd-4b6b-b9a3-e4ad3c7245eb<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>MS Excel is a powerhouse in spreadsheet software and isn&#8217;t just about tables &amp; charts. It has a range of &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#more-2446\" aria-label=\"Read more about Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":2464,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[1614,1616,1615],"class_list":["post-2446","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-excel-matrix-functions","tag-matrix-function-in-microsoft-excel","tag-matrix-functions-in-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?<\/title>\n<meta name=\"description\" content=\"Explore the efficiency of Excel matrix functions for streamlining your spreadsheet data. Also, learn how to create a matrix in Excel easily.\" \/>\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.repairmsexcel.com\/blog\/excel-matrix-functions\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?\" \/>\n<meta property=\"og:description\" content=\"Explore the efficiency of Excel matrix functions for streamlining your spreadsheet data. Also, learn how to create a matrix in Excel easily.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-09T06:04:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-09T09:47:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png\" \/>\n\t<meta property=\"og:image:width\" content=\"675\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?\",\"datePublished\":\"2024-01-09T06:04:21+00:00\",\"dateModified\":\"2024-01-09T09:47:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions\"},\"wordCount\":1394,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png\",\"keywords\":[\"Excel matrix functions\",\"matrix function in Microsoft Excel\",\"matrix functions in Excel\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions\",\"name\":\"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png\",\"datePublished\":\"2024-01-09T06:04:21+00:00\",\"dateModified\":\"2024-01-09T09:47:08+00:00\",\"description\":\"Explore the efficiency of Excel matrix functions for streamlining your spreadsheet data. Also, learn how to create a matrix in Excel easily.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png\",\"width\":675,\"height\":350,\"caption\":\"excel matrix functions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?","description":"Explore the efficiency of Excel matrix functions for streamlining your spreadsheet data. Also, learn how to create a matrix in Excel easily.","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.repairmsexcel.com\/blog\/excel-matrix-functions","og_locale":"en_US","og_type":"article","og_title":"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?","og_description":"Explore the efficiency of Excel matrix functions for streamlining your spreadsheet data. Also, learn how to create a matrix in Excel easily.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions","og_site_name":"Excel File Repair Blog","article_published_time":"2024-01-09T06:04:21+00:00","article_modified_time":"2024-01-09T09:47:08+00:00","og_image":[{"width":675,"height":350,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?","datePublished":"2024-01-09T06:04:21+00:00","dateModified":"2024-01-09T09:47:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions"},"wordCount":1394,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png","keywords":["Excel matrix functions","matrix function in Microsoft Excel","matrix functions in Excel"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions","url":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions","name":"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png","datePublished":"2024-01-09T06:04:21+00:00","dateModified":"2024-01-09T09:47:08+00:00","description":"Explore the efficiency of Excel matrix functions for streamlining your spreadsheet data. Also, learn how to create a matrix in Excel easily.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/excel-matrixs.png","width":675,"height":350,"caption":"excel matrix functions"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-matrix-functions#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Excel Matrix Functions- How to Create a Matrix in Excel Like a Pro?"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=2446"}],"version-history":[{"count":7,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2446\/revisions"}],"predecessor-version":[{"id":7803,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2446\/revisions\/7803"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/2464"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=2446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=2446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=2446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}