Free Video Tutorial: Numbers for Mac & iOS - Apple Mac, iPad & iPhone Tutorials from ScreenCastsOnline
Free 10 Day Trial

Tutorial Topics

Search for Tutorials Show All Tutorials Pricing About Us Free Trial

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 full tutorial covers:

  • Two-Factor Authentication
  • Numbers on the Mac
  • Basic Functionality – Mac
  • Entering Data – Mac
  • Rows & Columns – Mac
  • Insert Objects & Comments – Mac
  • Collaboration – Mac
  • Numbers on iOS
  • Collaboration – iOS
  • Basic Operations – iOS
  • Row & Column Actions – iOS
  • Working with Cells – iOS

App Store Links:

Numbers for iOS iOS App Store

Numbers for macOS Mac App Store

Video Tutorial Comments

(4 comments posted)

Simon Ledwith

Hello
I have been testing the new My Stocks template. A London listed stock, i.e. Aviva plc (Symbol AV.L) that is quoted in pence is shown by Apple as £ ie. £534.00 instead of 534.00p. The same error is shown in the Price Change column. The result of this error is that the Market Value and Gain are increased by two decimal points!

There appears to be no setting that can be altered. Is this an Apple problem providing a Template that only works with US quoted stocks?

Reply

Don McAllister

Hi Simon, It looks like a bug that you will need to report to Apple. It's not that it only works with US Stocks as it reflects the correct exchange if you select the exchange parameter. A work around would be to have the actual Stock formula in one cell and display the stock/100 in the displayed cell.

Simon Ledwith

Hello
I have been testing the new My Stocks template. A London listed stock, i.e. Aviva plc (Symbol AV.L) that is quoted in pence is shown by Apple as £ ie. £534.00 instead of 534.00p. The same error is shown in the Price Change column. The result of this error is that the Market Value and Gain are increased by two decimal points!

There appears to be no setting that can be altered. Is this an Apple problem providing a Template that only works with US quoted stocks?

Simon Ledwith

Thanks Don, I have reported the problem to Apple.

Simon

Posting comments is restricted to ScreenCastsOnline members only.

Sign Up

Video Tutorial Transcription