The 7 Skills You Need To Learn To Master Numbers

[@Frecsmou]

Use Numbers everyday thought I knew what I needed, yet just I learned soemthing new and useful - Thank you Gary!

[@JohnnyHands]

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!

[@giljusino]

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!

[@meeluanistyn1644]

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

[@mikecusick4327]

I have used Numbers for years but always learn something new or get a new idea watching your lessons.

[@MrTsatour]

Brilliant again Gary. You truly are the "gift that keeps on giving". 🎁👏

[@rosbiffy]

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.

[@loisalanoa6342]

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.

[@loisskiathitis8926]

Excellent class today. A very useful and informative video tutorial! Thank you, Gary!👏🏻❤️

[@gowanclews6566]

Extremely useful, thank you. Use Excel daily with simple list that I sort often. You explained clearly what I need to do with Numbers

[@pressrepeat2000]

Love your stuff Gary, you’re the best. All your Mac stuff is just another level. So clear, so thoughtful. Thank you.

[@christinebryant9143]

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.

[@dwanehoughtaling419]

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.

[@JoeC1977]

Glad I watched your video - it exposed some features I was not aware of (multiple tables in a worksheet). Thank you!

[@NancyYates-h6b]

Thanks, Gary! First time using numbers instead of Excel to make a budget. This is a terrific start!

[@janp9960]

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 😉🥰

[@patconlon5513]

Many thanks Gary, all your tips and tricks are making my mac experience much more productive and enjoyable.

[@DJoslin322]

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!

[@milenaandroshchuk6095]

Thank you very much for this video! I found it very helpful in my transition from Excel to Numbers.

[@anaotero8817]

Your Content is PRICELESS!!! Always clear and to the point. I am sooo grateful to you. 🤗

[@Zugunru]

This series is incredibly helpful, thanks for all your work putting this together!

[@raymondw.stevensjr.5756]

Thank you for this video; it has clarified many stumbling blocks I had transitioning from Excel to Numbers.

[@DebKaiser]

I knew about header rows and use them to freeze, but didn't even know footer row was a thing. Thank you!

[@macforme]

Video is 11 months old and still helping us figure out this app. 👍👍 Thanks Gary.

[@meyou58]

Thank you so much for this very informative tutorial. Your videos are the best when it comes to learning Mac OS techniques!

[@Lorenzo-ft1vt]

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.

[@BasicFolders]

From this video I have learned that I am header row sectional. 😜 Best explaination on KZbin for beginners, thank you so much! 💙

[@BarneyLeith]

Another really helpful video, Gary. I love the clarity of your explanations. Thank you!

[@davebryer6133]

I am a casual user of Numbers, but this video helped me so very much. Thank you

[@JerryN7970]

Thanks Gary! I don’t use Numbers too often, but I do use it occasionally for a few things so this was helpful!

[@ZSarPhoto]

I really enjoyed this tutorial. Very concise and easy to follow. Looking forward to viewing your other Numbers tutorials. Thank you.

[@utnietje]

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 👏👏👏👏👍👍👍

[@magneticinteriors8530]

Man, this guy knows his stuff - big thanks!

[@andrewsprojectmanagementse4720]

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!👍

[@pdwhit]

Wow! So much and only 9 minutes. Thank you 😊 😊 😊

[@AssiieJj]

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.

[@macmost]

kzbin.info/www/bejne/fHWwq4qmqtGhoq8

[@davep6603]

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.

[@georgee3401]

Excellent tutorial, as usual. Many thanks!

[@davidcking7]

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.

[@babeyoulove1883]

I use Numbers most time, and it is very simple compared to other platforms Like - Sheets and Excel. Love this video -

[@DiegoMendezMessias]

Your tutorial videos are great! thanks for sharing!

[@davidhutchinson6235]

Thanks, I’ve filled in a few blanks in my Excel to Numbers journey. 👍

[@rusr29]

Excellent tutorial!!! I've learn something useful today👊

[@heavyizthacrown-5842]

Great video and explanation. 👍🏾 You just taught me everything I came here to learn.

[@moonrocks21m]

nice and simple and clear - thanks!

[@sshaw70]

Newbie here. Thank you sooo much! I learned a lot!

[@ptgizmo]

