How to Make a Simple Bookkeeping Template in Excel

preview_player
Показать описание
By popular demand, here is a video on how to make a simple bookkeeping template in Microsoft Excel. Everything you need to know to make this awesome spreadsheet all the way from scratch!

SPREADSHEET LINK

COURSES

OTHER

VIDEO CHAPTERS
00:00 - Intro
00:50 - Worksheet Structure
03:20 - The Setup Worksheet
09:34 - The Income Worksheet
15:44 - The Expense Worksheet
19:36 - Finish the Setup Worksheet
28:07 - The Dashboard Worksheet
31:28 - Dashboard Charts

Music by Epidemic Sound
Рекомендации по теме
Комментарии
Автор

Hi i am having a problem with the formula, that you enter into cell C7 in the setup page, it only refrences the cells in the first arguement ($I$3=0, $I$4=0), after this it does not reference the next cells in the formula $B7. And just gives me an error at the end of the formula when i press enter!

Any help would be apriciated
Kind Regards

stephanvanbiljon
Автор

Me encantan tus vídeos y he aprendido mucho de ellos. ¿Harás una plataforma similar en Google Sheets? Saludos desde México

rockfunismo