MacMost: Numbers

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.
Understanding Sheets and Tables In Mac Numbers
8/31/21
Many Numbers users will try to fit everything into a single Sheet or even a single Table in a single Sheet. But the key to using Numbers effectively is to spead out the functions of your document across multiple sheets and multiple tables inside a sheet in a way that makes the most sense.
How To Plot X And Y Values In Numbers
7/12/21
You can use a special type of chart in Numbers to plot points on a graph. To make it look like graph paper you can adjust the chart in several ways.
10 Useful Numbers Cell Formatting Examples
7/6/21
Often the solution to a problem in Numbers isn't to use a formula, but to use custom cell formatting. See some practical examples such as adding units, abbreviating large numbers, replacing 0 values with blanks, showing hexadecimal numbers and much more.
How To Show Zeros As Empty In Mac Numbers
6/15/21
Often you want to display formula results only if the value isn't zero. The best way to do that is with a Custom Format. You can also use functions like IFERROR to display something other than an error message in some situations.
The 10 Functions That Every Mac Numbers User Should Know
6/1/21
Here are 10 Numbers functions that all beginners and expert users of Numbers should know. Learn how to use functions like SUM, SUMIF, LOOKUP, STOCK and more.
How To Use Percent In Mac Numbers
5/7/21
When using percentages in Mac Numbers, keep in mind that what you are using are really decimal fractions, and not the whole number shown as a percentage. Use formatting to properly show a value as a percent. Also learn how to use percents for sales tax and other things.
Showing Trend Arrows and Other Icons In Mac Numbers
4/8/21
By using formulas, you can show special characters inside your Numbers tables to indicate things like increases or decreases in values, amounts and ranks. These simple techniques can make your tables easier to read and understand at a glance.
Creating Useful Helper Actions For Mac Numbers
2/23/21

By using JavaScript in Automator you can change the value of selected cells in Numbers. But a little more coding you can place specific or random values in the cells, reorder them, insert data from the clipboard or even an Internet location. There are allo sorts of ways to use code like this to do things you couldn't easily do in Numbers otherwise.