This was extremely helpful. Thank you!

[@carolinebarlow4795]

Thanks very much, Gary, for this very informative video! Very helpful.

[@jeanlucvassort6411]

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 🙂

[@JAD73567]

Mac user since 1986. By the time Numbers came along, I like most other people had been using Excel for a number of years. My rule for new tech is, if it’s better than the old tech I’ll use it. I’ve tried several times to get into Numbers and frankly, it’s just not better than Excel. LibreOffice and Google Sheets basically follow the format of Excel, so I also use those spreadsheets. I guess my main problem with Numbers is that it changes many of the user procedures for formatting your spreadsheet without offering any real new benefits. I have to break old habits to learn something that gets me to the same place. I think Numbers is mostly for people who are brand new to using a spreadsheet and obviously use a Mac.

[@macmost]

I used Excel and the like for years before Numbers. But the multi-table ability of Numbers makes it far more usable to me. Excel just looks archaic to me now. Like something from a previous era.

[@johnvender]

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.

[@macmost]

Using TextEdit as a go-between is the way.

[@johnvender]

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 :)

[@aav2364]

Very good teacher. Thanks

[@TheKingsOutlaw]

Wow! I had no idea. Thank you very much!

[@da-AL]

thank you! this is clear & concise!

[@Eszlee]

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".

[@solomon1021]

use numbers everyday to update my registry and review our family budget. love it.

[@maryjaye1356]

somehow I removed format tool! I like your videos. you are not too fast and you help me a lot

[@jackwebb5917]

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

[@macmost]

I typed SUM and then ( and then clicked on the "B" header of that column.

[@jq5596]

Great!!! There's always something to learn.

[@WeberBaker]

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. 😆

[@miggo8203]

filter out ">= "

[@djr3386]

Thank you Gary. Very informative. 🙇 Can we have more than one filter saved ?

[@KouroshDini]

Super useful. Thank you!

[@Fogaata]

thank you, for this helpful video!

[@giljusino]

Thank you Gary!

[@nicolemuller654]

Thanks for your tutorial. I'm a creative and admittedly a bit math/spreadsheet challenged. I was doing really well using my newly created spread sheet when all of the sudden I couldn't get the thing to calculate. I have no idea what I could have done and am growing more and more frustrated. Any suggestions would be terrific.

[@macmost]

Just look carefully at the formulae and the error messages and trace the connections to cells with value. Take your time.

[@nicolemuller654]

I'm not familiar enough with spreadsheets to understand what you are talking about. Thanks for trying.

[@RenoFencingMan]

Thank you, thank you, thank you!!

[@Sjrick]

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 ?

[@nkwhph]

thanks Gary . quick question... when i use command F to search something on numbers, I would always fail finding it if I did not put a capital letter in the beginning of the word if the word has a capital in the beginning to. Example if I am looking for the word "Arrive" in a numbers document, I would not find it if I searched "arrive" due to the capital . In pages this is not an issue. can you help please ? kevin x

[@macmost]

Click on the little gear-like button at the left side of the Find & Replace window. Then turn off "Match Case."

[@desertdiamond26]

Thank you, very helpful. My issue with Numbers is saving documents, especially when I go over the same doc to keep the format, and saveit as a NEW doc ??

[@macmost]

So you want to use Save As? Hold the Option key down and look in the File menu. But it also sounds like you may want to create your own Numbers template instead.

[@CraftyOldGit]

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).

[@tobytja]

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?

[@callmeNeno]

I am using more Apple’ native stock apps because of you. Gracias

[@mikeleese6694]

I’ve been using iPhones since iPhone 3 and the iPad when it was introduced I never knew what a powerful tool I had and all the money wasted on M/s office 😡 Now I can keep track of my Wargames and passably show other players what they’ve won or last even during a game. I can produce and record like dBase II and produce reports I hope!!!

[@Rageeffectbros]

Thank you very much, very useful

[@lucwillemsens1901]

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

[@macmost]

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.

[@desertpatient]

Thanks bunches...super helpful

[@mikemayhew9052]

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.

[@macmost]

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.

[@bikeman5]

