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.
@permonjackson9696
5 жыл бұрын
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.
@user-gp8mb4qw3m
4 жыл бұрын
now you are 14
@sflick2558
5 жыл бұрын
David Cox is hands-down the BEST video trainer in the biz!
@Germie2352
5 жыл бұрын
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.
@josephcollins6033
3 жыл бұрын
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!!
@garypillischafske1425
5 жыл бұрын
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.
@wuppyluvr8675
4 жыл бұрын
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!!
@erik_daems
4 жыл бұрын
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!
@PeterQuentercrimsonbamboo
5 жыл бұрын
Yup - keynote would be helpful, too - Thanks muchly for your fine tutorials -
@TechTalkAmerica
5 жыл бұрын
Thanks. Your feedback is appreciated!
@josh8490
5 жыл бұрын
Thank you so much David!! Your hard work does NOT go unnoticed. I really appreciated this video very informative
@JuliusSDeLaCruz
4 жыл бұрын
Thank you for the great overview. "Two Girls One Cupcake" huh? Anyone?
@joecervantes1427
4 жыл бұрын
Julius S DeLaCruz glad I’m not the only one that saw that 😂
@UVPimpernel
4 жыл бұрын
sheeeiiiit
@HaulinAssAssin
4 жыл бұрын
I nearly spit out my drink all over my laptop!
@WmsYTpage
4 жыл бұрын
😂😂😂
@lillianlee25
4 жыл бұрын
Sure nightmare of my childhood 😂
@Taraandmusic
5 жыл бұрын
'Two Girls One Cupcake' ---I fuckin busted up laughing. Thanks for that XD
@dcreate
4 жыл бұрын
I see what he did there ;)
@sameerdhalwani775
3 жыл бұрын
hahhahaha
@nicfarrow
2 жыл бұрын
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)
@Hyvelez
3 жыл бұрын
"Two girls one cupcake" Um, that was unexpected...
@jimlee6280
5 жыл бұрын
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!! 🙂😁
@trainroomgary
5 жыл бұрын
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 🚂
@dorothyknable9825
4 жыл бұрын
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!
@marke2401
4 жыл бұрын
Dorothy Knable What do you mean by “Manipulate boxes?” Do you mean to move a cell to a different location on the spreadsheet?
@DianaMecum
4 жыл бұрын
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.
@joshuapeck8850
4 жыл бұрын
How do 40 people not like this video? It's a great overview. Good gravy.
@rick_brindle
2 жыл бұрын
The business name for the Invoice template. I see what you did there. We must be close in age. 🤣😉
@WealthGambit
2 жыл бұрын
Two Girls One Cup.... Cake lol Never thought I'd ever see a reference to that haha. Great video though, super useful. 👍🏼
@rajarajanmanoharan
4 жыл бұрын
His eyes stare into my soul...
@emerycarlsten1677
5 жыл бұрын
Among everything, it is interesting that Numbers will open a Microsoft Excel spreadsheet if I got that correctly.
@marke2401
4 жыл бұрын
Emery Carlsten yes that is correct. Numbers will also export as an Excel file.
@MrNojoke911
4 жыл бұрын
This dude is a pro. No Doubt. Thank you sir!
@Melimax83
4 жыл бұрын
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.
@marke2401
4 жыл бұрын
Nitin Arora Could you be more specific? Maybe I can help....
@johnmcclung4736
Жыл бұрын
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!!!
@QueAquatics
5 жыл бұрын
speaking of numbers, you are about to hit 600k!!! Rock on!
@Creative7inc
5 жыл бұрын
An awesome program which is super underrated! thanks for sharing
@sangotal
2 жыл бұрын
You're really great at making these tutorials! So much I didn't know and which is NOT obvious! Thank you!
@clorineharris8335
5 жыл бұрын
Your tutorials are great. I have learned from them. I am interest in at least 1 or 2 private classes.
@TechTalkAmerica
5 жыл бұрын
Cool beans!
@jonimyatt2920
4 жыл бұрын
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?
@marke2401
4 жыл бұрын
Joni Myatt page numbers is under the print menu. Go there and you will find a toggle to turn them on or off
@marke2401
4 жыл бұрын
Joni Myatt Page numbers is under the print menu. Go there and you will find a toggle to turn them on or off.
@walt1849
3 жыл бұрын
KEYNOT CLASS!
@saurabhsoni1759
4 жыл бұрын
Your videos and style of talking and teaching is amazing, awesome I love it :)
@jimtipton8888
5 жыл бұрын
"Gadget Addiction"! That cracked me up because it was so applicable! Great video. Love Numbers.
@billg1213
2 жыл бұрын
Wonderfully clear and easy to understand! My highest endorsement!
@jonminer9891
5 жыл бұрын
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
@rosaalvarez9534
5 жыл бұрын
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 KZitem and I learned thanks to you! You have tought me how to love my iMac! Rosa A.
@deeapple1096
2 жыл бұрын
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.
@brianmarkie4667
5 жыл бұрын
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
@serafinsilva1055
5 жыл бұрын
Keynote? No... Advanced features? Yes!
@shahkar_alam
5 жыл бұрын
Thanks for making a tutorial. It’s full of knowledge. I’ll wait for next.
@irenecortez7819
5 жыл бұрын
I really learn a lot from your videos. Yes, Keynote.
@jsjiang6120
5 жыл бұрын
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.
@MorinProductions
5 жыл бұрын
Excellent video, same quality as your Pages video, both will sure help me get started using these 2 great apps.
@charlenes.1005
2 жыл бұрын
Great! simple, straight forward. I like it, keep up the great videos
@gotcaldwell
3 жыл бұрын
You have great delivery. Good job.
@joedaddezio5869
4 жыл бұрын
Any big changes for Numbers for the iPad? its a little different to navigate. thanks.
@hodaalavi5564
5 жыл бұрын
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.
@marke2401
4 жыл бұрын
Hoda Alavi is it a “Time” duration that you are trying to calculate?
@silbannacusofoxyrhynchus6096
4 жыл бұрын
Good job, man.
@pauleastwood734
4 жыл бұрын
Great teacher!
@estradaj777
3 жыл бұрын
Great video my friend , glad to see something very simple
@rapaent
4 жыл бұрын
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
@eliseuramim9883
2 жыл бұрын
Switching Microsoft Word, Excel and PowerPoint can I have my files in iWork respectively?
@MasterAlarcon
2 жыл бұрын
I have a question, how can I change the color of a cell by checking a checkbox?
@paddyboy6155
5 жыл бұрын
Yes a KeyNote session would be good, please. Thank you for your help.
@martinsinclair55
3 жыл бұрын
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.
@jessicanicolkoch4888
3 жыл бұрын
Hi can someone tell me where the back button is haha like the arrow in the app numbers. I just wanna go one step back
@vishnu108hari
3 жыл бұрын
apple numbers is much easier to use than excel . excel is a living hell for newbies
@gedteesdale2794
4 жыл бұрын
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.
@chiarafuriani5470
3 жыл бұрын
Thank you! Great video easy to follow and understand.
@instilltime2014
3 жыл бұрын
Amazing video! I learned so much that will save me a ton of time! Highly recommended and many thanks!
@normanrichardson144
5 жыл бұрын
I’ve been using Excel in Office for Mac 2008 very successfully for years but now that Microsoft are no longer updating Office for Mac and Apple are moving to 64bit which won’t support Office 2008 I’m having problems. I am the only Mac user in my office and everyone else uses Excel. I notice that I can open Excel spreadsheets without any problems in Numbers but my colleagues cannot successfully open Numbers in Excel.
@mace5380
4 жыл бұрын
There shouldn't be an issue with them opening it on their end because when you send it to them it gives you the option of converting it to excel as you send it to them.
@richquesty8371
3 жыл бұрын
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?
@irenecortez7819
5 жыл бұрын
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 KZitem. 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.
@marke2401
4 жыл бұрын
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.
@simple-human-being
4 жыл бұрын
Super useful and easy to follow video, subscribed!
@andreagonzales1824
4 жыл бұрын
Im trying to edit the gardening journal in numbers and im not sure this video helped. I want to change the pictures and im having trouble with that. can you help?
@deejay4839
2 жыл бұрын
I have Excel documents that won't save, Numbers says the file is damaged. To save a document I'll save it as a duplicate. I tried the Format placeholder and that didn't work. Any suggestions?
@sunshinencoastlines
3 жыл бұрын
Help! I have a huge numbers spreadsheet that I’ve worked on for 2 days. I’ve gone to save it, and I’ve got the spinning curser. PLEASE HELP!!! What can I do to save this before I loose it? Thanks so much to anyone with any suggestions.
@robertmullan9130
4 жыл бұрын
Nice, clear explanation, David.
@carlosacostaboricua
5 жыл бұрын
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 !!!
@nounix
4 жыл бұрын
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??
@Carina-2906
4 жыл бұрын
Thank you very much for this very nice explanation! Kind regards!
@mokoaruba
3 жыл бұрын
Great vid. I would loke to know how to freeze pane in Numbers, thanks
@stefsgem5650
3 жыл бұрын
Thank you much appreciated.
@vincentsolomitajr4029
5 жыл бұрын
Can you do a video on iTunes changes that can affect all are devices including iPod’s. For what ever reasons there breaking up iTunes don’t know why it works well!!!
@eduardoalvarez2497
5 жыл бұрын
Hi, can you make a quick video about the new features of Keynotes, Numbers and Pages that where release a few days ago?
@rickmitchell6735
4 жыл бұрын
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
@jamesmason8259
3 жыл бұрын
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?
@JonPal68
2 жыл бұрын
Hello there. I need help with Apple Numbers. I can’t seem to find how to convert a list of musical Artists and Years into Columns (One column for the artist’s name + one column for the song title + one column for the year). Can you help? Thanks a lot in advance.
@MsKarmachameleon
4 жыл бұрын
Does anyone know how to copy and paste in Finder to Numbers? I only need the text. Everytime I copy and paste from Finder to Numbers it auto copies the image and not just the file name? I don't need the image but only the file name.
@SandeepAcharya4630
5 жыл бұрын
Thanks for a great tutorial David! Well, I really want to know about the 'Poster Frame' option in Keynote. This is a feature which I had been using for long in Keynote'09 but sadly, it does not work in the latest version even though it has the option. When a video clip is placed inside Keynote, at the top right hand corner click on the 'QuickTime Player' icon and below you can find the 'Poster Frame' slider. After moving the slider control to a desired frame and rendering the video, the poster frame effect does not show. However, in Keynote'09 version it still works. Trust you would be able to help in this issue. Thank you!
@_I_am_Groot_
3 жыл бұрын
hey, is there any way to export data from a pdf sheet to mac numbers? (without using any third party software)
@kingb_8431
4 жыл бұрын
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.
@capttomhughes
4 жыл бұрын
Excellent learning video. Thanks.
@warwickjarvis
4 жыл бұрын
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?
@marke2401
4 жыл бұрын
Warwick Jarvis I use my iCloud account. For me personally Ive found this to be the best. I would be open to suggestions though
@warwickjarvis
4 жыл бұрын
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.
@marke2401
4 жыл бұрын
@@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
@johang8789
5 жыл бұрын
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.
@lmadsen7118
5 жыл бұрын
Maybe I missed it, but if I make a document in Numbers, and send it to an excel user, can he then open, edit in excel and send back to me, and I can open in numbers and work on?
@mace5380
4 жыл бұрын
yes you can. when you send it over to the other person it asks you what format you would like to send it in, and you can choose to send it in excel format.
@marke2401
4 жыл бұрын
G. Eheime You would “Export” it as an Excel spreadsheet under the “File” menu
@bjmgraphics617
4 жыл бұрын
How to round a decimal to two digits? I have a percentage formula but the answer is way too long. Thanks
@marke2401
4 жыл бұрын
BJM Graphics First highlight the cell. On the right on the screen choose “Cell”. Under “Cell” you will see “Data Format”. Use the drop down list to choose “Percentage”. Below that you will see “Decimals”. You can set how many digits from there.
@rodlee2788
5 жыл бұрын
All I can say is: ABOUT TIME!!! Thank you!
@TriscuitsForDays
4 жыл бұрын
I'm trying to get a scatter plot to plot my x axis values in a descending order but I can't figure out how. I know I could change the values of the data set to be negative but I don't want that to be the values presented on the graph. I'm trying to make an H-R diagram and I need my y axis to be ascending and my x axis to be descending
@marke2401
4 жыл бұрын
Tristan E Troy look on the channel macmostvideo. Gary is really good and probably has a video for it.
@juanguacanemeesmerald128
5 жыл бұрын
Hey David, thank you for your help! Very useful stuff, all best from Colombia!
@bhuvanbtaneja7738
4 жыл бұрын
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
@alontachapman5150
4 жыл бұрын
great information here in 12 minutes I've learned what I needed thank you!!
@vitocaressa3403
4 жыл бұрын
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
@marke2401
4 жыл бұрын
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
@adityagarg9340
5 жыл бұрын
You're a life saver man.!! Keep up the good work!
@dianethompson8079
3 жыл бұрын
Thanks for your helpful info!
@farrokhmabhouti9257
3 жыл бұрын
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.
@drbranto
4 жыл бұрын
Is individual cell protection possible?
@frankvet1
4 жыл бұрын
Numbers help! What am I missing, like EXCEL, I continue to expect Apple Numbers to have a way to easily CENTER vertically/horizontally or both, a spreadsheet for printing. I am shocked frankly that apple does not have this feature! A table does not even "snap" to center guides when I place them in the numbers document. Please tell me I missing something. THANK YOU
@scheduleruser4843
4 жыл бұрын
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
Пікірлер: 237