The 7 Skills You Need To Learn To Master Numbers
ฝัง
- เผยแพร่เมื่อ 4 ก.ค. 2024
- macmost.com/e-2899 In order to use Numbers to its fullest, first master these essential skills before worrying about functions.
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:34 1. The Importance of Tables
01:29 2. The Importance of Rows
02:11 3. The Importance of Headers and Footers
03:41 4. The Importance of Cell Formatting
05:16 5. How To Sort Tables
06:26 6. How To Filter Rows In Tables
07:23 7. Looking Up Functions
#macmost #mactutorial #numbers - วิทยาศาสตร์และเทคโนโลยี
Use Numbers everyday thought I knew what I needed, yet just I learned soemthing new and useful - Thank you Gary!
Excellent class today. A very useful and informative video tutorial! Thank you, Gary!👏🏻❤️
This series is incredibly helpful, thanks for all your work putting this together!
Love these vids, so easy to follow. My questions are answered before I even form them. You’re a step ahead but you make it easy to catch up. Keep up the good work. Thank you.
Brilliant again Gary. You truly are the "gift that keeps on giving". 🎁👏
Glad I watched your video - it exposed some features I was not aware of (multiple tables in a worksheet). Thank you!
Hey Gary,
Many of your suggestions I have already taken onboard by trial and error but as always you find more elegant ways of achieving the same result. I would love to see a more in-depth tutorial of Numbers.
I like Gary's presentations. He gets right to the meat of the topic.
THANK YOU Gary!! As ever, clear, concise, loaded and immensely helpful. My spouse and I LOVE YOU sooooo much, helping us in your retirement years optimally operate our computers. We make a 'date with Gary' to learn something almost every day!!! Sending HUGE HUGS 😉🥰
Many thanks Gary, all your tips and tricks are making my mac experience much more productive and enjoyable.
I’ve been using Numbers for a while, and I didn’t know about that footer row tip. I’ve been making the totals row at the bottom without specifying it as a footer (which makes for extra - unnecessary - work, when you want to add a new data row right above the totals row.) Thanks, Gary!
Thank you Gary! I have used Excel in the past but now am exclusively a Mac user. Have created a few Numbers tables & would have gone further with it by using the "Help" feature but it just confuses me more!! This is PERFECT and I will be using Numbers a lot more from now on thanks to your video!
Thanks Gary, I followed your instructions. What a difference! I migrated from years using excel in business. I was trying to make NUMBERS look and operate like EXCEL. Thanks for the tips!
thank you, for this helpful video!
Great video...I used the sort and filter functions many times, but wasn't aware of how powerful they were. As always, I've learned something new that I can use in my daily work. Thanks again!👍
Great introduction to Numbers. I watch your videos showing how to use a specific app or topic even if I think I know the topic only to find out I didn't know as much as I thought . Your discussion of footers in this video is a good example of not knowing as much as I thought. Had to lookup function STRIPDURATION shown in an example format window. It just sounded interesting. I probably won't use it but thanks to your video and looking it up, I'm aware of it should a need arise. Thanks for the great job.
Fantastic delivery, content and pace - I have been using Apple computers for decades in my work (Marine Scientist) but there is always room to learn ... as evidenced by dipping into one of your basic Intros. Many thx Gary.
Thank you, I have learned a little more. So thankful that you are showing this. It’s always nice to listen to someone who knows what he’s talking about, thank you 👏👏👏👏👍👍👍
Thank you so much for this very informative tutorial. Your videos are the best when it comes to learning Mac OS techniques!
I really enjoyed this tutorial. Very concise and easy to follow. Looking forward to viewing your other Numbers tutorials. Thank you.
I’ve used Excel a lot in the past. Am now referring to Gary’s excellent Numbers course as I need to understand the differences between both apps
Man, this guy knows his stuff - big thanks!
Excellent tutorial, as usual. Many thanks!
Thank you for this video; it has clarified many stumbling blocks I had transitioning from Excel to Numbers.
Thanks very much, Gary, for this very informative video! Very helpful.
Excellent tutorial!!! I've learn something useful today👊
Very well explained, Gary. Thank you for this lovely primer. I'm trying to move to Numbers (from you-know-which-app) and this sets out the concepts very well. Many thanks. Much appreciated.
Wow! So much and only 9 minutes. Thank you 😊 😊 😊
Your tutorial videos are great! thanks for sharing!
This was extremely helpful. Thank you!
I love it how you can use different tables, like you explained. I think it makes numbers a more intuitive tool. My main wish for Numbers is that they make it possible to use data from different Numbers documents, like you can on excel, but I bet that would be a huge undertaking and unlikely to happen.
Thanks Gary! I don’t use Numbers too often, but I do use it occasionally for a few things so this was helpful!
Video is 11 months old and still helping us figure out this app. 👍👍 Thanks Gary.
I use Numbers most time, and it is very simple compared to other platforms Like - Sheets and Excel. Love this video -
I have used Numbers for years but always learn something new or get a new idea watching your lessons.
Thanks for this new video, using numbers daily i am very familiar but ... watching your videos is always a great benefit to learn a piece of new information, always 🙂
A wonderful summary of how to use Numbers Gary. You never fail to give helpful information. Thanks again - pleeeeeaaasse don't stop. we need you.
From this video I have learned that I am header row sectional. 😜 Best explaination on TH-cam for beginners, thank you so much! 💙
thank you! this is clear & concise!
Great!!! There's always something to learn.
Thank you, Gary. This was a very helpful tutorial presented in your usual friendly teaching style which is appreciated. I know you offer a full Numbers course on your MacMost site, which I will be sure to check out.
Wow! I had no idea. Thank you very much!
Very good teacher. Thanks
Super useful. Thank you!
Thanks bunches...super helpful
Newbie here. Thank you sooo much! I learned a lot!
Thank you very much, very useful
Thank you, thank you, thank you!!
Thank you Gary!
Thank you!
Thank you Gary. Very informative. 🙇
Can we have more than one filter saved ?
Great vid!!
Thank you for this very informative video. Although, it would be an EXTRA plus if there was a way to create an "X" strikethrough option from the Cell/Border Format selection. I create calendar logs and like to see when something has been accomplished & like to X off the cells once things have been completed. So, until "Numbers" app has an added option like that, I still prefer to use "Excel".
Great video, as always, Gary! Question: is there any way to print only one table on a sheet that has more than one table?
Thank you so much for this tutorial. I hope you also can make one tutorial about using the standard templates that are pre-build in the Numbers app for keeping track of your own budget/finances.
th-cam.com/video/FDMzWpulnlM/w-d-xo.html
Very good 👍
I am using more Apple’ native stock apps because of you. Gracias
Thank you
thank you
I taught myself a lot of this just by loading the premade templates and playing around with them until I could reverse engineer the formulas for dynamic tables.
Where did you find the premade templates
Hi, I have a problem in Numbers, could you make a video explaining stuff needed for that?
I have a personal budget for which I used a template contained in the Numbers (the one with the circle graph - real expenses - at the top left, column graph - budget x reality - next to it and a table detailing the categories at the bottom left) in the first sheet. There’s a sheet summarising the expenses and a transactions sheet for writing each expense. I want to have a summary for each month in a year (one summary sheet for January, one for February etc.). Right now I always duplicate both the summary and transactions sheet and reroute the summary to the new transactions sheet. I’d like to set the summary sheets in such a way that they all use the same transactions sheet but only select the transactions from the month related to them. But I don’t know how the correct syntax for the IF function (particularly the logical condition) to accomplish that. Or if you already made a video for this, can you give its name please?
Im brand new to this program. When i made a list i started at the very top. However i wanted to add some cushioning. How do i add more at the top and push my entire list down a bit ?
Great info. One of the things I so often forget is when using a filter. Example: if you ask to filter out grades > 90 you wont be the one that are exactly 90. I used to use just such a sheet when teaching and had to learn the hard way I was excluding kids from the “A” group and adding too many to the “F” group. 😆
filter out ">= "
Is there a way to paste a formula in MacOS Numbers? If there is, I can't find it -- I end up opening the spreadsheet in iPad Numbers. (Ask the forums & people say 'Paste & Match Style', but they obviously haven't checked).
This is a great tutorial video. Thank you. One question though. In the section on formatting the date, can you create a different date format on the list? For example, I do genealogy and the standard format for the date is, day, month, year - 5 Jun 2022 (note the 3 letter abbreviation for the month). I did not see that format in the list. Can I create that format and add it to the list? Thank you.
Yes, you can set it up that way. See th-cam.com/video/x4PZbRp_K3k/w-d-xo.html
very informative video. thanks. i have a question about cells. Is it possible to have like a ghost cell that when you cursor over it you have a hidden cell with say time in it that becomes viewable? Then when the cursor is moved it is no longer viewable. used to do that in excel before becoming exclusively a Mac user.
No, I've never seen anything like that. Why not just have that cell in another column? You could always hide that entire column if you don't need it at the moment.
Awesomeness
Another very helpful video. One thing that is likely very easy but I haven't worked out yet is if I select part of a Numbers table, copy it to the clipboard and then paste into a Pages document I get a table with that data. I generally want just the text with tabs separating the column data on each row. Even if I Paste and Match Style I still get a table in the Pages document. The work around I've been using is creating a new TextEdit document, do Paste and Match Style into it, select all, copy and then in the Pages document Paste and Match Style. I'd love a way to do this directly from Numbers to Pages.
Using TextEdit as a go-between is the way.
Thanks Gary, it's easy enough to do and at least now I know there is no direct way and that's why I was not finding it :)
Absolutely fantastic video, thank you for this. Is it possible for a cell to contain a link to an external file on the desktop rather than a cloud/web link?
If your Desktop is in iCloud then you could share it and take that share link and use it as a link in Numbers.
Thank you so much, worked like a charm@@macmost
Thank you for the help. I did not know I am able to have several tables on one page. But I am struggling with sum of a row. The header ist defined but still the formula adds the header row which is text. What do I miss?
Make sure you are referring to the column like: SUM(B)
and not a specific range like: SUM(B1:B22)
I am an old excel user. Retired just before the pandemic, moved my house to Apple products. I now wish to use Numbers... Think about a translation tutorial, to assist the many new converts like myself into a smooth migration.
I have a whole course: courses.macmost.com
thank you ! im trying to add up how much im spending every month and to what my money is going to
Hi, i need to use Numbers for my daughter, she as a health activity And she must do the patient management. I just started tonight on my iPad Pro to make an application for his office. I feel like I’m limited to the NUmbers functions to do something simple. Do you have an idea to submit to me to start this project to follow up on customer appointments and billing? Thank you for your time and help
Sorry, I don't know from that description what it is you want to do. Usually "customer appointments and billing" isn't something you do in a spreadsheet but in an aop dedicated for that purpose.
tyty
In reference to testing formulas, if I try anything new, I often just duplicate my tab so I have an easy way to revert back.
Is not the best video to ask that, but.. Is possible to create custom formulas on Numbers using javascript of script editor? Or even create custom formulas/functions using applescript? Thank you!
I have several videos on this. Search my channel. Here is one: th-cam.com/video/Wjf1QHKHPpI/w-d-xo.html
At 3:03 when you added a sum formula, can you explain a bit more what to click on to do that? I can’t figure it out
I typed SUM and then ( and then clicked on the "B" header of that column.
I really wish the Apple Store did Today at Apple sessions for Numbers, Keynote and Pages. Would be much more useful than what they currently offer.
thanks for your videos. i am starting to use numbers more and more. but today I have an Apple Automator question, or maybe it can be better solved using Apple Script. can you answer questions on Automator?
I can try. Ask at macmost.com/ask
@@macmost I got my answer. I can share
Gary, I think you have a bigger brain 🧠 than we do. 🤣🤓
Your videos have been very useful! I need help -- I got a pop-up when I tried opening my numbers file and it says 'The document "zzz.numbers" could not be opened. The volume "MAY 16 2018" couldn't be mounted. Mount the volume and try opening the document again.' The steps Apple gave in their forum didn't help. What do you suggest I do to get access to my numbers spreadsheet again? Thanks.
So is that "volume" an external drive or a disk image? Or something else. I don't have a complete picture here.
@@macmost It's not an external drive...unless I had saved the file in an external drive which I would have to dust it off from my bookshelf and connect it back to the Macbook, right? And what's a disk image? Thanks.
@@aslwithanna7118 Probably should call Apple Support. I don't know what you are dealing with here, sorry.
Will do. Thank you for your attention and trying to help me. I appreciate it! Keep up the good work! 🙂@@macmost
Do I have to purchase Tables for my MacBook Air or how do I find this feature?
Use Numbers, it's free with your Mac. If it's not in your dock look in Applications.
The app is called "Numbers" and if you don't already have it on your Mac, just download it from the App Store. It is free and made by Apple itself.
How about a video that shows how to prevent formulas from executing when there is no data entered in the related cells? Thanks!
How do I fill down a function.. I have several rows that need to be added (sum). Do I need to create the sum function for each row?
Copy the one cell, select the rest and paste.
Does Numbers have Sheets like in Excel? I need to see my payment of bills each month in the year
In my spreadsheet I enter stock $ on weekly basis. During the week my stock holdings change. In excel I could start a new subheader and freeze it to enter new data but keep prior data on same spreadsheet. Is there a way to have a new header row in a numbers spreadsheet. If there’s a source that explines this point me toward it please. Thanks, Robert
Free Header Rows in the Tables menu. It should be on by default.
I don't find it. @@macmost
Question: If you have two tables side by side, and you decide to delete a row on the table on the left, what happens to the rows in the table to the right? Are they deleted as well?
No, the rows (and columns) live independently in each table.
I have different spreadsheets each with a year date. I have a date column with format, March 18, 2022 I would like to be able to input different dates of that year without having to always type in the year for example 03/25 end it and return it would give me March 25, 2022, but it always gives me 2023.
do you offer any kind of one on one help?
No, sorry, I don't.
Thanks. With an attractive GI, numbers has always played 2nd fiddle to Excel and is the only Apple app that frequently hangs. Definitely not aspiring to be the best.
As much as I dislike Microsoft, and appreciate the Numbers concept of multiple small tables, rather than having to fit different data, especially column widths, into a single table, I find entering values in to the cells in Numbers, much more cumbersome than in Excel.
#7, basically RTFM 🤣
How do I find the sum formula? It is to add all the numbers in one column.
I show that in this video.
Good video. But I still feel Microsoft Excel is much more easier and user friendly than Numbers. I keep struggeling with Numbers on my new MacBook Air so much so that I have reverted back to my old Windows Laptop once again.
Thanks,
HOW CAN U LOCK INDIIVIDUAL CELL LIKE EXCEL
There is no way in Numbers to lock individual cells.
Row vs column??
Row = horizontal, column = vertical.
Unfortunately there is no good conditional filtering in Numbers like in Excel
There is filtering in Numbers.
@@macmost not like Excel, when you can style single cell based on condition that is in another cell
Do numbers and live life
Does anybody use Numbers in the world where Excel exist?
Hell yes
Useful, but please slow down.
You can adjust payback speed for to 75%
You go too fast for a total neophyte.
th-cam.com/video/liZTyiy9NnU/w-d-xo.html
@@macmost I know how to slow down a TH-cam video. What I don't know how to use is Numbers. You missed the point of my comment. I did find another one of your videos that you are slower and more methodical with your instruction and I am enjoying it.
@@journeyhome98 Sorry, you commented "too fast" so I was pointing you to info on how to slow down the video. Not sure what other video you found, but if you are very new to Numbers then jumping right into a "to master" video is probably skipping ahead a bit.
@@macmost Lol. I think what we have here is a failure to communicate. Look at your title from a perspective of someone who searched for “Apple Numbers tutorial for beginners “. No where in your title does it say “this video is for Masters”. So, I’ve been enjoying the one where you put in the book titles and I learned a lot from it. Thanks.