{"id":1865,"date":"2013-10-21T07:14:18","date_gmt":"2013-10-21T13:14:18","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=1865"},"modified":"2024-12-19T11:29:53","modified_gmt":"2024-12-19T17:29:53","slug":"contabilidad-en-excel11-tema12","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/contabilidad-en-excel11-tema12.html","title":{"rendered":"Dise\u00f1ando Tu Contabilidad en Excel \u2013 Tema12"},"content":{"rendered":"<h1 style=\"text-align: center;\">Creando una Macro para la Hoja Diario de tu contabilidad en excel11<\/h1>\n<p style=\"\">Comencemos con el articulo <strong>Creando una Macro para la Hoja Diario de tu contabilidad en excel11.<\/strong> Pero antes que nada te invito a que leas el articulo anterior, para eso tan solo pulsa clic en el bot\u00f3n:<\/p>\n<p style=\"\">Hemos avanzado el 70% y estamos apunto de entrar en una etapa bien importante, pero antes cu\u00e9ntame como te fue con el tema 11 lograste aplicar todo el contenido?<\/p>\n<p style=\"\">Antes de entrar de lleno a la programaci\u00f3n, vamos a crear una macro que nos ayude a borrar el contenido del Libro Diario. Esta macro lo vamos a utilizar solamente para cierre de periodo. Bien comencemos entonces:<\/p>\n<h2 style=\"text-align: center;\">Creando Macros para la Hoja Diario de tu contabilidad en excel11<\/h2>\n<p style=\"\">Vamos a crear una macro que nos ayude a limpiar los datos contenidos en el Libro Diario. Esta macro se utilizara solamente en los cierres de periodo.<\/p>\n<p style=\"\"><strong>Por ejemplo:<\/strong> Lo recomendable es, cada vez que se hace el cierre de periodo, se debe crear una copia del archivo, digamos si el archivo se llama \u00abRegistros 2012\u00bb entonces creamos otro que se llame \u00abRegistros 2013\u00bb.&nbsp;<\/p>\n<p style=\"\">Entonces el cierre de Periodo se Ejecuta en el archivo Registros 2012 una vez termines de hacer el cierre, abres el archivo Registros 2013 y ejecutas la macro y listo tienes un libro nuevo para un periodo nuevo, solo copiamos los saldos finales del a\u00f1o 2012 como saldo inicial en el libro 2013 y listo siempre en marcha con tu contabilidad.<\/p>\n<p style=\"\">Vamos a crear esta macro de la forma m\u00e1s f\u00e1cil, sigue los siguientes pasos:<\/p>\n<ul>\n<li style=\"\"><span>Entra a VBA (Alt + F11)<\/span><\/li>\n<li style=\"\"><span>Insertamos un Modulo<\/span><\/li>\n<li style=\"\"><span>Copiamos el siguiente c\u00f3digo tal a como esta dentro del modulo:<\/span><\/li>\n<\/ul>\n<p style=\"\">Sub DIARIO()<\/p>\n<p style=\"\">&#8216;<\/p>\n<p style=\"\">&#8216; ESTA MACRO LIMPIA EL CONTENIDO DEL DIARIO<\/p>\n<p style=\"\">&nbsp; &nbsp; Range(\u00abA2:L1000\u00bb).Select<\/p>\n<p style=\"\">&nbsp; &nbsp; Selection.ClearContents<\/p>\n<p style=\"\">&nbsp; &nbsp; Range(\u00abA12\u00bb).Select<\/p>\n<p style=\"\">End Sub<\/p>\n<ul>\n<li style=\"\"><span>Guardamos la informaci\u00f3n y cerramos VBA.<\/span><\/li>\n<li style=\"\"><span>Nos ubicamos en la Hola DIARIO y pulsamos clic derecho sobre el bot\u00f3n NUEVO DIARIO, seleccionamos asignar macro, se abre una nueva ventana y seleccionamos la macro llamada DIARIO y pulsamos aceptar.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: center;\">Ejemplo de la Imagen<\/h3>\n<p><span><img decoding=\"async\" alt=\"contabilidad en excel11\" data-id=\"57704\" width=\"407\" data-init-width=\"407\" height=\"248\" data-init-height=\"248\" title=\"Asignar Macros\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/01\/Asignar-Macros.png\" data-width=\"407\" data-height=\"248\" style=\"aspect-ratio: auto 407 \/ 248;\"><\/span><span><img decoding=\"async\" alt=\"contabilidad en excel11\" data-id=\"57705\" width=\"409\" data-init-width=\"409\" height=\"383\" data-init-height=\"383\" title=\"Asignar Macros 2\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/01\/Asignar-Macros-2.png\" data-width=\"409\" data-height=\"383\" style=\"aspect-ratio: auto 409 \/ 383;\"><\/span><\/p>\n<p style=\"\">Muy bien, ahora te pido que tomes acci\u00f3n, que tal si empiezas a crear tu macro ahora.. no te quedes atr\u00e1s, en los pr\u00f3ximos temas empezaremos a programar tu sistema contable.<\/p>\n<p style=\"\">Si tienes dudas o preguntas no dudes en contactarnos por la sala de chat. Si no estamos en linea solo escr\u00edbenos tu mensaje y te contestaremos en menos de 4 Horas.<\/p>\n<p style=\"\">Si te gusto el tema de hoy, comp\u00e1rtelo con tus amigos de Facebook, pulsando clic en compartir:<\/p>\n<p style=\"\">Y si aun no estas suscrito en nuestro canal, tan solo pulsa clic en el bot\u00f3n rojo para acceder a todos los v\u00eddeos nuevos que subimos cada semana:<\/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<h4 style=\"\">Para Finalizar:<\/h4>\n<p style=\"\">Me gustar\u00eda saber que piensas de este articulo \u00abPlantillas Excel &#8211; Creando una Macro para la Hoja Diario\u00bb, por lo tanto, d\u00e9jame tu comentario con dudas, criticas constructivas y sugerencias.<\/p>\n<p style=\"\">Hasta aqu\u00ed hemos llegado con este articulo, para continuar con el siguiente articulo, tan solo pulsa clic en el bot\u00f3n:<\/p>\n<p>Cualquier duda o pregunta, tan solo escribeme en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\">pagina del chat<\/a> o bien enviame un correo a rogerperez@aplicaexcelcontable.com<\/p>\n<p>Te saluda tu amigo,<\/p>\n<p><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n<p>Creador del Curso \u2013 <a href=\"https:\/\/aplicaexcelcontable.com\/Alumnos\/aplica-excel-contable\" target=\"_blank\" style=\"outline: none;\">Aplica Excel Contable<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creando una Macro para la Hoja Diario de tu contabilidad en excel11 Comencemos con el articulo Creando una Macro para la Hoja Diario de tu contabilidad en excel11. Pero antes que nada te invito a que leas el articulo anterior, para eso tan solo pulsa clic en el bot\u00f3n: Hemos avanzado el 70% y estamos [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":57704,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18cea37b986\" style=\"\"><h1 style=\"text-align: center;\" data-css=\"tve-u-18cea1769db\" class=\"\">Creando una Macro para la Hoja Diario de tu contabilidad en excel11<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18cea188918\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18cea188905\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Comencemos con el articulo <strong>Creando una Macro para la Hoja Diario de tu contabilidad en excel11.<\/strong> Pero antes que nada te invito a que leas el articulo anterior, para eso tan solo pulsa clic en el bot\u00f3n:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18cea209613\" style=\"\" data-button-size-d=\"m\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"rgb(0, 15, 255)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/plantillas-excel-disenando-tu-contabilidad-en-excel-tema11.html\" class=\"tcb-button-link tcb-plain-text\" style=\"\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\"><strong><span style=\"font-size: 20px !important;\" data-css=\"tve-u-18cea209615\">Pulsa clic aqu\u00ed P\/Ver el Tema 11 \u2192<\/span> <\/strong><\/span><\/span>\n\t<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18cea188918\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18cea188905\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Hemos avanzado el 70% y estamos apunto de entrar en una etapa bien importante, pero antes cu\u00e9ntame como te fue con el tema 11 lograste aplicar todo el contenido?<\/p><p style=\"\">Antes de entrar de lleno a la programaci\u00f3n, vamos a crear una macro que nos ayude a borrar el contenido del Libro Diario. Esta macro lo vamos a utilizar solamente para cierre de periodo. Bien comencemos entonces:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18cead9120d\" style=\"\"><h2 style=\"text-align: center;\" data-css=\"tve-u-18cea2ae56b\" class=\"\">Creando Macros para la Hoja Diario de tu contabilidad en excel11<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18cea2bd408\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18cea2bd3f1\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Vamos a crear una macro que nos ayude a limpiar los datos contenidos en el Libro Diario. Esta macro se utilizara solamente en los cierres de periodo.<\/p><p style=\"\"><strong>Por ejemplo:<\/strong> Lo recomendable es, cada vez que se hace el cierre de periodo, se debe crear una copia del archivo, digamos si el archivo se llama \"Registros 2012\" entonces creamos otro que se llame \"Registros 2013\".&nbsp;<\/p><p style=\"\">Entonces el cierre de Periodo se Ejecuta en el archivo Registros 2012 una vez termines de hacer el cierre, abres el archivo Registros 2013 y ejecutas la macro y listo tienes un libro nuevo para un periodo nuevo, solo copiamos los saldos finales del a\u00f1o 2012 como saldo inicial en el libro 2013 y listo siempre en marcha con tu contabilidad.<\/p><p style=\"\">Vamos a crear esta macro de la forma m\u00e1s f\u00e1cil, sigue los siguientes pasos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18cea33c1c9\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><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><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18cea33c1d5\"><div style=\"text-align: justify;\">Entra a VBA (Alt + F11)<\/div><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18cea33c1dd\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><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><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18cea33c1e7\"><div style=\"text-align: justify;\">Insertamos un Modulo<\/div><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18cea33c1ef\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><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><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18cea33c1f8\"><div style=\"text-align: justify;\">Copiamos el siguiente c\u00f3digo tal a como esta dentro del modulo:<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18cea3287af\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18cea328799\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Sub DIARIO()<\/p><p style=\"\">'<\/p><p style=\"\">' ESTA MACRO LIMPIA EL CONTENIDO DEL DIARIO<\/p><p style=\"\">&nbsp; &nbsp; Range(\"A2:L1000\").Select<\/p><p style=\"\">&nbsp; &nbsp; Selection.ClearContents<\/p><p style=\"\">&nbsp; &nbsp; Range(\"A12\").Select<\/p><p style=\"\">End Sub<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18cea3232bf\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><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><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18cea3118dc\">Guardamos la informaci\u00f3n y cerramos VBA.<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18cea3232bf\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><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><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18cea3118dc\"><div style=\"text-align: justify;\">Nos ubicamos en la Hola DIARIO y pulsamos clic derecho sobre el bot\u00f3n NUEVO DIARIO, seleccionamos asignar macro, se abre una nueva ventana y seleccionamos la macro llamada DIARIO y pulsamos aceptar.<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18cead8ed4c\" style=\"\"><h3 style=\"text-align: center;\" data-css=\"tve-u-18cead88e93\" class=\"\">Ejemplo de la Imagen<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18ceadac282\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-57704\" alt=\"contabilidad en excel11\" data-id=\"57704\" width=\"407\" data-init-width=\"407\" height=\"248\" data-init-height=\"248\" title=\"Asignar Macros\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/01\/Asignar-Macros.png\" data-width=\"407\" data-height=\"248\" style=\"aspect-ratio: auto 407 \/ 248;\"><\/span><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18ceadd87a6\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-57705\" alt=\"contabilidad en excel11\" data-id=\"57705\" width=\"409\" data-init-width=\"409\" height=\"383\" data-init-height=\"383\" title=\"Asignar Macros 2\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/01\/Asignar-Macros-2.png\" data-width=\"409\" data-height=\"383\" style=\"aspect-ratio: auto 409 \/ 383;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18ceadf2419\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18ceadf23fe\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Muy bien, ahora te pido que tomes acci\u00f3n, que tal si empiezas a crear tu macro ahora.. no te quedes atr\u00e1s, en los pr\u00f3ximos temas empezaremos a programar tu sistema contable.<\/p><p style=\"\">Si tienes dudas o preguntas no dudes en contactarnos por la sala de chat. Si no estamos en linea solo escr\u00edbenos tu mensaje y te contestaremos en menos de 4 Horas.<\/p><p style=\"\">Si te gusto el tema de hoy, comp\u00e1rtelo con tus amigos de Facebook, pulsando clic en compartir:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social tve_share_left\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-18ceaeca219\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb tve-prevent-content-edit\">\n<div class=\"tve_s_item tve_s_fb_share thrv_wrapper tve_share_item\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/sistema-de-facturacion-en-excel.html\" data-label=\"Compartir\" data-css=\"tve-u-18be2dd4a6b\">\n<a href=\"javascript:void(0)\" class=\"tve_s_link\"><span class=\"tve_s_icon thrv-svg-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"tcb-facebook\" viewBox=\"0 0 16 28\"><path d=\"M14.984 0.187v4.125h-2.453q-1.344 0-1.813 0.562t-0.469 1.687v2.953h4.578l-0.609 4.625h-3.969v11.859h-4.781v-11.859h-3.984v-4.625h3.984v-3.406q0-2.906 1.625-4.508t4.328-1.602q2.297 0 3.563 0.187z\"><\/path><\/svg><\/span><span class=\"tve_s_text\">Compartir<\/span><span class=\"tve_s_count\">0<\/span><\/a>\n<\/div>\n<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18ceadf2419\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18ceadf23fe\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Y si aun no estas suscrito en nuestro canal, tan solo pulsa clic en el bot\u00f3n rojo para acceder a todos los v\u00eddeos nuevos que subimos cada semana:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-18ceaed4b87\" style=\"\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-18ceaed4b85\"><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\" style=\"\" data-css=\"tve-u-18ceaed4b90\"><h1 data-css=\"tve-u-18ceaed4b8d\" class=\"\"><strong>S\u00edguenos en:<\/strong><\/h1><\/div><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-18ceaed4b84\" style=\"--tcb-col-el-width: 181;\"><div class=\"tcb-flex-row tcb--cols--2 tcb-resized\" style=\"\" data-css=\"tve-u-18ceaed4b8f\"><div class=\"tcb-flex-col\" data-css=\"tve-u-18ceaed4b89\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-18ceaed4b94\"><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-18ceaed4b8b\" 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-18ceaed4b88\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-18ceaed4b92\"><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-viewport-triggered\" data-css=\"tve-u-18ceaed4b8a\" 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-viewport-triggered\" data-css=\"tve-u-18ceaed4b8e\" 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 class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18ceaedf1c7\" style=\"\"><h4 class=\"\" style=\"\" data-css=\"tve-u-18ceaee293c\">Para Finalizar:<\/h4><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18ceadf2419\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18ceadf23fe\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Me gustar\u00eda saber que piensas de este articulo \"Plantillas Excel - Creando una Macro para la Hoja Diario\", por lo tanto, d\u00e9jame tu comentario con dudas, criticas constructivas y sugerencias.<\/p><p style=\"\">Hasta aqu\u00ed hemos llegado con este articulo, para continuar con el siguiente articulo, tan solo pulsa clic en el bot\u00f3n:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18ceaf3b18f\" style=\"\" data-button-size-d=\"m\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"rgb(0, 15, 255)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/plantillas-excel-disenando-tu-contabilidad-en-excel-tema13.html\" class=\"tcb-button-link tcb-plain-text\" style=\"\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\"><strong><span style=\"font-size: 20px !important;\" data-css=\"tve-u-18ceaf3b191\">Pulsa clic aqu\u00ed P\/Ver el Tema 13 \u2192<\/span> <\/strong><\/span><\/span>\n\t<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18ceadf2419\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18ceadf23fe\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Cualquier duda o pregunta, tan solo escribeme en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\">pagina del chat<\/a> o bien enviame un correo a rogerperez@aplicaexcelcontable.com<\/p><p>Te saluda tu amigo,<\/p><p><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><p>Creador del Curso \u2013 <a href=\"https:\/\/aplicaexcelcontable.com\/Alumnos\/aplica-excel-contable\" target=\"_blank\" class=\"\" style=\"outline: none;\" data-css=\"tve-u-18ceaf922d3\">Aplica Excel Contable<\/a><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) [data-css=\"tve-u-18cea1769db\"] { font-size: 42px !important; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18cea188905\"] { --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-18cea188905\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea188905\"] 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-18cea188905\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18cea188918\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-18cea209613\"] .tcb-button-link { letter-spacing: 2px; background-image: linear-gradient(var(--tcb-local-color-62516,rgb(19,114,211)),var(--tcb-local-color-62516,rgb(19,114,211))); --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-62516,rgb(19,114,211)),var$(--tcb-local-color-62516,rgb(19,114,211))); background-size: auto; background-attachment: scroll; border-radius: 10px; padding: 14px 22px; background-position: 50% 50%; background-repeat: no-repeat; overflow: hidden; border: none; --tve-applied-border: none; background-color: transparent !important; }[data-css=\"tve-u-18cea209613\"] .tcb-button-link span { color: rgb(255, 255, 255); --tcb-applied-color: #fff; }[data-css=\"tve-u-18cea209613\"] { --tve-border-radius: 10px; --tcb-local-color-62516: rgb(0,15,255) !important; }:not(#tve) [data-css=\"tve-u-18cea209613\"] .tcb-button-link { line-height: 1.2em; font-size: 24px; }[data-css=\"tve-u-18cea209615\"] { font-size: 20px !important; }:not(#tve) [data-css=\"tve-u-18cea2ae56b\"] { font-size: 38px !important; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18cea2bd3f1\"] { --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-18cea2bd3f1\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea2bd3f1\"] 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-18cea2bd3f1\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18cea2bd408\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-18cea3232bf\"] { padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18cea328799\"] { --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-18cea328799\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18cea328799\"] 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-18cea328799\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18cea3287af\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-18cea33c1c9\"] { padding-bottom: 0px !important; }[data-css=\"tve-u-18cea33c1dd\"] { padding-bottom: 0px !important; }[data-css=\"tve-u-18cea33c1ef\"] { padding-bottom: 0px !important; }[data-css=\"tve-u-18cea37b986\"] { margin-top: 20px !important; margin-bottom: 20px !important; }:not(#tve) [data-css=\"tve-u-18cead88e93\"] { font-size: 30px !important; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; }[data-css=\"tve-u-18cead8ed4c\"] { margin-top: 20px !important; margin-bottom: 20px !important; }[data-css=\"tve-u-18cead9120d\"] { margin-top: 20px !important; margin-bottom: 20px !important; }[data-css=\"tve-u-18ceadac282\"] { width: 407px; --tve-alignment: center; float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-18ceadd87a6\"] { width: 409px; --tve-alignment: center; float: none; margin-left: auto !important; margin-right: auto !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18ceadf23fe\"] { --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-18ceadf23fe\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18ceadf23fe\"] 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-18ceadf23fe\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18ceadf2419\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-18ceaeca219\"] { float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-18ceaed4b84\"] { margin-top: -55px !important; margin-left: 25px !important; }[data-css=\"tve-u-18ceaed4b85\"] { min-height: 1px; }[data-css=\"tve-u-18ceaed4b87\"] { max-width: 208px; float: none; z-index: 3; position: relative; width: 100%; --tve-alignment: center; margin-top: 20px !important; margin-left: auto !important; margin-right: auto !important; padding-left: 1px !important; }[data-css=\"tve-u-18ceaed4b88\"] { max-width: 81.3%; }[data-css=\"tve-u-18ceaed4b89\"] { max-width: 18.7%; }:not(#tve) [data-css=\"tve-u-18ceaed4b8a\"] > :first-child { color: rgb(191, 20, 20); }:not(#tve) [data-css=\"tve-u-18ceaed4b8b\"] > :first-child { color: rgb(60, 18, 215); }:not(#tve) [data-css=\"tve-u-18ceaed4b8d\"] { font-size: 26px !important; color: rgb(3, 77, 44) !important; }[data-css=\"tve-u-18ceaed4b8e\"] { font-size: 60px; margin-top: -50px !important; margin-left: 100px !important; }[data-css=\"tve-u-18ceaed4b8b\"] { font-size: 60px; }[data-css=\"tve-u-18ceaed4b8a\"] { font-size: 60px; margin-right: 65px !important; margin-left: 45px !important; }[data-css=\"tve-u-18ceaed4b8f\"] { padding-left: 0px !important; }[data-css=\"tve-u-18ceaed4b90\"] { padding-left: 15px !important; }[data-css=\"tve-u-18ceaedf1c7\"] { margin-top: 20px !important; margin-bottom: 20px !important; }:not(#tve) [data-css=\"tve-u-18ceaee293c\"] { color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; font-size: 25px !important; }[data-css=\"tve-u-18ceaf3b18f\"] .tcb-button-link { letter-spacing: 2px; background-image: linear-gradient(var(--tcb-local-color-62516,rgb(19,114,211)),var(--tcb-local-color-62516,rgb(19,114,211))); --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-62516,rgb(19,114,211)),var$(--tcb-local-color-62516,rgb(19,114,211))); background-size: auto; background-attachment: scroll; border-radius: 10px; padding: 14px 22px; background-position: 50% 50%; background-repeat: no-repeat; overflow: hidden; border: none; --tve-applied-border: none; background-color: transparent !important; }[data-css=\"tve-u-18ceaf3b18f\"] .tcb-button-link span { color: rgb(255, 255, 255); --tcb-applied-color: #fff; }[data-css=\"tve-u-18ceaf3b18f\"] { --tve-border-radius: 10px; --tcb-local-color-62516: rgb(0,15,255) !important; }:not(#tve) [data-css=\"tve-u-18ceaf3b18f\"] .tcb-button-link { line-height: 1.2em; font-size: 24px; }[data-css=\"tve-u-18ceaf3b191\"] { font-size: 20px !important; }:not(#tve) [data-css=\"tve-u-18ceaf922d3\"] { font-style: normal !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; }}@media (max-width: 767px){[data-css=\"tve-u-18ceaed4b8e\"] { margin-left: 90px !important; }[data-css=\"tve-u-18ceaed4b92\"] { margin-left: 128px !important; padding-left: 1px !important; margin-right: -51px !important; margin-top: -96px !important; }[data-css=\"tve-u-18ceaed4b94\"] { margin-left: -16px !important; padding-left: 0px !important; padding-right: 0px !important; margin-right: 0px !important; }[data-css=\"tve-u-18ceaed4b8b\"] { margin-left: 20px !important; }[data-css=\"tve-u-18ceaed4b8a\"] { margin-left: -35px !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":[21],"tags":[293,292,295,294],"class_list":["post-1865","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-plantillas-excel","tag-aprender-excel","tag-excel-y-contabilidad","tag-plantillas-excel","tag-programar-en-excel","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/1865","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=1865"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/1865\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/57704"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=1865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=1865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=1865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}