MacMost: Numbers

Mac Numbers: New Filter Options
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

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

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.

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.

Using Special Viewing Modes With Pages, Numbers and Keynote On iOS
There is a special Reading Mode in Pages, Numbers and Keynote on the iPhone and iPad that allow you to view your documents without accidentally making changes. Pages also include a Presenter Mode for using your iPad as a teleprompter.
Importing and Exporting Contacts On a Mac
Exporting contacts from the Contacts app to a spreadsheet may seem impossible until you learn one simple trick. You can also export a spreadsheet to a CSV format and import contacts into the app.
Proper Use of Header and Footer Cells In Numbers
Header and Footer rows and columns have special properties in Mac Numbers. They label the cells in the body of a table, and also exclude themselves from calculations. You can scroll and print with better results using headers too.
Last Name Sort In Mac Numbers
The latest versions of Numbers make it much easier to sort by last name, even if the data includes only full names. The new functions TEXTBEFORE, TEXTAFTER and COUNTMATCHES allow you to put last name before the first name. You can also use REGEX to do it with an even shorter formula.
How To Find Duplicates In Numbers
Learn how to find duplicate rows in Numbers using various functions and formulas. You can also deal with the duplicates by deleting them or combining the data in them.
MacMost Live: Building a Basic Business Spreadsheet In Mac Numbers

Watch as I build a basic business spreadsheet live from scratch. Expenses and income will have their own tables in their own sheets, with a summary sheet that adds up each category. We'll also track items that don't have a category assigned and add a custom filter that will allow this one document to be used for multiple years.

How To Sort In Mac Numbers
Learn how to sort your tables in Mac Numbers. You can quickly sort by any column, or set up soem complex sort rules and resort by those rules at any time. You can also use Categories to group rows together and sort those Categories in various ways. Sometimes you need to set up special columns for meaningful sorts.
Tracking Stocks With Numbers On Your Mac
You can track and chart stocks in Numbers on your Mac with the STOCKH function. You can get the close, high and low prices for a stock on different days and then use formulas and filters to build various charts. You can then easily change the stock symbol and dates to generate new charts.