MacMost: Numbers

How To Use Autofill In Mac Numbers
10/4/22
You can autofill cells in Numbers using copy and paste, a special autofill feature, and by simply adding new rows to a well-formed table. With the autofill feature, you can have values increase by 1, or using a pattern.
Calculating Difficult Dates In Mac Numbers
9/22/22

Learn how to calculate dates like the first or last day of a month, the first or last day-of-week of a month, or the nth day-of-week of a month.

Mac Numbers Conditional Highlighting and Alternatives
9/9/22
You can use Conditional Highlighting in Numbers to make values stand out. You can also use alternatives like formulas in other columns or custom formats. Also learn how to have cells highlight based on the value of a different cell.
Learn How To Use Pivot Tables In Numbers By Example
8/29/22
If Pivot Tables in Numbers seem intimidating, watch this tutorial to see how easy they are to use. You can get a lot of information without ever needing to using functions or formulas.
Printing Labels Using Mac Pages
8/1/22
You can easily create a simple labels template to print a list of addresses to labels in Pages. The list can come from text or a Number spreadsheet. You can also modify pre-made labels templates to work better.
Calculating Rank In Mac Numbers
7/11/22
If you need to find the ranking of rows in Numbers, you can sort, use COUNTIF or use RANK. It gets a little more complex if you have to use multiple values for tie-breakers or rank within groups.
5 Ways To Generate Random Numbers On Your Mac
7/6/22
Learn how to get random numbers on your Mac using the Calculator app, the Numbers app, Siri, the Terminal and a custom Shortcut.
Quick Calculations In Mac Numbers
6/7/22
You can get the sum, average and perform other calculations on selected cells without needing to create a formula in another cell. The Quick Calculations appear at the bottom of the Numbers window whenever you have more than one cell selected. They also can be dragged-and-dropped to create permanent formulas and will obey filters.
Using Shortcuts To Add Data To a Numbers Spreadsheet
4/21/22
A new action in Shortcuts for Mac allows you to add a row of data to a Numbers spreadsheet. You can prompt for information and then record a time and some data. Numbers version 12 is required. An older technique allows you to change existing data in a Numbers spreadsheet.
Designing Better Numbers Spreadsheets With Text And Shapes
4/18/22
Creating good spreadsheets isn't just about getting the formulas right. By adding some text and design elements you can make it clear to someone else, or yourself in the future, what to do to use the spreadsheet and understand how it works.
An Introduction To Using Formulas In Mac Numbers
2/14/22
Learn the basics of using formulas to perform calculations in the Numbers spreadsheet app. You can perform basic arithmetic, copy and paste formulas to multiple rows, and use functions to get the sum of a column.
How To Track Crypto and More In Numbers and Stocks On a Mac
2/11/22
You can track things like cryptocurrencies, metals, commodities, market funds and other things in the macOS Stocks app and in Numbers. The trick is to realize that the values come from Yahoo Finance and to use the same symbols.
Calculations With Time and Duration Values In Numbers
2/3/22
Dates, times and duration values behave differently in Numbers and other spreadsheet apps than other values. Learn what makes up time and duration values and how to use them in formulas and functions.
Find the Difference Between Two Tables In Mac Numbers
12/23/21
Here's how to compare two tables to see which rows are missing from one or the other. You can also compare two tables using multiple columns. Conditional highlighting can show you which rows don't match.
6 Ways To Sort a List On a Mac
12/3/21
If you have a list of items you need to sort, you can do it using what you have on your Mac or some free apps. Learn how to sort in Pages, Numbers, the Terminal, VIM, CotEditor and using a Shortcut.
Functions For Working With Text In Mac Numbers
12/2/21
Learn how to test and manipulate text in cells in Mac Numbers. You can search for characters, replace them, grab parts of text and more.
Creating Map Charts In Mac Numbers
11/19/21
Sometimes it is useful to have bar charts where each bar is placed at a spot on a map or graphic. You can do that in Numbers, even though there is no special chart type for it. You just need to get creative.
Mac Numbers: New Filter Options
10/13/21
Numbers version 11.2 adds the ability to filter by unique values, fin duplicates and distinct values. Quick filters are also improved with a more comprehensive checkbox system. Learn how to search for duplicates that include several columns with a function.
MacMost Live: Working With Pivot Tables In Numbers
10/8/21

Watch as I take an in-depth look at using the new pivot tables feature in Mac Numbers. Learn how pivot tables can be useful for visualizing data and lots of tips and tricks.

The New Pivot Table Feature In Numbers
9/30/21
The latest version of Mac Numbers adds a new Pivot Table feature. You can now quickly and easily create pivot tables based on the data of another table. Use pivot tables to visualize information in different ways.