APLICA EXCEL CONTABLE

Domina Excel.
Organiza tu negocio.

Guías paso a paso, plantillas listas para usar y recursos de contabilidad para aplicar lo que aprendes.

Aprende y practica con Roger Pérez, de Aplica Excel Contable.

RECURSO DESTACADO

Calendario 2027 en Excel

Calendario 2027 en Excel con vista anual, vista mensual y diario de notas

Vista anual, calendario mensual y agenda para organizar tus fechas.

Explorar el calendario 2027 →

NOVEDADES DEL BLOG

Aprende algo nuevo hoy.

Validando la Columna Codigos en la Hoja Excel Factura Sistema de Facturación en Excel 2

10 Sep 2014

Como Crear Tu Sistema de Facturación en Excel 2

Como crear tu Sistema de Facturación en Excel 2Estas listo para ver el video 3 de Como crear tu Sistema

Leer la guía →

Plantillas gratis en Excel: sistema básico de facturación e inventario

9 Sep 2014

Sistema de Facturacion en Excel

Como Crear Tu Sistema de Facturación en Excel Comenzamos con el video 1 de como crear tu Sistema de Facturación

Leer la guía →

Insertando Botones para Hipervinculos Sistema de Facturación en Excel 2

5 Sep 2014

Crear un Menu con Hipervinculos Excel para tu Plantilla

Como crear un Menu con Hipervinculos Excel para tu PlantillaTe gustaría aprender a Crear indices o Menu con hipervinculos excel

Leer la guía →

2 Sep 2014

Como Crear Hipervinculos Excel con las Formulas Excel HIPERVINCULO

Como crear Hipervinculos Excel con las Formulas Excel Hipervinculo Iniciemos con el articulo Como crear Hipervinculos Excel con las Formulas

Leer la guía →

29 Ago 2014

Como Crear Hipervinculos Excel Conectados a Objetos

