Here are a variety of functions, features and tips for Mac Numbers that many Numbers users don't know about.
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.
The latest version of Numbers allows you to use regular expressions, also called regex, in formulas. Regex is very powerful if you can master it. You can use them to match patterns in text to perform otherwise difficult or impossible things in your spreadsheets.