วีดีโอ

Great tutorial on creating an Expense Tracker in Excel! Managing Excel payments and expenses can be challenging, especially for larger projects. That’s why we developed buildcontrol, a dedicated app to streamline payment tracking, petty cash management, and contractor/supplier payments. It simplifies everything Excel does but with added automation and real-time updates. Would love to hear your thoughts on how tools like buildcontrol can complement Excel for better financial management! Keep up the awesome content! www.youtube.com/@buildcontrol-construction-app/shorts

soooo herereeeeeeee so thereeeeeeeeeeee so hereeeeeeeeeee💀😭

THANK YOU SO MUCH!!!

Hi You seem to do a lot on Excel, i was wondering if you could do a tutorial for me (i am "noob" with tech). I rent out several caravans on behalf of other owners (short stays, maybe like airbnb?) and need an easy way to keep track of bookings, income and expenses. i found a template which sort of gives me what i want, but needs work done, this was a "smart Bill Calendar". i could do with a calendar for the bookings (days of the month), with a drop down tab for months of the year which would also change the calendar. i would need another option to input the guests check in and check out date, the price they paid, guests refundable deposit and my fee i take (say 10% fee of the booking, not including the deposit). then an expenses section where i can say how much money i returned to the owner (unless this can be auto filled out after it works out my percentage fee?), how much of the deposit was returned to guests, and other expenses such as internet fee, travel, cleaning etc, then how much was paid in total and how much was paid out and what is left (my net income) for that month. maybe extra tabs on the bottom for each caravan i rent out? i assume this is just a case of duplicating the sheet?, then 1 more tab with the "total", this, if possible would need to add everything up from all caravan tabs, all the income and expenses etc and my net earnings, though this is not vitally important as i can go through each tab and add and subtract it myself.

Lifesaver

Thank you! Your instructions are great. I'm not an Excel expert, but I'd like to track items like kettlebell swings and goblet squats. I'm not sure how to do that in this tracker. Do I need to create separate trackers for those items, or is there a way to add them to this tracker?

It doesn't show the step in how he got the miles entered into the column in the Daily Input tab. Can someone help with that?

really helpfull thank u

greatttttt 💌🤟

Thanks so much, the multi-variable nested XLOOKUP worked perfectly.

Insanely helpful

Exactly what i am looking for. Thank you for 2 the variables look-up!

5:58 - what if there are three conditions rather than your example of two conditions?

If i put two expenses in the same month the numbers turn into hashtags

It's there any way to create a live continuous update into Excel from data i can only see on my computer screen? To clarify, i trade options and use thinkorswim platform. There is certain data from option statistics in the put call ratios that i want to feed into Excel and calculate with certain formulas... Instead of having to constantly manually update them I'd love to find a way to get them updated automatically. Normally the platform provides a link to feed into Excel but not for this data. I can only see it change on screen... Is it possible to get that data from just my screen live into Excel and update automatically as it constantly changes?

Thank you, I have managed to create an expense tracker by following the video. I surprised myself by creating an income tracker (using the same logic) on another tab and got it to feed into the summary sheet.

Your website is suspended 😞

you are wizard my guy!

This is fantastic. So many people I work with wish Microsoft would use some common sense here - in that nearly everyone in the U.S. knows that zip codes are 5 digits - with 10% of them having leading zeroes here - and just build in code to recognize that it is a zip code. Thank you!

Thank you …. Is it passable to create it with 3 conditions? Two rows and one column ?

Thanks man. Been looking for this for day 👌👌

Finally, Find This Video 100% help me

I was trying to get some ideas on how to design an expense tracker and I came across your video and the free tracker. I have tried using paid apps to track my expenses, but they never work for me. Your template has been a lifesaver. I can easily and quickly track my own expenses being aware of where and how much I spend each month. Thank you so much!

Is there any way to search for multiple tags at once? e.g. I’d like to search for franchise, then narrow down further to sequel, then even further to CGI, etc?

I wonder if you can also add a roll for attack and damage by everyone in the party and monsters?

I followed the steps but Excel loaded all the numbers in my Summary page as a 0 in each column and row? Does anyone know how that happnes?

Dear SIr if i put continue same date 2 or 3 time for 2-3 different categories expense then it will go to undated or outside date range what can we do for that :) by the way thanks for you sheet

How do I put both lists side by side and then make both lists equal so I can compare apples to apples on each row? Vlookup?

thanks so much for it. It helps my startup in very early stages

I find myself needing some assistance with the following: Please imagine a spreadsheet with various columns between A-T For simplicity I will reference my own needs to column A & C Column A will contain the name of a person who is assigned a piece of work. Column B will contain the date they were assigned the work. Column C will contain the date they completed and return the work. The task I have been assigned it to collate how many times a person is assigned a piece of work and when they returned it. ( I am required to present data on a month by month basis ) At the moment I have been using filters as I am unsure how to use formulas to simply this process. We have up to 25 names that could be used in column A. Over a month we have 125-180 pieces of work. As you can imagine using filters for this process has been difficult. Colleagues will not assist me or teach me how to use excel functions and make my life easier. Is there a way of searching for colleague (x) in column A and automatically finding all return dates associated this colleague (x) in column C ? Any help would be greatly appreciated.

how can I add more columns and rows on the first tab without messing up the sheet's formula's?

This was the triumphant finish to understanding why I my ISBLANK formulas weren't working on data exported from Salesforce. And yes, the 'text to columns' hack is a great time saver. Very well presented - like a rockstar!

you dont need to show 3 minutes and 30 seconds of different examples of why these fake "blank" cells arent actually blank. we get it, theyre FAKE. Get on with it... I bet your students fall asleep on every single of your lecture, jesus christ edit: doesnt work

This was super helpful, I was able to adapt to my personal tracker! Thanks so much for sharing!!

Thank you! I was able to extract the info I needed very quickly using this methodology! Thanks for sharing!

It's too complicated for me

I followed your steps and it was helpful. But when I actually went to use it the numbers weren't transferring from the expense spreadsheet to the summary spreadsheet . Did I miss a step? I even downloaded the one provided from the video link and it is still not working. Please help me understand what step I'm missing. I have a MacBook Air.

beautiful

Could you please make a weekly version of this?

Some cells came with a space and are easy to replace but the false blanks are really a pain... Thanks for your help.

This is NOT beginner!

What is the comparable way to do this with Power Query?

This is such a terrible video😂. It does not have to be this complicated.

Thanks so much

Hello Sir, thank you for your share, but I have one more question, how I can set the if not found to show "Name Error" and "Month Error"? Thanks

Amazing 👌

Amazing video, thank you its just what I've been looking for!

thank you for the excel download

Thanks a ton awesome video

Thank you, that was much simpler than I was considering