An Introduction To Using Formulas In Mac Numbers
HTML-код
- Опубликовано: 6 июл 2024
- macmost.com/e-2641 Learn the basics of using formulas to perform calculations in the Numbers spreadsheet app. You can perform basic arithmetic, copy and paste formulas to multiple rows, and use functions to get the sum of a column.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ RUclips - macmost.com/j-youtube (And hit the 🔔)
▶︎ RUclips Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/newsletter ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
00:00 Intro
00:31 Entering Values
01:08 Entering Formulas
04:22 Basic Arithmetic
04:53 Header Rows and Columns
06:20 Relative Copy and Paste
09:00 Functions
10:23 SUM Function
11:18 Proper Use of Tables
12:51 Footer Row
#macmost #numbers 
Наука
After many years with Windows Computer, I switched to an iMac. I stopped using Office and started exploring Pages and Numbers. These videos are a big help to me.
You are a very good, accessible educator, Gary.
I know all of this but you have made it accessible to people who may not understand spreadsheets in a really accessible way 👍 Thanks for all you do.
As an older (70's) learner, I appreciated the easy to understand detailed explanations that you provide in order to learn how to create the desired results on what I'm trying to accomplish. You speak clearly and at a good pace so it allows me to stop the video to rewind it or practice implementing what you are saying very easily. Other educators put too many details into one video making it way too confusing to me. Your method of starting with the basics in one video, without going into too much detail, allows me to understand & remember what I've learned before moving on to the next level on the subject. Thank you so much!
Ditto my friend! At 76 it take a lot more concentration etc.
Brilliant. You are a great teacher. I have been doing spread sheets, both Numbers and Excel for decades (literally), and never knew about footer rows until I watched this video. Thank you. And you go at just the right speed
I just found your page and am so grateful! I’ve been looking for simple concise instructions to use numbers and your video are incredibly helpful! Thank you for creating these to help us learn and use these tools more effectively 🙏🏼. You are sincerely appreciated!
Great video yet again. As a rudimentary spreadsheet user I only know the most basic functions and tend to often do things in a more complicated and labor-intensive manner than necessary. TIL about footer rows. Many thanks for growing my knowledge so painlessly.
At 72 I have transitioned from PC to Mac and now am forced to forget Excel and learn Numbers! Thank you for this basic introduction that has allowed me to build my spreadsheets again! You made it an easy transition!
Man that footer row thing has blown my mind - I had no idea! Thanks a bunch Gary 🙂
Thank you Gary. I used Excel 25 years ago and now, in my 70's, I am relearning spreadsheets on a Mac. Very useful
I LOVE this tutorial! Thank you so much for this simple walk through.
Thanks again, Barry. As a 75+er coming back after 6 weeks abroad without a computer, I found this invaluable (again!)! It's amazing what you forget at my age. You are so reassuring. Thank you.
You are able to learn, understand and simplify the various Apple software so profoundly. I find the easier than MS but you take it to the next level.
That’s fantastic! Thank-you. That’s got me started. Not easy to figure out until someone shows you!
Wanted to make a spreadsheet budget for my family's overseas vacation this summer and had no idea where to start. This helped tremendously. Thank you!
Thank you. So easy to understand - this was exactly what I was looking for 😊
A very informative video tutorial today! Thank you, Gary! 👏🏻❤️
Thank you for all the videos! They are all very helpful. I've used Macs exclusively for 30 years and wouldn't change, but I have never really used Numbers but after watching your video, I will. I learn so much from you.
You are so bloody good at explaining things. The vast majority of 'teachers' on here always talk from a place where they assume we must already know the most basic things but you don't do that, you explain it from the root to the branch. Thank you very much! This has helped me more than you could know! New subbie! New Like!
Thanks bunches. I have Microsoft 365 subscription on my two iMac as I thought I would never learn to use Pages or Numbers...but thanks to you, I am learning. I am not renewing my 365 as I have Office 2016 on a PC laptop. Again, you have made the journey into Apple enjoyable. And again, I do enjoy your basics video and hope you never stop offering them.
EXCELLENT TEACHING! [From one teacher to another]
Thank you! Exactly what I needed! Simple, easy to follow instructions :)
I'm so thankful I discovered your channel (after buying my Mac). I can't begin to tell you how much I've learned.
I'm new to using numbers but have used excel since grade school. Thank you for this video, it helped me figure out how to do functions in numbers!
No words can express how thankful i am 😭 i hv to submit a work tmrw and ur video just saved me from days of working with these numbers 😭 thank you a looot
Thanks so very much,finally i understand how to use this function. I am a senior citizen and new to use of spreadsheets. Really good explanation.
Wow, i dont know why I didn’t see basic tutorials for numbers. Great video, i learned so much!
Thank you subbed and liked. Been using numbers formulae for many years. Changed jobs 5 years ago. Totally forgot how to even start a formula. Thank you I am starting to remember again.
Thanks Gary...appreciate all that you do!
AWESOME! I learned this years ago and now needed a spreadsheet. I think I tossed my notes-yikes. This got me going! Thanks for making it easy!
wow, I wish I would have found you sooner. You have a clear-sounding voice and I love the pace. I subscribed and look forward to watching more of your videos.
Great instruction for a newbie. Thank you so much.
Interesting once again. Today I learned about the footer row, something that doesnt exist in other spreadsheets like Excel.
Proper and easy explanation. Thank you
Thanks you so much Gary, I learned so much from you :)
I really like your Numbers videos. It took me a while to convert from Excel to Numbers and your videos have made this transition easier. Thank you!
I wanted to come on here to say thank you so much for these videos! I am a brand new Mac Desk top user. Just bought my very first MAC computer and received it yesterday and I have to say you are an absolute God send! Thank you for your very helpful videos! I am a dog walker and I like to keep a track of the miles I do from each dog walk and this was EXTREMELY easy and helpful to someone who is not very technologically intelligent. HA HA or at least I didn't think I was! Now I feel like a badass getting to use this computer! Thank you again! :-). Happy new year!
Great tutorial! Thank you for sharing!
really enjoy your tutorials
Hi Gary,
1.000 likes to you.
I worked with DOS > Windows > Office for the last 35 years and consequently I became addicted of Microsoft products.
Now I decided to jump in to the Apple's ecosystem and I'm really well surprised.
Thanks to your tutorials I'm learning really fast this environment - I'm seeing all of your videos.
Thank you very much to you
Again, 1.000 likes to you.
Regards,
António
This was fantastic! Thank You!
Thanks, helped me a lot!
This video helped me so much thank you 🙏
Thank you so much!!! You are a total life saver!
Great video!
Are we just going to ignore the fact that Tom got an amazing deal? Great content. Learned a lot in one video.
So helpful. Thank you!
thank you so much! so hard to find any useful help in the application
Thank you very much. Fantastic tutorial video
I absolutely love your videos! You are my Mac education go to😀
Gary, God bless your heart for helping us out and for making it easy. I meant it.
i love your pace.
As others have commented, you have a serious gift for teaching. Using Numbers is also a dream. I had previously used a competitor's product for 20 years, pulling my hair out when it came to formulas, but after watching your video, I was off any running, and it was fun! Thank you so much for your time on this. All of your video's are outstanding.
By far the most understandable tutorial
You explain so well, i really would like to learn more. Thank you Sir.
Soooo helpful. Thank you!
Thank you!!
Nice video, cheers
Thank you SO much.
very useful thank you so much
THANK YOU!
Amazing thank you am learning so much from you ....thank you
You a real one for this 😘
Thank you mate
Great video
Awesome job on this video, friend.
Hey Gary thanks for this video helped me get a basic business income and expenses sheet setup!
I retired 12 years ago after having to use MS apps for many years. What many do not know is that a few years be before retiring I did most of my work,on my Powerbook and iMac and then converted them to MS format to use on my windows machine at the office. That God for USB thumb drives.
Thank you its basic but its really informative
Gary im 100% agree with ALL positive comments from those folks that what your educational video 👍👍
EXCELLENT!!!!
Yay..finally found what I am looking for..I'll have to tell U2 all about it. 😎
Thank you
As others have said you are a great teacher. I am 85 years old and I find I need to use a simple spreadsheet for my money accounts for the home. Thank you for your clear and concise explanations. John.
very useful
I wish and hope that Gary knows just how AMAZING he is!
Thank you for showing me how to move the formula box.
Thank you for this video. Better than Apple explanations.
Hi Gary, how to change the options there so it doesnt round the numbers up? I need to be more accurate within the "budget" template.
thanks a lot
EXCELLENT
man's out here doing God's work even though no one asked for nor deserved it.
Can you do this with a template ? I do not see the same things when I use the invoice that my Mac has... Thanks
I am trying to use the IF function to say if the value in a certain column = 0.00, then the value in another column will =0.00 The particular column also has another = function in it. Could anyone show me how to do that?
Holy crap! I’ve had this on my Mac the whole time and been fooling with office 360! That ends today
Gary, another great tutorial from you. Keep it up. Is there any way we can link our eTrade account and portfolio to Numbers which will help to review it from Numbers. This will help to use the regularly updated Portfolio with various Number functions. Yahoo finance allow to link eTrade and thought may be Mac also has some option to link / import portfolio from eTrade
No, there's no easy way to do that. I'm guessing ETrade has some sort of download function where you could get a CSV, but it would be a one-time download and nothing "linked."
Hey Gary. I appreciate your contribution of knowledge towards helping us novices. A question- if I insert a value into a cell, then I want the next cell below it to show an amount 5% higher than that number, how would I create that formula? I’ve tried B3+5%, but obviously it doesn’t work. I’d appreciate any advice. Thanks🤔😵💫
This just in… a friend advised me to try (B3)*1.05. It worked so I’m good to go. Thanks.
Nothing complex, just basic math: you multiply by 1.05.
Hi Gary, Is there any way to add a function like 'Average' to multiple rows which are already occupied by values? I have hundreds of rows with just a plain number in each of them and have no idea how to assign 'Average' to all of them at once. I'd really appreciate it if you could please kindly advise.
BTW, your videos are always the best.
Not sure what you mean. You can use the AVERAGE function to find the average of a range of cells. But if there are already values there, then I'm not sure what you are asking. Calculate the averages in a new location.
If you highlight the cells it adds it up for you too without the plus sign.
I was surprised you didn't mention using the yellow dot that appears at the bottom of the selected formula cell to drag the formula down several rows in the column. It's quicker than copying, shift-clicking the cells and then pasting.
Because that, and a lot of other techniques like it, just confuse things when you are dealing with "An Introduction To..." video. Got to keep it simple. You can easily add those shortcuts and tricks later on, after you understand how formulas work.
@@macmost That makes sense. Thanks for explaining the reason.
What is the formula for entering the next numeric value in a column ? For e.g: If I have a column that needs to be 1, 2, 3, etc can I do this with a formula instead of typing the numbers for each column?
The main way you would do that is with autofill. See ruclips.net/video/ygVZYEwIIjE/видео.html
Can we input formulas in drop down menus? I want to use drop down options to that reference other cells
No way to do that.
Is there a syntax for finding the difference between 2 values? I think I remember using something like =dif ....etc years ago but it doesn't seem to work anymore. While I can type out (for example) B2-G2, it's kinda awkward. Just asking...
Subtracting them is the way to find the difference. If you want an absolute value, put the ABS function around it.
Hi Gary, Is there any way to create a formula on a spread sheet that has a column with a running total as each new row is added?
I want to track my mileage and I have one column with date, one column with Job, one column with Miles and then a total in the footer but I want to have another column that keeps adding the previous totals as I enter data so I can see how many miles I drove in a month or a week.
Yes. Do exactly that. So if column E is miles, then F can be a running total. F2 would have SUM(E$2:E2) so then when you put that same formula in F3 it would be SUM(E$2:E3) and so on. The $ is notation for "Preserve Row/Column" which you can set by clicking on the reference in the formula.
@@macmost Thank you. Does this mean I need to enter the SUM(E2:E3) in every row of the column that will have the running total?
@@swaha55 No. Copy and paste. If you copy SUM(E$2:E3) from F3 and paste it in F4, you should get SUM(E$2:E4). Try it and see.
guys I am really struggling with a project on numbers, I need a drop down menu to populate one of three numbers dependant on certain sequences of answers chosen by 6 other drop down menus
I'm new to Numbers. What am I doing wrong? Entering "=" doesn't put me into a formula mode it just thinks I'm entering the character "=" as part of my data. Entering any cell references after that are also treated as just data.
(After I wrote the comment above I tried it the manual way you mentioned at the beginning (insert/formula/etc.) and it worked. Now, every time I enter a "=" it starts a formula. Is it normal that you have to use insert/formula the first time?)
Not sure what you were experiencing there. Pressing = with a cell selected should just take you into formula entry mode. Glad it is working for you now.
Hi Gary, how to sum the same cell across multiple sheets in mac numbers as a formula? thanks
You can use INDEX or INDIRECT for that. ruclips.net/video/RVFXSwXaVaU/видео.html
Hi Gary i am trying to convert decimal time to hh:mm in numbers. I would really appreciate if you could help me out with this.
Thank you
What do you mean exactly? First, do you mean date and time, or do you mean duration? If duration, then do you mean you want 5.5 converted to 5h 30m?
Question: How do I Unhide only selected rows or columns NOT ALL in Numbers on iPad?
I don't think you can. You unhide all, then hide the ones you you still don't want to see.
How do you calculate a row of numbers to show the balance at the end of the row if you know what your balance is? Example: If I enter a number of cost, let's say 7 columns that indicate payments. I want the end of the row to show what balance is left. Thx
Depends on how you have it set up. If you have a column that is "deposits" and other that is "withdrawals" then you take the value from the balance in the row above, add one and subtract the other. Repeat for each row.
Hello Gary, hoping you can point me in the right direction. Loved your video on Numbers Budget and I like the person budget template but the one transaction sheet for a year is over wielding, so I want a transaction sheet for each month. I've tried adjusting the formula to accommodate that but just end up with the dreaded red triangle in my cells. Can you point to to another of your videos or other help. Thank you.
I wouldn't do transactions-per-month. Keep it all in one table. Dividing your transactions into months makes it very hard to do calculations on them. Just have one table with all of your transactions, with one per row. Filter if needed. Use pivot tables if needed. As for errors in formulas, it is just a matter of looking at the error message, then looking at your formula and making adjustments. There's no one-size-fits-all solution to correcting mistakes. You need to assess, plan, try things out, repeat.
@@macmost thank you very much. I will take your suggestion and use either filter and or pivot tables. Thank you .