{"id":1709,"date":"2024-01-04T08:48:21","date_gmt":"2024-01-04T07:48:21","guid":{"rendered":"https:\/\/www.educapharos.com\/?p=1709"},"modified":"2024-01-03T09:07:26","modified_gmt":"2024-01-03T08:07:26","slug":"how-to-create-an-excel-table-a-step-by-step-guide","status":"publish","type":"post","link":"https:\/\/educapharos.com\/en\/blog\/recursos-laborales\/como-hacer-una-tabla-de-excel-guia-paso-a-paso\/","title":{"rendered":"How to Create an Excel Table: A Step-by-Step Guide"},"content":{"rendered":"<p><strong>Excel<\/strong> It is the go-to tool for everything related to the a<strong>Business administration, human resources, and records management.<\/strong> The reality is that its popularity is growing. Currently, many jobs require varying levels of Excel proficiency.<\/p>\n<p>That is why it is essential that we learn everything from the basics to the most advanced concepts, starting with <strong>How to Create an Excel Table<\/strong>. Do you think it might be a challenge? The truth is, if you follow this step-by-step guide, you'll be able to do it easily and simply.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Contents\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/educapharos.com\/en\/blog\/recursos-laborales\/como-hacer-una-tabla-de-excel-guia-paso-a-paso\/#%C2%BFQue_es_una_tabla_Excel\" >What is an Excel table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/educapharos.com\/en\/blog\/recursos-laborales\/como-hacer-una-tabla-de-excel-guia-paso-a-paso\/#%C2%BFQue_debemos_considerar\" >What should we consider?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/educapharos.com\/en\/blog\/recursos-laborales\/como-hacer-una-tabla-de-excel-guia-paso-a-paso\/#Primeros_pasos\" >Getting Started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/educapharos.com\/en\/blog\/recursos-laborales\/como-hacer-una-tabla-de-excel-guia-paso-a-paso\/#Haciendo_una_tabla_con_estilo\" >Creating a Stylish Table<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/educapharos.com\/en\/blog\/recursos-laborales\/como-hacer-una-tabla-de-excel-guia-paso-a-paso\/#Eliminado_el_estilo\" >Style removed<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/educapharos.com\/en\/blog\/recursos-laborales\/como-hacer-una-tabla-de-excel-guia-paso-a-paso\/#%C2%BFComo_ordenar_y_filtrar_en_una_tabla_Excel\" >How do you sort and filter a table in Excel?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/educapharos.com\/en\/blog\/recursos-laborales\/como-hacer-una-tabla-de-excel-guia-paso-a-paso\/#Anade_los_datos\" >Add the data<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%C2%BFQue_es_una_tabla_Excel\"><\/span><strong>What is an Excel table?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we start creating our table, it\u2019s essential to understand that a table is not just a range of structured data, cells containing elements, or a different type of visualization, as many people think. The reality is that it goes far beyond that\u2014it\u2019s not just about cells with organized data; it\u2019s nothing less than <strong>A Special Object<\/strong>, which is created using Excel commands.<\/p>\n<p>An example would be to use the <strong>\u201cTable\u201d command\u201d<\/strong> which is available at the <strong>\u201cInsert\u201d section\u201d<\/strong> which is part of the table group. That said, we should mention that this is indeed a special format that organizes a range of cells, and the best part is that it applies filters to the columns you've chosen to convert into a <strong>Excel table<\/strong>l.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%C2%BFQue_debemos_considerar\"><\/span><strong>What should we consider?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Of course, before<strong> Learn how to create an income and expense spreadsheet in Excel<\/strong>, it's essential that we keep a few important points in mind. These tips will be a huge help, especially if you have little or no experience with this program:<\/p>\n<ul>\n<li>The data must be organized into rows and columns as appropriate.<\/li>\n<li>Leave the first row blank to add a label. For example, if you need to keep track of expenses and income, you can write \u201cIncome\u201d in the first row of the column and \u201cExpenses\u201d next to it.\u201d<\/li>\n<li>It's recommended that each column have the same data type; this will help you avoid confusion. For example, if you labeled a column \u201cExpenses,\u201d use it only for expense data.<\/li>\n<li>Try to avoid having rows or columns with blank cells.<\/li>\n<\/ul>\n<p>If you've already verified that you meet all these requirements, then you're ready to get started.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Primeros_pasos\"><\/span><strong>Getting Started<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The first step is to learn how to create the table directly. To do this, select any cell within the data range and click the \u201cInsert\u201d command that appears at the top. Then go to \u201cTable\u201d and immediately<strong> Excel<\/strong> It will recognize the data or content you've added and classify it as a table. Of course, there are cases where, due to errors in the content, Excel won't recognize the data you've added, so you'll need to roll up your sleeves and fix any empty spaces or content issues you have.<\/p>\n<p>Another thing to note is that when the program detects a row of headers in the data you added, an option will appear telling you that the table has those headers. This way, you'll <strong>will streamline the process<\/strong>, which is a convenient advantage; that's why we've mentioned that you should add that content.<\/p>\n<p>Once this final message appears, all you have to do is click \u201cOK,\u201d and that's it! You'll now have your<strong> Excel spreadsheet.<\/strong> To wrap up this point, we'd like to note that the program will likely apply a specific table style, which you can modify.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Haciendo_una_tabla_con_estilo\"><\/span><strong>Creating a Stylish Table<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you've already tried the default style we mentioned earlier and want to change it or improve its design, then this section is for you. You can create<strong> a table with the style<\/strong> that you want, making any necessary adjustments.<\/p>\n<p>However, for this we\u2019re going to use a different button. The thing is, just like before, you need to enter the relevant data, go to the \u201cInsert\u201d tab, but this time, you need to go to the \u201cStyle\u201d group and click the \u201cFormat as Table\u201d button that appears.<\/p>\n<p>If you've done it right, you'll see a menu or section with the <strong>styles that are available.<\/strong> All you have to do is choose the one you like best. Once you've selected your favorite, click the \"Accept\" button, and the table will automatically be added with the desired style.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Eliminado_el_estilo\"><\/span><strong>Style removed<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you'd like to <strong>remove the style,<\/strong> But if you want to keep the features that are added to the table, then you should do the following: Go to \u201cTable\u201d and then to the \u201cTable Tools\u201d section.<\/p>\n<p>There you'll find the design section; when you click on it, the table styles will appear. Here, you'll need to select the \"Delete\" option at the bottom of the menu. If you followed the steps correctly, you'll see that the design has been removed, but the features it provides are still intact.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%C2%BFComo_ordenar_y_filtrar_en_una_tabla_Excel\"><\/span><strong>How do you sort and filter a table in Excel?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Well, now that we know all about <strong>How to Create an Excel Table<\/strong>, it's important that we take it a step further and learn how to use the filter to sort numbers, names, and any other relevant data. To do this, follow these steps:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Anade_los_datos\"><\/span><strong>Add the data<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Remember that the first step is to add the<strong> the data you want to filter.<\/strong> To do this, you'll need to add a header or name for each column in the first row. Once you've done that, you'll know which items you're filtering and what each data point corresponds to.<\/p>\n<p>Select all the headers you want to filter, then right-click; a menu will appear with several options, including one that says: <strong>\u201cFilter.\u201d.<\/strong> Now you must select the value you want to filter by; the following options appear:<\/p>\n<ul>\n<li>Filter by value<\/li>\n<li>By Cell Color<\/li>\n<li>Font Color<\/li>\n<li>Filter by icon<\/li>\n<\/ul>\n<p>Click the option that applies to your situation. This option <strong>It will allow you to sort the data or numbers you've added in ascending or descending order.<\/strong> It's worth noting that all the filtering options available allow us to create or apply specific criteria that meet our needs in the table.<\/p>\n<p>My recommendation here is that you try the ones you think are best and keep adjusting until you find the one that really works for you.<\/p>","protected":false},"excerpt":{"rendered":"<p>Excel es la herramienta por excelencia en todo lo que tiene que ver la administraci\u00f3n empresarial, personal y gesti\u00f3n de archivos. La realidad es que su popularidad cada vez es m\u00e1s grane. Actualmente, muchos puestos de trabajo requieren distintos niveles de manejos de Excel. Es por eso que es fundamental que aprendamos desde lo m\u00e1s [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":1710,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[12],"tags":[],"class_list":["post-1709","post","type-post","status-publish","format-standard","has-post-thumbnail","category-recursos-laborales"],"acf":[],"_links":{"self":[{"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/posts\/1709","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/comments?post=1709"}],"version-history":[{"count":1,"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/posts\/1709\/revisions"}],"predecessor-version":[{"id":1711,"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/posts\/1709\/revisions\/1711"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/media\/1710"}],"wp:attachment":[{"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/media?parent=1709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/categories?post=1709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/educapharos.com\/en\/wp-json\/wp\/v2\/tags?post=1709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}