You need a disclaimer that your videos are only for people who have used Microsoft Word for years and a merely slightly confused about some things with Mac. You are perfect for that group.
You are the best here, and I appreciate it. Please remember that YOU know what you are talking about; some do not. I am thinking particularly of the place where you are doing the cupcake thing and you go to a new something in "finder" and then suddenly you click and drag; I was "what , what??!!". This is just an example. I understand that all of this is new to me, but, if you can...And, you speak so well! I can understand every word you say! Thank you so so much!!
I learn a lot from your tutorials and would like to learn more in depth about numbers. I have switched from Excel and want to know more on how to navigate the many features of numbers and make useful spreadsheets for my own personal use.
I am just 13 and I can say that from my experience it was mind blowing when I tried using Numbers because what I was used to is excel. Thank you so much Sir for helping me out.
How you created the invoice without chuckling, I have no idea, but you're my new hero! Found you in search because of the new Mac OS Catalina update - trying to figure out if I really need to purchase Microsoft or if Numbers will be sufficient and I have lots of basic how-to and "where do I find that button"-type questions. I also want to know if I have a spreadsheet with a lot of columns, if it's possible - how to move all of the right-column Table/Cell/Text/Arrange functions to the top like it is in Excel. I can spend forever Googl'ing each one, or spend 10 or even 20 minutes watching a video. I haven't checked your video list yet, but if you don't have a "basics" video, now might be a good time to put one together. I'd bet you'll get a ton of views!!
Thank. You. Very. Much!!!! I thought Pages and Numbers were so hard to use but the layout of the apps is so visual and logical. And you explain all the basic functions so well and clearly! I’ll always remember this day as The Day I Finally Swiched from Word and Xcel for Mac to Pages and Numbers! Thanks to your clear explanation!
As an old excel user I must say I am enjoying Numbers much better. Writing formulas was not my strong suit but I think I can figure it out with numbers.
Thank you so much, David for the videos and hard work! Through your videos I’ve learnt the basics of Apple products and know how to use them to improve productivity and make everything so much easier to solve. You’re without a doubt a life saver and an inspiration for me to be able to share what I learnt with others. I just wanted to express my great admiration. Thank you thank you!! 🙂😁
I need to move a sheet from one Numbers document to another. Online resources said to do that from the File... menu, I see the move to... question is: do I have to have that target doc open to do this? Love your videos, David!!!
Using your vid, in ONE MINUTE, I found the answer I had been searching for for half an hour elsewhere! BRILLIANT! (How to replicate the same formula for multiple rows of figures)
I'm all thumbs (71 & new to Numbers) I'm using it to list all the apartments I'm searching through to choose the best to BUY in NYC. I've got a spreadsheet with location, price, descriptor and public trans, but how to manipulate basic boxes??? Thanks!
David Thank you so much for your videos your classes are always so informative and helpful Awesome! Please keep us updated with your classes you really are a great teacher! I used to be a windows person until I bought an iMac for the first time in my life, I was totally lost on how to use an iMac until I discovered you on TH-cam and I learned thanks to you! You have tought me how to love my iMac! Rosa A.
I'm going absolutely NUTS with this "Numbers" program! Been using Excel for decades with zero problems. How do you get rid of the page numbers? How do you insert a page break?
Do you have or will you have any tutorials on Numbers about how to copy the color of one cell to another cell like Format Painter in Excel?? Also, I may need to book a private lesson to help me figure out how to do something in a spreadsheet that I might sell. Thanks, Rick
For what I do I can make number work & if I need help, I stop by my Apple Store or call Apple Care and they will transfer the call to a Numbers advisor. Your demo is also helpful and I have made a bookmark 😎 • Cheers from The Detroit & Mackinac Railway 🚂
Vito Caressa that would be in the “Format” menu, then “Currency”. First click on the cell or highlight multiple cells and then format them to the currency you want
Thanks for this. Just bought a new Air and it has Numbers. If someone sends me an Excel document already made, can I use Numbers to open, modify, and save changes to it? Thanks.
Simple and precise vid David. I have been an Excel user for 25 yrs or more and have recently converted to numbers so any tutorials are always welcome. However, Im not so sure about the fishy tale :D
Hi David, I love your voice very calm.. btw could you make video how to manage file when your google drive storage max out 15 G. I am trying to save all my photos/videos on google drive on my LG stylo 4 but it wont let me due to google drive storage full. Are there any solutions so I could make more videos and transfer all my photos/videos on my Macbook pro? Thanks in advance.
Hello David, I am more used to MS Office products and struggling a bit with some of the more basic functions in Numbers that was not covered in your video and can not find out from the Numbers help screen or by trial and error as to how I save a numbers spread sheet to my iPad documents folder. Is there an easy way of doing this on an iPad?
Mark E, I have tried numerous times to access MS Windows 360 with my iCloud account but windows 360 (?) won’t recognise my password even after calling the Microsoft help desk, it also took 4 months of having to pay for a service that I could not access before I could cancel the subscription. I was hoping David A. Cox could show us how to freeze screens and some of the more basic functions that I use in excel but can’t find in Numbers.
@@warwickjarvis I hate MS. I have had the same issues with the 360 account. The only reason I still use MS is one program I use for work is Windows only. If it wasn't for that I wouldn't own a PC. If you are having problems with the MS cloud storage try Google Drive or Dropbox. I use multiple platforms, but for Numbers, Keynote, and Pages I use iCloud Drive....... Im not sure what you mean "freeze screen" I would have to read up on that. David does a good job teaching but another great resource for learning Numbers in macmostvideo. Gary is excellent
Is there a vid about just basic sheets in Numbers? How do you sort columns alphabetically, for example. Just really basic. I don't think most people use spreadsheets for finances. I work in the tech and legal industries and we use them for everything but finances.
Hey, thank you for your amazing videos, I have a question about Numbers and I hope you cold guide me. I want to be able to have a master data sheet that I can duplicate several times, make edits to the master that will automatically update on the other sheets. Is this possible? Thanks for your help.
Great video David I need to ask a question about numbers , With numbers can I make a simple input form to get the information from office people to input a database?
yeah you can, when you are creating the sheet/table select cells, select the data format drop down menu - select pop up menu then add you data item 1,2,3, etc. Then pull the yellow dot from cell A1 to A1000 to format the the whole of the column. now staff just select what they want.
Was wondering , is it possible to add a watermark to numbers? you may have covered this , but I didn't see it. thank you in advance for the quick reply.
Hi, my name is Ged, I live in France. I am 82 yrs old and only very slightly knowledgeable on my iPad. All I want from Pages is to be able to write simple letters. Having failed miserably so far only able to type my name but when trying to move one space down to add address can’t move the glyph. Any simple tips would help an old soldier. Thanks Ged.
Hi there, Thank you for your great video. I was wondering if you would be able to help me to know how can I email one sheet only from my several sheets in PDF format attachment. Thank you in advance.
It looks like LastPass, which was purchased by another password management company is going to be a subscription service. LastPass review summary. LastPass combines a host of great features with a handful of additional security tools. The latest version overcomes some of its past issues to become a password manager easily worth the already low price for $3 per month
hello I have been trying to learn a lot from your videos. and was looking for how to protect the formulas and locking them up so that nobody could se and more over when we delete (backspace) the formulas gets delete automatically. it will be a great help It might be possible while working I myself accidentally delete the formulas. plz help me get out of this Thank you
Can one sort data by colors in Number as you can with Excel? I transferred an Excel program to a new Mini M1. In Excel I could sort by colors. For example my sheet has over 1600 rows and 7 columns, as I find errors and correct them I highlight that entery with a color, then resort making sure the data is in the correct place. I cannot seem to find a way to do this with Mac Number, can you help?
I need a tutorial on double checking the storage of my Mac. iPads and iPhones to my time capsule 802.11n 2 to wifi-hard drive. I can't seem to find the information on the Apple site or TH-cam. I have over 33,000 photos on my MacBook Pro. I haven't deleted them because I want to verify that they are safe in the time capsule. I also have iCloud.
Irene Cortez just did that tonight. You’re Time Capsule should show up in the “Finder” on the left side. You can get into it there and verify any backup up files.
I wish you would dig deep in formula. my question is how to do more complex calculations in formula like for example tell numbers to add 2 numbers to the cell above; i.e the first cell is 8 am, below it is 10 am, below it is 12 am and so on.
My English listening comprehensibility is poor, but it's so amazing that I can understand your English almost 100%. You pronunciation is crystal clear with appropriate pace, and the content is informative and really helpful. Another thing that I couldn't help but notice is you have beautiful and attractive blue eyes. Fantastic.
Under the personal section in numbers there is a calendar. How do you change the month and year, and get the dates to auto-populate, so that the first falls on the correct day?
Great tutorial. I have a table with five columns. My last column is amount. After I enter the amount if I press return it creates a new row but goes to the cell below if I press tab it creates a new column. Is there a shortcut to advance to the first column in the new row or do I always have to use my mouse?
Hey. Need a formula to allow me to record ONLY the lowest 4 of "7" scores for golf. Here's an example of what I have now. It records the average of the last 4 scores posted. AVERAGE(OFFSET($A2,0,(MAX(1,(COUNTA($B2:$H2)-3),1,4)) Everything in the formula is correct except for maybe some parentheses. The actual formula looks like it's written by an artist, so I'm guessing what's what. If I could give you a picture, I would. Don't see that option. Let me know if you can help. Thanks.
Why can you not right-click on a cell in Numbers and just add a hyperlink to a file on your hard disk, just like you can do in Excel?? In Excel (even in a very old 2011 version..) I can just right click on a cell, and add a hyperlink to a file anywhere on my disk (and if it's a video, for example, the video files is opened with VLC player which is the default player I have selected to open videos. Simple.). Is it possible that in the year 2020 Numbers is still so far behind Excel?? Or is this function "hidden" somewhere Numbers and I just can't find it??
Thanks for the great video! I can't shade every oth row. I highlighted the Table as Apples instruction and checked the bos in Table for color but, it doesn't change anything. Thanks again, Ray
![[Full] 4 ต่อ 4 Celebrity EP.920 | 3 พ.ย. 67 | one31](http://i.ytimg.com/vi/KwiW2M_kAg4/mqdefault.jpg)
You need a disclaimer that your videos are only for people who have used Microsoft Word for years and a merely slightly confused about some things with Mac. You are perfect for that group.
You are the best here, and I appreciate it. Please remember that YOU know what you are talking about; some do not. I am thinking particularly of the place where you are doing the cupcake thing and you go to a new something in "finder" and then suddenly you click and drag; I was "what , what??!!". This is just an example. I understand that all of this is new to me, but, if you can...And, you speak so well! I can understand every word you say! Thank you so so much!!
David Cox is hands-down the BEST video trainer in the biz!
Thank you so much David!! Your hard work does NOT go unnoticed. I really appreciated this video very informative
I learn a lot from your tutorials and would like to learn more in depth about numbers. I have switched from Excel and want to know more on how to navigate the many features of numbers and make useful spreadsheets for my own personal use.
I am just 13 and I can say that from my experience it was mind blowing when I tried using Numbers because what I was used to is excel. Thank you so much Sir for helping me out.
now you are 14
How you created the invoice without chuckling, I have no idea, but you're my new hero!
Found you in search because of the new Mac OS Catalina update - trying to figure out if I really need to purchase Microsoft or if Numbers will be sufficient and I have lots of basic how-to and "where do I find that button"-type questions. I also want to know if I have a spreadsheet with a lot of columns, if it's possible - how to move all of the right-column Table/Cell/Text/Arrange functions to the top like it is in Excel. I can spend forever Googl'ing each one, or spend 10 or even 20 minutes watching a video. I haven't checked your video list yet, but if you don't have a "basics" video, now might be a good time to put one together. I'd bet you'll get a ton of views!!
Yup - keynote would be helpful, too -
Thanks muchly for your fine tutorials -
Thanks. Your feedback is appreciated!
You're really great at making these tutorials! So much I didn't know and which is NOT obvious! Thank you!
This dude is a pro. No Doubt. Thank you sir!
Thank. You. Very. Much!!!! I thought Pages and Numbers were so hard to use but the layout of the apps is so visual and logical. And you explain all the basic functions so well and clearly! I’ll always remember this day as The Day I Finally Swiched from Word and Xcel for Mac to Pages and Numbers! Thanks to your clear explanation!
Wonderfully clear and easy to understand! My highest endorsement!
You have great delivery. Good job.
Great! simple, straight forward. I like it, keep up the great videos
An awesome program which is super underrated! thanks for sharing
Thank you! Great video easy to follow and understand.
As an old excel user I must say I am enjoying Numbers much better. Writing formulas was not my strong suit but I think I can figure it out with numbers.
Thank you for the great overview. "Two Girls One Cupcake" huh? Anyone?
Julius S DeLaCruz glad I’m not the only one that saw that 😂
sheeeiiiit
I nearly spit out my drink all over my laptop!
😂😂😂
Sure nightmare of my childhood 😂
Great video my friend , glad to see something very simple
Super useful and easy to follow video, subscribed!
Nice, clear explanation, David.
Your videos and style of talking and teaching is amazing, awesome I love it :)
KEYNOT CLASS!
Thanks for your helpful info!
Thanks for making a tutorial. It’s full of knowledge. I’ll wait for next.
Thank you so much, David for the videos and hard work! Through your videos I’ve learnt the basics of Apple products and know how to use them to improve productivity and make everything so much easier to solve. You’re without a doubt a life saver and an inspiration for me to be able to share what I learnt with others. I just wanted to express my great admiration. Thank you thank you!! 🙂😁
I really learn a lot from your videos. Yes, Keynote.
I need to move a sheet from one Numbers document to another. Online resources said to do that from the File... menu, I see the move to... question is: do I have to have that target doc open to do this? Love your videos, David!!!
Thank you very much for this very nice explanation!
Kind regards!
Using your vid, in ONE MINUTE, I found the answer I had been searching for for half an hour elsewhere! BRILLIANT! (How to replicate the same formula for multiple rows of figures)
Excellent learning video. Thanks.
Good job, man.
How do 40 people not like this video? It's a great overview. Good gravy.
Great teacher!
Excellent video, same quality as your Pages video, both will sure help me get started using these 2 great apps.
Yes a KeyNote session would be good, please. Thank you for your help.
Amazing video! I learned so much that will save me a ton of time! Highly recommended and many thanks!
I'm all thumbs (71 & new to Numbers) I'm using it to list all the apartments I'm searching through to choose the best to BUY in NYC. I've got a spreadsheet with location, price, descriptor and public trans, but how to manipulate basic boxes??? Thanks!
Dorothy Knable What do you mean by “Manipulate boxes?” Do you mean to move a cell to a different location on the spreadsheet?
David Thank you so much for your videos your classes are always so informative and helpful Awesome! Please keep us updated with your classes you really are a great teacher! I used to be a windows person until I bought an iMac for the first time in my life, I was totally lost on how to use an iMac until I discovered you on TH-cam and I learned thanks to you! You have tought me how to love my iMac!
Rosa A.
'Two Girls One Cupcake' ---I fuckin busted up laughing. Thanks for that XD
I see what he did there ;)
hahhahaha
I'm going absolutely NUTS with this "Numbers" program! Been using Excel for decades with zero problems.
How do you get rid of the page numbers?
How do you insert a page break?
Joni Myatt page numbers is under the print menu. Go there and you will find a toggle to turn them on or off
Joni Myatt Page numbers is under the print menu. Go there and you will find a toggle to turn them on or off.
Hi David, great work as always, have loved and have benefited from all your videos. But yes to a Keynote video too ! Thanks for videos !!!
speaking of numbers, you are about to hit 600k!!! Rock on!
great tutorial
Thank you so much
"Gadget Addiction"! That cracked me up because it was so applicable! Great video. Love Numbers.
Do you have or will you have any tutorials on Numbers about how to copy the color of one cell to another cell like Format Painter in Excel?? Also, I may need to book a private lesson to help me figure out how to do something in a spreadsheet that I might sell. Thanks, Rick
Hey David, thank you for your help!
Very useful stuff, all best from Colombia!
For what I do I can make number work & if I need help, I stop by my Apple Store or call Apple Care and they will transfer the call to a Numbers advisor. Your demo is also helpful and I have made a bookmark 😎
• Cheers from The Detroit & Mackinac Railway 🚂
Two Girls One Cup.... Cake lol Never thought I'd ever see a reference to that haha. Great video though, super useful. 👍🏼
great information here in 12 minutes I've learned what I needed thank you!!
Any big changes for Numbers for the iPad? its a little different to navigate. thanks.
You're a life saver man.!! Keep up the good work!
I learned something today. Thanks
Thank you so much for this "Easy to Understand" video! I just upgraded my MacBook Pro, and am not ready to subscribe yearly to Excel downloads.
Thank you much appreciated.
The business name for the Invoice template. I see what you did there. We must be close in age. 🤣😉
Your tutorials are great. I have learned from them. I am interest in at least 1 or 2 private classes.
Cool beans!
Thanks David, i really love the portfolio. Just a question. I have canadian stocks. How can i change from US dollars to canadian dollars? Thanks
Vito Caressa that would be in the “Format” menu, then “Currency”. First click on the cell or highlight multiple cells and then format them to the currency you want
Great video, David.
All I can say is: ABOUT TIME!!! Thank you!
Thanks for this. Just bought a new Air and it has Numbers. If someone sends me an Excel document already made, can I use Numbers to open, modify, and save changes to it? Thanks.
Thanks David, learnt a few good tips in this vid.
Is there a way to have to status bar on iOS on iPad for Numbers app? To have quick access to selected cells average , sum, etc information.
Nitin Arora Could you be more specific? Maybe I can help....
Simple and precise vid David. I have been an Excel user for 25 yrs or more and have recently converted to numbers so any tutorials are always welcome. However, Im not so sure about the fishy tale :D
excellent. thanks David.
Hi David, I love your voice very calm.. btw could you make video how to manage file when your google drive storage max out 15 G. I am trying to save all my photos/videos on google drive on my LG stylo 4 but it wont let me due to google drive storage full. Are there any solutions so I could make more videos and transfer all my photos/videos on my Macbook pro? Thanks in advance.
Great vid. I would loke to know how to freeze pane in Numbers, thanks
Very nice
Hello David, I am more used to MS Office products and struggling a bit with some of the more basic functions in Numbers that was not covered in your video and can not find out from the Numbers help screen or by trial and error as to how I save a numbers spread sheet to my iPad documents folder. Is there an easy way of doing this on an iPad?
Warwick Jarvis I use my iCloud account. For me personally Ive found this to be the best. I would be open to suggestions though
Mark E, I have tried numerous times to access MS Windows 360 with my iCloud account but windows 360 (?) won’t recognise my password even after calling the Microsoft help desk, it also took 4 months of having to pay for a service that I could not access before I could cancel the subscription. I was hoping David A. Cox could show us how to freeze screens and some of the more basic functions that I use in excel but can’t find in Numbers.
@@warwickjarvis I hate MS. I have had the same issues with the 360 account. The only reason I still use MS is one program I use for work is Windows only. If it wasn't for that I wouldn't own a PC. If you are having problems with the MS cloud storage try Google Drive or Dropbox. I use multiple platforms, but for Numbers, Keynote, and Pages I use iCloud Drive.......
Im not sure what you mean "freeze screen" I would have to read up on that. David does a good job teaching but another great resource for learning Numbers in macmostvideo. Gary is excellent
Is there a vid about just basic sheets in Numbers? How do you sort columns alphabetically, for example. Just really basic. I don't think most people use spreadsheets for finances. I work in the tech and legal industries and we use them for everything but finances.
damn David I just subbed cuz of the time codes I'm not even a minute into the video. Thank you!
Hey, thank you for your amazing videos, I have a question about Numbers and I hope you cold guide me. I want to be able to have a master data sheet that I can duplicate several times, make edits to the master that will automatically update on the other sheets. Is this possible? Thanks for your help.
Great video David I need to ask a question about numbers , With numbers can I make a simple input form to get the information from office people to input a database?
yeah you can, when you are creating the sheet/table select cells, select the data format drop down menu - select pop up menu then add you data item 1,2,3, etc. Then pull the yellow dot from cell A1 to A1000 to format the the whole of the column. now staff just select what they want.
Was wondering , is it possible to add a watermark to numbers? you may have covered this , but I didn't see it. thank you in advance for the quick reply.
Switching Microsoft Word, Excel and PowerPoint can I have my files in iWork respectively?
His eyes stare into my soul...
Thank you, David, I learned some things.
Keynote? No... Advanced features? Yes!
Hi David, thanks for the video. 1 quick question- what is the way to add "Add In" in Numbers, the way we do for Excel
This is great! Thanks, this helped me a lot!
Hi, my name is Ged, I live in France. I am 82 yrs old and only very slightly knowledgeable on my iPad. All I want from Pages is to be able to write simple letters. Having failed miserably so far only able to type my name but when trying to move one space down to add address can’t move the glyph. Any simple tips would help an old soldier. Thanks Ged.
Thank You
Hi there,
Thank you for your great video.
I was wondering if you would be able to help me to know how can I email one sheet only from my several sheets in PDF format attachment.
Thank you in advance.
It looks like LastPass, which was purchased by another password management company is going to be a subscription service. LastPass review summary. LastPass combines a host of great features with a handful of additional security tools. The latest version overcomes some of its past issues to become a password manager easily worth the already low price for $3 per month
hello
I have been trying to learn a lot from your videos. and was looking for how to protect the formulas and locking them up so that nobody could se and more over when we delete (backspace) the formulas gets delete automatically. it will be a great help
It might be possible while working I myself accidentally delete the formulas. plz help me get out of this
Thank you
Can one sort data by colors in Number as you can with Excel? I transferred an Excel program to a new Mini M1. In Excel I could sort by colors. For example my sheet has over 1600 rows and 7 columns, as I find errors and correct them I highlight that entery with a color, then resort making sure the data is in the correct place. I cannot seem to find a way to do this with Mac Number, can you help?
Very helpful! Thank you so much 👍🏻
I need a tutorial on double checking the storage of my Mac. iPads and iPhones to my time capsule 802.11n 2 to wifi-hard drive. I can't seem to find the information on the Apple site or TH-cam. I have over 33,000 photos on my MacBook Pro. I haven't deleted them because I want to verify that they are safe in the time capsule. I also have iCloud.
Irene Cortez just did that tonight. You’re Time Capsule should show up in the “Finder” on the left side. You can get into it there and verify any backup up files.
hey, is there any way to export data from a pdf sheet to mac numbers? (without using any third party software)
I wish you would dig deep in formula. my question is how to do more complex calculations in formula like for example tell numbers to add 2 numbers to the cell above; i.e the first cell is 8 am, below it is 10 am, below it is 12 am and so on.
Hoda Alavi is it a “Time” duration that you are trying to calculate?
My English listening comprehensibility is poor, but it's so amazing that I can understand your English almost 100%. You pronunciation is crystal clear with appropriate pace, and the content is informative and really helpful. Another thing that I couldn't help but notice is you have beautiful and attractive blue eyes. Fantastic.
Is individual cell protection possible?
Hi, can you make a quick video about the new features of Keynotes, Numbers and Pages that where release a few days ago?
Under the personal section in numbers there is a calendar. How do you change the month and year, and get the dates to auto-populate, so that the first falls on the correct day?
Great tutorial. I have a table with five columns. My last column is amount. After I enter the amount if I press return it creates a new row but goes to the cell below if I press tab it creates a new column. Is there a shortcut to advance to the first column in the new row or do I always have to use my mouse?
Hey. Need a formula to allow me to record ONLY the lowest 4 of "7" scores for golf. Here's an example of what I have now. It records the average of the last 4 scores posted.
AVERAGE(OFFSET($A2,0,(MAX(1,(COUNTA($B2:$H2)-3),1,4)) Everything in the formula is correct except for maybe some parentheses. The actual formula looks like it's written by an artist, so I'm guessing what's what. If I could give you a picture, I would. Don't see that option. Let me know if you can help. Thanks.
I have a question, how can I change the color of a cell by checking a checkbox?
"Two girls one cupcake" Um, that was unexpected...
Why can you not right-click on a cell in Numbers and just add a hyperlink to a file on your hard disk, just like you can do in Excel?? In Excel (even in a very old 2011 version..) I can just right click on a cell, and add a hyperlink to a file anywhere on my disk (and if it's a video, for example, the video files is opened with VLC player which is the default player I have selected to open videos. Simple.). Is it possible that in the year 2020 Numbers is still so far behind Excel?? Or is this function "hidden" somewhere Numbers and I just can't find it??
Thanks for the great video! I can't shade every oth row. I highlighted the Table as Apples instruction and checked the bos in Table for color but, it doesn't change anything. Thanks again, Ray