Take Control of Your Finances in 2024 with Excel!
HTML-код
- Опубликовано: 19 июн 2024
- Make an automated budget tracker in Excel in just 15 minutes.
🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/kgv
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
In this step-by-step tutorial you'll learn to make a personal finance dashboard from scratch in Excel in just 15 minutes. This can be used to track your finances such as your expenses, your income, or your savings. As the dashboard is fully dynamic, as soon as you enter a new transaction it will be added to the dashboard. To automate the dashboard, we use Excel tables, text formulas, SUMIFS, Date formulas, and more.
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:42 - Adding Entries
4:48 - Personal Finance Dashboard
10:15 - Category Breakdown
12:38 - Summary Numbers
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/kgv
Great video Really I like it.
Hi Kenji,
I am a great admirer of your videos.
I have seen so many videos of Excel of various RUclips instructors, but I haven't found a video suit to my requirement.
I receive both invoices and packing list in excel format from China. Following is an example but not the actual one:-
Invoice
Apple Juice
Pineapple Juice
Mango Juice
Orange Juice
Grape Juice
Packing List
Apple Juice Keels 12956
Pineapple Juice Keels 12957
Mango Juice Keels 12958
Orange Juice Keels 12959
Grape Juice Keels 12960
Apple Juice 1280 Cargill
Pineapple Juice 1281 Cargill
Mango Juice 1282 Cargill
Orange Juice 1283 Cargill
Grape Juice 1284 Cargill
Apple Juice Laughs 1123 12
Pineapple Juice Laughs 1123 13
Mango Juice Laughs 1123 14
Orange Juice Laughs 1123 15
Grape Juice Laughs 1123 16
Now you may have noticed that in the packing list the products comes with extentions such as the name of the production company and a product ID..
I wanted to eliminate the company name and the product ID from the list and produce a new list while keeping complete item names in the packing list. Is this possible in excel.
What I do now is "TEXTSPLIT" the description. Delete the unnecessary data manually and join the Description again to get the list as I wanted.
I'm interested in investing in alternative assets but I'm not sure if it's a good idea. Can anyone provide some insights on their risks and potential rewards?
Looking to deviate from traditional retirement accounts? Consider a taxable investing account centered around dividend-paying stocks as an alternative. Despite its fewer tax benefits, it still serves as a strong avenue for future financial security. For tailored advice and recommendations, consulting with Julie Ann Lerch, an esteemed expert in the field, is recommended.
@@EdwinCunningham-vj3nm Continuously monitor the performance of your forest investments and make adjustments as necessary. Stay informed about market developments, environmental regulations, and emerging trends in the forestry industry. Regularly review your investment portfolio to ensure it remains aligned with your financial goals and risk tolerance.
By following these steps and exercising due diligence, you can effectively invest $300k in forests and potentially benefit from long-term financial growth while contributing to environmental sustainability.
I have been looking forward to this Mr Kenji. Thank you so much
Simple, and really useful. Thanks a lot!
This was awesome as usual. Thank you Kenji
This is what I was looking for. Thank you
Nice video 😊 thanks a lot I’ve learned a lot from you 🎉
Great video Kenji thanks a lot !
Thank you very simple and very useful.
Great model! How to include or keep record of the ballance of your different bank and different creditcard accounts and your cash? I have looked through a lot of your videos without finding any video covering this. Hope you make it in the future.
great video. very nicely demonstrated in a way i can follow 10/10
This is super helpful!! Thanks
Great efforts Kenji. Love your videos man! is it possible to link a google forum for the transactions on Phone and then they would be automatically exported to Excel? I feel that would be more convenient instead of manually inputting the transactions on a laptop
Great job Kenji
Useful for me , thanks
This video will definitely help my small business
This works awesome! After building it, I’ve tried adding a monthly category totals area but can’t figure out a formula to make it work.
Simple amazing personal tool! Many thanks.
Glad you like it!
Hi Kenji, thanks for the informative video. One question, how is the budget tracking done here?
Help full video.
Thank a lot brother. :)
Nice video! 👍 can you make more videos on careers in business and finance?
Thanks buddy❤
thanks so much
Great video honestly, is there anyway to also include subscriptions and when those payments will go in this spreadsheet template?
Your video help me a lot brother.
Keep it up
Glad to hear that!
Hi Kenji, this is another amazing vedio. Can you make a video on transferring 12 months' credit cards pdf statements combine with bank statements to excel? I transferred the file by each month then copy paste to one table. Maybe you have better way to do it. Thanks.
My favourite RUclipsr Kenji the best.
Thanks buddy
Kenji what's your desk setup?
This is Art
I have a list of data that is about 2400 seconds long, and includes data up to the hundredths decimal place. Is there a function or filter I can use in order to just keep the integer values and delete all entries with decimals?
how did you make the category table? Is it just a normal table?
Hi Kenji, thank you very much for this useful video! I will definitely use it for my personal projects :) ! Just one thing, I was testing it out by myself, but I think I found a problem with the EOM formula.. because the MONTH formula will produce a month number (e.g. 7 for July) then the EOM formula would take this 7 as the 7th of Jan 1900.. thus will always yield 31/01/1900 as the EOM.. so all percentage of month lapsed will be based 31.. won't work for February for example
I rewrote like this and it works =DAY(C4)/DAY(EOMONTH(C4,0))
I'm having trouble in the sumifs part pls
Help the value comes to zero even though I have some income in January
it says my expenses and income are the same? fix for this?
I’m using a Swedish version of Excel. Converting date into text of a month does not work in the same way as you show in the video. The Swedish standard is: 2024-01-01. I can do: =MONTH(B5) which shows as 1, 2, 3 etc, but show month in text, I can’t do it?
Somehow my Excel does not work with the "=TEXT(B5, "mmmm") setting. Pops an error message. :
I don't see any updates in dashboard for February entries.
Hello- my result in cell C11 is a 0 (zero). I cannot see why, I've debugged the formula, rewritten it a few time to no avail. Any suggestions? Thanks- WS
Im trying the sumifs formula to calculate the Monthly Category breakdown but its not working
Does this work on a Mac with Numbers?
Banking apps allow you to download excel files of transactions so this allows data to be included. Alternative is manual inputting.
🖐
Great information as usual. Question. I presume you can add to the income/expense table. I did; however, when I copied the formula to Expenses and Savings, I get 0 for expenses for the months. Any idea?
I had the same issue. However, when I checked I made a spelling mistake. I used 'Expenses' as my Header in Dashboard sheet instead of 'Expense' as in the Entries sheet.
@@VishnuVardhan-sj6nd Thank you! That was the issue.
@@VishnuVardhan-sj6nd Thank you so much for this information. I was starting to pull my hair out LOL
how do you create the headline "personal finance"
I would like a video on the least useful things college taught you based on your career choice.
Great vedio
Thanks but could you tell me the difference between xlookup and vlookup
thanks! I have a video about that here: ruclips.net/video/3MdPSHkyfdI/видео.html
Help. Im getting stuck on this walkthrough. When i put in the sumifs formula, I recieve a 0 value for january. Ive only put in two entries for salary and 1 entry for expense.
Me Too
where to download excel template
Pls how can i download the template
unable to open download in excel 2007?
Greetings sir,
Im unable to download the Excel
How do i go about it.
Thanks for your usual promptness
i was unable to download as well
where to download the templet?
What about rolling over into 2025 and we still want to input our income/expenses on the same tab?
I am far from an Excel Wiz but you may be able to group all the 2024 tabs manually and then hide them all and make some changes to the dashboard to switch between years. I could be wrong or there could be an easier way lol
The =XLOOKUP(E5,Table1[Category],Table1[Income / Expense]) at minute 2:35 did not work for me
can you do a divident tracker too?
maybe in the future!
Yhat would be awesome @@KenjiExplains
Wow
thanks!
Banks need to introduce an API that would allow you to pull the entries from you account through a refresh table
For that there are professional software applications that can pull the data directly from the bank. I think because of the safety concerning privacy and security this possibility through an API will not be given away by the banks. You can however work with the data you downloaded from your bank. Make an automated import and conversion proces for your financial workbook
@@joukenienhuis6888 I understand. It’s not a major inconvenience to export a new file every time you need a feed but a live link would work wonders
I know that Xero and other accounting software allows you to do this if my memory serves me correctly
Naturally, I’d think any user who requests their banking provider to provide said means is a sophisticated user and should have some awareness of security risks.
And the biggest risk is having you transactions information stolen. Sloppy work has to have been done on the API for someone to potentially gain your login information, take your money etc
How does this trading stuff work? I'm really interested but I just don't know how it go about it. I heard people really make it huge trading
Please how do I contact her?
I strongly agree with you guys, Mary's team is the best. My funds are safe and ROI is always sent directly to my external wallet exchange monthly
I really appreciate your feedback. Thanks
Wow Mrs Mary Gail really helped me for real, trading with her has been going smoothly for me as I've been able to raise over almost four btc when I started at 10k in my first deposit
Coincidentally I met Mrs Mary Gail in a conference in Dallas. She shared me her views on the market and her strategies really mind blowing!. I really recommend her
I wish you start this tutorial from scratch. Because many of us don’t know how to create the category & income/expense.
HEY Kenji , Thanks for the video . Can you tell me please why my sumifs formula is returning to zero though I am doing everything accordingly ? @KwnjiExplains
Me too though it worked for certain months