{"id":894,"date":"2019-07-27T04:45:47","date_gmt":"2019-07-27T04:45:47","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=894"},"modified":"2021-07-31T11:51:32","modified_gmt":"2021-07-31T11:51:32","slug":"excel-matriz-funcoes","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes","title":{"rendered":"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" 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;\">O Excel \u00e9 um aplicativo amplamente usado, pois ajuda a armazenar, analisar, calcular, etc. <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-trim-funcao-nao-trabalhando\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Excel Fun\u00e7\u00e3o<\/strong><\/a> cont\u00e9m muitas fun\u00e7\u00f5es que s\u00e3o usadas para manter e mostrar dados de uma forma apresent\u00e1vel. Matriz \u00e9 uma das fun\u00e7\u00f5es \u00fateis do Excel, \u00e9 uma cole\u00e7\u00e3o de n\u00fameros que s\u00e3o organizados em um n\u00famero de colunas e linhas. A matriz pode conter n\u00fameros complexos, mas n\u00e3o veremos esse n\u00famero.<!--more--><\/p>\n<p style=\"text-align: justify;\">Neste tutorial, voc\u00ea obter\u00e1 informa\u00e7\u00f5es completas sobre o que \u00e9 a <strong>Matrix Fun\u00e7\u00e3o<\/strong>? Seus tipos, como criar uma matriz e muito mais. Ent\u00e3o, prepare-se para aprender algo novo hoje.<\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><strong>O que \u00e9 Matrix Fun\u00e7\u00e3o?<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">U matriz fun\u00e7\u00e3o\u00a0 uma matriz de elementos retangulares, dispostos em colunas e linhas, que s\u00e3o usados para mostrar a coloca\u00e7\u00e3o dos conceitos juntamente com dois eixos. Tomemos por exemplo, que voc\u00ea pode fazer uso de uma matriz para demonstrar quatro combina\u00e7\u00f5es de dois conceitos. Fazendo uso de um SmartArt gr\u00e1fico no Excel voc\u00ea ser\u00e1 capaz de criar uma matriz que voc\u00ea pode inclu\u00ed-lo em sua planilha.<\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><strong>Tipos do Matriz Fun\u00e7\u00f5es<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"># 1: MINVERSO Fun\u00e7\u00e3o<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">O MINVERSO Matriz fun\u00e7\u00e3o significa que retorna o inverso da matriz de uma determinada f\u00f3rmula de matriz.<\/p>\n<p style=\"text-align: justify;\">Isso geralmente \u00e9 inserido como fun\u00e7\u00e3o de matriz e, portanto, deve ser inserido pressionando <strong>Ctrl + Shift + Enter<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Nem todas, exceto algumas matrizes quadradas, t\u00eam invers\u00f5es. Para verificar se esses fatos s\u00e3o inversos corretos, voc\u00ea ter\u00e1 que multiplicar duas matrizes juntas.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-896\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/minverse-000.png\" alt=\"MINVERSO Fun\u00e7\u00e3o\" width=\"583\" height=\"220\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/minverse-000.png 583w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/minverse-000-300x113.png 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/p>\n<p style=\"text-align: justify;\">Uma matriz sem invers\u00e3o tem um determinante de zero e \u00e9 dito singular.<\/p>\n<p style=\"text-align: justify;\">Uma matriz quadrada com inverso \u00e9 dita: &#8220;n\u00e3o singular&#8221; ou &#8220;invert\u00edvel&#8221;.<\/p>\n<p style=\"text-align: justify;\">Uma matriz quadrada sem invers\u00e3o \u00e9 dita &#8220;singular&#8221; ou &#8220;n\u00e3o revers\u00edvel&#8221;.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"># 2: MMULT Fun\u00e7\u00e3o<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">O MMULT Matriz fun\u00e7\u00e3o \u00e9 a que retorna o produto das duas matrizes. Para multiplicar duas matrizes, deve haver uma dimens\u00e3o comum nelas. O n\u00famero de colunas em um deve ser igual ao n\u00famero de linhas em outro. Voc\u00ea pode inserir essa fun\u00e7\u00e3o pressionando <strong>Ctrl + Shift + Enter<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-897\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mmult.png\" alt=\"MMULT Fun\u00e7\u00e3o\" width=\"736\" height=\"220\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mmult.png 736w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mmult-300x90.png 300w\" sizes=\"auto, (max-width: 736px) 100vw, 736px\" \/><\/p>\n<p style=\"text-align: justify;\">Por exemplo: Se voc\u00ea multiplicar Matriz A com Matriz B, o resultado n\u00e3o ser\u00e1 o mesmo quando voc\u00ea multiplicar Matriz B com Matriz A.<\/p>\n<p style=\"text-align: center;\"><strong>voc\u00ea tamb\u00e9m pode gostar: <a class=\"row-title\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-trim-funcao-nao-trabalhando\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"\u201cCoisas a fazer quando a fun\u00e7\u00e3o TRIM do Excel n\u00e3o funciona\u201d (Edit)\">Coisas a fazer quando a fun\u00e7\u00e3o TRIM do Excel n\u00e3o funciona<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"># 3: TRANSPOSE Fun\u00e7\u00e3o<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">O TRANSPOSE Matriz fun\u00e7\u00e3o significa que a nova matriz \u00e9 formada por colunas intercambi\u00e1veis e linhas da matriz original. Transpor uma matriz significa converter colunas em linhas e linhas em colunas.<\/p>\n<p style=\"text-align: justify;\">Isso geralmente \u00e9 inserido como fun\u00e7\u00e3o de matriz e, portanto, \u00e9 inserido como <strong>Ctrl + Shift + Enter<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-898\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/transpose-1.png\" alt=\"TRANSPOSE Fun\u00e7\u00e3o\" width=\"531\" height=\"220\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/transpose-1.png 531w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/transpose-1-300x124.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/p>\n<h3><\/h3>\n<h3 style=\"text-align: justify;\"># 4: MDETERM Fun\u00e7\u00e3o<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">O MDETERM Matriz fun\u00e7\u00e3o significa que retorna o determinante da matriz como uma f\u00f3rmula de matriz.<\/p>\n<p style=\"text-align: justify;\">Esta fun\u00e7\u00e3o tem uma precis\u00e3o de apenas 16 d\u00edgitos, de modo que o array singular retorna um resultado que difere de 1E-16.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-899\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mdeterm-1.png\" alt=\"MDETERM Fun\u00e7\u00e3o\" width=\"677\" height=\"237\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mdeterm-1.png 677w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/mdeterm-1-300x105.png 300w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/p>\n<h2><\/h2>\n<h2 style=\"text-align: center;\"><strong>Como fa\u00e7o para criar uma matriz no Excel?<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><u>Para 2016 e mais recente vers\u00e3o:<\/u><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">\u00a0Clique na guia <strong>Inserir<\/strong>, selecione o grupo <strong>Ilustra\u00e7\u00f5es<\/strong> e clique em <strong>SmartArt<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-900\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/smart-art000.png\" alt=\"SmartArt\" width=\"300\" height=\"186\" \/><\/p>\n<ol style=\"text-align: justify;\">\n<li>Escolha uma galeria de gr\u00e1ficos SmartArt, clique em Matriz, clique em um layout de matriz e clique em OK.<\/li>\n<li>Para inserir um texto na matriz, siga as etapas:<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">o Clique em <strong>[Texto]<\/strong> no painel Texto e digite o texto.<\/p>\n<p style=\"text-align: justify;\">o Copie o texto de outro programa, clique em <strong>[Texto]<\/strong> no painel Texto e cole o texto.<\/p>\n<p style=\"text-align: justify;\">Clique em uma caixa no <strong>SmartArt gr\u00e1fico<\/strong> e digite o texto.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><u>Para 2007, 2010 e 2013 vers\u00e3o:<\/u><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">\u00a0Clique na guia <strong>Inserir<\/strong>, selecione o grupo Ilustra\u00e7\u00f5es e clique em <strong>SmartArt<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-901\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/2007.jpg\" alt=\"SmartArt\" width=\"189\" height=\"60\" \/><\/p>\n<ol style=\"text-align: justify;\">\n<li>Escolha uma galeria de <strong>gr\u00e1ficos SmartArt<\/strong>, clique em Matriz, clique em um layout de matriz e clique em <strong>OK<\/strong>.<\/li>\n<li>Para inserir um texto na matriz, siga as etapas:<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">o Clique em <strong>[Texto]<\/strong> no painel Texto e digite o texto.<\/p>\n<p style=\"text-align: justify;\">o Copie o texto de outro programa, clique em <strong>[Texto]<\/strong> no painel Texto e cole o texto.<\/p>\n<p style=\"text-align: justify;\">Clique em uma caixa no SmartArt gr\u00e1fico e digite o texto.<\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><strong>Algumas Coisas Interessantes em Matrix:<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><u>Como mover uma caixa em uma Matrix?<\/u><\/h3>\n<p>&nbsp;<\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique na caixa que voc\u00ea deseja mover e arraste-a para o novo local. OU<\/li>\n<li>Voc\u00ea pode segurar a tecla <strong>CTRL<\/strong> enquanto pressiona as teclas de seta no teclado.<\/li>\n<\/ul>\n<h3><\/h3>\n<h3 style=\"text-align: justify;\"><u>Como escolher um diferente Matriz Layout?<\/u><\/h3>\n<p>&nbsp;<\/p>\n<ol style=\"text-align: justify;\">\n<li>Clique com o bot\u00e3o direito do mouse na matriz que precisa alterar o layout e clique em Alterar layout.<\/li>\n<li>Clique na Matriz e escolha:<\/li>\n<\/ol>\n<ul style=\"text-align: justify;\">\n<li><strong>B\u00e1sica Matriz<\/strong> para mostrar quadrantes inteiros em um.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-902\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/basic.png\" alt=\"B\u00e1sica Matriz\" width=\"214\" height=\"215\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/basic.png 214w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/basic-150x150.png 150w\" sizes=\"auto, (max-width: 214px) 100vw, 214px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Intitulada Matriz<\/strong> para mostrar quatro quadrantes para todo<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-903\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/titled.png\" alt=\"Intitulada Matriz\" width=\"269\" height=\"220\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Grid Matrix <\/strong>para enfatizar o quadrante em vez de componentes inteiros.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-904\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/grid.png\" alt=\"Grid Matrix\" width=\"214\" height=\"215\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/grid.png 214w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/grid-150x150.png 150w\" sizes=\"auto, (max-width: 214px) 100vw, 214px\" \/><\/p>\n<h3><\/h3>\n<h3 style=\"text-align: justify;\"><u>Como aplicar o SmartArt Estilo para a matriz?<\/u><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Um SmartArt estilo \u00e9 composto de v\u00e1rios efeitos como chanfro, estilo de linha ou 3D, que podem ser aplicados a caixas no gr\u00e1fico SmartArt para criar uma apar\u00eancia profissional e exclusiva.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Clique no SmartArt gr\u00e1fico que voc\u00ea deseja fazer altera\u00e7\u00f5es nele.<\/li>\n<li>Nas Ferramentas SmartArt, na guia Design, no grupo Estilos SmartArt, clique no SmartArt Estilo que voc\u00ea quer.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-905\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/change-color.png\" alt=\"SmartArt Estilos\" width=\"384\" height=\"181\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/change-color.png 384w, https:\/\/pt.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;\">Confira mais <strong>SmartArt Estilos<\/strong> clicando no bot\u00e3o Mais Ao executar as etapas acima, voc\u00ea pode aplicar o SmartArt estilo para sua matriz.<\/p>\n<p style=\"text-align: center;\"><strong>voc\u00ea pode ler: <a class=\"row-title\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/fixar-excel-countif-funcao-erros\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"\u201c5 Excel COUNTIF Fun\u00e7\u00e3o Problemas E Conserta\u201d (Edit)\">5 Excel COUNTIF Fun\u00e7\u00e3o Problemas E Conserta<\/a><\/strong><\/p>\n<h3><\/h3>\n<h3 style=\"text-align: justify;\"><u>Como animar a matriz?<\/u><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">\u00a0Se voc\u00ea estiver usando o PowerPoint 2010, poder\u00e1 animar a matriz e enfatizar cada caixa.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Clique na matriz para animar.<\/li>\n<li>Na guia <strong>Anima\u00e7\u00f5es<\/strong>, no grupo <strong>Anima\u00e7\u00f5es<\/strong>, clique em Animar e clique em Um por um.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-906\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/animation.jpg\" alt=\"Anima\u00e7\u00f5es\" width=\"659\" height=\"400\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/animation.jpg 659w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/animation-300x182.jpg 300w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><\/p>\n<p>3. Esses passos ajudar\u00e3o voc\u00ea a animar sua matriz.<\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><strong>Conclus\u00e3o:<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Isso foi tudo sobre Matrix fun\u00e7\u00e3o no Excel. As informa\u00e7\u00f5es mencionadas acima ajudar\u00e3o voc\u00ea a entender o Matrix e us\u00e1-lo.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, se voc\u00ea quiser saber mais sobre o Excel, aprenda <a href=\"http:\/\/www.adexchangecloud.com\/jump\/next.php?r=308135&amp;cb=1564200963627\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Advance Excel guia<\/strong><\/a> para se tornar mais produtivo no Excel.<\/p>\n<p style=\"text-align: justify;\">Espero que tenham gostado deste artigo e ajudaram a obter informa\u00e7\u00f5es sobre Matrix Fun\u00e7\u00e3o. Se voc\u00ea quiser fazer perguntas sobre este artigo, deixe suas perguntas na se\u00e7\u00e3o de coment\u00e1rios.<\/p>\n<p><a href=\"http:\/\/www.adexchangecloud.com\/jump\/next.php?r=308135&amp;cb=1564200963627\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-918\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/Excel_promo_img.jpg\" alt=\"Excel_promo_img\" width=\"650\" height=\"325\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/Excel_promo_img.jpg 650w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/Excel_promo_img-300x150.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>O Excel \u00e9 um aplicativo amplamente usado, pois ajuda a armazenar, analisar, calcular, etc. Excel Fun\u00e7\u00e3o cont\u00e9m muitas fun\u00e7\u00f5es que &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes#more-894\" aria-label=\"Read more about Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":895,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[476,477,482,483,479,480,481],"class_list":["post-894","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-como-criar-matriz","tag-matriz-funcao","tag-matriz-produto","tag-mdeterm-funcao","tag-minverso-funcao","tag-mmult-funcao","tag-transpose-funcao","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es<\/title>\n<meta name=\"description\" content=\"&quot;Confira as informa\u00e7\u00f5es completas sobre a fun\u00e7\u00e3o Matrix diferente, como minverso, mmult, transpose, fun\u00e7\u00e3o mdeterm no Excel&quot;.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es\" \/>\n<meta property=\"og:description\" content=\"&quot;Confira as informa\u00e7\u00f5es completas sobre a fun\u00e7\u00e3o Matrix diferente, como minverso, mmult, transpose, fun\u00e7\u00e3o mdeterm no Excel&quot;.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-27T04:45:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-31T11:51:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/portuguese-excel.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=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es\",\"datePublished\":\"2019-07-27T04:45:47+00:00\",\"dateModified\":\"2021-07-31T11:51:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes\"},\"wordCount\":1030,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/portuguese-excel.png\",\"keywords\":[\"como criar matriz\",\"matriz fun\u00e7\u00e3o\",\"matriz produto\",\"MDETERM fun\u00e7\u00e3o\",\"MINVERSO fun\u00e7\u00e3o\",\"MMULT fun\u00e7\u00e3o\",\"TRANSPOSE fun\u00e7\u00e3o\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes\",\"name\":\"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/portuguese-excel.png\",\"datePublished\":\"2019-07-27T04:45:47+00:00\",\"dateModified\":\"2021-07-31T11:51:32+00:00\",\"description\":\"\\\"Confira as informa\u00e7\u00f5es completas sobre a fun\u00e7\u00e3o Matrix diferente, como minverso, mmult, transpose, fun\u00e7\u00e3o mdeterm no Excel\\\".\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/portuguese-excel.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/portuguese-excel.png\",\"width\":675,\"height\":350,\"caption\":\"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-matriz-funcoes#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es","description":"\"Confira as informa\u00e7\u00f5es completas sobre a fun\u00e7\u00e3o Matrix diferente, como minverso, mmult, transpose, fun\u00e7\u00e3o mdeterm no Excel\".","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:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes","og_locale":"en_US","og_type":"article","og_title":"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es","og_description":"\"Confira as informa\u00e7\u00f5es completas sobre a fun\u00e7\u00e3o Matrix diferente, como minverso, mmult, transpose, fun\u00e7\u00e3o mdeterm no Excel\".","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2019-07-27T04:45:47+00:00","article_modified_time":"2021-07-31T11:51:32+00:00","og_image":[{"width":675,"height":350,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/portuguese-excel.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es","datePublished":"2019-07-27T04:45:47+00:00","dateModified":"2021-07-31T11:51:32+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes"},"wordCount":1030,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/portuguese-excel.png","keywords":["como criar matriz","matriz fun\u00e7\u00e3o","matriz produto","MDETERM fun\u00e7\u00e3o","MINVERSO fun\u00e7\u00e3o","MMULT fun\u00e7\u00e3o","TRANSPOSE fun\u00e7\u00e3o"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes","url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes","name":"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/portuguese-excel.png","datePublished":"2019-07-27T04:45:47+00:00","dateModified":"2021-07-31T11:51:32+00:00","description":"\"Confira as informa\u00e7\u00f5es completas sobre a fun\u00e7\u00e3o Matrix diferente, como minverso, mmult, transpose, fun\u00e7\u00e3o mdeterm no Excel\".","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/portuguese-excel.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/07\/portuguese-excel.png","width":675,"height":350,"caption":"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-matriz-funcoes#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Tudo que voc\u00ea precisa saber sobre Excel Matriz Fun\u00e7\u00f5es"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=894"}],"version-history":[{"count":4,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/894\/revisions"}],"predecessor-version":[{"id":3442,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/894\/revisions\/3442"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/895"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}