{"id":822,"date":"2019-06-08T11:50:04","date_gmt":"2019-06-08T11:50:04","guid":{"rendered":"http:\/\/blog.eticsolutions.ro\/?p=822"},"modified":"2020-01-20T07:01:19","modified_gmt":"2020-01-20T07:01:19","slug":"cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste","status":"publish","type":"post","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/","title":{"rendered":"Cursuri Excel gratuite &#8211; Format as table, cum se realizeaza si la ce foloseste?"},"content":{"rendered":"<p>Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016.<\/p>\n<p>Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea <strong>Format as Table<\/strong> din meniul <strong>Home <\/strong>ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date, unde:<\/p>\n<ul>\n<li>Primul rand (capul de tabel) reprezinta caracteristicile bazei de date<\/li>\n<li>Fiecare rand (de dupa capul de tabel) reprezinta articole ale bazei de date, care pentru fiecare caracteristica (reprezentata de capul de tabel din coloana respectiva) are o anumita valoare \u2013 aceasta valoare poate fi si <strong>blank<\/strong>.<\/li>\n<li>Baza de date se termina acolo unde apare primul rand gol sau prima coloana goala<\/li>\n<\/ul>\n<p>Se da un tabel cu incasari pe anumite categorii de activitati.<\/p>\n<p><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-817 aligncenter\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd.png\" alt=\"08.07_Excel 2013_format as table_bd\" width=\"602\" height=\"469\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd.png 602w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd-300x234.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd-100x78.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd-150x117.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd-200x156.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd-450x351.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table_bd-600x467.png 600w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><\/p>\n<p>Pozitionati cursorul in stanga sus a tabelului (pe prima eticheta de coloana, din celula A1) si apasati \u00a0<strong>Format as Table <\/strong>din tab-ul <strong>Home.<\/strong><\/p>\n<p>Alegeti un format de afisare si dati click pe acesta.<\/p>\n<figure id=\"attachment_816\" aria-describedby=\"caption-attachment-816\" style=\"width: 305px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-816\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table.png\" alt=\"Excel 2013_Format as table_choose style\" width=\"305\" height=\"398\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table.png 238w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-230x300.png 230w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-100x130.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-150x195.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-200x261.png 200w\" sizes=\"auto, (max-width: 305px) 100vw, 305px\" \/><\/a><figcaption id=\"caption-attachment-816\" class=\"wp-caption-text\"><em><strong>Excel 2013_Format as table_choose style<\/strong><\/em><\/figcaption><\/figure>\n<p>In urmatoarea fereastra de dialog, observati ca au fost automat selectate toate randurile din tabel. Bifati optiunea <strong>My Table has headers<\/strong>.<a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-dialog-window.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-821 aligncenter\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-dialog-window.png\" alt=\"08.07_Excel 2013_format as table dialog window\" width=\"234\" height=\"147\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-dialog-window.png 234w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-dialog-window-100x63.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-dialog-window-150x94.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table-dialog-window-200x126.png 200w\" sizes=\"auto, (max-width: 234px) 100vw, 234px\" \/><\/a><\/p>\n<p>Observati ca pe bara de meniu a aparut meniul dinamic <strong>Table Tools<\/strong>, cu submeniul <strong>Design.<\/strong><\/p>\n<p>Din sectiunea Properties putem redenumi tabelul, astfel incat sa ne poata fi mai usor sa facem referire la el. Automat, in momentul definirii unui grup de celule ca tabel, acestuia i se va atribui un nume de tipul Table1,2\u2026.., in ordine, in functie de cate tabele au mai fost definite in fisierul respectiv.<\/p>\n<p>Pentru acest exemplu, am redenumit tabelul <strong>facturi<\/strong><strong>.<\/strong><\/p>\n<figure id=\"attachment_819\" aria-describedby=\"caption-attachment-819\" style=\"width: 536px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_optiuni-de-sinteza-table-excel-2013.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-819\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_optiuni-de-sinteza-table-excel-2013.png\" alt=\"Optiuni de sinteza tabel -Excel 2013\" width=\"536\" height=\"204\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_optiuni-de-sinteza-table-excel-2013.png 536w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_optiuni-de-sinteza-table-excel-2013-300x114.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_optiuni-de-sinteza-table-excel-2013-100x38.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_optiuni-de-sinteza-table-excel-2013-150x57.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_optiuni-de-sinteza-table-excel-2013-200x76.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_optiuni-de-sinteza-table-excel-2013-450x171.png 450w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/a><figcaption id=\"caption-attachment-819\" class=\"wp-caption-text\"><strong><em>Optiuni de sinteza tabel -Excel 2013<\/em><\/strong><\/figcaption><\/figure>\n<p>In ribbon-ul Table Style Options putem bifa sau debifa diferite optiuni, printre care unele de sintetizare a informatiilor (vezi imaginea de mai sus). Daca, de exemplu bifam optiunea Total Row, va aparea automat la finalul tabelului un rand de total. Pentru fiecare coloana putem alege (dand click pe sageata) tipul de sintetizare dorit (suma, medie, maxim, minim, etc.)<\/p>\n<p>Celelalte optiuni disponibile in ribbon-ul Table Style Options sunt doar de formatare.<\/p>\n<p>Daca dorim sa introducem noi inregistrari in tabel, pozitionam cursorul in ultima celula din dreapta a tabelului &#8211; deasupra randului de total &#8211; (se observa ca apare marcata vizibil\u00a0\u00a0 si apasam de pe tastatura butonul Tab) pentru a deschide o noua inregistrare in tabel. Aceasta va fi luata in considerare si se vor reactualiza totalurile de pe ultimul rand.<\/p>\n<p><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_insert-new-article-table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-818\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_insert-new-article-table.png\" alt=\"08.07_insert new article table\" width=\"171\" height=\"42\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_insert-new-article-table.png 171w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_insert-new-article-table-100x25.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_insert-new-article-table-150x37.png 150w\" sizes=\"auto, (max-width: 171px) 100vw, 171px\" \/><\/a><\/p>\n<p>Daca vrem sa redefinim intervalul de referinta al tabelului, este suficient sa \u201ctragem\u201dcu mouse-ul din coltul din dreapta jos, cuprinzand si celulele care vrem sa faca parte din tabel.<\/p>\n<p>Cealalta varianta este optiunea <strong>Resize table<\/strong> din sectiunea <strong>Properties<\/strong>.<\/p>\n<p>In momentul in care introducem o formula intr-o anumita coloana, se va completa automat toata coloana atunci cand apasam Enter.<\/p>\n<p>Referinta la celulele care fac parte din tabel s-a modificat.<\/p>\n<p>Sa presupunem ca vrem sa introducem o noua coloana, denumita <strong>An factura, <\/strong>pozitionata imediat dupa <strong>Data factura<\/strong>.<\/p>\n<p>Selectati coloana <strong>Moneda contract<\/strong>, dati click dreapta si apasati <strong>Insert.<\/strong> Tabelul a fost redimensionat automat, astfel incat sa includa si aceasta celula.<\/p>\n<p>In celula D2, utilizati functia YEAR pentru a extrage anul facturii.<\/p>\n<p>Formula va arata astfel:<\/p>\n<p><span style=\"color: #800000;\"><strong>=YEAR([@[DATA FACTURA]])<\/strong><\/span><\/p>\n<p>unde [@[DATA FACTURA]] reprezinta valoarea campului (caracteristicii) <strong>DATA FACTURA<\/strong> de pe randul curent.<\/p>\n<p><span style=\"color: #800000;\"><strong>Realizarea si actualizarea unui Pivot Table<\/strong><\/span><\/p>\n<p>Atunci cand datele au fost organizate ca table, utilizand Format as table, <strong>NU<\/strong> mai este nevoie sa redimensionati pivotul de fiecare data cand adaugati noi intrari in baza de date (ca mai sus).<\/p>\n<p>Observati ca atunci cand apasati Insert -&gt; Pivot Table, referinta la date va arata astfel:<\/p>\n<figure id=\"attachment_820\" aria-describedby=\"caption-attachment-820\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_pivot-din-table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-820\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_pivot-din-table.png\" alt=\"Insert Pivot Table - Excel 2013\" width=\"400\" height=\"332\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_pivot-din-table.png 400w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_pivot-din-table-300x249.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_pivot-din-table-100x83.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_pivot-din-table-150x125.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_pivot-din-table-200x166.png 200w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/a><figcaption id=\"caption-attachment-820\" class=\"wp-caption-text\">Insert Pivot Table &#8211; Excel 2013<\/figcaption><\/figure>\n<p>In fine, pentru utilizatorii experimentati, \u201ctransformarea\u201d datelor in <strong>baza de date<\/strong>, utilizand optiunea <strong>Format as Table<\/strong> este obligatorie daca vor sa utilizeze <span style=\"color: #800000;\">Power Pivot<\/span>, care lucreaza <strong>doar<\/strong> cu tabele.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":816,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[16],"tags":[978,976,164,165,166],"class_list":["post-822","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cursuri-excel-gratuite","tag-cursuri-excel-companii","tag-cursuri-excel-online-gratuite","tag-excel-2013","tag-format-as-table","tag-power-pivot"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date,\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"-\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Cursuri Excel gratuite \u2013 Format as table, cum se realizeaza si la ce foloseste? -\" \/>\n\t\t<meta property=\"og:description\" content=\"Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date,\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-06-08T11:50:04+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-01-20T07:01:19+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Cursuri Excel gratuite \u2013 Format as table, cum se realizeaza si la ce foloseste? -\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date,\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#blogposting\",\"name\":\"Cursuri Excel gratuite \\u2013 Format as table, cum se realizeaza si la ce foloseste? -\",\"headline\":\"Cursuri Excel gratuite &#8211; Format as table, cum se realizeaza si la ce foloseste?\",\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/08.07_Excel-2013_format-as-table.png\",\"width\":238,\"height\":310,\"caption\":\"Excel 2013_Format as table_choose style\"},\"datePublished\":\"2019-06-08T11:50:04+00:00\",\"dateModified\":\"2020-01-20T07:01:19+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#webpage\"},\"articleSection\":\"Cursuri Excel gratuite, cursuri excel companii, cursuri excel online gratuite, Excel 2013, Format as Table, Power Pivot\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"position\":2,\"name\":\"Cursuri Excel\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"position\":3,\"name\":\"Cursuri Excel gratuite\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#listItem\",\"name\":\"Cursuri Excel gratuite &#8211; Format as table, cum se realizeaza si la ce foloseste?\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#listItem\",\"position\":4,\"name\":\"Cursuri Excel gratuite &#8211; Format as table, cum se realizeaza si la ce foloseste?\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/SIGLA-BUNA-150x150.jpg\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#organizationLogo\",\"width\":150,\"height\":150},\"image\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#webpage\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/\",\"name\":\"Cursuri Excel gratuite \\u2013 Format as table, cum se realizeaza si la ce foloseste? -\",\"description\":\"Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date,\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/08.07_Excel-2013_format-as-table.png\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#mainImage\",\"width\":238,\"height\":310,\"caption\":\"Excel 2013_Format as table_choose style\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\\\/#mainImage\"},\"datePublished\":\"2019-06-08T11:50:04+00:00\",\"dateModified\":\"2020-01-20T07:01:19+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Cursuri Excel gratuite \u2013 Format as table, cum se realizeaza si la ce foloseste? -","description":"Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date,","canonical_url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#blogposting","name":"Cursuri Excel gratuite \u2013 Format as table, cum se realizeaza si la ce foloseste? -","headline":"Cursuri Excel gratuite &#8211; Format as table, cum se realizeaza si la ce foloseste?","author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table.png","width":238,"height":310,"caption":"Excel 2013_Format as table_choose style"},"datePublished":"2019-06-08T11:50:04+00:00","dateModified":"2020-01-20T07:01:19+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#webpage"},"isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#webpage"},"articleSection":"Cursuri Excel gratuite, cursuri excel companii, cursuri excel online gratuite, Excel 2013, Format as Table, Power Pivot"},{"@type":"BreadcrumbList","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","position":1,"name":"Home","item":"https:\/\/eticsolutions.ro\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","position":2,"name":"Cursuri Excel","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","position":3,"name":"Cursuri Excel gratuite","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#listItem","name":"Cursuri Excel gratuite &#8211; Format as table, cum se realizeaza si la ce foloseste?"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#listItem","position":4,"name":"Cursuri Excel gratuite &#8211; Format as table, cum se realizeaza si la ce foloseste?","previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"}}]},{"@type":"Organization","@id":"https:\/\/eticsolutions.ro\/blog\/#organization","url":"https:\/\/eticsolutions.ro\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#organizationLogo","width":150,"height":150},"image":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author","url":"https:\/\/eticsolutions.ro\/blog\/author\/"},{"@type":"WebPage","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#webpage","url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/","name":"Cursuri Excel gratuite \u2013 Format as table, cum se realizeaza si la ce foloseste? -","description":"Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date,","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#breadcrumblist"},"author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"creator":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/08.07_Excel-2013_format-as-table.png","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#mainImage","width":238,"height":310,"caption":"Excel 2013_Format as table_choose style"},"primaryImageOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/#mainImage"},"datePublished":"2019-06-08T11:50:04+00:00","dateModified":"2020-01-20T07:01:19+00:00"},{"@type":"WebSite","@id":"https:\/\/eticsolutions.ro\/blog\/#website","url":"https:\/\/eticsolutions.ro\/blog\/","inLanguage":"en-US","publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"-","og:type":"article","og:title":"Cursuri Excel gratuite \u2013 Format as table, cum se realizeaza si la ce foloseste? -","og:description":"Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date,","og:url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/","og:image":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","og:image:secure_url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","article:published_time":"2019-06-08T11:50:04+00:00","article:modified_time":"2020-01-20T07:01:19+00:00","twitter:card":"summary_large_image","twitter:title":"Cursuri Excel gratuite \u2013 Format as table, cum se realizeaza si la ce foloseste? -","twitter:description":"Exemplul de mai jos este construit pentru Microsoft Excel 2013, dar se realizeaza cvasi-identic si in versiunea 2010 sau 2016. Desi majoritatea utilizatorilor de nivel mediu utilizeaza optiunea Format as Table din meniul Home ca modalitate de formatare rapida a unui tabel, in fapt aceasta reprezinta transformarea unui interval de celule in baza de date,","twitter:image":"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg"},"aioseo_meta_data":{"post_id":"822","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-06-29 09:49:57","updated":"2026-06-29 09:49:57"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/\" title=\"Cursuri Excel\">Cursuri Excel<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/\" title=\"Cursuri Excel gratuite\">Cursuri Excel gratuite<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tCursuri Excel gratuite \u2013 Format as table, cum se realizeaza si la ce foloseste?\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/eticsolutions.ro\/blog"},{"label":"Cursuri Excel","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/"},{"label":"Cursuri Excel gratuite","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/"},{"label":"Cursuri Excel gratuite &#8211; Format as table, cum se realizeaza si la ce foloseste?","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cursuri-excel-gratuite-format-as-table-cum-se-realizeaza-si-la-ce-foloseste\/"}],"_links":{"self":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/822","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/comments?post=822"}],"version-history":[{"count":3,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/822\/revisions"}],"predecessor-version":[{"id":825,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/822\/revisions\/825"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/media\/816"}],"wp:attachment":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/media?parent=822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/categories?post=822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/tags?post=822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}