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.
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 th-cam.com/play/PL9sScDdMR-OefCWHwoyOa0C9h6YPtuq-0.html
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
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.
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.
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.
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
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
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
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 TH-cam 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
thank you very much! as a total numbers beginner i am now able to quickly setup my own budget sheet.
That’s great news. Glad to help
AND, with your instruction, I was able to figure out how to do year totals at the end! Life is good. I will look forward to using this table!
Thanks!
Very helpful and easy to follow
Thank you for the feedback!
This is a great video!! I think I finally understand Numbers. Thanks.
Thank u 🎉
exactly what I was looking for. Thanks
Very helpful. Thank you.
You're welcome!
Thanks. Really appreciated, excellently presented. Can you tell me how to widen columns. I’m having a bit of a problem with that! On my iPhone.
Tap on the whole column, when you see the options for cut, copy paste pop up. the arrow goes to column actions, Fit to content
Good showing , did you add a transaction page ?
In this particular episode, we did not. But we do have other episodes talking about budgets and doing transactions.
Super video! You explained creating a budget very simply. Now I can create one myself.
Awesome!!! Thank you
I'm doing this for my boyfriend and I. I still need to learn a lot but this was very helpful. Thank you!
Glad it was helpful!
Really useful! Thank you!
Glad it was helpful!
Is there a show on how to combine data from different sheets into a summary sheet?
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.
Thank you so much, I just need to do this slowly with you so I will try step by step. Really great explanation !!!!!!🙏🏼
You are welcome. You can slow down the video if it helps
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
th-cam.com/play/PL9sScDdMR-OefCWHwoyOa0C9h6YPtuq-0.html
Thank you so much! This is so much easier than Apple Numbers Help!!
I love to hear this!!! Thank you
thank you
You are welcome!
Thanks for breaking this down so easily. Look forward to using it.
Glad it was helpful!
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
@@frankfunke8689 I will try the 3 out, and see, I m learning to use the app, so I m grateful for your help.
You are like a god!!. THIS VIDEO IS LITERALLY EXACTLY WHAT I WAS LOOKING FOR TO A T. THANK YOU!!!!!!
I LOVE ALL CAPS! thank you very much. we have much more to teach.
Is there a way to add income to the pre made budget and transactions spreadsheet in numbers? Great video by the way!
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.
Great information. I'm going to start my spread sheet now!!! Thank you
Awesome Mary. Thank you
Amazing indeed. I followed this all the through an did my own. Thank you for sharing.
Awesome feedback.
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.
Thats great! Thank you
Thank you soooo much. I have been trying to figure this out for a while now
Happy to help
This is the best tutorial.
Thank you. Very Proud of this one!
Thanks that helps !
Happy to help!
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.
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
Great walk through. Detailed to a Tee.
Thank you for the feedback
Thank you so much for your video!
That’s awesome! Thank you
Damn always thought I hate excel....nah I was lacking proper training 🤣🤣🤣this thing is fun. Thank u sir
You are welcome!
@@APPLE1TO1 New subbie...plz keep them coming😊
how do i find the budget templates for numbers
When you Open Apple Numbers and see the templates, personal budgets. This was a custom one I created.
This was extremely helpful - thank you for your efforts!
No problem. Happy to help.
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
thanks need all this help!!
I am happy to help!!!!
Thank you this was very easy to follow. Excited for what else you have to offer.
Check out our numbers training playlist
How did you bring 3 sheets on one page?
There is a plus sign on the top left you can add sheets
Great to watch
Thanks, Tone! We hope to create more content you like!
Dude, that was great. Thank you!!
excellent instruction, especially for a beginner to numbers
Thank you very much. Many videos are numbers in pages are on our channel.
Great tutorial! Thank you. Just what I needed.
Thank you for the feedback.
Great tutorial! ❤❤😊
Thank you Pat!
Thank you, very informative
You are welcome
Awesome! Thanx
Thank you very much!
Amazing tutorial. Thank you
Happy to help
great video, thanks so much!
Our pleasure thank you
Thank you!
You are welcome. Let us know what else you like
Fantastic!! - Thanks so much.
Happy to help!
thanks dude !
You are welcome
Thank you this was cool
Thanks for the feedback! Happy to help
Can this be done on a IPad?
Yes. This can be done. On an iPad also
Thank you!!
Thank you!!! I can’t believe I never use this app before. This is easier than Excel for real. 😁
Thank you. I agree it’s easier.
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
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
Thank you, Daryl. I actually think this is a great point. We can attempt to offer more explanation as we move our cursor across the screen thank you.
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,
It’s a click and drag. You press down and drag your cursor to the location you want.
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 TH-cam 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.
I really want to watch but I can’t get past the lip smacking. I hope the other videos are not like that.
Well we have over 2000 subscribers so we are doing something right. Your more then welcome to find other videos that fit your voice preferences.
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
@@APPLE1TO1 Would it be possible to send over what I have? And you guys can tell me what direction would be best to proceed?
thinkdifferentpod@gmail.com
Thank you!!! This was super helpful and easy to understand! I will follow on IG too 😄
Thank you very much for the feedback. We appreciate it.
Awesome video! Thank you!
You are welcome!
Thank You!
Thank you!
You are welcome. Happy new year
Thank you!
You're welcome!