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.
ELIGE POR DÓNDE EMPEZAR
¿Qué quieres resolver hoy?
01 / EXPLORA
Plantillas gratis
Descarga y adapta archivos para tu día a día.
Ver recursos →
02 / EXPLORA
Plantillas avanzadas
Explora herramientas para tus procesos de trabajo.
Ver recursos →
03 / EXPLORA
Funciones de Excel
Aprende con explicaciones y ejemplos prácticos.
Ver recursos →
04 / EXPLORA
Contabilidad desde cero
Empieza con el mini curso de contabilidad.
Ver recursos →
NOVEDADES DEL BLOG
Aprende algo nuevo hoy.
20 Ago 2018
Demo Curso AEC Sistema Contable
Demo Curso AEC Como crear tu Sistema Contable V6.0 ¿Ya probaste el Demo Curso AEC? Te gustaría aprender a crear
25 Jul 2018
Videos de 10 Consejos de fecha y hora
Videos de 10 consejos de fecha y hora en excel Estas listo para ver los videos de 10 consejos de
15 Jul 2018
Resaltar fines de semana en Excel
Como Resaltar Fines de semana en Excel Estás listo para aplicar los pasos de como Resaltar fines de semana en
9 Jul 2018
Valores de Fecha en las Formulas Excel
Como utilizar los Valores de Fecha en las Formulas Excel Estas listo para aprender a utilizar los Valores de Fecha
5 Jul 2018
Funciones de Fecha y hora en Excel
Como utilizar las Funciones de Fecha y hora en Excel Estás listo para aprender los pasos de como utilizar las
1 May 2018
Funciones del Sistema Contable basico
.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;}}Funciones del Sistema Contable Básico Estás listo para ver las funciones del Sistema Contable básico?En este video, te voy a
PARA CONSULTAR Y VOLVER
Guías que te acompañan en la práctica.
Autosuma en varios rangos
Domina la suma con selección múltiple.
Leer la guía →
Catálogos de cuentas en Excel
Organiza las cuentas de tu contabilidad.
Leer la guía →
Cuadro de lista en tu libro diario
Haz más ágil el registro de operaciones.
Leer la guía →
Fórmula SUMAR.SI
Suma los datos que cumplen una condición.
Leer la guía →
Sistema contable en Excel
Conoce un recurso para tus registros contables.
Leer la guía →
Formato condicional
Resalta la información que necesitas ver.
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 cursoSigue 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.