The 7 Skills You Need To Learn To Master Numbers

Quite honestly, I found your explanations much clearer than the guide furnished with Numbers. Numbers is not exactly intuitive, either.

Does numbers have a traverse function (like excel does)? If so, how to activate it ? Thx

Distilled to the essentials! Gary, you've done it again!

Thank you 🙏

You cleared up many mysteries…Thank you!!

you speak very fast and then do the action very fast - can you slow down please?

Thank you! I switched from a Windows laptop to a Mac and now learning how to use Numbers :)

Thanks for your clarity. Best explanations I’ve found.

Dear Gary, may I ask:

How can I copy the text of a comment from someone else on Apple Numbers on iPhone ? Text can be selected only if it's my own comment

Excellent!

Perfect first start video. This is the video I needed coming from Excel knowing where and how things work but needed a quick video of how things work and where they are in Numbers.

Switched to Numbers when my Excel license ran out. Numbers is so much better! And those tips are killer Gary. Thank you!

hi gary 👋🏽 , lets say i am in a cell in a table in numbers and want to start a new line within the same cell, how do I do that? In google sheets it's control + enter, what about in numbers? thank you

Hi Gary
If I sort a table that has a sum formula, when I move a row to a different order, the formula does not automatically change to fit the new order.

What could i be missing?

So if I move a row up or down then the sum formula cell gets all screwed up. I want to use a running total.

How to convert numbers to words

Gary, your Numbers videos are a lifesaver! I've learned some great tricks from you but I've got a question I've really hit a wall with: 
If you have two separate tables containing similar types of data—each table includes dates that overlap with the other—how can you combine both into one single, vertically-stacked table, so that all dates and data points are merged into a unified dataset that can then be analyzed using a pivot table?

Thank you for the lesson. Im having fun exploring Numbers.

Gary, could you recommend a good book on using numbers? Not just a beginner book. Thank you.

The best thing about numbers is that its free. idk why not so many people use it

Hi Gary, Not sure how to ask this question but what I want to do on my MAC Numbers is swap data in a column without loosing any of the data in each cell. For instance if I had a column with numers 1-10 as we go down, I want to move 8 to the 2 cell by draging it to the 2 cell and now the 2 would have an 8 in it and the old 8 cell would have a 2 in it. Can you do this? Thank you for everything!

Hi Gary question I use numbers on my mac book to track my sleep data I finished february sheet but not sure how to make another one for the rest of the months of the year (copy them?)

Hmmmmm think I’m going to stay with Excel.

Hoping you can help me. I’m trying to just move from one cell to the next on my ipad in a table without having to actually click on each cell. In Excel I just hit the tab button and it would move. I can’t find how to do that in numbers. Can you help me?

Still struggling…just want to add up the column’s😢

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

Sorry, but as an ex teacher, you’re doing a bad job. Going too fast and clicking on things without explaining. You’re doing it from your experience not your audience’s. SLOW DOWN!

How can i add any number in a cell with existing number? Let’s just say in a cell number is 532 and i want to add 232 in that, how can I do that?

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

Trying to use Numbers/ Pages so I can stop paying though the nose for Microsoft subscription..Numbers seems so weird with so many basics are hard to find, like how to change borders or add cells that are automatically included in the sum. I'll give it a few hours to try to learn these different ways of thinking but maybe it's just gonna be worth paying for what I've spent years knowing how to work with, Sigh.

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

nice and simple and clear - thanks!

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

Excel is the best

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

Dude you are speaking like everyone knows the interface all ready

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

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.

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

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

Greetings 😀
I created a table with five fields, date, comment, income, expenditure, total. The idea was to first enter the current account balance (E2) in the fifth field, and then to automatically summarize fields C3 as income and D3 as expenditure, the total account that will be displayed in column E.

But when I entered the formula in E3 (=E2+C3-D2) it also showed me the result of the current state. then I selected the array fields to automatically apply the formula, but the results of the current state also appeared.

If I try to delete the number in the cell, it does not allow, I can only delete the formula.

How can I copy only the formula, so that the fields remain empty in column E?

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