• +44 01379 671280
  • training@computertrainingsuffolk.co.uk

Apple NumbersTraining

numbers training apple

Audience: This course is ideal for those wishing to unleash the power of Apple Numbers. No prior knowledge is required.


Numbers – For Mac, sophisticated spreadsheets are just the start. The whole sheet is your canvas. Just add dramatic interactive charts, tables and images that paint a revealing picture of your data.

You can work seamlessly between Mac and iOS devices. And work effortlessly with people who use Microsoft Excel. 
We are happy to arrange for a trainer to contact you to help tailor you course.

 

 

gold apple icon

 

Course Duration: 1 day.
Course Availability: Monday – Saturday
Course Types: Group bookings, 1-2-1 sessions, bespoke tailored courses and office migrations.


Course Location: This Apple Numbers training course can be delivered either at your offices at home or online. 
Tailored Course Content: Course content can be customised to meet your specific requirements, with dates to suit you.

 

 

At Course Completion

  • Understand the Numbers interface
  • Use Formulas and Functions
  • Manage Tables
  • Work with Charts
  • Use Multiple-axis charts
  • Work with Objects
  • Share documents
  • Print documents

Module 1: Numbers Basics

  • Launching Numbers
  • Exploring Templates Options
  • The user interface
  • File Management
  • Importing and Exporting Spreadsheets
  • Sheet Management
  • Customising the user interface
  • Working with Constant Values
  • Entering and Editing Text
  • Formatting Numbers and Dates
  • Conditional Formatting
  • Entering Special Characters

Module 2: Using Formulas and Functions

  • Using the Formula bar and Formula Editor
  • Using cell references
  • Manipulating functions
  • Accessing Formula List view

Module 3: Table Management

  • Adding tables and Table Contents
  • Using Table controls and Using Auto-fill capabilities
  • Working with rows, columns and cells
  • Table headers and footers
  • Table categories
  • Sorting table data
  • Creating reusable tables
  • Copying tables
  • Table Style Default Table Style
  • Using Address Book data

Module 4: Working with Charts

  • • Adding charts
  • • Changing chart types
  • • Modifying chart data
  • • Adding data to a chart from multiple tables

Module 5: Using Multiple-axis charts

  • Chart attributes
  • Adding trend lines and error bars
  • Formatting 3D charts
  • Linking charts to Keynote/Pages
Module 6: Working with Objects
  • Manipulating text boxes
  • Creating bulleted & numbered lists
  • Managing Shapes
  • Manipulating images
  • Masking objects
  • Instant Alpha Tool
  • Aligning and layering objects
  • Adding media files
Module 7: Spreadsheet Sharing
  • Password-protecting and emailing spreadsheets
Module 8: Creating Spreadsheet Templates
  • Creating and saving templates
  • Creating Media Placeholders
Module 9: Printing
  • Printing Options
  • Headers, Footers and Page numbering
  • Page Breaks

Most or our training sessions are 1 day duration with some specific software requiring 2-day sessions, for example, Project Introduction, Access Introduction and VBA. We specialise in taking what might seem a 'standard' course and customising the course content to suit our clients' needs.

This customisation is also helpful to employees as they are able to select the sessions that are most suited to their needs at the time without being away from the office for the entire day. All the course content is supplied with learning goals as well as prerequisites for the training to ensure compatibility with the learner’s needs and well as current level of knowledge.