Become a Member

Library

Search All Tutorials Testimonials Pricing Why ScreenCastsOnline? Become a Member
Testimonials
Close

Incredible Time-Saving Tips

"If you value your time, signing up for ScreenCastsOnline is a no brainer. The number of time-saving 'tips per minute' is frankly incredible."

Michael Shulver

More Helpful Than Any Manual

"Much more helpful than trying to alternate between a book/manual and the keyboard/screen."

Bill Lucke

Save Time And Money

"It keeps me abreast of the latest tools - I've saved HOURS of time with the tips I've obtained."

Jonathan Sanchez-James

Get More Out Of Your Mac

"I switched from Windows so ScreenCastsOnline helps me get more out of my Mac."

Guenther Breitenstein

Can't Find Anywhere Else

"I can get great reviews and 'How-To's' on software that I cannot find anywhere else."

Dan Nelson

Become A Mac Power User

"ScreenCastsOnline is how I have become a Mac Power user, without spending my entire day doing trial and error."

Roper DeGarmo

Learn From Every Show

"I always learn something new and useful in every show - even for applications I have been using for months or even years!"

Don Stark

Great Tutorials

"I feel that technology changes at a rate faster than I can learn how to harness it, so your tutorials help a lot."

Christopher Smith

Get Up To Speed Fast

"Brings me up to speed with the latest and greatest apple software and saves me oodles of stress!"

David Saunders

Become An Expert

"I became a member years ago and now my family think I'm a Mac expert! Don, little do they know, it's all because of you."

Gerald Snodgrass

Go Back And Review

"I really have learned so much from the ScreenCasts videos. I like the way I can go back and re-listen and review as I learn."

Anne Davis

Apple TV App

"The Apple TV app is excellent and easy to navigate... a first class application to view your excellent screencasts."

Mike Collis

Valuable Resource

"ScreenCastsOnline is by far the best and most valuable Mac resource available on the internet."

Chris Burns

Archived Shows

"Really educational, I especially like being able to see archived shows to see if there is a show on something that I want to learn or use"

Chris Whittle

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

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

Transcription