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.
I used Dell PC for 25 years. Finally got sick of it, with 2 mother boards replaced during the first year of a new Dell, and switched to Mac, and not going back. Wished I had switched earlier. Now I'm learning Pages, Numbers, and Keynote. Thank you for bringing me up to speed quickly!!
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!
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.
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!
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!
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.
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
Hi Gary Thank you. I appreciate your time and effort presenting this excellent tutorial. That was just what I have been wanting to learn; a whole lesson dedicated to working on a specific project using pages. I am an experienced Microsoft Publisher user. As a teacher, I was able to make my own certificates and teaching resources. I have been struggling to learn Pages. It appears to be a combination of Word and Publisher but I continually come across difficulties and don’t know where to turn. What I learned today is that I can still do all that but will have some extras functions to use not available with Microsoft. Using styles and making templates, is a big plus and time saver. Again my sincere thanks for increasing my knowledge and confidence to continue learning to use pages.
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!
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
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.
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 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.
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.
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.
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!
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
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 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.
What a great instructional video. Is there anyway of reading a spread sheet with formulas in it and locking the formula so that they can't accidentally be deleted or changed. I don't find this is an issue on a MacBook but do on an iPad when entering data
You can only lock tables, not individual cells. So you'd need to design your document with data inputs in one table and locked formulas in another table.
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.
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.
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."
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?
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...
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.
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.
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.
If you have the formula in every cell in a column (except header and footer rows) and then add a new row (like by being in the last regular row and pressing Return) then the formula should automatically appear in that new row.
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.
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.
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 used Dell PC for 25 years. Finally got sick of it, with 2 mother boards replaced during the first year of a new Dell, and switched to Mac, and not going back. Wished I had switched earlier. Now I'm learning Pages, Numbers, and Keynote. Thank you for bringing me up to speed quickly!!
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.
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.
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!
EXCELLENT TEACHING! [From one teacher to another]
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!
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.
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 🙂
Hi Gary
Thank you. I appreciate your time and effort presenting this excellent tutorial. That was just what I have been wanting to learn; a whole lesson dedicated to working on a specific project using pages.
I am an experienced Microsoft Publisher user. As a teacher, I was able to make my own certificates and teaching resources. I have been struggling to learn Pages. It appears to be a combination of Word and Publisher but I continually come across difficulties and don’t know where to turn.
What I learned today is that I can still do all that but will have some extras functions to use not available with Microsoft. Using styles and making templates, is a big plus and time saver.
Again my sincere thanks for increasing my knowledge and confidence to continue learning to use pages.
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!
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
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.
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.
Very useful.Doing all of my entries for 1099 on my taxes for musical gigs and teaching in this.I should probably check out your courses.Thanks again.
Are we just going to ignore the fact that Tom got an amazing deal? Great content. Learned a lot in one video.
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 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!
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.
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.
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!
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!
That’s fantastic! Thank-you. That’s got me started. Not easy to figure out until someone shows 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!
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
Thank you for this tutorial. Complete newbie to Numbers - never felt the need to know it until now :)
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.
I LOVE this tutorial! Thank you so much for this simple walk through.
By far the most understandable tutorial
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.
What a great instructional video. Is there anyway of reading a spread sheet with formulas in it and locking the formula so that they can't accidentally be deleted or changed. I don't find this is an issue on a MacBook but do on an iPad when entering data
You can only lock tables, not individual cells. So you'd need to design your document with data inputs in one table and locked formulas in another table.
Thanks you so much Gary, I learned so much from you :)
You explain so well, i really would like to learn more. Thank you Sir.
man's out here doing God's work even though no one asked for nor deserved it.
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! Exactly what I needed! Simple, easy to follow instructions :)
A very informative video tutorial today! Thank you, Gary! 👏🏻❤️
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!
I wish and hope that Gary knows just how AMAZING he is!
Gary im 100% agree with ALL positive comments from those folks that what your educational video 👍👍
thank you so much! so hard to find any useful help in the application
Hey Gary thanks for this video helped me get a basic business income and expenses sheet setup!
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!
Proper and easy explanation. Thank you
Great instruction for a newbie. Thank you so much.
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.
Thank you. So easy to understand - this was exactly what I was looking for 😊
I absolutely love your videos! You are my Mac education go to😀
Thanks Gary...appreciate all that you do!
Thank you so much!!! You are a total life saver!
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."
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.
Thank you for this video. Better than Apple explanations.
Yay..finally found what I am looking for..I'll have to tell U2 all about it. 😎
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
Great tutorial! Thank you for sharing!
Can you do this with a template ? I do not see the same things when I use the invoice that my Mac has... Thanks
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.
This video helped me so much thank you 🙏
Thanks, helped me a lot!
really enjoy your tutorials
Awesome job on this video, friend.
Can you please show how you're repeating the process for all the names? Or do I have to insert the formula for all 10k names I want to combine? TY!!
You can copy and paste formulas. I show that in the video.
That was helpful. Thank you.
This was fantastic! Thank You!
If you highlight the cells it adds it up for you too without the plus sign.
Does the copy and paste work if you have multiple formulas across the rows ?
Not sure what you mean. But just try it and see.
Thank you its basic but its really informative
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
Amazing thank you am learning so much from you ....thank you
i love your pace.
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.
Thank you very much. Fantastic tutorial video
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.
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.
Thank you for showing me how to move the formula box.
This was excellent
very useful thank you so much
Good video! Please how can i do as a macro in Numbers?
Can i do a data form?
Numbers doesn't do forms on the Mac. Not sure what you are trying to do "as a macro."
I want to do an automated data entry form like excel macros without coding
Thanks
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 .
Soooo helpful. Thank you!
Great video!
Thank you SO much.
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 love numbers. I used excel before I found numbers and numbers exceeds excel by far.
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?
Nice video, cheers
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.
can you set it up so the same formula is automatically the same on every row?
If you have the formula in every cell in a column (except header and footer rows) and then add a new row (like by being in the last regular row and pressing Return) then the formula should automatically appear in that new row.
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.
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?
Thank you mate
How do you fix the syntax error in Number when using the formula? Thanks
Depends what the error is. You have to examine your formula and figure out the mistake.
Can you have multiple formulas for different purposes in one cell?
Not sure what you mean. What would the "different purposes" be and why would you need to have both values in one cell? Be more specific.