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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
