Apple Numbers Training Course Outline

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.

Course Duration: 1 day.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Apple Numbers training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled 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

Course Outline

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

Module 10: Installing Applications

  • Using the App Store to install Applications and update applications
  • Updating purchased applications from App Store
  • Installing software from other mediums

Module 11: Notification Center

  • Working with Notifications
  • Working with the Today view in Notification Center

Module 12: Networking and Sharing

  • Sharing with Networks
  • Sharing files, printers and screen control over a local network
  • Sharing files quickly with AirDrop
  • Using Handoff to transfer tasks between an iPhone and a Mac

Module 13: Backing Up and Restoring

  • Understanding backups and archives
  • Setting up a Time Machine backup and restoring files

Module 14: Security Settings

  • Turning on the Firewall
  • FileVault
  • Changing the Login Password
  • Setting  Multiple User Accounts
  • Privacy options

Module 15: System Preferences

  • Customising the Dock
  • Language and Region settings
  • Display options
  • Working with multiple displays
  • Energy Saver settings
  • Setting up the keyboard, mouse and trackpad
  • Managing printers
  • Dictation
  • Parental Control
  • Setting the Date and Time
, Apple Numbers Training Course
, Apple Numbers Training Course