How To: Creating a Budget using Apple Numbers on a Mac
HTML-код
- Опубликовано: 15 июл 2024
- Former Apple Creative discusses how to use Apple Numbers to create a monthly budget.
ApplePodcasts: apple.co/37Z2VDW
Spotify: spoti.fi/3oV36pR
Stitcher: bit.ly/3kL0lVG
Google Podcasts: bit.ly/3e5GFJv
Pandora: pandora.app.link/sJDWIDzKYab
Amazon Music: amzn.to/3e4d2Z2
Twitter: / thinkdiffpod
Facebook: / thinkdifferentpod
LaunchpadDM: www.launchpaddm.com/pd/Think-...
From the perspective of former Apple Geniuses and Creatives at Apple retail, we aim to enrich our listeners with personal customer stories. Also, coverage of Apple news, live reactions during Apple Events, and so much more. We love to educate and talk about everything at Apple. We challenge you to Think Different. Наука
exactly what I was looking for. Thanks
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!
Dude, that was great. Thank you!!
Thank you this was very easy to follow. Excited for what else you have to offer.
Check out our numbers training playlist
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
This is a great video!! I think I finally understand Numbers. Thanks.
Thank u 🎉
Great tutorial! Thank you. Just what I needed.
Thank you for the feedback.
Amazing indeed. I followed this all the through an did my own. Thank you for sharing.
Awesome feedback.
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
Thank You!
Thank you soooo much. I have been trying to figure this out for a while now
Happy to help
Great information. I'm going to start my spread sheet now!!! Thank you
Awesome Mary. Thank you
This was extremely helpful - thank you for your efforts!
No problem. Happy to help.
Thank you so much! This is so much easier than Apple Numbers Help!!
I love to hear this!!! Thank you
excellent instruction, especially for a beginner to numbers
Thank you very much. Many videos are numbers in pages are on our channel.
Thanks for breaking this down so easily. Look forward to using it.
Glad it was helpful!
Thanks!
Very helpful and easy to follow
Thank you for the feedback!
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.
Really useful! Thank you!
Glad it was helpful!
Thank you so much for your video!
That’s awesome! Thank you
Fantastic!! - Thanks so much.
Happy to help!
thank you
You are welcome!
great video, thanks so much!
Our pleasure 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!
Amazing tutorial. Thank you
Happy to help
Awesome video! Thank you!
You are welcome!
Great walk through. Detailed to a Tee.
Thank you for the feedback
Thank you!
You are welcome. Happy new year
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.
thanks need all this help!!
I am happy to help!!!!
Very helpful. Thank you.
You're welcome!
Thank you, very informative
You are welcome
Awesome! Thanx
Thank you very much!
This is the best tutorial.
Thank you. Very Proud of this one!
Great to watch
Thanks, Tone! We hope to create more content you like!
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
ruclips.net/p/PL9sScDdMR-OefCWHwoyOa0C9h6YPtuq-0
thanks dude !
You are welcome
Thank you this was cool
Thanks for the feedback! Happy to help
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!!! This was super helpful and easy to understand! I will follow on IG too 😄
Thank you very much for the feedback. We appreciate it.
Great tutorial! ❤❤😊
Thank you Pat!
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
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.
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😊
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.
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.
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
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.
How did you bring 3 sheets on one page?
There is a plus sign on the top left you can add sheets
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
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.
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
Can this be done on a IPad?
Yes. This can be done. On an iPad also
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.
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
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 RUclips 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!
You're welcome!
Thank you!
You are welcome. Let us know what else you like