{"id":23687,"date":"2025-02-21T00:30:00","date_gmt":"2025-02-21T05:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=23687"},"modified":"2025-04-02T01:12:33","modified_gmt":"2025-04-02T06:12:33","slug":"control-de-ingresos-y-gastos-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/","title":{"rendered":"Control de Ingresos y gastos en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-control-de-ingresos-y-gastos-en-excel\">Control de Ingresos y gastos en Excel<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-contabilidad-en-casa-control-financiero-en-excel\">Contabilidad en Casa: control financiero en excel <\/h2>\n\n\n\n<p>\u00bfTe gustar\u00eda aprender a manejar la contabilidad en casa de manera sencilla y eficiente? En este post, te ense\u00f1aremos paso a paso c\u00f3mo llevar un Control de Ingresos y Gastos en Excel, creando un balance general, un resumen de ingresos y un resumen de egresos con el poder de las tablas din\u00e1micas y gr\u00e1ficos. Este m\u00e9todo es perfecto para gestionar las finanzas del hogar o de peque\u00f1os negocios de forma clara y organizada. Adem\u00e1s, podr\u00e1s personalizarlo seg\u00fan tus necesidades. \u00a1Sigue leyendo y convi\u00e9rtete en un experto en contabilidad en casa!<\/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 title=\"\ud83d\udcc8 Contabilidad en Casa - Control de Ingresos y Gastos en Excel \ud83d\udcb0 (Administra tu Dinero)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/KM5-ducaivA?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<div class=\"wp-block-uagb-advanced-heading uagb-block-98362134\"><h2 class=\"uagb-heading-text\">Descargar Material de Apoyo<\/h2><p class=\"uagb-desc-text\">Descarga los archivos vistos en el v\u00eddeo, incluido el control de ingresos y gastos en Excel finalizado.<\/p><\/div>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-d6548f\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-191ed5 ultp-button-layout2\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/Ingresos-y-Egresos-Contabilidad-del-Hogar-2.xlsx\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 37.1 49.16\"><path stroke=\"rgba(0,0,0,0)\" stroke-miterlimit=\"10\" d=\"M1.1 31A2.05 2.05 0 1 1 4 28.1l12.5 12.5V2.55a2.05 2.05 0 0 1 4.1 0V40.6l12.5-12.5A2.05 2.05 0 1 1 36 31L18.549 48.45Z\"><\/path><\/svg><\/div><div class=\"ultp-button-text\">Descargar<\/div><\/a>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-94dc2c\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\"><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-por-que-usar-excel-para-la-contabilidad-en-casa\">\u00bfPor Qu\u00e9 Usar Excel para la Contabilidad en casa?<\/h2>\n\n\n\n<p>Excel es una herramienta poderosa y vers\u00e1til que te permite organizar y analizar datos financieros de manera eficiente. Con Excel, puedes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Crear tablas din\u00e1micas<\/strong>&nbsp;para resumir y analizar grandes cantidades de datos.<\/li>\n\n\n\n<li><strong>Generar gr\u00e1ficos<\/strong>&nbsp;visuales que te ayudar\u00e1n a entender mejor tus finanzas.<\/li>\n\n\n\n<li><strong>Automatizar c\u00e1lculos<\/strong>&nbsp;para ahorrar tiempo y reducir errores.<\/li>\n<\/ul>\n\n\n\n<p>\ud83d\ude80 Con nuestro <a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/curso-excel-avanzado\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel B\u00e1sico<\/a>, aprender\u00e1s trucos y funciones que te ahorrar\u00e1n tiempo y te har\u00e1n m\u00e1s eficiente en el trabajo. <b>\u00a1No d<\/b><strong>ejes pasar esta oportunidad!<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-como-administrar-tu-contabilidad-en-casa\">C\u00f3mo administrar tu contabilidad en casa<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-paso-1-configuracion-de-la-tabla-de-ingresos\">Paso 1: Configuraci\u00f3n de la Tabla de Ingresos<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"cdd7cb\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"369\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-8-1024x369.avif\" alt=\"alt=&quot;Control de ingresos y gastos en Excel: Tabla de ingresos.&quot;\" class=\"wp-image-23690 has-transparency\" style=\"--dominant-color: #cdd7cb; width:673px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-8-1024x369.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-8-300x108.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-8-768x277.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-8-600x216.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-8-png.avif 1394w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Columnas B\u00e1sicas:<\/strong>&nbsp;Comienza creando una tabla con las siguientes columnas: Fecha, Categor\u00eda, Descripci\u00f3n y Valor.<\/li>\n\n\n\n<li><strong>Formato de Tabla:<\/strong>&nbsp;Selecciona los datos y convi\u00e9rtelos en una tabla haciendo clic en&nbsp;<em>Insertar &gt; Tabla<\/em>. Aseg\u00farate de marcar la opci\u00f3n \u00abMi tabla tiene encabezados\u00bb.<\/li>\n\n\n\n<li><strong>Nombre de la Tabla:<\/strong>&nbsp;Asigna un nombre a tu tabla, por ejemplo, \u00abIngresos\u00bb.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-paso-2-configuracion-de-la-tabla-de-egresos\">Paso 2: Configuraci\u00f3n de la Tabla de Egresos<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"cbccd2\" data-has-transparency=\"true\" decoding=\"async\" width=\"445\" height=\"465\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-9-png.avif\" alt=\"alt=&quot;Configurar la tabla de egresos en Excel para un control completo de ingresos y gastos.&quot;\" class=\"wp-image-23691 has-transparency\" style=\"--dominant-color: #cbccd2; width:299px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-9-png.avif 445w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-9-287x300.avif 287w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Duplicar la Hoja:<\/strong>&nbsp;Para ahorrar tiempo, duplica la hoja de ingresos y renombra la nueva hoja como \u00abEgresos\u00bb.<\/li>\n\n\n\n<li><strong>Cambiar Colores:<\/strong>&nbsp;Cambia el color de la tabla para diferenciarla visualmente de la tabla de ingresos.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-gestion-financiera-en-excel-administracion-de-ingresos-y-gastos-con-tablas-dinamicas\"><strong>Gesti\u00f3n Financiera en Excel: Administraci\u00f3n de Ingresos y Gastos con Tablas Din\u00e1micas<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-paso-1-resumen-de-ingresos-por-mes\">Paso 1: Resumen de Ingresos por Mes<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"d1d2d9\" data-has-transparency=\"true\" decoding=\"async\" width=\"618\" height=\"400\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-10-png.avif\" alt=\"alt=&quot;Crear un resumen de ingresos por mes en Excel para un mejor control de ingresos y gastos.&quot;\n\" class=\"wp-image-23692 has-transparency\" style=\"--dominant-color: #d1d2d9; width:476px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-10-png.avif 618w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-10-300x194.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-10-600x388.avif 600w\" sizes=\"(max-width: 618px) 100vw, 618px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Insertar Tabla Din\u00e1mica:<\/strong>&nbsp;Selecciona la tabla de ingresos y haz clic en&nbsp;<em>Insertar &gt; Tabla Din\u00e1mica<\/em>.<\/li>\n\n\n\n<li><strong>Organizar Datos:<\/strong>&nbsp;Arrastra el campo \u00abMeses\u00bb a las filas y el campo \u00abValor\u00bb a los valores. Esto te dar\u00e1 un resumen de los ingresos por mes.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-paso-2-resumen-de-ingresos-por-categoria\">Paso 2: Resumen de Ingresos por Categor\u00eda<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"e0e6e9\" data-has-transparency=\"true\" style=\"--dominant-color: #e0e6e9;\" loading=\"lazy\" decoding=\"async\" width=\"280\" height=\"223\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-11-png.avif\" alt=\"alt=&quot;Control de ingresos y gastos en Excel: Resumen por categor\u00eda.&quot;\" class=\"wp-image-23693 has-transparency\"\/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Cambiar Campos:<\/strong>&nbsp;En la misma tabla din\u00e1mica, cambia el campo \u00abMeses\u00bb por \u00abCategor\u00eda\u00bb para obtener un resumen de los ingresos por categor\u00eda.<\/li>\n\n\n\n<li><strong>Personalizar:<\/strong>&nbsp;Ajusta el ancho de las columnas y el dise\u00f1o de la tabla para que sea m\u00e1s legible.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-visualizacion-de-datos-con-graficos-dinamicos\">Visualizaci\u00f3n de Datos con Gr\u00e1ficos Din\u00e1micos<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-paso-1-crear-un-grafico-de-ingresos-en-excel\">Paso 1: Crear un Gr\u00e1fico de Ingresos en Excel <\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"dae4e8\" data-has-transparency=\"true\" style=\"--dominant-color: #dae4e8;\" loading=\"lazy\" decoding=\"async\" width=\"465\" height=\"120\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-12-png.avif\" alt=\"alt=&quot;Crear un gr\u00e1fico de ingresos en Excel para visualizar y controlar tus ingresos y gastos.&quot;\" class=\"wp-image-23694 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-12-png.avif 465w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-12-300x77.avif 300w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Seleccionar Tabla Din\u00e1mica:<\/strong>&nbsp;Haz clic en la tabla din\u00e1mica de ingresos y selecciona&nbsp;<em>Analizar &gt; Gr\u00e1fico Din\u00e1mico<\/em>.<\/li>\n\n\n\n<li><strong>Elegir Tipo de Gr\u00e1fico:<\/strong>&nbsp;Selecciona el tipo de gr\u00e1fico que prefieras, como columnas o barras.<\/li>\n\n\n\n<li><strong>Personalizar:<\/strong>&nbsp;Cambia los colores y el dise\u00f1o del gr\u00e1fico para que sea m\u00e1s atractivo visualmente.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-paso-2-crear-un-grafico-de-egresos-en-excel\">Paso 2: Crear un Gr\u00e1fico de Egresos en Excel <\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e4dcd9\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"396\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-13-1024x396.avif\" alt=\"\" class=\"wp-image-23695 has-transparency\" style=\"--dominant-color: #e4dcd9; width:761px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-13-1024x396.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-13-300x116.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-13-768x297.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-13-600x232.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-13-png.avif 1382w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Repetir el Proceso:<\/strong>&nbsp;Sigue los mismos pasos para crear un gr\u00e1fico din\u00e1mico de egresos.<\/li>\n\n\n\n<li><strong>Comparar:<\/strong>&nbsp;Coloca los gr\u00e1ficos de ingresos y egresos uno al lado del otro para comparar f\u00e1cilmente tus finanzas.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-calculo-del-balance-general-para-el-control-de-ingresos-y-gastos-en-excel\">C\u00e1lculo del Balance General para el Control de Ingresos y Gastos en Excel<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-paso-1-crear-una-tabla-en-balance\">Paso 1: Crear una Tabla en Balance<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"cfe3ed\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"343\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-14-png.avif\" alt=\"\" class=\"wp-image-23696 has-transparency\" style=\"--dominant-color: #cfe3ed; width:504px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-14-png.avif 786w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-14-300x131.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-14-768x335.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-14-600x262.avif 600w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Insertar Nueva Tabla:<\/strong>&nbsp;Crea una nueva tabla con las columnas: Mes, Ingresos, Egresos y Balance.<\/li>\n\n\n\n<li><strong>F\u00f3rmulas:<\/strong>&nbsp;Utiliza f\u00f3rmulas como&nbsp;<code>SUMAR.SI<\/code>&nbsp;para calcular autom\u00e1ticamente los ingresos y egresos de cada mes.<\/li>\n\n\n\n<li><strong>Balance:<\/strong>&nbsp;Resta los egresos de los ingresos para obtener el balance mensual.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-paso-2-grafico-de-balance-en-excel\">Paso 2: Gr\u00e1fico de Balance en Excel<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"f1f3f5\" data-has-transparency=\"true\" style=\"--dominant-color: #f1f3f5;\" loading=\"lazy\" decoding=\"async\" width=\"794\" height=\"281\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/12\/image-12-png.avif\" alt=\"alt=&quot;Opciones para exportar a PDF con f\u00f3rmulas activas desde tablas en Word.&quot;\" class=\"wp-image-23716 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/12\/image-12-png.avif 794w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/12\/image-12-300x106.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/12\/image-12-768x272.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/12\/image-12-600x212.avif 600w\" sizes=\"(max-width: 794px) 100vw, 794px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Insertar Gr\u00e1fico:<\/strong>&nbsp;Selecciona la tabla de balance y crea un gr\u00e1fico de columnas para visualizar el balance mensual.<\/li>\n\n\n\n<li><strong>Personalizar:<\/strong>&nbsp;Ajusta los colores y el dise\u00f1o del gr\u00e1fico para que sea m\u00e1s claro y f\u00e1cil de entender.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"dedcdb\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"607\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-16-1024x607.avif\" alt=\"\" class=\"wp-image-23698 has-transparency\" style=\"--dominant-color: #dedcdb; width:706px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-16-1024x607.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-16-300x178.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-16-768x456.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-16-600x356.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-16-png.avif 1212w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Llevar un <strong>control de ingresos y gastos en Excel<\/strong> es una manera eficiente y accesible de gestionar tus finanzas personales o las de tu negocio. Con tablas din\u00e1micas, gr\u00e1ficos y f\u00f3rmulas, puedes crear reportes financieros detallados y visualmente atractivos<\/p>\n\n\n\n<p>No importa si eres principiante o tienes experiencia en Excel, este tutorial te proporciona las bases necesarias para empezar a trabajar de manera eficiente. Recuerda que la pr\u00e1ctica es clave, as\u00ed que no dudes en experimentar con las funciones y personalizar tus tablas y gr\u00e1ficos.<\/p>\n\n\n\n<p>\ud83d\udce2 <strong>\u00a1Automatiza tus formularios en Excel ahora!<\/strong> Aprende a crear <a href=\"https:\/\/dostinhurtado.com\/site\/tutoriales\/tutoriales-excel\/formularios-automaticos-en-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Formularios autom\u00e1ticos en Excel<\/strong><\/a> que agilicen la recolecci\u00f3n de datos y optimicen tu trabajo. \ud83d\ude80 <strong>\u00a1No pierdas esta oportunidad de mejorar tu productividad!<\/strong> Accede al tutorial y lleva tu Excel al siguiente nivel. \u2705<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-consejos-finales-para-optimizar-tu-contabilidad-en-excel\">Consejos Finales para Optimizar tu Contabilidad en Excel<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Validaci\u00f3n de Datos:<\/strong>&nbsp;Utiliza la validaci\u00f3n de datos para evitar errores al ingresar informaci\u00f3n.<\/li>\n\n\n\n<li><strong>Actualizaci\u00f3n Autom\u00e1tica:<\/strong>&nbsp;Aseg\u00farate de actualizar las tablas din\u00e1micas y gr\u00e1ficos cada vez que agregues nuevos datos.<\/li>\n\n\n\n<li><strong>Licencias Originales:<\/strong>&nbsp;Usa versiones originales de Excel para garantizar el correcto funcionamiento de todas las funciones.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Si necesitas Office y no quieres pagar el precio completo, tengo algo que podr\u00eda interesarte. \ud83d\ude0f Est\u00e1s a un clic de conseguir <strong>66% de descuento<\/strong> = <strong>DH66<\/strong> en Office gracias a <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong>, \u00a1y no es algo que veas todos los d\u00edas! \ud83d\ude31<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1740149702447\"><strong class=\"schema-faq-question\">1.\u00a0<strong>\u00bfQu\u00e9 versiones de Excel son compatibles con este m\u00e9todo?<\/strong><\/strong> <p class=\"schema-faq-answer\">Este m\u00e9todo funciona en todas las versiones de Excel, incluyendo Excel 2010, 2013, 2016, 2019, 2021 y Excel para Microsoft 365. Tambi\u00e9n es compatible con alternativas como Google Sheets y LibreOffice.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1740149735971\"><strong class=\"schema-faq-question\">2.\u00a0<strong>\u00bfPuedo usar este m\u00e9todo para la contabilidad de un negocio peque\u00f1o?<\/strong><\/strong> <p class=\"schema-faq-answer\">S\u00ed, este m\u00e9todo es ideal para la contabilidad de negocios peque\u00f1os. Te permite organizar ingresos, egresos y generar balances de manera sencilla, y puedes personalizarlo seg\u00fan las necesidades de tu negocio.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1740149768604\"><strong class=\"schema-faq-question\">3.\u00a0<strong>\u00bfC\u00f3mo evito errores al ingresar datos en las categor\u00edas?<\/strong><\/strong> <p class=\"schema-faq-answer\">Si los datos no se actualizan, haz clic en la tabla din\u00e1mica y selecciona\u00a0<em>Analizar > Actualizar<\/em>. Tambi\u00e9n puedes configurar Excel para que actualice autom\u00e1ticamente las tablas din\u00e1micas cada vez que abres el archivo.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1740149786693\"><strong class=\"schema-faq-question\">4.\u00a0<strong>\u00bfQu\u00e9 hago si mis datos no se actualizan autom\u00e1ticamente en las tablas din\u00e1micas?<\/strong><\/strong> <p class=\"schema-faq-answer\">Usa la funci\u00f3n de\u00a0<strong>Validaci\u00f3n de Datos<\/strong>\u00a0en Excel. Selecciona la columna de categor\u00edas, ve a\u00a0<em>Datos > Validaci\u00f3n de Datos<\/em>, y elige \u00abLista\u00bb para restringir la entrada a categor\u00edas predefinidas. Esto evitar\u00e1 errores ortogr\u00e1ficos o duplicados.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Aprende a realizar el Control de Ingresos y Gastos en Excel de forma sencilla con tablas din\u00e1micas y gr\u00e1ficos efectivos.<\/p>\n","protected":false},"author":1,"featured_media":23836,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"video","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","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":"disabled","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":[52],"tags":[225,232,365,529,486],"class_list":["post-23687","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel","tag-facil","tag-office","tag-sheets","tag-tutorial","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Control de Ingresos y Gastos en Excel F\u00e1cil y R\u00e1pido - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a realizar el Control de Ingresos y Gastos en Excel de forma sencilla con tablas din\u00e1micas y gr\u00e1ficos efectivos.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Control de Ingresos y Gastos en Excel para el Hogar\" \/>\n<meta property=\"og:description\" content=\"Descubre c\u00f3mo llevar un Control de Ingresos y Gastos en Excel y personaliza tu contabilidad dom\u00e9stica o de peque\u00f1os negocios.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-21T05:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T06:12:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"750\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Control de Ingresos y Gastos en Excel F\u00e1cilmente\" \/>\n<meta name=\"twitter:description\" content=\"Aprende a llevar un Control de Ingresos y Gastos en Excel de forma sencilla y organizada para tus finanzas personales.\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/\"},\"author\":{\"name\":\"Dostin\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"headline\":\"Control de Ingresos y gastos en Excel\",\"datePublished\":\"2025-02-21T05:30:00+00:00\",\"dateModified\":\"2025-04-02T06:12:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/\"},\"wordCount\":1176,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/contabilidad-miniatura-05-1.avif\",\"keywords\":[\"Excel\",\"Facil\",\"office\",\"Sheets\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/\",\"name\":\"Control de Ingresos y Gastos en Excel F\u00e1cil y R\u00e1pido - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/contabilidad-miniatura-05-1.avif\",\"datePublished\":\"2025-02-21T05:30:00+00:00\",\"dateModified\":\"2025-04-02T06:12:33+00:00\",\"description\":\"Aprende a realizar el Control de Ingresos y Gastos en Excel de forma sencilla con tablas din\u00e1micas y gr\u00e1ficos efectivos.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149702447\"},{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149735971\"},{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149768604\"},{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149786693\"}],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/contabilidad-miniatura-05-1.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/contabilidad-miniatura-05-1.avif\",\"width\":1000,\"height\":750},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Control de Ingresos y gastos en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\"],\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/dostin\\\/\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149702447\",\"position\":1,\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149702447\",\"name\":\"1.\u00a0\u00bfQu\u00e9 versiones de Excel son compatibles con este m\u00e9todo?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Este m\u00e9todo funciona en todas las versiones de Excel, incluyendo Excel 2010, 2013, 2016, 2019, 2021 y Excel para Microsoft 365. Tambi\u00e9n es compatible con alternativas como Google Sheets y LibreOffice.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149735971\",\"position\":2,\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149735971\",\"name\":\"2.\u00a0\u00bfPuedo usar este m\u00e9todo para la contabilidad de un negocio peque\u00f1o?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"S\u00ed, este m\u00e9todo es ideal para la contabilidad de negocios peque\u00f1os. Te permite organizar ingresos, egresos y generar balances de manera sencilla, y puedes personalizarlo seg\u00fan las necesidades de tu negocio.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149768604\",\"position\":3,\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149768604\",\"name\":\"3.\u00a0\u00bfC\u00f3mo evito errores al ingresar datos en las categor\u00edas?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Si los datos no se actualizan, haz clic en la tabla din\u00e1mica y selecciona\u00a0<em>Analizar > Actualizar<\\\/em>. Tambi\u00e9n puedes configurar Excel para que actualice autom\u00e1ticamente las tablas din\u00e1micas cada vez que abres el archivo.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149786693\",\"position\":4,\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/control-de-ingresos-y-gastos-en-excel\\\/#faq-question-1740149786693\",\"name\":\"4.\u00a0\u00bfQu\u00e9 hago si mis datos no se actualizan autom\u00e1ticamente en las tablas din\u00e1micas?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Usa la funci\u00f3n de\u00a0<strong>Validaci\u00f3n de Datos<\\\/strong>\u00a0en Excel. Selecciona la columna de categor\u00edas, ve a\u00a0<em>Datos > Validaci\u00f3n de Datos<\\\/em>, y elige \\\"Lista\\\" para restringir la entrada a categor\u00edas predefinidas. Esto evitar\u00e1 errores ortogr\u00e1ficos o duplicados.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Control de Ingresos y Gastos en Excel F\u00e1cil y R\u00e1pido - Dostin Hurtado","description":"Aprende a realizar el Control de Ingresos y Gastos en Excel de forma sencilla con tablas din\u00e1micas y gr\u00e1ficos efectivos.","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Control de Ingresos y Gastos en Excel para el Hogar","og_description":"Descubre c\u00f3mo llevar un Control de Ingresos y Gastos en Excel y personaliza tu contabilidad dom\u00e9stica o de peque\u00f1os negocios.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2025-02-21T05:30:00+00:00","article_modified_time":"2025-04-02T06:12:33+00:00","og_image":[{"width":1000,"height":750,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif","type":"image\/jpeg"}],"author":"Dostin","twitter_card":"summary_large_image","twitter_title":"Control de Ingresos y Gastos en Excel F\u00e1cilmente","twitter_description":"Aprende a llevar un Control de Ingresos y Gastos en Excel de forma sencilla y organizada para tus finanzas personales.","twitter_misc":{"Escrito por":"Dostin","Tiempo de lectura":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/"},"author":{"name":"Dostin","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"headline":"Control de Ingresos y gastos en Excel","datePublished":"2025-02-21T05:30:00+00:00","dateModified":"2025-04-02T06:12:33+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/"},"wordCount":1176,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif","keywords":["Excel","Facil","office","Sheets","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/","name":"Control de Ingresos y Gastos en Excel F\u00e1cil y R\u00e1pido - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif","datePublished":"2025-02-21T05:30:00+00:00","dateModified":"2025-04-02T06:12:33+00:00","description":"Aprende a realizar el Control de Ingresos y Gastos en Excel de forma sencilla con tablas din\u00e1micas y gr\u00e1ficos efectivos.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149702447"},{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149735971"},{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149768604"},{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149786693"}],"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif","width":1000,"height":750},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Control de Ingresos y gastos en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"],"url":"https:\/\/dostinhurtado.com\/site\/author\/dostin\/"},{"@type":"Question","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149702447","position":1,"url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149702447","name":"1.\u00a0\u00bfQu\u00e9 versiones de Excel son compatibles con este m\u00e9todo?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Este m\u00e9todo funciona en todas las versiones de Excel, incluyendo Excel 2010, 2013, 2016, 2019, 2021 y Excel para Microsoft 365. Tambi\u00e9n es compatible con alternativas como Google Sheets y LibreOffice.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149735971","position":2,"url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149735971","name":"2.\u00a0\u00bfPuedo usar este m\u00e9todo para la contabilidad de un negocio peque\u00f1o?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"S\u00ed, este m\u00e9todo es ideal para la contabilidad de negocios peque\u00f1os. Te permite organizar ingresos, egresos y generar balances de manera sencilla, y puedes personalizarlo seg\u00fan las necesidades de tu negocio.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149768604","position":3,"url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149768604","name":"3.\u00a0\u00bfC\u00f3mo evito errores al ingresar datos en las categor\u00edas?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Si los datos no se actualizan, haz clic en la tabla din\u00e1mica y selecciona\u00a0<em>Analizar > Actualizar<\/em>. Tambi\u00e9n puedes configurar Excel para que actualice autom\u00e1ticamente las tablas din\u00e1micas cada vez que abres el archivo.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149786693","position":4,"url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/control-de-ingresos-y-gastos-en-excel\/#faq-question-1740149786693","name":"4.\u00a0\u00bfQu\u00e9 hago si mis datos no se actualizan autom\u00e1ticamente en las tablas din\u00e1micas?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Usa la funci\u00f3n de\u00a0<strong>Validaci\u00f3n de Datos<\/strong>\u00a0en Excel. Selecciona la columna de categor\u00edas, ve a\u00a0<em>Datos > Validaci\u00f3n de Datos<\/em>, y elige \"Lista\" para restringir la entrada a categor\u00edas predefinidas. Esto evitar\u00e1 errores ortogr\u00e1ficos o duplicados.","inLanguage":"es"},"inLanguage":"es"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif",1000,750,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-768x576.avif",768,576,true],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif",1000,750,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif",1000,750,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif",1000,750,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1.avif",1000,750,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-870x570.avif",870,570,true],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-600x750.avif",600,750,true],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-600x600.avif",600,600,true],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-400x400.avif",400,400,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-600x450.avif",600,450,true],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/contabilidad-miniatura-05-1-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin","author_link":"https:\/\/dostinhurtado.com\/site\/author\/dostin\/"},"uagb_comment_info":0,"uagb_excerpt":"Aprende a realizar el Control de Ingresos y Gastos en Excel de forma sencilla con tablas din\u00e1micas y gr\u00e1ficos efectivos.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=23687"}],"version-history":[{"count":13,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23687\/revisions"}],"predecessor-version":[{"id":23851,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23687\/revisions\/23851"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/23836"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=23687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=23687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=23687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}