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.
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
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
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 ua-cam.com/video/ygVZYEwIIjE/v-deo.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?
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.
@@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.
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.
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).
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 UA-cam.
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.
Thanks Gary. These videos are opening up for me the power of Numbers.
The less I have to use Excel the better.
Gary is the best, thanks for educating!
Amazing content. I had no idea about most of these "tips" and I am quite conversant with spreadsheets. Thanks!
Great tips I like learning about more functions in Numbers thanks Gary
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.
Thank you, Gary! 👍🏻
Your vids on numbers are so good!
Hi Gary, You've been such a great help with my Number solutions....cheers from the UK
Thank you Gary. Wonderful tips I learnt today from you. I'm floored by dates addition and subtraction stuff.
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
Thanks Gary you're the best👍
thanks for this, just seeing it
Thank you Gary
Wonderful Tips!!! Thanks Very Much.
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.
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. :)
Awesome tips, thank you!
Merci, vous nous facilité la vie.
First day of subscription. Great content
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.
Thanks this is good stuff!
Fantastic
Tip for iPad keyboard, swipe from top to bottom of a key gets the second row eg: swipe the t key gets you 5
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 ua-cam.com/video/ygVZYEwIIjE/v-deo.html
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 .
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
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?
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.
Great video. Do you have one on creating a database?
Like this? ua-cam.com/video/Ycj9syUXoqE/v-deo.html
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.
Stock quote are not update live..
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.
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.
Can Numbers create pivot tables?
ua-cam.com/video/Xv5kUn4o1ss/v-deo.html
@@macmost will check it out, thanks for a terrific channel!
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).
how do you get to the spreadsheet page with all the information?