Ok, thanks. I DID get 'er done! I had to listen several times and even with the two things I critiqued earlier, I was able to do it, with a bit of gnashing of teeth and hair pulling (but that's just my drama) and I appreciate this video. It was a useful video.
We would need to create a video to explain this. You need to make another sheet for the transactions and I would do it based on months and then he would create a formula using the equal sign and adding that month together.
Thanks for this video it was a great start! I'd like to learn how to create budgets for each category in the month (as you called the luxuries) like restaurants/groceries etc. and compile it or bring the total into this spreadsheet. Do you have a video on that?
Currently we don’t. We do have a numbers training playlist. One of the templates has something similar to what you need. Numbers Training ru-vid.com/group/PL9sScDdMR-OefCWHwoyOa0C9h6YPtuq-0
Thanks! Taking your nice offer to answer questions, what is the way to have a cell that shows % from one amount to the next neg or pos? Such as if you profit or loss from an investment? Thanks
Depending on what you want to see we can do the following: Add a column, label it “Actual vs Budget %”. The formula for the col is “Actual Other”/Budget Other” (/ is divide by in this example) the col should be formatted as percentage with however many decimals you want. The second example is as follows: create a col called “Cost” another “Current Value” another “Profit/Loss” and finally one for “Percentage”. The first three col format as currency with two decimals. The formula for the profit loss will be “current value” minus “Cost” The percentage formula will be “profit/loss ” divided by “current value” with the format as percentage with neg numbers in red. I hope this answers your question. Thank you
WOW Fantastic tutorial. I have a question: What do you do to keep track of grocery expenses ? Is there a formula I can use to add up my grocery expenses or do I have to create a separate table?
Thank you. I created a budget of $900. I use mint.com and one credit card to track it and add it at the end of the month. You can make one table on another tab. Put the total and date. You can add it together on the other tab.
The concept it the same when trying to get data from different tables. For example, you take the last table in this tutorial and move to a different sheet and do the same calculation.
Is there a way to format each cell to add numbers as the month goes on. For ex. apple services Pay -24 Jan 3, -28 Jan 17. Can the second number be added to the cell & have it automatically update? I found this video very helpful, Thank you!
I’m not sure that I fully understand your example. Do you want to base the result on the date? Also, are the numbers changing. Where is that figure coming from. Perhaps this example may help. Examples Suppose cells B1:E1 contain 1, 2, 3, and 4. Suppose cells B2:E2 contain 2, 4, 6, and 8. =SUMPRODUCT(B1:E1, B2:E2) returns 60, the sum of B1*B2 (2), C1*C2 (8), D1*D2 (18), and E1*E2 (32). =SUMPRODUCT(B1:E1) returns 10 because there is only one collection and the sum of that collection is 10. If the numbers to be calculated are based on a date than perhaps an if statement might be required. Let me know if the sumproduct works for you. I’ll also look into the if statement
OK, so I managed to get the Bills done. But then, you went on to make a separate table for the Income and did not show me how to do that. So irritating that you know how to do it, but you don't instruct me. I've listened to it twice and still can't figure it out. Help!
I actually have this numbers article for you. Please look at other videos that go over the basics. www.icloud.com/numbers/0606EV070jXq1Ht42qF124hpA#Budget_Example_2022
When I try to select the bills total and the income total to create the formula for the final income it selects the entire column and won't create a formula. Any tips to help with this? Thank you
Around 14 minutes we show how to select the income total and bills total. You start the formula with equal and select the bills total + the income total.
Karlie, when you click on the total cell I.e. col C row 22, the first thing you should is key the = sign, type summ than select the first cell with a number in it, hold down the mouse or track pad and slide down to the last cell BEFORE the total line click on the check mark. Hope this helps
I really learned a lot on this video. However, I am totally blind and have to use voice at all times. I would like a video or if there is a video that helps with that please let me know because some of the items you were saying just click here just drag this there are not the same on voiceover and I have been unable to figure them out. Thank you respectfully Daryl
71 learning a totally new skill. All good, except you keep saying highlight and I don’t know how to do the whole thing. I need to make the whole sheet in currency. Take me ages if I do each column,
People! You think you're talking to someone who knows how to even find the place where I can make a template like that. Not so. I would like to say this was useful, but I can't - yet.
Please speak more slowly. ( I need time to digest what you are saying) 2. Please use a similar term after the computer name. Examples Table = Title , or page name, Format or arraignment, sum - is to add numbers in rows together. Please, give me more time to write down the formula., 3. Show both the numbers in all the rows & columns, while you are describing the choices and features of how they can appear on the printed page.
You can slow down RU-vid videos so that will help digest it better. We use the terminology Apple describes it as. We have many more videos for you to enjoy.
Hey! first off LOVE the video! Learned a bunch. I want to be able to create a savings table that showcases exactly what you have here, monthly expenses. In a separate sheet(s) I would like to dive into separating the money within the savings to see how much of what money I got for each category. I have it set up where i can see hat % goes where but when I take out money it is taking out money from the savings as a whole and not that specific category. Do you have any tips? *Messaged you on instagram and Facebook as well*
We might suggest to create a withdrawal row for each savings account and then have a net number for the account but show % for deposits and withdrawals. Don’t know if that will work without seeing the worksheet you created