Take Control of Your Finances in 2024 with Excel!

Useful for me , thanks

where to download excel template

Thanks buddy

Kenji what's your desk setup?

Somehow my Excel does not work with the "=TEXT(B5, "mmmm") setting. Pops an error message. :<

Im trying the sumifs formula to calculate the Monthly Category breakdown but its not working

Banking apps allow you to download excel files of transactions so this allows data to be included. Alternative is manual inputting.
🖐

Thanks buddy❤

Hi Kenji, thanks for the informative video. One question, how is the budget tracking done here?

unable to open download in excel 2007?

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.

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?

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?

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

FORMULA -----------> '=IFERROR(INDEX($A$3:$A$178, MATCH(TRUE, ISNUMBER(SEARCH($A$3:$A$178, B3)), 0)), "")

I asked you my requirement in another video Alhamdulillah thanks to CHAT GPT I found a formula

Invoice Packing List Third List without extensions or codes

Apple Juice Apple Juice Deels 12960 Apple Juice

With this formula I eliminated the Company name and the code and made the product as in Invoice

Simple, and really useful. Thanks a lot!

This was awesome as usual. Thank you Kenji

I would like a video on the least useful things college taught you based on your career choice.

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?

Money is not meant to control people, rather it is meant to be put to work producing more money for you. You cannot build wealth without putting money in its rightful place.💸

Great video Kenji thanks a lot !

Banks need to introduce an API that would allow you to pull the entries from you account through a refresh table

This is super helpful!! Thanks

Nice video 😊 thanks a lot I’ve learned a lot from you 🎉

I have been looking forward to this Mr Kenji. Thank you so much

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.

Nice video! 👍 can you make more videos on careers in business and finance?

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

This video will definitely help my small business

Great job Kenji

What about rolling over into 2025 and we still want to input our income/expenses on the same tab?

Simple amazing personal tool! Many thanks.

Your video help me a lot brother.
Keep it up

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

Great vedio
Thanks but could you tell me the difference between xlookup and vlookup

Wow

can you do a divident tracker too?