25 Things You Didn’t Know You Could Do With Mac Numbers

Here are a variety of functions, features and tips for Mac Numbers that many Numbers users don't know about.



Download the example file.

Comments: 10 Responses to “25 Things You Didn’t Know You Could Do With Mac Numbers”

    Eduard Nebbeling
    8 months ago

    Thank you very much for this topic, it’s really helpful when working in Numbers.

    Sue Dickie
    8 months ago

    Very timely. I just looked at the Stocks template yesterday and couldn’t figure out how they had done some calculations. After poking around, I found ‘Previous gain’ in a hidden row. Your video has now shown me more things that I wasn’t aware of, and some will be helpful. As an aside, I wish Apple annotated their templates to explain how they were pulled together.

    John R Carter Sr
    8 months ago

    You just blew my mind with this.
    I’m using Numbers at the very basic level of just showing tabular data.
    I knew that there were many formulas available, and I’ve used some of the math functions. But this goes beyond anything I would need to do! Still, fun to know.

    Ray Johnston
    8 months ago

    Very helpful, Gary. Do you have a way to generate a value for “yesterday” which also skips over holidays? I’d like to use that in a spreadsheet to look at yesterday’s closing stock value, since todays closing value won’t be correct until after the close.

    8 months ago

    Ray: Look at WORKDAYS in the help. You can use a value like -1 and then add your holidays in to get the previous work day.

    Ray
    8 months ago

    Tried that: =WORKDAY(“1/1/21″,-1,”1/1/21″) returns 12/30/20, not 31. Also tried =STOCK(TSLA, previous close), but that seems to return value for two days ago, according to =STOCKH(TSLA,close,”2/18/21”) {today’s the 20th}.

    8 months ago

    Ray: WORKDAY(“1/1/21″,-1,”1/1/21″) probably returns 12/30/20 because you are eliminating 1/1/21 and also going back one more day as well. The other one makes sense because you are asking for the “previous” close, not the current price.

    Ray
    8 months ago

    Thanks, Gary. For my personal finance tracking, those answers work well enough. I think I’ll use the =STOCK( ticker,previous close) function for just a quick look, and perhaps the =WORKDAY( date,-1) function (no holidays) and =STOCKH( ticker,close,date ) for trend tracking.

    Joe Pustai
    8 months ago

    After watching your Hidden Mac Numbers Tips I successfully inserted several links (to other places in the same workbook). This was simple and easy to do and worked well for my rather extensive financial spreadsheet (thank you). As of today I can no longer insert a link. The three link options are showing up but are no longer selectable (Control K will not work either). I even updated my OS and my Numbers is the most recent but I cannot seem to be able to link any more…. how can I fix that?

    8 months ago

    Joe: Are you selecting some text in a cell? You can’t just select the cell.

Leave a New Comment Related to "25 Things You Didn't Know You Could Do With Mac Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)