{"id":18136,"date":"2015-04-06T14:45:50","date_gmt":"2015-04-06T20:45:50","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=18136"},"modified":"2025-01-27T13:35:16","modified_gmt":"2025-01-27T19:35:16","slug":"subtotales-en-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/subtotales-en-excel.html","title":{"rendered":"Subtotales en Excel para Automatizar Tarjeta de Almac\u00e9n"},"content":{"rendered":"<h1 style=\"text-align: center;\">Subtotales en Excel para Automatizar Tarjeta de almacen&nbsp;<\/h1>\n<p style=\"text-align: justify;\">Te gustar\u00eda aprender a automatizar las Tarjetas de almac\u00e9n &nbsp;con Subtotales en Excel?<\/p>\n<p style=\"text-align: justify;\">He prometido compartir tres t\u00e9cnicas o formar para automatizar la Tarjeta de almac\u00e9n en Excel, hoy voy a compartir la segunda T\u00e9cnica.<\/p>\n<p style=\"text-align: justify;\">Pero antes d\u00e9jame presentarme:<\/p>\n<p style=\"text-align: justify;\">Hola Soy Roger P\u00e9rez y hoy voy a compartirte la segunda Forma de Como Automatizar una Tarjeta de Almac\u00e9n utilizando Subtotales Excel. Comencemos.<\/p>\n<h2 style=\"text-align: center;\">Pasos para automatizar una Tarjeta de Almac\u00e9n Con Subtotales en Excel<\/h2>\n<p style=\"text-align: justify;\">Antes de compartirte los pasos de la segunda t\u00e9cnica, te invito a que veas la Primera t\u00e9cnica <span style=\"color: rgb(0, 23, 255);\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-automatizar-la-tarjeta-de-almacen-en-excel.html\" style=\"outline: none;\" target=\"_blank\"><strong>pulsando clic aqu\u00ed<\/strong><\/a><\/span>, donde aprender\u00e1s los pasos de \u201cComo Automatizar la Tarjeta de Almac\u00e9n en Excel Con Tablas Din\u00e1micas\u201d.<\/p>\n<p style=\"text-align: justify;\">Una vez termines regresa nuevamente aqu\u00ed y continua con la segunda t\u00e9cnica.<\/p>\n<h2 style=\"text-align: center;\">Automatizando una Tarjeta de Almac\u00e9n con el comando Subtotales en Excel<\/h2>\n<p style=\"text-align: justify;\">Vamos a utilizar el mismo archivo que utilizamos en el Primer ejemplo de Como Automatizar la Tarjeta de Almac\u00e9n en Excel con Tablas Din\u00e1micas. <\/p>\n<p style=\"text-align: justify;\">A continuaci\u00f3n te dejo el enlace de Descarga:<\/p>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/go\/tarjeta-de-almacen-en-excel\" target=\"_blank\"><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/aplicaexcelcontable.com\/go\/tarjeta-de-almacen-en-excel\" target=\"_blank\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo Excel<\/strong><\/em><\/a><\/p>\n<p style=\"\">Pulsa clic en el enlace o bien en la imagen de Excel para descargar el archivo de practica para aprender Subtotales en Excel.<\/p>\n<p style=\"text-align: justify;\">Muy bien, considerando que ya has descargado el archivo, vamos a seguir los siguientes pasos para automatizar la tarjeta de Almac\u00e9n en Excel con el comando Subtotales:<\/p>\n<ul>\n<li style=\"\"><span>Como primer paso, la Base de Datos debe estar alimentada, es decir debe de contener datos, en este caso puedes observar que ya le he agregado Datos en el archivo de ejemplo.<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Subtotales en Excel\" width=\"618\" height=\"431\" title=\"Datos-en-la-Hoja-Base.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Datos-en-la-Hoja-Base.png\" data-width=\"618\" data-height=\"431\" data-init-width=\"618\" data-init-height=\"431\" style=\"aspect-ratio: auto 618 \/ 431;\"><\/span><\/p>\n<ul>\n<li style=\"\"><span>Vamos a Crear una copia de la Hoja Base, para eso pulsamos clic derecho sobre la pesta\u00f1a de la hoja Base, pulsamos clic en el comando Mover o Copiar.<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Subtotales en Excel\" width=\"363\" height=\"293\" title=\"Mover-o-Copiar-Datos-en-Excel.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Mover-o-Copiar-Datos-en-Excel.png\" data-width=\"363\" data-height=\"293\" data-init-width=\"363\" data-init-height=\"293\" style=\"aspect-ratio: auto 363 \/ 293;\"><\/span><\/p>\n<ul>\n<li style=\"\"><span>Se presenta una ventanita, en este seleccionamos con un Check la casilla crear una copia y pulsamos aceptar.<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Subtotales en Excel\" width=\"309\" height=\"291\" title=\"Crear-una-Copia-de-la-Hoja-Base.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Crear-una-Copia-de-la-Hoja-Base.png\" data-width=\"309\" data-height=\"291\" data-init-width=\"309\" data-init-height=\"291\" style=\"aspect-ratio: auto 309 \/ 291;\"><\/span><\/p>\n<h3 style=\"text-align: center;\">Para continuar<\/h3>\n<ul>\n<li><span>Muy bien, ahora puedes observar una nueva Hoja llamada BASE (2), dentro de este vamos a seleccionar el siguiente rango, desde la A1: G20.<\/span><\/li>\n<li><span>Ahora vamos a ordenarlo por C\u00f3digo, para eso nos ubicamos en la Pesta\u00f1a DATOS y pulsamos clic en el comando Ordenar.<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Subtotales en Excel\" width=\"231\" height=\"129\" title=\"Comando-Ordenar.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Comando-Ordenar.png\" data-width=\"231\" data-height=\"129\" data-init-width=\"231\" data-init-height=\"129\" style=\"aspect-ratio: auto 231 \/ 129;\"><\/span><\/p>\n<ul>\n<li style=\"\"><span>Se presenta una ventana, dentro de este seleccionamos Ordenar por C\u00f3digo y pulsamos clic en Aceptar.<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Subtotales en Excel\" width=\"623\" height=\"281\" title=\"Ordenando-por-Codigo.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Ordenando-por-Codigo.png\" data-width=\"623\" data-height=\"281\" data-init-width=\"623\" data-init-height=\"281\" style=\"aspect-ratio: auto 623 \/ 281;\"><\/span><\/p>\n<ul>\n<li style=\"\"><span>Muy bien, ahora que ya hemos ordenado la Base, ahora vamos a crear el Subtotal de Cada C\u00f3digo.<\/span><\/li>\n<li style=\"\"><span>Desde la Pesta\u00f1a DATOS, pulsamos clic en el comando Subtotales, se presenta una ventana.<\/span><\/li>\n<li style=\"\"><span>Dentro de este en la primera opci\u00f3n seleccionamos Codigos, o bien puedes seleccionar Productos para que te muestre el Nombre.<\/span><\/li>\n<li style=\"\"><span>En el segundo cuadro de opciones lo dejamos en suma.<\/span><\/li>\n<li style=\"\"><span>En la tercera opci\u00f3n, marcamos con un check entrada y salida, para que las tres columnas de valores quede marcada. En la siguiente imagen puedes ver c\u00f3mo debe de quedar:<\/span><\/li>\n<\/ul>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Subtotales en Excel\" width=\"277\" height=\"341\" title=\"Configuracion-comando-Subtotales.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Configuracion-comando-Subtotales.png\" data-width=\"277\" data-height=\"341\" data-init-width=\"277\" data-init-height=\"341\" style=\"aspect-ratio: auto 277 \/ 341;\"><\/span><\/p>\n<ul>\n<li><span>Si lo tienes asi, entonces pulsa clic en aceptar.<\/span><\/li>\n<\/ul>\n<h3>Listo!<\/h3>\n<p style=\"text-align: justify;\">Ya tenemos el resumen de cada C\u00f3digo, tenemos el movimiento de entrada, salida y Saldo de todo los c\u00f3digos equivalentes a Cada Tarjeta de Almac\u00e9n.<\/p>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Subtotales en Excel\" width=\"628\" height=\"527\" title=\"Automatizando-con-el-Comando-Subtotal.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Automatizando-con-el-Comando-Subtotal.png\" data-width=\"628\" data-height=\"527\" data-init-width=\"628\" data-init-height=\"527\" style=\"aspect-ratio: auto 628 \/ 527;\"><\/span><\/p>\n<p style=\"text-align: justify;\">Hasta aqu\u00ed con el tema de hoy, en el pr\u00f3ximo articulo voy a compartir la t\u00e9cnica n\u00famero 3 donde aprender\u00e1s \u201cComo Automatizar la Tarjeta de Almac\u00e9n con Formulas Excel\u201d.<\/p>\n<p style=\"text-align: justify;\">\u00bfQue tal te pareci\u00f3 el articulo de hoy \u00bb Subtotales en Excel para Automatizar Tarjetas de Almac\u00e9n\u00bb?<\/p>\n<p style=\"text-align: justify;\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por&nbsp;<a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" rel=\"noopener\" target=\"_blank\">Facebook<\/a>, a continuaci\u00f3n te dejo un bot\u00f3n para que puedas compartirlo:<\/p>\n<p style=\"text-align: justify;\">Tambi\u00e9n, puedes seguirnos en Youtube, para recibir el acceso a todos los videos que publicamos semanalmente:<\/p>\n<h1><strong>S\u00edguenos en:<\/strong><\/h1>\n<p><a href=\"https:\/\/www.facebook.com\/aplicaexcecontable\" target=\"_blank\" rel=\"  noopener\"><\/a><a href=\"http:\/\/www.youtube.com\/user\/excelycontabilidad?sub_confirmation=1\" target=\"_blank\" rel=\"  noopener\"><\/a><\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Subtotales en Excel para Automatizar Tarjeta de almacen&nbsp; Te gustar\u00eda aprender a automatizar las Tarjetas de almac\u00e9n &nbsp;con Subtotales en Excel? He prometido compartir tres t\u00e9cnicas o formar para automatizar la Tarjeta de almac\u00e9n en Excel, hoy voy a compartir la segunda T\u00e9cnica. Pero antes d\u00e9jame presentarme: Hola Soy Roger P\u00e9rez y hoy voy a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":61399,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h1 data-css=\"tve-u-1611fb7f94e\" style=\"text-align: center;\" class=\"\">Subtotales en Excel para Automatizar Tarjeta de almacen&nbsp;<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-1611fed859b\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1611fb99404\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1611fb99406\" style=\"text-align: justify;\">Te gustar\u00eda aprender a automatizar las Tarjetas de almac\u00e9n &nbsp;con Subtotales en Excel?<\/p><p data-css=\"tve-u-1611fb99406\" style=\"text-align: justify;\">He prometido compartir tres t\u00e9cnicas o formar para automatizar la Tarjeta de almac\u00e9n en Excel, hoy voy a compartir la segunda T\u00e9cnica.<\/p><p data-css=\"tve-u-1611fb99406\" style=\"text-align: justify;\">Pero antes d\u00e9jame presentarme:<\/p><p data-css=\"tve-u-1611fb99406\" style=\"text-align: justify;\">Hola Soy Roger P\u00e9rez y hoy voy a compartirte la segunda Forma de Como Automatizar una Tarjeta de Almac\u00e9n utilizando Subtotales Excel. Comencemos.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h2 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-194709ecf44\">Pasos para automatizar una Tarjeta de Almac\u00e9n Con Subtotales en Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-1611fef42d8\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1611feee98a\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1611feee98c\" style=\"text-align: justify;\">Antes de compartirte los pasos de la segunda t\u00e9cnica, te invito a que veas la Primera t\u00e9cnica <span style=\"color: rgb(0, 23, 255);\" data-css=\"tve-u-1611ff6e30a\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-automatizar-la-tarjeta-de-almacen-en-excel.html\" class=\"\" style=\"outline: none;\" target=\"_blank\"><strong>pulsando clic aqu\u00ed<\/strong><\/a><\/span>, donde aprender\u00e1s los pasos de \u201cComo Automatizar la Tarjeta de Almac\u00e9n en Excel Con Tablas Din\u00e1micas\u201d.<\/p><p data-css=\"tve-u-1611feee98c\" style=\"text-align: justify;\">Una vez termines regresa nuevamente aqu\u00ed y continua con la segunda t\u00e9cnica.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h2 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-194709eb04d\">Automatizando una Tarjeta de Almac\u00e9n con el comando Subtotales en Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-1611ff14b59\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1611ff113e3\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1611ff113e6\" style=\"text-align: justify;\">Vamos a utilizar el mismo archivo que utilizamos en el Primer ejemplo de Como Automatizar la Tarjeta de Almac\u00e9n en Excel con Tablas Din\u00e1micas. <\/p><p data-css=\"tve-u-1611ff113e6\" style=\"text-align: justify;\">A continuaci\u00f3n te dejo el enlace de Descarga:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194709f73f5\" style=\"\" id=\"descarga\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-194709f73f6\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194709f73f3\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-194709f73f4\" style=\"--tcb-col-el-width: 645.938;\"><div class=\"tcb-flex-row v-2 tcb-resized tcb--cols--2\"><div class=\"tcb-flex-col\" data-css=\"tve-u-194709f73f0\" style=\"\"><div class=\"tcb-col\"><a href=\"https:\/\/aplicaexcelcontable.com\/go\/tarjeta-de-almacen-en-excel\" target=\"_blank\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-194709f73ef\" style=\"\" data-link-wrap=\"true\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 384 512\" data-id=\"icon-file-excel-solid\" data-name=\"\" style=\"\"><path d=\"M224 136V0H24C10.7 0 0 10.7 0 24v464c0 13.3 10.7 24 24 24h336c13.3 0 24-10.7 24-24V160H248c-13.2 0-24-10.8-24-24zm60.1 106.5L224 336l60.1 93.5c5.1 8-.6 18.5-10.1 18.5h-34.9c-4.4 0-8.5-2.4-10.6-6.3C208.9 405.5 192 373 192 373c-6.4 14.8-10 20-36.6 68.8-2.1 3.9-6.1 6.3-10.5 6.3H110c-9.5 0-15.2-10.5-10.1-18.5l60.3-93.5-60.3-93.5c-5.2-8 .6-18.5 10.1-18.5h34.8c4.4 0 8.5 2.4 10.6 6.3 26.1 48.8 20 33.6 36.6 68.5 0 0 6.1-11.7 36.6-68.5 2.1-3.9 6.2-6.3 10.6-6.3H274c9.5-.1 15.2 10.4 10.1 18.4zM384 121.9v6.1H256V0h6.1c6.4 0 12.5 2.5 17 7l97.9 98c4.5 4.5 7 10.6 7 16.9z\"><\/path><\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-194709f73f1\" style=\"\"><div class=\"tcb-col\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: center;\" data-css=\"tve-u-194709f73f2\"><a href=\"https:\/\/aplicaexcelcontable.com\/go\/tarjeta-de-almacen-en-excel\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo Excel<\/strong><\/em><\/a><\/p><\/div><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Pulsa clic en el enlace o bien en la imagen de Excel para descargar el archivo de practica para aprender Subtotales en Excel.<\/p><\/div><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root tve_evt_manager_listen tve_et_tve-viewport tve_ea_thrive_animation tve_anim_slide_right\" data-css=\"tve-u-194709f73f7\" style=\"\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_right&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-hand-point-up-solid\" data-name=\"\" style=\"\"><path d=\"M135.652 0c23.625 0 43.826 20.65 43.826 44.8v99.851c17.048-16.34 49.766-18.346 70.944 6.299 22.829-14.288 53.017-2.147 62.315 16.45C361.878 158.426 384 189.346 384 240c0 2.746-.203 13.276-.195 16 .168 61.971-31.065 76.894-38.315 123.731C343.683 391.404 333.599 400 321.786 400H150.261l-.001-.002c-18.366-.011-35.889-10.607-43.845-28.464C93.421 342.648 57.377 276.122 29.092 264 10.897 256.203.008 242.616 0 224c-.014-34.222 35.098-57.752 66.908-44.119 8.359 3.583 16.67 8.312 24.918 14.153V44.8c0-23.45 20.543-44.8 43.826-44.8zM136 416h192c13.255 0 24 10.745 24 24v48c0 13.255-10.745 24-24 24H136c-13.255 0-24-10.745-24-24v-48c0-13.255 10.745-24 24-24zm168 28c-11.046 0-20 8.954-20 20s8.954 20 20 20 20-8.954 20-20-8.954-20-20-20z\"><\/path><\/svg><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1611ff4668a\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1611ff4668e\" style=\"text-align: justify;\">Muy bien, considerando que ya has descargado el archivo, vamos a seguir los siguientes pasos para automatizar la tarjeta de Almac\u00e9n en Excel con el comando Subtotales:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-1611ff50de5\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\" data-css=\"tve-u-19470a1b01d\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1611ff4fa5d\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-19470a0d0c8\">Como primer paso, la Base de Datos debe estar alimentada, es decir debe de contener datos, en este caso puedes observar que ya le he agregado Datos en el archivo de ejemplo.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1611ff7f167\" data-clear=\"both\" style=\"\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"Subtotales en Excel\" width=\"618\" height=\"431\" title=\"Datos-en-la-Hoja-Base.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Datos-en-la-Hoja-Base.png\" data-width=\"618\" data-height=\"431\" data-init-width=\"618\" data-init-height=\"431\" style=\"aspect-ratio: auto 618 \/ 431;\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-1611ff8f560\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\" data-css=\"tve-u-19470a1cb8d\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1611ff8df79\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-19470a15ca9\">Vamos a Crear una copia de la Hoja Base, para eso pulsamos clic derecho sobre la pesta\u00f1a de la hoja Base, pulsamos clic en el comando Mover o Copiar.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1611ffa222d\" data-clear=\"both\" style=\"\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"Subtotales en Excel\" width=\"363\" height=\"293\" title=\"Mover-o-Copiar-Datos-en-Excel.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Mover-o-Copiar-Datos-en-Excel.png\" data-width=\"363\" data-height=\"293\" data-init-width=\"363\" data-init-height=\"293\" style=\"aspect-ratio: auto 363 \/ 293;\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-1611ffb8978\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1611ffb71a6\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-19470a1db33\">Se presenta una ventanita, en este seleccionamos con un Check la casilla crear una copia y pulsamos aceptar.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1611ffcd3d3\" data-clear=\"both\" style=\"\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image tcb-moved-image\" alt=\"Subtotales en Excel\" width=\"309\" height=\"291\" title=\"Crear-una-Copia-de-la-Hoja-Base.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Crear-una-Copia-de-la-Hoja-Base.png\" data-width=\"309\" data-height=\"291\" data-init-width=\"309\" data-init-height=\"291\" style=\"aspect-ratio: auto 309 \/ 291;\" data-css=\"tve-u-19470a2052d\"><\/span><\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\" data-css=\"tve-u-1611ffdaa43\"><h3 class=\"\" style=\"text-align: center;\">Para continuar<\/h3><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-css=\"tve-u-1611fff7187\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-19470a2ccc2\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1611fff5bd4\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-19470a29528\">Muy bien, ahora puedes observar una nueva Hoja llamada BASE (2), dentro de este vamos a seleccionar el siguiente rango, desde la A1: G20.<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-19470a2ccc2\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1612002db9a\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-19470a29528\">Ahora vamos a ordenarlo por C\u00f3digo, para eso nos ubicamos en la Pesta\u00f1a DATOS y pulsamos clic en el comando Ordenar.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1612004149d\" data-clear=\"both\" style=\"\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"Subtotales en Excel\" width=\"231\" height=\"129\" title=\"Comando-Ordenar.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Comando-Ordenar.png\" data-width=\"231\" data-height=\"129\" data-init-width=\"231\" data-init-height=\"129\" style=\"aspect-ratio: auto 231 \/ 129;\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-161200508bb\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1612004f24e\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\">Se presenta una ventana, dentro de este seleccionamos Ordenar por C\u00f3digo y pulsamos clic en Aceptar.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-16120062e1f\" data-clear=\"both\" style=\"\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"Subtotales en Excel\" width=\"623\" height=\"281\" title=\"Ordenando-por-Codigo.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Ordenando-por-Codigo.png\" data-width=\"623\" data-height=\"281\" data-init-width=\"623\" data-init-height=\"281\" style=\"aspect-ratio: auto 623 \/ 281;\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-css=\"tve-u-1612007a58a\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-16120078f2d\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\">Muy bien, ahora que ya hemos ordenado la Base, ahora vamos a crear el Subtotal de Cada C\u00f3digo.<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-16120078f37\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\">Desde la Pesta\u00f1a DATOS, pulsamos clic en el comando Subtotales, se presenta una ventana.<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1612008b5eb\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\">Dentro de este en la primera opci\u00f3n seleccionamos Codigos, o bien puedes seleccionar Productos para que te muestre el Nombre.<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1612008dc84\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\">En el segundo cuadro de opciones lo dejamos en suma.<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-1612008ede5\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\">En la tercera opci\u00f3n, marcamos con un check entrada y salida, para que las tres columnas de valores quede marcada. En la siguiente imagen puedes ver c\u00f3mo debe de quedar:<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1612009b320\" data-clear=\"both\" style=\"\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"Subtotales en Excel\" width=\"277\" height=\"341\" title=\"Configuracion-comando-Subtotales.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Configuracion-comando-Subtotales.png\" data-width=\"277\" data-height=\"341\" data-init-width=\"277\" data-init-height=\"341\" style=\"aspect-ratio: auto 277 \/ 341;\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-color=\"rgb(0, 0, 0)\" data-css=\"tve-u-161200acb65\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-19470a53c50\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-161200ab51b\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\">\n\n<path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path>\n<\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\">Si lo tienes asi, entonces pulsa clic en aceptar.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\"><h3 class=\"\">Listo!<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16120107ba7\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16120102817\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16120102819\" style=\"text-align: justify;\">Ya tenemos el resumen de cada C\u00f3digo, tenemos el movimiento de entrada, salida y Saldo de todo los c\u00f3digos equivalentes a Cada Tarjeta de Almac\u00e9n.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-161201216eb\" data-clear=\"both\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"Subtotales en Excel\" width=\"628\" height=\"527\" title=\"Automatizando-con-el-Comando-Subtotal.png\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/04\/Automatizando-con-el-Comando-Subtotal.png\" data-width=\"628\" data-height=\"527\" data-init-width=\"628\" data-init-height=\"527\" style=\"aspect-ratio: auto 628 \/ 527;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1612013d1f4\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1612013d1f7\" style=\"text-align: justify;\">Hasta aqu\u00ed con el tema de hoy, en el pr\u00f3ximo articulo voy a compartir la t\u00e9cnica n\u00famero 3 donde aprender\u00e1s \u201cComo Automatizar la Tarjeta de Almac\u00e9n con Formulas Excel\u201d.<\/p><p data-css=\"tve-u-1612013d1f7\" style=\"text-align: justify;\">\u00bfQue tal te pareci\u00f3 el articulo de hoy \" Subtotales en Excel para Automatizar Tarjetas de Almac\u00e9n\"?<\/p><p data-css=\"tve-u-1612013d1f7\" style=\"text-align: justify;\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por&nbsp;<a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" rel=\"noopener\" target=\"_blank\">Facebook<\/a>, a continuaci\u00f3n te dejo un bot\u00f3n para que puedas compartirlo:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-19470a66b09\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-device-config=\"{&quot;desktop&quot;:{&quot;isFullWidth&quot;:&quot;0&quot;},&quot;tablet&quot;:{},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-19470a66b08\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_itb\">\n\t\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_fb_share tve_share_item\" data-s=\"fb_share\" data-href=\"{tcb_post_url}\" data-label=\"Compartir\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 264 512\" data-id=\"icon-fb\" data-name=\"\">\n            <path d=\"M76.7 512V283H0v-91h76.7v-71.7C76.7 42.4 124.3 0 193.8 0c33.3 0 61.9 2.5 70.2 3.6V85h-48.2c-37.8 0-45.1 18-45.1 44.3V192H256l-11.7 91h-73.6v229\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Compartir<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_t_share tve_share_item\" data-s=\"t_share\" data-href=\"{tcb_post_url}\" data-label=\"Tweet\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-t\" data-name=\"\">\n            <path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text tve-froala\">Tweet<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_pin_share tve_share_item\" data-s=\"pin_share\" data-href=\"{tcb_post_url}\" data-label=\"Pin\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-pin\" data-name=\"\">\n            <path d=\"M204 6.5C101.4 6.5 0 74.9 0 185.6 0 256 39.6 296 63.6 296c9.9 0 15.6-27.6 15.6-35.4 0-9.3-23.7-29.1-23.7-67.8 0-80.4 61.2-137.4 140.4-137.4 68.1 0 118.5 38.7 118.5 109.8 0 53.1-21.3 152.7-90.3 152.7-24.9 0-46.2-18-46.2-43.8 0-37.8 26.4-74.4 26.4-113.4 0-66.2-93.9-54.2-93.9 25.8 0 16.8 2.1 35.4 9.6 50.7-13.8 59.4-42 147.9-42 209.1 0 18.9 2.7 37.5 4.5 56.4 3.4 3.8 1.7 3.4 6.9 1.5 50.4-69 48.6-82.5 71.4-172.8 12.3 23.4 44.1 36 69.3 36 106.2 0 153.9-103.5 153.9-196.8C384 71.3 298.2 6.5 204 6.5z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Pin<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1612017772c\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1612017772f\" style=\"text-align: justify;\">Tambi\u00e9n, puedes seguirnos en Youtube, para recibir el acceso a todos los videos que publicamos semanalmente:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-1612017d081\"><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-1612017d086\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1612017d084\"><div class=\"thrv_wrapper thrv_text_element\"><h1 data-css=\"tve-u-1612017d08d\" class=\"\"><strong>S\u00edguenos en:<\/strong><\/h1><\/div><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-1612017d083\" style=\"--tcb-col-el-width: 206;\"><div class=\"tcb-flex-row tcb--cols--2 tcb-resized\"><div class=\"tcb-flex-col\" data-css=\"tve-u-1612017d088\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-1612017d091\"><a href=\"https:\/\/www.facebook.com\/aplicaexcecontable\" target=\"_blank\" rel=\" \" class=\"tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display\" data-css=\"tve-u-1612017d08c\" data-link-wrap=\"1\"><svg class=\"tcb-icon\" viewBox=\"0 0 24 28\" data-name=\"facebook-official\">\n<path d=\"M22.672 2c0.734 0 1.328 0.594 1.328 1.328v21.344c0 0.734-0.594 1.328-1.328 1.328h-6.109v-9.297h3.109l0.469-3.625h-3.578v-2.312c0-1.047 0.281-1.75 1.797-1.75l1.906-0.016v-3.234c-0.328-0.047-1.469-0.141-2.781-0.141-2.766 0-4.672 1.687-4.672 4.781v2.672h-3.125v3.625h3.125v9.297h-11.484c-0.734 0-1.328-0.594-1.328-1.328v-21.344c0-0.734 0.594-1.328 1.328-1.328h21.344z\"><\/path>\n<\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-1612017d087\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-1612017d090\"><a href=\"http:\/\/www.youtube.com\/user\/excelycontabilidad?sub_confirmation=1\" target=\"_blank\" rel=\" \" class=\"tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tve_evt_manager_listen tve_et_tve-viewport tve_ea_thrive_animation tve_anim_rotate\" data-css=\"tve-u-1612017d089\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;rotate&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\" data-link-wrap=\"1\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 24 28\" data-name=\"youtube\">\n<path d=\"M15.172 19.437v3.297c0 0.703-0.203 1.047-0.609 1.047-0.234 0-0.469-0.109-0.703-0.344v-4.703c0.234-0.234 0.469-0.344 0.703-0.344 0.406 0 0.609 0.359 0.609 1.047zM20.453 19.453v0.719h-1.406v-0.719c0-0.703 0.234-1.062 0.703-1.062s0.703 0.359 0.703 1.062zM5.359 16.047h1.672v-1.469h-4.875v1.469h1.641v8.891h1.563v-8.891zM9.859 24.938h1.391v-7.719h-1.391v5.906c-0.313 0.438-0.609 0.656-0.891 0.656-0.187 0-0.297-0.109-0.328-0.328-0.016-0.047-0.016-0.219-0.016-0.547v-5.688h-1.391v6.109c0 0.547 0.047 0.906 0.125 1.141 0.125 0.391 0.453 0.578 0.906 0.578 0.5 0 1.031-0.313 1.594-0.953v0.844zM16.562 22.625v-3.078c0-0.719-0.031-1.234-0.141-1.547-0.172-0.578-0.562-0.875-1.109-0.875-0.516 0-1 0.281-1.453 0.844v-3.391h-1.391v10.359h1.391v-0.75c0.469 0.578 0.953 0.859 1.453 0.859 0.547 0 0.938-0.297 1.109-0.859 0.109-0.328 0.141-0.844 0.141-1.563zM21.844 22.469v-0.203h-1.422c0 0.562-0.016 0.875-0.031 0.953-0.078 0.375-0.281 0.562-0.625 0.562-0.484 0-0.719-0.359-0.719-1.078v-1.359h2.797v-1.609c0-0.828-0.141-1.422-0.422-1.813-0.406-0.531-0.953-0.797-1.656-0.797-0.719 0-1.266 0.266-1.672 0.797-0.297 0.391-0.438 0.984-0.438 1.813v2.703c0 0.828 0.156 1.437 0.453 1.813 0.406 0.531 0.953 0.797 1.687 0.797s1.313-0.281 1.687-0.828c0.172-0.25 0.297-0.531 0.328-0.844 0.031-0.141 0.031-0.453 0.031-0.906zM12.344 8.203v-3.281c0-0.719-0.203-1.078-0.672-1.078-0.453 0-0.672 0.359-0.672 1.078v3.281c0 0.719 0.219 1.094 0.672 1.094 0.469 0 0.672-0.375 0.672-1.094zM23.578 19.938c0 1.797-0.016 3.719-0.406 5.469-0.297 1.234-1.297 2.141-2.5 2.266-2.875 0.328-5.781 0.328-8.672 0.328s-5.797 0-8.672-0.328c-1.203-0.125-2.219-1.031-2.5-2.266-0.406-1.75-0.406-3.672-0.406-5.469v0c0-1.813 0.016-3.719 0.406-5.469 0.297-1.234 1.297-2.141 2.516-2.281 2.859-0.313 5.766-0.313 8.656-0.313s5.797 0 8.672 0.313c1.203 0.141 2.219 1.047 2.5 2.281 0.406 1.75 0.406 3.656 0.406 5.469zM7.984 0h1.594l-1.891 6.234v4.234h-1.563v-4.234c-0.141-0.766-0.453-1.859-0.953-3.313-0.344-0.969-0.688-1.953-1.016-2.922h1.656l1.109 4.109zM13.766 5.203v2.734c0 0.828-0.141 1.453-0.438 1.844-0.391 0.531-0.938 0.797-1.656 0.797-0.703 0-1.25-0.266-1.641-0.797-0.297-0.406-0.438-1.016-0.438-1.844v-2.734c0-0.828 0.141-1.437 0.438-1.828 0.391-0.531 0.938-0.797 1.641-0.797 0.719 0 1.266 0.266 1.656 0.797 0.297 0.391 0.438 1 0.438 1.828zM19 2.672v7.797h-1.422v-0.859c-0.562 0.656-1.094 0.969-1.609 0.969-0.453 0-0.781-0.187-0.922-0.578-0.078-0.234-0.125-0.609-0.125-1.172v-6.156h1.422v5.734c0 0.328 0 0.516 0.016 0.547 0.031 0.219 0.141 0.344 0.328 0.344 0.281 0 0.578-0.219 0.891-0.672v-5.953h1.422z\"><\/path>\n<\/svg><\/div><\/a><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_icon tcb-icon-display tve_evt_manager_listen tve_et_tve-viewport tve_ea_thrive_animation tve_anim_slide_bottom\" data-css=\"tve-u-1612017d08e\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_bottom&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 26 28\" data-name=\"hand-pointer-o\">\n<path d=\"M10 2c-1.109 0-2 0.891-2 2v14l-2.359-3.156c-0.391-0.516-1.016-0.844-1.672-0.844-1.094 0-1.969 0.922-1.969 2 0 0.438 0.141 0.859 0.406 1.203l6 8c0.375 0.5 0.969 0.797 1.594 0.797h11.219c0.453 0 0.859-0.313 0.969-0.75l1.437-5.75c0.25-1 0.375-2.016 0.375-3.031v-3.391c0-0.828-0.641-1.578-1.5-1.578-0.828 0-1.5 0.672-1.5 1.5h-0.5v-0.953c0-0.984-0.75-1.797-1.75-1.797-0.969 0-1.75 0.781-1.75 1.75v1h-0.5v-1.406c0-1.125-0.859-2.094-2-2.094-1.109 0-2 0.891-2 2v1.5h-0.5v-8.906c0-1.125-0.859-2.094-2-2.094zM10 0c2.234 0 4 1.875 4 4.094v3.437c0.172-0.016 0.328-0.031 0.5-0.031 1.016 0 1.969 0.391 2.703 1.078 0.484-0.219 1.016-0.328 1.547-0.328 1.125 0 2.172 0.5 2.875 1.359 0.297-0.078 0.578-0.109 0.875-0.109 1.969 0 3.5 1.641 3.5 3.578v3.391c0 1.172-0.141 2.359-0.438 3.516l-1.437 5.75c-0.328 1.328-1.531 2.266-2.906 2.266h-11.219c-1.25 0-2.453-0.609-3.203-1.594l-6-8c-0.516-0.688-0.797-1.547-0.797-2.406 0-2.188 1.781-4 3.969-4 0.719 0 1.422 0.187 2.031 0.547v-8.547c0-2.203 1.797-4 4-4zM12 22v-6h-0.5v6h0.5zM16 22v-6h-0.5v6h0.5zM20 22v-6h-0.5v6h0.5z\"><\/path>\n<\/svg><\/div><\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19470a88106\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19470a88104\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19470a88107\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19470a88108\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-19470a88109\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-19470a8810a\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-19470a8810b\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-161201216eb\"] + div { clear: both; }[data-css=\"tve-u-161201216eb\"] { width: 628px; float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-16120107ba7\"] { margin-top: 2px !important; }:not(#tve) [data-css=\"tve-u-161200acb65\"] p, :not(#tve) [data-css=\"tve-u-161200acb65\"] li, :not(#tve) [data-css=\"tve-u-161200acb65\"] blockquote, :not(#tve) [data-css=\"tve-u-161200acb65\"] address, :not(#tve) [data-css=\"tve-u-161200acb65\"] h1, :not(#tve) [data-css=\"tve-u-161200acb65\"] h2, :not(#tve) [data-css=\"tve-u-161200acb65\"] h3, :not(#tve) [data-css=\"tve-u-161200acb65\"] h4, :not(#tve) [data-css=\"tve-u-161200acb65\"] h5, :not(#tve) [data-css=\"tve-u-161200acb65\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-161200ab51b\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612009b320\"] + div { clear: both; }[data-css=\"tve-u-1612009b320\"] { width: 277px; float: none; margin-left: auto !important; margin-right: auto !important; margin-top: 10px !important; }:not(#tve) [data-css=\"tve-u-1612007a58a\"] p, :not(#tve) [data-css=\"tve-u-1612007a58a\"] li, :not(#tve) [data-css=\"tve-u-1612007a58a\"] blockquote, :not(#tve) [data-css=\"tve-u-1612007a58a\"] address, :not(#tve) [data-css=\"tve-u-1612007a58a\"] h1, :not(#tve) [data-css=\"tve-u-1612007a58a\"] h2, :not(#tve) [data-css=\"tve-u-1612007a58a\"] h3, :not(#tve) [data-css=\"tve-u-1612007a58a\"] h4, :not(#tve) [data-css=\"tve-u-1612007a58a\"] h5, :not(#tve) [data-css=\"tve-u-1612007a58a\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-16120078f37\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-16120078f2d\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-16120062e1f\"] + div { clear: both; }[data-css=\"tve-u-16120062e1f\"] { width: 623px; float: none; margin-left: auto !important; margin-right: auto !important; margin-top: 10px !important; }:not(#tve) [data-css=\"tve-u-161200508bb\"] p, :not(#tve) [data-css=\"tve-u-161200508bb\"] li, :not(#tve) [data-css=\"tve-u-161200508bb\"] blockquote, :not(#tve) [data-css=\"tve-u-161200508bb\"] address, :not(#tve) [data-css=\"tve-u-161200508bb\"] h1, :not(#tve) [data-css=\"tve-u-161200508bb\"] h2, :not(#tve) [data-css=\"tve-u-161200508bb\"] h3, :not(#tve) [data-css=\"tve-u-161200508bb\"] h4, :not(#tve) [data-css=\"tve-u-161200508bb\"] h5, :not(#tve) [data-css=\"tve-u-161200508bb\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612004f24e\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1612004149d\"] + div { clear: both; }[data-css=\"tve-u-1612004149d\"] { width: 231px; float: none; margin: 10px auto !important; }[data-css=\"tve-u-1611fff7187\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-1611fff7187\"] p, :not(#tve) [data-css=\"tve-u-1611fff7187\"] li, :not(#tve) [data-css=\"tve-u-1611fff7187\"] blockquote, :not(#tve) [data-css=\"tve-u-1611fff7187\"] address, :not(#tve) [data-css=\"tve-u-1611fff7187\"] h1, :not(#tve) [data-css=\"tve-u-1611fff7187\"] h2, :not(#tve) [data-css=\"tve-u-1611fff7187\"] h3, :not(#tve) [data-css=\"tve-u-1611fff7187\"] h4, :not(#tve) [data-css=\"tve-u-1611fff7187\"] h5, :not(#tve) [data-css=\"tve-u-1611fff7187\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1611fff5bd4\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1611ffdaa43\"] { margin-top: 35px !important; }[data-css=\"tve-u-1611ffcd3d3\"] + div { clear: both; }[data-css=\"tve-u-1611ffcd3d3\"] { width: 309px; float: none; margin-left: auto !important; margin-right: auto !important; margin-top: 10px !important; }:not(#tve) [data-css=\"tve-u-1611ffb8978\"] p, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] li, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] blockquote, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] address, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] h1, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] h2, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] h3, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] h4, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] h5, :not(#tve) [data-css=\"tve-u-1611ffb8978\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1611ffb71a6\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1611ffa222d\"] + div { clear: both; }[data-css=\"tve-u-1611ffa222d\"] { width: 363px; float: none; margin-left: auto !important; margin-right: auto !important; margin-top: 10px !important; }:not(#tve) [data-css=\"tve-u-1611ff8f560\"] p, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] li, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] blockquote, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] address, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] h1, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] h2, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] h3, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] h4, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] h5, :not(#tve) [data-css=\"tve-u-1611ff8f560\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1611ff8df79\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1611ff7f167\"] + div { clear: both; }[data-css=\"tve-u-1611ff7f167\"] { width: 618px; float: none; margin-left: auto !important; margin-right: auto !important; margin-top: 10px !important; }[data-css=\"tve-u-1611ff6e30a\"] { color: rgb(0, 23, 255) !important; }[data-css=\"tve-u-1611ff50de5\"] { margin-top: -10px !important; --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-1611ff50de5\"] p, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] li, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] blockquote, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] address, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] h1, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] h2, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] h3, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] h4, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] h5, :not(#tve) [data-css=\"tve-u-1611ff50de5\"] h6 { color: rgb(0, 0, 0); }[data-css=\"tve-u-1611ff4fa5d\"] { color: rgb(0, 0, 0); }[data-css=\"tve-u-1611ff14b59\"] { margin-top: 5px !important; }[data-css=\"tve-u-1611fef42d8\"] { margin-top: 5px !important; }[data-css=\"tve-u-1611fed859b\"] { margin-top: -1px !important; }:not(#tve) [data-css=\"tve-u-1611fb7f94e\"] { color: rgb(255, 0, 0) !important; font-size: 42px !important; }[data-css=\"tve-u-1611fb99404\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1611fb99406\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1611feee98a\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1611feee98c\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1611ff113e3\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1611ff113e6\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1611ff4668a\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1611ff4668e\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-16120102817\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-16120102819\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1612013d1f4\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1612013d1f7\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1612017772c\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1612017772f\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1612017d081\"]::after { clear: both; }[data-css=\"tve-u-1612017d083\"] { margin-top: -55px !important; }[data-css=\"tve-u-1612017d084\"] { min-height: 1px; }[data-css=\"tve-u-1612017d086\"] { max-width: 208px; float: right; z-index: 3; position: relative; width: 100%; margin-top: 5px !important; }[data-css=\"tve-u-1612017d087\"] { max-width: 81.3%; }[data-css=\"tve-u-1612017d088\"] { max-width: 18.7%; }:not(#tve) [data-css=\"tve-u-1612017d089\"] > :first-child { color: rgb(191, 20, 20); }:not(#tve) [data-css=\"tve-u-1612017d08c\"] > :first-child { color: rgb(60, 18, 215); }:not(#tve) [data-css=\"tve-u-1612017d08d\"] { font-size: 26px !important; color: rgb(3, 77, 44) !important; }[data-css=\"tve-u-1612017d08e\"] { font-size: 60px; margin-top: -48px !important; }[data-css=\"tve-u-1612017d08c\"] { font-size: 60px; }[data-css=\"tve-u-1612017d089\"] { font-size: 60px; margin-right: 65px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1611fb99404\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611fb99404\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611fb99404\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611fb99404\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611fb99404\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611fb99404\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1611fb99404\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1611feee98a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611feee98a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611feee98a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611feee98a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611feee98a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611feee98a\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1611feee98a\"] { --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-194709eb04d\"] { text-transform: none !important; }:not(#tve) [data-css=\"tve-u-194709ecf44\"] { text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff113e3\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff113e3\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff113e3\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff113e3\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff113e3\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff113e3\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1611ff113e3\"] { --tve-font-size: 20px; }[data-css=\"tve-u-194709f73ef\"] { font-size: 84px; margin-left: auto; margin-right: auto; --tcb-local-color-icon: rgb(4,228,38); --tcb-local-color-var: rgb(4,228,38); --tve-icon-size: 84px; --tcb-icon-rotation-angle: -22deg; width: 84px; height: 84px; }:not(#tve) [data-css=\"tve-u-194709f73ef\"] > :first-child { color: rgb(4, 228, 38); --tve-applied-color: rgb(4,228,38); }[data-css=\"tve-u-194709f73f0\"] { max-width: 18.1%; }[data-css=\"tve-u-194709f73f1\"] { max-width: 81.9%; }:not(#tve) [data-css=\"tve-u-194709f73f2\"] { font-size: 21px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194709f73f3\"] h6 { color: var(--tve-color,rgb(0,3,6)); --tve-applied-color: var$(--tve-color,rgb(0,3,6)); --tcb-applied-color: rgb(0,3,6); }[data-css=\"tve-u-194709f73f3\"] { --tve-color: rgb(0,3,6); --tve-applied---tve-color: rgb(0,3,6); text-align: justify; }[data-css=\"tve-u-194709f73f3\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-194709f73f4\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-194709f73f5\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-194709f73f6\"] { --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; border: 6px dashed rgb(234, 194, 13) !important; --tve-applied-border: 6px dashed rgb(234,194,13) !important; }[data-css=\"tve-u-194709f73f7\"] { font-size: 60px; --tcb-local-color-icon: rgb(227,12,38); --tcb-local-color-var: rgb(227,12,38); --tve-icon-size: 60px; float: none; z-index: 3; position: relative; --tve-alignment: center; margin: -109px auto 0px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-194709f73f7\"] > :first-child { color: rgb(227, 12, 38); --tve-applied-color: rgb(227,12,38); }:not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff4668a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff4668a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff4668a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff4668a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff4668a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1611ff4668a\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1611ff4668a\"] { --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-1611ff50de5\"] li { font-size: var(--tve-font-size,20px) !important; }:not(#tve) [data-css=\"tve-u-1611ff8f560\"] li { font-size: var(--tve-font-size,20px) !important; }[data-css=\"tve-u-1611ff8f560\"] { --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-1611ffb8978\"] li { font-size: var(--tve-font-size,20px) !important; }[data-css=\"tve-u-1611ffb8978\"] { --tve-font-size: 20px; padding-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-161200508bb\"] li { font-size: var(--tve-font-size,20px) !important; }[data-css=\"tve-u-161200508bb\"] { --tve-font-size: 20px; padding-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-1612007a58a\"] li { font-size: var(--tve-font-size,20px) !important; }[data-css=\"tve-u-1612007a58a\"] { --tve-font-size: 20px; padding-bottom: 0px !important; }[data-css=\"tve-u-161200acb65\"] { padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1612013d1f4\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612013d1f4\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612013d1f4\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612013d1f4\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612013d1f4\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612013d1f4\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1612013d1f4\"] { --tve-font-size: 20px; }[data-css=\"tve-u-19470a66b08\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-19470a66b09\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1612017772c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612017772c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612017772c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612017772c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612017772c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1612017772c\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1612017772c\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19470a88104\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19470a88104\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19470a88104\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19470a88106\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-19470a88107\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-19470a88108\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-19470a88109\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-19470a8810a\"] { --tcb-text-highlight-color: rgb(30,184,76) !important; }[data-css=\"tve-u-19470a8810b\"] { --tcb-text-highlight-color: transparent !important; }}@media (max-width: 767px){[data-css=\"tve-u-1612017d08e\"] { margin-left: 136px !important; }[data-css=\"tve-u-1612017d090\"] { margin-left: 128px !important; padding-left: 1px !important; margin-right: -51px !important; margin-top: -96px !important; }[data-css=\"tve-u-1612017d091\"] { margin-left: -16px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[157,166,165,7680,7681,156],"class_list":["post-18136","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-y-contabilidad","tag-almacen-en-excel","tag-comando-subtotales","tag-subtotales","tag-subtotales-en-excel","tag-subtotales-excel","tag-tarjeta-de-almacen","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/18136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=18136"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/18136\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/61399"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=18136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=18136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=18136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}