Beginner’s Guides Introducing Numbers
Table, charts and functions
Tables and charts are the heart of any spreadsheet. Here’s how they work
U
sing templates is a great way to get to grips with Numbers, but very soon you’ll find yourself wanting to hack them to work with your own data sets, or to create spreadsheets yourself from scratch. To do that, you’ll need to create your own formulas using the functions Numbers understands. There are hundreds of these and they range from the very basic, such as adding up a column of numbers or calculating an average, to complex statements with conditions and boolean operators. Thankfully, Numbers provides detailed descriptions and examples of how each function works so you know which ones to opt for.