image



APPLE iWORK - NUMBERS

Numbers spreadsheets are built on a flexible, free-form canvas so you can move tables, charts, graphics, and text anywhere you want on the page. As tables resize, objects automatically adjust to fit around them. You can create as many tables as you wan, and change fonts, sizes, colours, styles, and borders. With graphics tools, alignment guides, and rulers, spreadsheet-making becomes an exciting creative endeavour. With great-looking templates, easy-to-create formulas, and dynamic tables and charts, you will quickly become an expert.

Your tutor has been using and tutoring on Apple Macs since 1985, was Training Manager for an Apple reseller before setting up Albany Compuer Training, and presents Apple courses at Auckland University.

  Introduction - Level 1 (6 hrs)

  Intermediate - Level 2 (6 hrs)
  • The Workspace
  • The Inspector
  • Using Templates
  • Creating Spreadsheets
  • Importing Data
  • Adding Data
  • Instant Calculations
  • Quick Formulas
  • Writing Formulas
  • Sheet Division
  • Using Tables
  • Formating the Sheet
  • Creating Charts
  • Shape & Images
  • Sounds & Movies
  • Sharing your File
  • Printing
  • Advanced Functions
  • Cell Referencing
  • Absolute References
  • Date Calculations
  • IF Functions
  • Working with Lists
  • Sorting Data
  • Sheet Protection
  • Advanced Tables
  • Custom Table Styles
  • Advanced Charting
  • Address Book Data
  • Designing Templates
  • Pre-requisites:
    No prior experience is necessary.
  • Pre-requisites:
    You would have completed our Level 1 with us, or can prove you know and understand the Level 1 topics.
   

Plus you also get:

  • a comprehensive training manual
  • on-going email support
 

All courses are 6 hours duration, but you can take them as:

  • a 2 hour session (you will need to take 3 x 2 hr sessions to complete a level.)
  • a half day (3 hrs) session (take 2 x 3 hr sessions)
  • or the complete level in one day (6 hrs)

Design your Own course:  choose from the above topics to design your own custom training session to suit your skill levels.

 

Price:

  • By the hour  (min 2 hrs) - individual training:  $80 plus gst per hour
  • By the hour (min 2 hrs) - group training: $120 plus gst per hour
  • Schedule training in our training room: $175 inc gst per 3 hour session
  • Corporate 1 day training: POA

Back to Apple courses

image



image



image