Tags

You may think pivot tables are for spreadsheet nerds, and there's some truth to that. Allison's goal, however, is to show you how enjoyable and useful they can be.

Now that Apple has finally brought pivot tables to Numbers, we can create them on our Macs, iPads, and even iPhones. Faced with a pile of data, pivot tables can help you can turn that mess into actionable information.

Allison uses data she's collected about solar energy generation and power consumption to demonstrate how to take a long spreadsheet and turn it into a simple 4x4 pivot table that answers the question, "Am I generating more power than I'm consuming?"

Apple's decision to completely rewrite its iWork suite of apps way back in 2013 brought with it numerous changes to the overall feature set of those programs. Pages, Numbers, and Keynote are still being updated frequently, bringing back features that had been removed, and introducing some new functionality.

In this episode, Don takes a look at the new features added since his last look back in 2019.

Apple is continuously improving Pages, Numbers and Keynote by adding in new features or adding back functionality that had been removed from the original versions several years ago.

In this tip video, Don takes a look at some of the common features implemented in the most recent iOS release, as well as some app-specific features.

Apple is continuously improving Pages, Numbers and Keynote by adding in new features or adding back functionality that had been removed from the original versions several years ago.

In this tip video, Don takes a look at some of the common features implemented in the most recent macOS release, as well as some of the new app-specific features.

Following on from the recent update shows, a final quick update on Pages, Number and Keynote.

In this tip video, Don takes a look at some changes to Smart Annotations and Drawing in Pages, as well as the common changes in Charting and the support for displaying LaTeX or MathML equations across all of the iWork Apps.

The iWork suite of Pages, Numbers and Keynote has been updated to allow you to record audio clips into your word processing document, spreadsheet or presentation slide, directly from your iPad or iPhone.

In this tip video, Don shows you the common method for creating and editing these clips.

In addition, he also demonstrates how these clips are presented and can be replaced or updated in the macOS versions of the apps. You can also include audio in those, but it's necessary to record your audio externally - at least for now!

Following on from the recent Pages 2018 update tutorial, Don explores in this week's tutorial the 2018 updates to Numbers and Keynote, Apple's spreadsheet and presentation applications.

Numbers

As Apple have rewritten all of the iWork applications with the same code base, many of the new features are present in all three applications. With Numbers, some specific improvements have been made to controlling the import of external files on both the Mac and iOS, as well as some long-overdue enhancements to sorting and filtering in the iOS version.

Keynote

The Mac version of Keynote receives all of the standard updates delivered with Pages and Numbers including new shapes, image galleries and collaboration, and more. Most notable however is the addition of Apple Pencil support in the iOS version, along with the ability to animate line drawings on your slides. No Apple Pencil? Then you can use your finger!

Time for an update show this week, with updates to some of our favourite apps!

Plex - We've covered Plex many times for managing recorded media, but now you can watch and record Live "off the air" TV with the addition of a hardware tuner. This segment describes what you need and demonstrates how easy it is to configure.

iWork - After recently finishing a series of update shows for Pages, Numbers and Keynote, Apple have just released a slew of updates - some minor, some quite significant. Learn all about them with this latest update segment.

In the second of this occasional series, we take a look at the changes to the latest version of Apple's premiere spreadsheet application: Numbers for macOS and iOS.

With lots of extra features, Numbers is still the best way to crunch numbers and present them beautifully!

Also in this episode, we take a look at protecting your Apple ID using two-factor authentication. This is due to a mandatory requirement starting June 15, 2017, for any third-party apps to use app-specific passwords if they access iCloud services.

The final part of our two part series on Numbers for the Mac.

Apple have re-written Numbers from scratch to add additional compatibility with the iOS version, and to allow you to share and collaborate on iCloud.

In this episode, I take a look at using formulas and functions as well as inserting and manipulating charts and other objects into your spreadsheets.

The final part of our two part series on Numbers for iOS.

Apple have re-written Numbers from scratch to add additional compatibility with the Mac version, and to allow you to share and collaborate on iCloud.

In this episode, I take a look at using formulas and functions as well as inserting and manipulating charts and other objects into your spreadsheets.

As part of our ongoing coverage of all the new iWork applications, this week I take a look at Numbers for the Mac.

Apple have re-written Numbers from scratch to add additional compatibility with the iOS version, and to allow you to share and collaborate on iCloud.

This first in a two part series, will take you through the basics of Numbers and give you a good understanding of some of its core features and capabilities.

[Note: The day before publication, Apple released Numbers v3.1 on the Mac as well as an updated iOS version. The new version does not impact on any of the elements covered in this video as it's mainly bug fixes and stabilities improvements, with just a couple of tweaks - I'll cover them next week]

As part of our ongoing coverage of all the new iWork applications, this week I take a look at Numbers for the iOS.

Apple have re-written Numbers from scratch to add additional compatibility with the Mac version, and to allow you to share and collaborate on iCloud.

This first in a two part series will take you through the basics of Numbers and give you a good understanding of some of its core features and capabilities.

[Note: The day before publication, Apple released Numbers v3.1 on the Mac as well as an updated iOS version. The new version does not impact on any of the elements covered in this video as it'd mainly bug fixes and stability improvements, with just a couple of tweaks - I'll cover them next week]

Following on from the last episode, I continue examining the three iWork applications available on iOS, this time completing my look at Numbers - the spreadheet application.

You might think that a spreadsheet might not lend itself to working using a touch interface easily. However, once you’ve mastered some simple techniques, it’s a breeze. It’s even possible to create some specially optimised touch controls to enter data, all with just a few taps.

This second part of a two part series takes you through some of the more useful aspects of using Numbers on iOS.

This show covers the old version of of the application - an updated version of the tutorial is being planned!

This episode continues our look at the three iWork applications available on iOS, this time taking a look at Numbers - the spreadheet application.

You might think that a spreadsheet might not lend itself to working using a touch interface easily. However, once you’ve mastered some simple techniques, it’s a breeze. It’s even possible to create some specially optimised touch controls to enter data, all with just a few taps.

This first part of a two part series takes you through some of the basic principles of Numbers for iOS

This show covers the old version of of the application - an updated version of the tutorial is being planned!

Following on from an extremely impressive debut with Numbers 08, Apple has made some significant improvements to the new version of Numbers, making it a viable alternative to Excel for most people.

Straight into the good stuff this week with an in-depth look at all the major features of Numbers, the spectacular new spreadsheet application included in Apples iWork '08 suite.