.tcb-post-list.masonry article{flex-basis: unset;position: absolute;}.tve_editor_page .tcb-post-list.masonry article{transition: none;}article{box-sizing: border-box;transition: opacity 1s ease-in-out;width: 100%;}article.thrv_wrapper{margin-bottom: 0px;margin-top: 0px;padding: 0px;}body:not(.tve_editor_page) .tcb-post-list[data-disabled-links=»1″] article{position: relative;}body:not(.tve_editor_page) .tcb-post-list[data-disabled-links=»1″] article > .tve-article-cover,body:not(.tve_editor_page) .tcb-post-list[data-disabled-links=»1″] article .tve-article-cover a{position: absolute;width: 100%;height: 100%;top: 0px;left: 0px;cursor: pointer;z-index: 12;}.tcb-article-cover-link,.tcb-post-list .tve-article-cover a{line-height: 0 !important;font-size: 0px !important;color: rgba(0,0,0,0) !important;}.tve-loading article{opacity: 0.4;}.notifications-content-wrapper.tcb-permanently-hidden{display: none !important;}.tcb-permanently-hidden{display: none !important;}.tar-disabled{cursor: default;opacity: 0.4;pointer-events: none;}html.tve-o-hidden.tve-hide-overflow.tve-l-open{overflow: hidden;}html.tve-o-hidden.tve-hide-overflow.tve-l-open:not(.bp-th){height: auto !important;}body.tve-o-hidden.tve-hide-overflow.tve-l-open{overflow: hidden;}body.tve-o-hidden.tve-hide-overflow.tve-l-open:not(.bp-t){height: auto !important;}.tve_p_lb_overlay{opacity: 0;}.tve_p_lb_background{text-align: center;position: fixed;top: 0px;right: 0px;bottom: 0px;left: 0px;z-index: 999992;padding: 10px;}.tve-l-open.tve-o-hidden .tve_p_lb_background{overflow: hidden;}.tve-l-open.tve-o-hidden .tve_p_lb_background.tve-scroll{overflow-y: auto;}.tve_p_lb_background .tve_p_lb_overlay{position: absolute;top: 0px;left: 0px;right: 0px;opacity: 0;background: rgb(0,0,0);transition: opacity 0.3s ease-out;min-height: 100%;}.tve_p_lb_background.tve_lb_closing .tve_p_lb_overlay{transition: opacity 0.3s ease-out;opacity: 0 !important;}.tve_p_lb_background.tve_lb_closing .tve_p_lb_content{opacity: 0;}.tve_p_lb_background.tve_lb_opening .tve_p_lb_overlay,.tve_post_lightbox .tve_p_lb_background .tve_p_lb_overlay,.tve_p_lb_background.tve_lb_open .tve_p_lb_overlay{opacity: 0.8;transition: opacity 0.3s ease-out;}.tve_p_lb_background .tve_p_lb_content{border-radius: 6px;position: relative;background-color: rgb(255,255,255);padding: 15px;width: 100%;max-width: 650px;text-align: left;overflow: visible;box-sizing: border-box !important;margin: auto !important;}#tve_current_event_settings .tve_p_lb_background .tve_p_lb_content{box-shadow: rgb(0,0,0) 0px 0px 6px -2px;background-color: rgb(255,255,255);}.tve_p_lb_background .tve_p_lb_content .tve_p_lb_inner{max-height: none !important;}.tve_p_lb_background .tve_p_lb_content .tve_p_lb_close{z-index: 99;position: absolute;top: -10px;right: -10px;display: block;width: 22px;height: 22px;line-height: 20px;text-align: center;border: 1px solid rgb(255,255,255);background: rgb(0,0,0);color: rgb(255,255,255);text-decoration: none;font-size: 12px;transition: 0.1s;border-radius: 22px;}.tve_p_lb_background .tve_p_lb_content .tve_p_lb_close:hover{transform: scale(1.1);}.tve_p_lb_background .tve_p_lb_content .scon .btn{display: block;width: auto;}.tve_p_lb_background .tve_p_lb_content .out{margin-left: 0px;margin-right: 0px;}.tve_p_lb_background.tve_lb_anim_instant .tve_p_lb_overlay{opacity: 0.8;}.tve_p_lb_background.tve_lb_anim_instant.tve_lb_closing{display: none !important;}.tve_p_lb_background.tve_lb_anim_zoom_in .tve_p_lb_content{transform: scale(0);}.tve_p_lb_background.tve_lb_anim_zoom_in.tve_lb_opening .tve_p_lb_content,.tve_p_lb_background.tve_lb_anim_zoom_in.tve_lb_open .tve_p_lb_content{transform: scale(1);transition: 0.5s ease-out;}.tve_p_lb_background.tve_lb_anim_zoom_in.tve_lb_closing .tve_p_lb_content{transform: scale(0);transition: 0.3s ease-out;}.tve_p_lb_background.tve_lb_anim_zoom_out .tve_p_lb_content{transform: scale(1.8);}.tve_p_lb_background.tve_lb_anim_zoom_out.tve_lb_opening .tve_p_lb_content,.tve_p_lb_background.tve_lb_anim_zoom_out.tve_lb_open .tve_p_lb_content{transform: scale(1);transition: 0.5s ease-out;}.tve_p_lb_background.tve_lb_anim_zoom_out.tve_lb_closing .tve_p_lb_content{transform: scale(1.8);transition: 0.3s ease-out;}.tve_p_lb_background.tve_lb_anim_rotate .tve_p_lb_overlay{transition: opacity 0.5s;}.tve_p_lb_background.tve_lb_anim_rotate .tve_p_lb_content{transform: scale(0) rotate(500deg);}.tve_p_lb_background.tve_lb_anim_rotate.tve_lb_opening .tve_p_lb_content,.tve_p_lb_background.tve_lb_anim_rotate.tve_lb_open .tve_p_lb_content{transform: scale(1) rotate(0deg);transition: 0.6s ease-out;}.tve_p_lb_background.tve_lb_anim_rotate.tve_lb_closing .tve_p_lb_content{transform: scale(0) rotate(500deg);transition: 0.7s ease-out;}.tve_p_lb_background.tve_lb_anim_slide_top .tve_p_lb_content{transform: translateY(-100%);}.tve_p_lb_background.tve_lb_anim_slide_top.tve_lb_opening .tve_p_lb_content,.tve_p_lb_background.tve_lb_anim_slide_top.tve_lb_open .tve_p_lb_content{transform: translateY(0px);transition: 0.5s ease-out;}.tve_p_lb_background.tve_lb_anim_slide_top.tve_lb_closing .tve_p_lb_content{transform: translateY(100%);transition: 0.5s ease-out;}.tve_p_lb_background.tve_lb_anim_slide_bottom .tve_p_lb_content{opacity: 0;transform: translateY(1400px);}.tve_p_lb_background.tve_lb_anim_slide_bottom.tve_lb_opening .tve_p_lb_content,.tve_p_lb_background.tve_lb_anim_slide_bottom.tve_lb_open .tve_p_lb_content{opacity: 1;transform: translateY(0px);transition: 0.5s ease-out;}.tve_p_lb_background.tve_lb_anim_slide_bottom.tve_lb_closing .tve_p_lb_content{transform: translateY(-1400px);transition: 0.7s ease-out;}.tve_p_lb_background.tve_lb_anim_lateral .tve_p_lb_content{opacity: 0;transform: translateX(-100%);}.tve_p_lb_background.tve_lb_anim_lateral.tve_lb_opening .tve_p_lb_content,.tve_p_lb_background.tve_lb_anim_lateral.tve_lb_open .tve_p_lb_content{opacity: 1;transform: translateX(0px);transition: 0.3s ease-out;}.tve_p_lb_background.tve_lb_anim_lateral.tve_lb_closing .tve_p_lb_content{transform: translateX(100%);transition: 0.3s ease-out;}html{text-rendering: auto !important;}html body{text-rendering: auto !important;}#tve_editor ul{margin-left: 20px;}.thrv_wrapper{margin-top: 20px;margin-bottom: 20px;padding: 1px;}.thrv_wrapper div{box-sizing: content-box;}p{font-size: 1em;}.tve_p_lb_background .tve_p_lb_content.pattern1{background: rgb(41,128,185);}.tve_p_lb_background .tve_p_lb_content.pattern2{background: rgb(192,57,43);}.tve_p_lb_background .tve_p_lb_content.pattern3{background: rgb(46,204,113);}.tve_p_lb_background .tve_p_lb_content.tve_brdr_none,.tve_p_lb_background .tve_p_lb_close.tve_brdr_none{border-style: none !important;}.tve_p_lb_background .tve_p_lb_content.tve_brdr_dotted,.tve_p_lb_background .tve_p_lb_close.tve_brdr_dotted{border-style: dotted !important;}.tve_p_lb_background .tve_p_lb_content.tve_brdr_dashed,.tve_p_lb_background .tve_p_lb_close.tve_brdr_dashed{border-style: dashed !important;}.tve_p_lb_background .tve_p_lb_content.tve_brdr_solid,.tve_p_lb_background .tve_p_lb_close.tve_brdr_solid{border-style: solid !important;}.tve_p_lb_background .tve_p_lb_content.tve_brdr_double,.tve_p_lb_background .tve_p_lb_close.tve_brdr_double{border-style: double !important;}.tve_p_lb_background .tve_p_lb_content.tve_brdr_groove,.tve_p_lb_background .tve_p_lb_close.tve_brdr_groove{border-style: groove !important;}.tve_p_lb_background .tve_p_lb_content.tve_brdr_ridge,.tve_p_lb_background .tve_p_lb_close.tve_brdr_ridge{border-style: ridge !important;}.tve_p_lb_background .tve_p_lb_content.tve_brdr_inset,.tve_p_lb_background .tve_p_lb_close.tve_brdr_inset{border-style: inset !important;}.tve_p_lb_background .tve_p_lb_content.tve_brdr_outset,.tve_p_lb_background .tve_p_lb_close.tve_brdr_outset{border-style: outset !important;}body.tve-lightbox-page .tve_p_lb_overlay{position: fixed;top: 0px;right: 0px;bottom: 0px;left: 0px;background: rgb(0,0,0);opacity: 0.8;}body.tve-lightbox-page .tve_p_lb_background{top: 32px;padding-top: 150px;}body.tve-lightbox-page .tve-spacer{height: 40px;width: 100%;}.tvd-toast{justify-content: space-between;}.tvd-toast.tve-fe-message{top: 50px;width: 60%;padding: 0px;color: rgb(0,0,0);max-width: 500px;position: fixed;z-index: 9999993;left: 50%;}.tvd-toast.tve-fe-message .tve-toast-message{position: relative;left: -50%;background: rgb(255,255,255);box-shadow: rgb(167,167,167) 0px 0px 15px 0px;}.tvd-toast.tve-fe-message .tve-toast-icon-container{display: inline-block;width: 50px;background: green;color: rgb(255,255,255);height: 100%;position: absolute;}.tvd-toast.tve-fe-message .tve-toast-message-container{padding: 20px 10px 20px 70px;margin: auto 0px;font-family: Roboto,sans-serif;font-size: 16px;}.tvd-toast.tve-fe-message span{text-align: center;display: flex;justify-content: center;flex-direction: column;align-items: center;min-height: 50px;height: 100%;width: 100%;}:not(#_s):not(#_s) .tcb-conditional-display-placeholder{min-height: var(–tcb-container-height-d,100px) !important;position: relative;}:not(#_s):not(#_s) .tcb-conditional-display-placeholder.thrv-page-section{box-sizing: border-box;margin: 0px;}:not(#_s):not(#_s) .tcb-conditional-display-placeholder.thrv-content-box{box-sizing: border-box;}:not(#_s):not(#_s) .tcb-conditional-display-placeholder .tve-page-section-out,:not(#_s):not(#_s) .tcb-conditional-display-placeholder .tve-content-box-background{box-sizing: border-box;position: absolute;width: 100%;height: 100%;left: 0px;top: 0px;overflow: hidden;}.screen-reader-text{clip: rect(1px,1px,1px,1px);height: 1px;overflow: hidden;width: 1px;position: absolute !important;overflow-wrap: normal !important;}.screen-reader-text:focus{background-color: rgb(241,241,241);border-radius: 3px;box-shadow: rgba(0,0,0,0.6) 0px 0px 2px 2px;color: rgb(33,117,155);display: block;font-size: 0.7778rem;font-weight: bold;height: auto;left: 5px;line-height: normal;padding: 15px 23px 14px;text-decoration: none;top: 5px;width: auto;z-index: 100000;clip: auto !important;}article{position: relative;}.tcb-post-list[data-type=»list»] article{margin-top: 20px;}@media (max-width: 1023px){:not(#_s):not(#_s) .tcb-conditional-display-placeholder{min-height: var(–tcb-container-height-t) !important;}}@media (max-width: 767px){html{overflow-x: hidden !important;}html,body{max-width: 100vw !important;}:not(#_s):not(#_s) .tcb-conditional-display-placeholder{min-height: var(–tcb-container-height-m) !important;}}@media only screen and (min-device-width: 375px) and (max-device-width: 736px){html.tve-o-hidden.tve-hide-overflow.tve-l-open:not(.bp-th){height: 100% !important;}body.tve-o-hidden.tve-hide-overflow.tve-l-open:not(.bp-t){height: 100% !important;}}@media screen and (max-device-width: 480px){body{text-size-adjust: none;}}Como crear Hipervínculos Excel conectados a objetos En el artículo anterior conocimos como Editar los Hipervinculos Excel, Ahora sabes cómo

Leer la guía →

26 Ago 2014

Como Editar los Hipervinculos Excel

Como editar los Hipervínculos Excel Ahora que ya conoces los diferentes tipos de Hipervínculos Excel, vamos a ver como editarlos,

Leer la guía →

TU SIGUIENTE PASO

Aprende a tu ritmo.
Aplica desde el primer día.

Refuerza tus conocimientos de Excel y contabilidad con materiales que puedes consultar mientras practicas.

Mini curso de contabilidad

Un punto de partida para entender y organizar los registros de tu negocio.

Empezar el mini curso

Sigue avanzando con Excel

Consulta los cursos avanzados y la colección de cursos en PDF.

ESTAMOS PARA AYUDARTE

¿Necesitas orientación?

Cuéntame qué quieres aprender o qué plantilla necesitas para tu trabajo.

>