So many great tips in these few minutes. I've been an Excel user for many years and your tutorials have really shown me the power of Numbers. I'll be watching this video many times. Thanks for adding the spreadsheet examples. Your Patreon subscription is the best value I've found on the internet.
Thank you. I need to learn more. Just owned a macair, and still am familiarizing with keys, its shortcuts, and drags and its apps. Thank you for all these. I am population prog officer and vid tutorial like this is a big help.
11:50 - you can also drag all those quick formulae and drop them into a cell, saving the need to even type the function. Great tips. Even as a power user I learn something new! Love it.
I'm building a stock calculator. I'm stuck on building a trailing stop. Basically I need it to look at a start date, and as time goes forward to today and return the highest close of the stock. I need it to return to me the highest it goes and if the number goes down to only give me the highest number. Great video by the way, Thanks if you have some insight on how to build this
This is one of the most useful videos I've ever seen on Numbers. There's a NOW function? You have no idea how much time this could have saved me. Sometimes I feel as dumb as dirt :D
Very useful thanks. I found out the transpose and custom formats are not available for shared sheets for some reason (greyed out). The workaround is to move the file to the desktop, make the change and then move it back again.Bummer!
Gary, I appreciate your videos, thank you so much for producing them. Q: When I add rows or columns, how do I get the adjacent formula(s) to automatically update and include the data?
That depends on how you set up your tables. For instance, you could have a function like SUM total a column (B) instead of a range (B2:B40) so that it always includes all non-header/footer rows in that column.
wow Gary that was awesome. Question: I'd like the date to appear in the row when I type something in a cell in that row. Do I use an IF statement or is there another way? OH, figured it out used; IF b5 < 4,"",NOW
No, there's really no good way to do that. NOW will always update to the current time. You have to type the date when you enter the other data, or use Insert, Date.
Hi Gary I am new to Numbers and your videos and have a question if I may ask. I have been tasked with creating a train timetable for an amateur railway society. They want to see trains departing, say every 10 minutes from stations along the line, through the day, but I need a quicker way to repeat the times, rather than adding all the the times manually for each station. Can you please show me the formula to use and how this could be done?
Just a column with times like 12:10, 12:20, etc? You don't need a formula for that. Just use autofill. Put the first two, and then autofill. See ruclips.net/video/ygVZYEwIIjE/видео.html
Great video. Do you know how to link a text in numbers to completely separate document in my computer? I see only 4 options: webpage, email, phone number and sheet.
Great video! But, I just wanted to ask this quick question. So basically i lost my phone, but I have Apple Care. My question is; so if I lost my iPhone XR and I want to get another phone, can I get a discount on another phone or does it HAVE to another iPhone XR?
I'm forced to use Excel because I really need the pivot tables, and using functions is too complex and slow. Unfortunately that's the feature that I can't live without.
Do you know how to make numbers stop shrinking? How do you make it stop that? It seems to do that if I double tap on it, or accidentally tap, it will shrink so tiny I can't read it. Then it's difficult to enlarge it again. It didn't use to do that.
Hi, could you please help me ? I need to build a formula that count remaining days from today date to a future date stoping the count when that future date is reached. thank you!
@@macmost What's wrong with it is that it's hogging resources, particularly hard disk space for end users and money and time for Apple (to pay developers and testers). Numbers is not a portable software, Excel is. I live in the Apple environment: iphone, iPad Pro, iMac, Macbook Pro. They all come with Numbers hogging the storage space. (Same for Keynote and Pages). I cannot use Numbers because virtually no one else is using them.
@@macmost what i know and learnt is not to waste time on running MS Software on my Mac. It gives me peace of mind. Enough articles are available on these. I have nothing against MS, but same is true, i would never run itunes on Windows. It is not development challenge, it is purely willingness. Gary, you are making my goal using Mac software on Mac very easy....Thank you.,
@@lucasmuller4557 How do you collaborate with people who use PCs and therefore Microsoft Office? Almost all of my colleagues have PCs and Microsoft Office, almost none of them have any Mac products and so they do not use Numbers (nor Keynote, nor Pages). I cannot send them any Numbers, Keynote or Pages files because they cannot open them. And conversely, when they send me any files, they are in Excel, PowerPoint or Word. So I need to have MS Office to open them. And if I need to have MS Office, then what is the point of having my computer resources loaded with resource-gobbling software like Numbers, Keynote and Pages?
IKR? But being the king of the Dwarf Planets isn't all that bad. Maybe the next time I do an example like this, I'll use dwarf planet names (Pluto, Ceres, Eris, Makemake and Haumea).
@@macmost ok, what my actual goal is is to somehow make a “random button” for a pop up list, so i could press the button and a random item in a pop up menu would be displayed. I was thinking this might be possible with some outside thinking with the choose function?
@@cabijista1 Sure, you can do that. Just put a RANDBETWEEN function inside the CHOOSE function. Then when you change some value in the document (like a simple checkbox in a cell that the switch on or off) the RANDBETWEEN changes and the CHOOSE function picks another value.
So many great tips in these few minutes. I've been an Excel user for many years and your tutorials have really shown me the power of Numbers. I'll be watching this video many times. Thanks for adding the spreadsheet examples. Your Patreon subscription is the best value I've found on the internet.
Best educator on RUclips.
Thanks Gary. These videos are opening up for me the power of Numbers.
The less I have to use Excel the better.
My Lord Gary, you have overpacked my brain with this video. Thank you so much. Will need to watch this many times in order to try out all your tips.
Thank you. I need to learn more. Just owned a macair, and still am familiarizing with keys, its shortcuts, and drags and its apps. Thank you for all these. I am population prog officer and vid tutorial like this is a big help.
Amazing content. I had no idea about most of these "tips" and I am quite conversant with spreadsheets. Thanks!
Gary is the best, thanks for educating!
11:50 - you can also drag all those quick formulae and drop them into a cell, saving the need to even type the function. Great tips. Even as a power user I learn something new! Love it.
Great tips I like learning about more functions in Numbers thanks Gary
Thank you, Gary! 👍🏻
Hi Gary, You've been such a great help with my Number solutions....cheers from the UK
Your vids on numbers are so good!
Thank you Gary. Wonderful tips I learnt today from you. I'm floored by dates addition and subtraction stuff.
I'm building a stock calculator. I'm stuck on building a trailing stop. Basically I need it to look at a start date, and as time goes forward to today and return the highest close of the stock. I need it to return to me the highest it goes and if the number goes down to only give me the highest number. Great video by the way, Thanks if you have some insight on how to build this
You'd need to constantly record data then. Sounds like you want some sort of service that provides this, not a spreadsheet.
This is one of the most useful videos I've ever seen on Numbers. There's a NOW function? You have no idea how much time this could have saved me. Sometimes I feel as dumb as dirt :D
Very useful thanks. I found out the transpose and custom formats are not available for shared sheets for some reason (greyed out). The workaround is to move the file to the desktop, make the change and then move it back again.Bummer!
So my computer can actually compute things. I always thought it was just for emails and to order stuff on Amazon. :)
Thanks Gary you're the best👍
Wonderful Tips!!! Thanks Very Much.
thanks for this, just seeing it
Thank you Gary
Gary, I appreciate your videos, thank you so much for producing them. Q: When I add rows or columns, how do I get the adjacent formula(s) to automatically update and include the data?
That depends on how you set up your tables. For instance, you could have a function like SUM total a column (B) instead of a range (B2:B40) so that it always includes all non-header/footer rows in that column.
wow Gary that was awesome. Question: I'd like the date to appear in the row when I type something in a cell in that row. Do I use an IF statement or is there another way?
OH, figured it out used; IF b5 < 4,"",NOW
No, there's really no good way to do that. NOW will always update to the current time. You have to type the date when you enter the other data, or use Insert, Date.
Tip for iPad keyboard, swipe from top to bottom of a key gets the second row eg: swipe the t key gets you 5
Awesome tips, thank you!
Hi Gary I am new to Numbers and your videos and have a question if I may ask. I have been tasked with creating a train timetable for an amateur railway society. They want to see trains departing, say every 10 minutes from stations along the line, through the day, but I need a quicker way to repeat the times, rather than adding all the the times manually for each station.
Can you please show me the formula to use and how this could be done?
Just a column with times like 12:10, 12:20, etc? You don't need a formula for that. Just use autofill. Put the first two, and then autofill. See ruclips.net/video/ygVZYEwIIjE/видео.html
Fantastic
Merci, vous nous facilité la vie.
First day of subscription. Great content
Thanks this is good stuff!
Great video. Do you know how to link a text in numbers to completely separate document in my computer? I see only 4 options: webpage, email, phone number and sheet.
You can't.
Great video!
But, I just wanted to ask this quick question.
So basically i lost my phone, but I have Apple Care.
My question is; so if I lost my iPhone XR and I want to get another phone, can I get a discount on another phone or does it HAVE to another iPhone XR?
Wrong "MAC" ... sorry
I'm forced to use Excel because I really need the pivot tables, and using functions is too complex and slow. Unfortunately that's the feature that I can't live without.
Great video. Do you have one on creating a database?
Like this? ruclips.net/video/Ycj9syUXoqE/видео.html
Do you know how to make numbers stop shrinking? How do you make it stop that? It seems to do that if I double tap on it, or accidentally tap, it will shrink so tiny I can't read it. Then it's difficult to enlarge it again. It didn't use to do that.
Not sure what you mean. Numbers shouldn't "shrink." Can you describe in more detail what you are doing and what you see?
how do you get to the spreadsheet page with all the information?
Hi Gary ! Do you know how to paste formula results as links? I seem to lose my link when I paste the formula result.
As links? I don't know what you mean by that.
How did you add the black bars between the columns
Select the cells and use the grid borders controls in the right sidebar, Cell.
@@macmost thanks .
Hi, could you please help me ?
I need to build a formula that count remaining days from today date to a future date stoping the count when that future date is reached. thank you!
Just subtract. Subtracting one date from another will give you a duration. NOW() can be used for today.
Stock quote are not update live..
C'est bien
Why is Apple still committed to Numbers? Doesn't Excel do all the same things, if not more with greater portability?
Numbers does some things Excel does not, like multiple tables per sheet. Excel isn't free. What's wrong with some competition?
@@macmost What's wrong with it is that it's hogging resources, particularly hard disk space for end users and money and time for Apple (to pay developers and testers). Numbers is not a portable software, Excel is. I live in the Apple environment: iphone, iPad Pro, iMac, Macbook Pro. They all come with Numbers hogging the storage space. (Same for Keynote and Pages). I cannot use Numbers because virtually no one else is using them.
@@macmost what i know and learnt is not to waste time on running MS Software on my Mac. It gives me peace of mind. Enough articles are available on these. I have nothing against MS, but same is true, i would never run itunes on Windows. It is not development challenge, it is purely willingness. Gary, you are making my goal using Mac software on Mac very easy....Thank you.,
@@lucasmuller4557 How do you collaborate with people who use PCs and therefore Microsoft Office? Almost all of my colleagues have PCs and Microsoft Office, almost none of them have any Mac products and so they do not use Numbers (nor Keynote, nor Pages). I cannot send them any Numbers, Keynote or Pages files because they cannot open them. And conversely, when they send me any files, they are in Excel, PowerPoint or Word. So I need to have MS Office to open them. And if I need to have MS Office, then what is the point of having my computer resources loaded with resource-gobbling software like Numbers, Keynote and Pages?
Poor Pluto 😭 🤣
IKR? But being the king of the Dwarf Planets isn't all that bad. Maybe the next time I do an example like this, I'll use dwarf planet names (Pluto, Ceres, Eris, Makemake and Haumea).
Can Numbers create pivot tables?
ruclips.net/video/Xv5kUn4o1ss/видео.html
@@macmost will check it out, thanks for a terrific channel!
Is there a way to make the choose function select an item from a pop up list?
Not sure what you mean. The two things are unrelated. Take a step back and tell me what your goal is, what you are trying to do.
@@macmost ok, what my actual goal is is to somehow make a “random button” for a pop up list, so i could press the button and a random item in a pop up menu would be displayed. I was thinking this might be possible with some outside thinking with the choose function?
@@cabijista1 Sure, you can do that. Just put a RANDBETWEEN function inside the CHOOSE function. Then when you change some value in the document (like a simple checkbox in a cell that the switch on or off) the RANDBETWEEN changes and the CHOOSE function picks another value.