Numbers for the Mac - Part 2 - Preview
Interactive Transcription
The transcript will follow that audio as the video plays. Scroll and click on the transcript to jump to that part of the video.
9,476
Plays
23
Likes
The transcript will follow that audio as the video plays. Scroll and click on the transcript to jump to that part of the video.
9,476
Plays
23
Likes
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.
Don't forget to check out the companion iOS episodes SCOI0147 & 148 to take a look at Numbers on the Mac.
The full tutorial covers:
(3 comments posted)
Great show. Thx. I am very interested in the sharing capability of Numbers. Can one IMPORT and excel sheet into Numbers and thus turn it into a Numbers spreadsheet for future use?
Hi Nicholas, Indeed it is possible to open Excel spreadsheets with Numbers although you'll need to be careful in case the Excel spreadsheet contains advanced functions or formatting that perhaps Numbers doesn't support.
It's great seeing Numbers in action as it's different enough from Excel that I had for the longest time steered clear of it. It makes a lot more sense now.
However, from my Excel skills I believe I've spotted a bit where you haven't used the full power of the spreadsheet to save you effort.
At 04:44 where you fix the absolute reference, if you had selected to preserve only the row of B2 (thus $B2) and the column of A4 (thus A$4) then you could have filled that single formula down all the rows and then filled across to the next column.
Ember & Pixa - Organise Your Images tutorial is also available to watch in Issue 20 of the ScreenCastsOnline Monthly As a Premium member, this back issue may be available to you for free, or if published before you became a member, is available for individual purchase as a back issue in the ScreenCastsOnline Monthly Mag application.
Available on the App Store
Recent Full Tutorials
All Recent TutorialsWe pride ourselves in our responsiveness, but please allow up to 24 hours for us to get back in touch. We are based in UK so there may be a time difference!
Drop us an email
Posting comments is restricted to ScreenCastsOnline members only.
Sign Up