An Introduction To Using Formulas In Mac Numbers
ฝัง
- เผยแพร่เมื่อ 2 ก.ค. 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
▶︎ TH-cam - macmost.com/j-youtube (And hit the 🔔)
▶︎ TH-cam 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 - วิทยาศาสตร์และเทคโนโลยี
![แม่กลองสองใจ - ซีแกรม โตเกียว มิวสิค [ OFFICIAL MUSIC VIDEO ]](http://i.ytimg.com/vi/GSQfVjcr_f4/mqdefault.jpg)
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 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.
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
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.
Thank you Gary. I used Excel 25 years ago and now, in my 70's, I am relearning spreadsheets on a Mac. Very useful
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!
I LOVE this tutorial! Thank you so much for this simple walk through.
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.
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!
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 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!
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.
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
Man that footer row thing has blown my mind - I had no idea! Thanks a bunch Gary 🙂
A very informative video tutorial today! Thank you, Gary! 👏🏻❤️
EXCELLENT TEACHING! [From one teacher to another]
Thank you. So easy to understand - this was exactly what I was looking for 😊
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.
That’s fantastic! Thank-you. That’s got me started. Not easy to figure out until someone shows you!
Thank you! Exactly what I needed! Simple, easy to follow instructions :)
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.
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!
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.
Wow, i dont know why I didn’t see basic tutorials for numbers. Great video, i learned so much!
Great instruction for a newbie. Thank you so much.
I'm so thankful I discovered your channel (after buying my Mac). I can't begin to tell you how much I've learned.
Thanks Gary...appreciate all that you do!
Are we just going to ignore the fact that Tom got an amazing deal? Great content. Learned a lot in one video.
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!
Gary, God bless your heart for helping us out and for making it easy. I meant it.
Proper and easy explanation. 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!
Thanks you so much Gary, I learned so much from you :)
Great tutorial! Thank you for sharing!
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.
Interesting once again. Today I learned about the footer row, something that doesnt exist in other spreadsheets like Excel.
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!
Gary im 100% agree with ALL positive comments from those folks that what your educational video 👍👍
Thank you so much!!! You are a total life saver!
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!
By far the most understandable tutorial
really enjoy your tutorials
Thank you very much. Fantastic tutorial video
You explain so well, i really would like to learn more. Thank you Sir.
This was fantastic! Thank You!
I absolutely love your videos! You are my Mac education go to😀
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
So helpful. Thank you!
thank you so much! so hard to find any useful help in the application
This video helped me so much thank you 🙏
Thanks, helped me a lot!
Soooo helpful. Thank you!
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.
I wish and hope that Gary knows just how AMAZING he is!
Amazing thank you am learning so much from you ....thank you
i love your pace.
Great video!
Hey Gary thanks for this video helped me get a basic business income and expenses sheet setup!
Thank you SO much.
You a real one for this 😘
Thank you its basic but its really informative
THANK YOU!
very useful thank you so much
Thank you!!
Awesome job on this video, friend.
Thank you for this video. Better than Apple explanations.
Thank you mate
Nice video, cheers
Yay..finally found what I am looking for..I'll have to tell U2 all about it. 😎
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.
Thank you for showing me how to move the formula box.
Great video
Thank you
man's out here doing God's work even though no one asked for nor deserved it.
EXCELLENT!!!!
very useful
thanks a lot
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.
EXCELLENT
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.
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."
If you highlight the cells it adds it up for you too without the plus sign.
Can you do this with a template ? I do not see the same things when I use the invoice that my Mac has... Thanks
Holy crap! I’ve had this on my Mac the whole time and been fooling with office 360! That ends today
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.
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?
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.
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.
I love numbers. I used excel before I found numbers and numbers exceeds excel by far.
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 th-cam.com/video/ygVZYEwIIjE/w-d-xo.html
with power cost going up. Can you please make a video on a day to day electricity usage calculator?
Not sure what you'd want in a tutorial on that. Just keeping track of your bill?
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
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.
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. th-cam.com/video/RVFXSwXaVaU/w-d-xo.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?
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 .
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.
Is it possible to make a title for a footer cell with where the text is aligned left and the number is aligned right?
Not sure what you mean. A cell contains a single value. So you would have one cell with text, and other cell with a number.
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.