{"id":14416,"date":"2024-12-11T23:13:38","date_gmt":"2024-12-12T04:13:38","guid":{"rendered":"https:\/\/www.perucontable.com\/excelcontable\/?p=14416"},"modified":"2024-12-12T12:19:08","modified_gmt":"2024-12-12T17:19:08","slug":"las-funciones-mas-usadas-de-excel-en-la-contabilidad","status":"publish","type":"post","link":"https:\/\/www.perucontable.com\/excelcontable\/las-funciones-mas-usadas-de-excel-en-la-contabilidad\/","title":{"rendered":"Las funciones m\u00e1s usadas de Excel en la contabilidad"},"content":{"rendered":"\n<p>El Excel es una hoja de c\u00e1lculo para procesar datos,\nel cual se convierte en una herramienta que le permite al contador analizar y\nprocesar datos.<\/p>\n\n\n\n<p>En este art\u00edculo te mostraremos las 6 funciones b\u00e1sicas de Excel en la contabilidad.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/12\/122740465_3572143879498099_4760210729618211394_n-1-819x1024.jpg\" alt=\"\" class=\"wp-image-19176\"\/><\/figure>\n\n\n\n<h2><strong>Suma<\/strong><\/h2>\n\n\n\n<p>La funci\u00f3n matem\u00e1tica y trigonom\u00e9trica SUMA nos permite operar varios n\u00fameros de varias celdas o un rango determinado. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"335\" height=\"128\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/sumar.jpg\" alt=\"\" class=\"wp-image-14417\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/sumar.jpg 335w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/sumar-300x115.jpg 300w\" sizes=\"(max-width: 335px) 100vw, 335px\" \/><\/figure>\n\n\n\n<h2><strong>Resta<\/strong><\/h2>\n\n\n\n<p>Lo primero que debes saber es que la funci\u00f3n RESTA no existe, la manera de operar con la funci\u00f3n RESTA utilizamos \u201c &#8211; \u201d. Parecer\u00e1 extra\u00f1o pero para utilizar la funci\u00f3n RESTA podemos utilizar la funci\u00f3n suma, como lo veremos en el ejemplo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"423\" height=\"111\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/restar.jpg\" alt=\"\" class=\"wp-image-14418\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/restar.jpg 423w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/restar-300x79.jpg 300w\" sizes=\"(max-width: 423px) 100vw, 423px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-verse\">Lee tambi\u00e9n: <strong><a href=\"https:\/\/www.perucontable.com\/excelcontable\/plantilla-excel-automatizada-para-generar-estados-financieros-en-minutos\/\" target=\"_blank\" rel=\"noreferrer noopener\">Plantilla Excel automatizada para generar estados financieros en minutos<\/a><\/strong><\/pre>\n\n\n\n<h2><strong>Multiplicaci\u00f3n<\/strong><\/h2>\n\n\n\n<p>La igual que la funci\u00f3n RESTA la funci\u00f3n MULTIPLICACION no existe, para operar utilizamos \u00e9l \u201c * \u201d y podemos hacerlo de dos maneras, como en el ejemplo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"422\" height=\"111\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/multiplicaci\u00f3n.jpg\" alt=\"\" class=\"wp-image-14419\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/multiplicaci\u00f3n.jpg 422w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/multiplicaci\u00f3n-300x79.jpg 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/figure>\n\n\n\n<h2><strong>Divisi\u00f3n<\/strong><\/h2>\n\n\n\n<p>Para hacer uso de esta funci\u00f3n utilizamos \u201c \/ \u201d, para operar la funci\u00f3n DIVISION tambi\u00e9n podemos hacer uso de la funci\u00f3n SUMA o sin hacer uso de ello, ejemplo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"422\" height=\"113\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/divisi\u00f3n.jpg\" alt=\"\" class=\"wp-image-14420\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/divisi\u00f3n.jpg 422w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/divisi\u00f3n-300x80.jpg 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-verse\">Lee tambi\u00e9n: <a rel=\"noreferrer noopener\" href=\"https:\/\/www.perucontable.com\/excelcontable\/demasiados-datos-usa-filtros-en-excel-como-un-experto\/\" target=\"_blank\"><strong>Usa filtros en Excel como experto<\/strong><\/a><\/pre>\n\n\n\n<h2><strong>Contar<\/strong><\/h2>\n\n\n\n<p>Con la funci\u00f3n CONTAR obtendremos la cantidad de celdas que contienen valores l\u00f3gicos o representaciones textuales, ejemplo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"512\" height=\"132\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/contar.jpg\" alt=\"\" class=\"wp-image-14421\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/contar.jpg 512w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/contar-300x77.jpg 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-medium is-resized\"><a href=\"https:\/\/walink.co\/ad16d1\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2024\/12\/image-6-300x300.png\" alt=\"\" class=\"wp-image-19175\" width=\"521\" height=\"521\"\/><\/a><\/figure><\/div>\n\n\n<div class=\"is-content-justification-center is-layout-flex wp-container-1 wp-block-buttons\">\n<div class=\"wp-block-button is-style-shadow\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"https:\/\/walink.co\/ad16d1\" style=\"background-color:#061e2d\" target=\"_blank\" rel=\"noreferrer noopener\">Adquiere el Sistema Contable \u00abContaexcel\u00bb y accede a esta s\u00faper promo (clic aqu\u00ed)<\/a><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h2><strong>Redondear<\/strong><\/h2>\n\n\n\n<p>La funci\u00f3n REDONDEAR, como su mismo nombre lo dice nos ayuda a redondear a la cantidad de decimales que deseemos, puede ser numero positivos o negativos, ejemplo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"391\" height=\"133\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/redondear.jpg\" alt=\"\" class=\"wp-image-14422\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/redondear.jpg 391w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/02\/redondear-300x102.jpg 300w\" sizes=\"(max-width: 391px) 100vw, 391px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h2><strong>Te recomendamos:<\/strong><\/h2>\n\n\n\n<ul>\n<li><a href=\"https:\/\/walink.co\/a892ec\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Ser parte de PeruContable premium<\/strong><\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/walink.co\/ad16d1\" target=\"_blank\"><strong>Adquiere tu Sistema Contaexcel y optimiza tus <\/strong><\/a><a href=\"https:\/\/walink.co\/ad16d1\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>procesos<\/strong><\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/walink.co\/ad16d1\" target=\"_blank\"><strong> contables<\/strong><\/a><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/walink.co\/3df168\" target=\"_blank\" rel=\"noreferrer noopener\">Diplomado en An\u00e1lisis y Elaboraci\u00f3n de Estados Financieros<\/a><\/strong><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Aprende mas de nuestro Sistema Contaexcel aqu\u00ed: <\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"#EnVivo \ud83d\udd34Registro de compras y ventas en el Sistema ContaExcel V4.0\" width=\"696\" height=\"392\" src=\"https:\/\/www.youtube.com\/embed\/tArWraK25bU?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>\u00bfQu\u00e9 les pareci\u00f3 el art\u00edculo? Esperamos sus comentarios<\/p>\n","protected":false},"excerpt":{"rendered":"<p>El Excel es una hoja de c\u00e1lculo para procesar datos, el cual se convierte en una herramienta que le permite al contador analizar y procesar datos. En este art\u00edculo te mostraremos las 6 funciones b\u00e1sicas de Excel en la contabilidad. Suma La funci\u00f3n matem\u00e1tica y trigonom\u00e9trica SUMA nos permite operar varios n\u00fameros de varias celdas [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":14423,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[67],"tags":[],"yst_prominent_words":[327,335,275,128,133,461,216,126,454,455,460,459,218,458,456,127,317,457,462,217],"_links":{"self":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14416"}],"collection":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/comments?post=14416"}],"version-history":[{"count":10,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14416\/revisions"}],"predecessor-version":[{"id":19185,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14416\/revisions\/19185"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media\/14423"}],"wp:attachment":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media?parent=14416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/categories?post=14416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/tags?post=14416"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/yst_prominent_words?post=14416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}