Gary, I have a Numbers spread sheet I cant figure out, it is an estate budget sheet. I got it so it totals up certain columns. The problem i'm having is, that it rounds up or down the cents to the nearest dollar. I want it to show the actual amount in dollars and cents. Here are the 2 columns. Actual total is $103,059.21 it shows $103,059 & in menu bar it shows =SUBTOTAL(109,[Amount]) Another column is $95,623.54 it shows $95,624 & in menu bar it shows =SUBTOTAL(109,[Amount]) How can I fix this?

[@macmost]

Sounds like the cell formatting is simply set to show 0 decimal places. Select those cells, then go to the Format sidebar, Cells and change that aspect of the cell formatting.

[@Sinaidavid]

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?

[@macmost]

If your Desktop is in iCloud then you could share it and take that share link and use it as a link in Numbers.

[@Sinaidavid]

Thank you so much, worked like a charm@@macmost

[@Stefansemafo]

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?

[@macmost]

Make sure you are referring to the column like: SUM(B) and not a specific range like: SUM(B1:B22)

[@ElleGiguere]

Thank you!

[@MissNea1991]

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?

[@macmost]

Copy the one cell, select the rest and paste.

[@denniswoods3909]

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.

[@macmost]

Yes, you can set it up that way. See kzbin.info/www/bejne/rmWzi5WIpcR-ac0

[@robertrobinson9904]

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

[@macmost]

Free Header Rows in the Tables menu. It should be on by default.

[@robertrobinson9904]

I don't find it. @@macmost

[@hook_off]

Hello, thanks for the video, very useful. It's a pity that I didn't find it right away, as I started learning tables. I have a question, please tell me, is there a way to make an interconnected drop-down list like in google sheets? I am creating a table to track income and expenses and would like that when I select "income" or "expense" in one row, I would have different categories in the other row, depending on the first row? It would just be convenient to have just one quick command to immediately enter income or expense using a form. And if the list is general, then there are too many categories and it takes a long time to find the right one)

[@macmost]

No, you can't do that with the pop-up menu cell.

[@hook_off]

@@macmost 😭 either 2 separate forms, tables respectively, or the torment of scrolling?) Or switching to Google Sheets

[@macmost]

@@hook_off It doesn't do that. If Google Sheets can do it and you don't mind using something else, then sure why not. I use multiple tools for lots of things, but a lot of other people stick to just one.

[@JoeKool33]

Great vid!!

[@claudiaarmstead2676]

Does Numbers have Sheets like in Excel? I need to see my payment of bills each month in the year

[@aslwithanna7118]

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.

[@macmost]

So is that "volume" an external drive or a disk image? Or something else. I don't have a complete picture here.

[@aslwithanna7118]

@@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.

[@macmost]

@@aslwithanna7118 Probably should call Apple Support. I don't know what you are dealing with here, sorry.

[@aslwithanna7118]

Will do. Thank you for your attention and trying to help me. I appreciate it! Keep up the good work! 🙂@@macmost

[@adco]

Very good 👍

[@joao.grandizoli]

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!

[@macmost]

I have several videos on this. Search my channel. Here is one: kzbin.info/www/bejne/jZvJYoR-gK2Dpqs

[@jimalix6270]

Great video, as always, Gary! Question: is there any way to print only one table on a sheet that has more than one table?

[@Erin-Thor]

Gary, I think you have a bigger brain 🧠 than we do. 🤣🤓

[@elchicano187]

thank you ! im trying to add up how much im spending every month and to what my money is going to

[@maryannwaddell3359]

Do I have to purchase Tables for my MacBook Air or how do I find this feature?

[@ElleGiguere]

Use Numbers, it's free with your Mac. If it's not in your dock look in Applications.

[@macmost]

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.

[@ForagingOnward]

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.

[@demarcustankerboytv8987]

Where did you find the premade templates

[@spousewife]

Thank you

[@bluelid]

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?

[@macmost]

I can try. Ask at macmost.com/ask

[@bluelid]

@@macmost I got my answer. I can share

[@Tesnobay]

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?

[@eyeojo]

No, the rows (and columns) live independently in each table.

[@zero_ehxe]

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.

[@khinmoethinn8470]

May I know how to create buttons in number is like excels buttons

[@macmost]

Buttons that do what? Instead of trying to make Numbers like Excel, take a step back. What is it you are trying to accomplish, exactly? What is your goal?