HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How To Create A Dynamic General Journal & Accounts Register In Excel

334,097 views October 25, 2019 1:27:45

Watch on YouTube
ChannelExcel For Freelancers

Chapters

Description from the creator

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:
excelforfreelancers.com/general-journal-pt-1/

🔥OWN 550+ TEMPLATES & WORKBOOKS IN ONE PACK👉 excelforfreelancers.com/ultimate-wkbk-pack-yt-d…

🆕 New Excel Add-In: 8 Productivity Tools In One Ribbon Tab 👉 excelforfreelancers.com/excel-productivity-suit…

📌 JOIN MY MENTORSHIP & START BUILDING INCOME-GENERATING EXCEL APPS 👉 excelforfreelancers.com/mentorship-program-ytde…

😎 JOIN OUR ELITE MEMBERSHIP: PREMIUM TRAININGS, RESOURCES & COACHING 👉excelforfreelancers.com/elite-membership-yt-desc

🚀 GET YOUR OPERATIONS UNDER CONTROL — 3 Spots Open This Quarter👉 excelforfreelancers.com/business-transformation…

🛠 NEED THIS BUILT FOR YOUR BUSINESS OR NEEDS? Get Expert Customization Help 👉excelforfreelancers.com/CustomsJobs_YTDesc

🛒 Browse All Excel And AI Templates, Courses & Tools: 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: excelforfreelancers.com/EFFGroup
🔗 LinkedIn: linkedin.com/in/excelforfreelancers/
😎 Facebook: facebook.com/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

About this tutorial

Excel For Freelancers published this 1:27:45 video tutorial on October 25, 2019. It has been watched 334,097 times on YouTube.

Category
Education
Duration
1:27:45
Published
October 25, 2019
Views
334,097
Likes
3,787

Tags

Share

This tutorial in other languages