Video Tutorials, News and Insights for Apple Users

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. (Read More, 2 Replies)

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. Video Transcript (Click to Expand) Hi, this is Gary with MacMost Now. On todays episode [...] (Read More, 3 Replies)

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 [...] (Read More, 1 Reply)

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. Video Transcript (Click to Expand) Hi. This is Gary with MacMost Now. On today's episode [...] (Read More, 1 Reply)

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 [...] (Read More, 3 Replies)

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. Video Transcript (Click to Expand) Hi, this is Gary, with MacMost Now. On today's episode let's use if statements and checkboxes in iWork [...] (Read More, 12 Replies)

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. Video Transcript (Click to Expand) Hi! This is Gary with MacMost [...] (Read More, 9 Replies)

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. Video Transcript (Click to Expand) Gary Rosenzweig: Hi, this is Gary with MacMost Now. On today's episode [...] (Read More, 16 Replies)

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. Video Transcript (Click to Expand) Hi this is Gary at MacMost Now. On today's [...] (Read More, 5 Replies)

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. Video Transcript (Click to Expand) Hi, this is Gary [...] (Read More, 9 Replies)

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. Video Transcript (Click to Expand) Hi, this is Gary with MacMost Now. On today's episode, let's look at Numbers on the [...] (Read More, 48 Replies)

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. Video Transcript (Click to Expand) On today's episode: Let's take a look at how [...] (Read More, 6 Replies)

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. Video Transcript (Click to Expand) Gary Rosenzweig: Hi this is Gary with MacMost Now. Today’s episode, let’s learn how to create formulas [...] (Read More, 103 Replies)