MacMost: Numbers

MacMost Now 736: Numbers Pie Charts
7/18/12
Learn how to create pie charts in iWork Numbers. You can create beautiful 2D and 3D pie charts from a simple list of numbers. Find out how to break single wedges out of the chart and how to put the chart on a separate page for printing.
MacMost Now 724: Numbers Headers and Footers
6/20/12
Learn to use header and footer rows in iWork Numbers. Footers allow you to easily perform functions, like sums and averages on entire columns. Headers can remain at the top of the screen as you scroll. Both can be used to keep calculations and titles separate from sorted data in the body of a spreadsheet.
MacMost Now 680: Filtering Rows and Columns in Numbers
3/7/12
You can hide rows and columns in Numbers to effectively filter your data. Hiding can be done one row or column at a time, or by groups of rows and columns. You can also set criteria for rows or columns to be automatically filtered, allowing you to see only the data you need.
MacMost Now 665: Simple Spreadsheets Using Pages
2/1/12
If you don't have Numbers, you can use Pages to create simple spreadsheets. Just use the tables inside Pages to create small spreadsheets that can use formulas to perform calculations. You can even sort and use basic and conditional formatting.
MacMost Now 658: Counting Items In iWork Numbers
1/16/12
You can use the COUNTIF function to count the number of times an item appears in a column. You can also use COUNTIFS to total the number of rows based on several conditions in several columns. The SUMIF and SUMIFS functions will give you the total of the rows in another column based on the same criteria.
MacMost Now 649: iWork Numbers Printing Tips
12/26/11
You can create nice-looking printouts from Numbers, but the options to do so aren't always obvious. Learn how to view your spreadsheets in layout view, adjust scaling, darken borders and use styles and design elements to create nicer Numbers printouts.
MacMost Now 629: iWork Numbers Cell Formatting
11/9/11
There are many options for formatting cells in iWork Numbers. You can choose the number of decimal places, or use fractions. You can format as currency or choose a different base system. You can choose from a variety of date and time formats. You can also create steppers, sliders and pop-up menus to make it easy to change values to cells. Conditional formatting allows you to have cells that change color and style with certain values or ranges.
MacMost Now 557: If Statements and Checkboxes in iWork Numbers
5/23/11
Learn how to use if statements in formulas in iWork Numbers. You can combine these with checkboxes and pop-up menus to create results based on conditions. Useful for solving problems and bookkeeping.
MacMost Now 503: Sharing Documents With iWork.com
1/14/11
You can share your Pages, Numbers and Keynote documents using Apple's iWork.com service. Others can view your documents right in their browser, and make comments and notes if they are using Safari. You can even upload Keynote presentations and present right from the Safari.
MacMost Now 478: Pivot Tables in iWork 09 Numbers
11/17/10
While iWork Numbers doesn't have true pivot tables, you can get similar results using Table Categories. This feature lets you group data together in various ways to reveal the same summaries that you can get with pivot tables.
MacMost Now 475: Adding Up Amounts In iWork Numbers
11/10/10
The simple task of adding a column of numbers in iWork Numbers can be done elegantly using right-sized tables with footer rows. Learn how to easily add a list of amounts and perform other function like averages using iWork 09 Numbers.
MacMost Now 460: Creating Charts in iWork 09 Numbers
10/6/10
Learn how to create simple charts from spreadsheet data in iWork 09 Numbers. You can create pie charts and line graphs and then customize how they look with inspectors and by just dragging elements. You can also put the charts on a separate page for printing.
MacMost Now 398: Creating Forms In iPad Numbers
5/14/10
One interesting feature of Numbers on the iPad is the ability to create forms. You can use forms to fill in the rows of a spreadsheet instead of entering data into the spreadsheet grid.
MacMost Now 258: Using Multiple Tables In iWork Numbers
6/26/09
iWork 09's spreadsheet program Numbers isn't like the old-fashioned spreadsheet programs you may be used to. You can create small tables and design a sheet with each table having its own numbers and formulas and also using numbers from other tables.
MacMost Now 255: Using Spreadsheet Formulas in iWork Numbers
6/19/09
Learn how to use basic spreadsheet formulas in iWork 09's Numbers program. You can use basic mathematical functions and also use functions to get the sum or average of a list of numbers.