Перейти к содержимому

General Journal In Excel: Build A Bookkeeping System With Accounts Register [Part 1]

Excel For Freelancers

0:00 / 0:00

General Journal In Excel: Build A Bookkeeping System With Accounts Register [Part 1]

334 768 просмотров · 7 л. назад
Excel For Freelancers
1 млн подписчиков
334 768 просмотров · 7 л. назад
Dynamic general journal in Excel — every single transaction is about to get tracked automatically inside this journal. Recording every transaction by hand is slow, and it's easy to lose track of what's already been entered. Here, you'll build a general journal inside Excel that records financial transactions as they happen. You'll see exactly how each entry gets logged and organized automatically. 👇 GET THE FREE FILES FOR THIS VIDEO: https://www.excelforfreelancers.com/g... 🔥OWN 550+ TEMPLATES & WORKBOOKS IN ONE PACK👉 https://www.excelforfreelancers.com/u... 🆕 New Excel Add-In: 8 Productivity Tools In One Ribbon Tab 👉 https://www.excelforfreelancers.com/e... 📌 JOIN MY MENTORSHIP & START BUILDING INCOME-GENERATING EXCEL APPS 👉 https://www.excelforfreelancers.com/m... 😎 JOIN OUR ELITE MEMBERSHIP: PREMIUM TRAININGS, RESOURCES & COACHING 👉https://www.excelforfreelancers.com/e... 🚀 GET YOUR OPERATIONS UNDER CONTROL — 3 Spots Open This Quarter👉 https://www.excelforfreelancers.com/b... 🛠 NEED THIS BUILT FOR YOUR BUSINESS OR NEEDS? Get Expert Customization Help 👉https://www.excelforfreelancers.com/C... 🛒 Browse All Excel And AI Templates, Courses & Tools: https://www.excelforfreelancers.com/shop ⏱ TIMESTAMPS: 0:00 - Introduction 0:30 - Overview 17:18 - Selection Change Event 22:39 - Conditional Formatting 40:27 - Named Ranges Detail 46:35 - Change Event 49:01 - Show Save Button 51:18 - Save Transaction 1:13:25 - Load Transactions 👥 JOIN OUR COMMUNITY: https://www.excelforfreelancers.com/E... 🔗 LinkedIn:   / excelforfreelancers   😎 Facebook:   / excelforfreelancers   About: I'm Randy Austin — Excel developer and business systems builder. I help business owners and entrepreneurs replace expensive software subscriptions with powerful, done-for-you Excel templates they can customize and own forever. New training every week. #excel #exceltutorial #excelforfreelancers #dynamicgeneraljournal #exceltemplate Thanks so much for your continued support, Randy Austin