Bespoke Apple iWork Numbers 2016 - 1 Day Introduction Course

Bespoke iWork Numbers 2016 - 1 Day Introduction Overview

Apple iWork Numbers is the easy to user spreadsheet tool bringing together a full feature set for formulas, table and charts with Apple's intuitive user interface. This 1 day course covers the functionality available to Mac spreadsheet professionals with Numbers and the most effective ways to benefit from them.

By the end of this course you will be fully confident in the use of formulas, charts, tables, templates and how to use this powerful spreadsheet application most effectively.

Course Target Audience and delegate prerequisites

 

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

• 1 delegate: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £845
• 5 delegates: £895
• 6 delegates: £945
• 7 delegates: £995
• 8 delegates: £1045

Bespoke iWork Numbers 2016 - 1 Day Introduction Outline

The following is a general outline. The range of topics covered during your training is dependent upon student level, time available and preferences of your course booking.

Getting Started with Numbers

• Launching Numbers
• Exploring Templates Options
• The user interface
• File Management
• Importing and Exporting Spreadsheets
• Sheet Management
• Customising the user interface

Using Formulas and Functions

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

Working with Constant Values

• Entering and Editing Text
• Formatting Numbers and Dates
• Conditional Formatting
• Entering Special Characters

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

Using Charts

• Adding charts
• Changing chart Types
• Modifying chart data
• Adding data to a chart from multiple tables
• Using Multiple-axis charts
• Chart attributes
• Adding trend lines and error bars
• Formatting 3D charts
• Linking charts to Keynote/Pages

Using Objects

• Manipulating text boxes
• Creating bulleted & numbered lists and Paragraph formatting
• Managing Shapes
• Manipulating images
• Masking objects
• Instant Alpha Tool
• Aligning and layering objects
• Adding media files

Sharing Spreadsheets

• Password-protecting and emailing spreadsheets

Creating Spreadsheet Templates

• Creating and saving templates
• Creating Media Placeholders

Proofing Tools

• Using Spell Checker
• Find and Replace tool

Printing Tools

• Printing Options
• Headers, Footers and Page numbering
• Page Breaks

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

• 1 delegate: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £845
• 5 delegates: £895
• 6 delegates: £945
• 7 delegates: £995
• 8 delegates: £1045

What's Included

The following are provided for your best experience on this bespoke course:

• Tailored course content arranged around your requirements
• Flexible dates to suit your desired timeframe
• Course location either at our training centres or onsite at your premises.
• All computers for your use with choice of Windows or Mac systems (not onsite)
• Quality reference manual for post course reference to take away with you
• 6 months post course support to assist you where needed
• Official Authorised Certificate for your successful completion of the course
• Lunch To give you the most flexible options for lunch we provide lunch vouchers which can be redeemed locally at a number of popular eateries including Pret A Manger, EAT, Starbucks, Tesco, Sainsburys, Boots and Gregs (not onsite)
• Refreshments to keep you on top form are available for you throughout the course with a full range of teas, coffees and biscuits (not onsite)

Normal daily course times run between 10am and 5pm however we can offer flexibility for this bespoke course should your time requirements vary.

Quality training manual

Included with our iWork courses is the Apple Training Series: iWork book for free to use as a post course reference resource. This is a full 300+ page manual to supplement the content covered during the course.

6 months support

Included with your course booking for all delegates on this course is 6 months free support so if you run into problems or need assistance relating to anything covered during your course we would be happy to assist you during this time.

Official Course Certificate

After your class with XChange Training you will receive our official Certificate as a record of your successful completion of the course.

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

• 1 delegate: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £845
• 5 delegates: £895
• 6 delegates: £945
• 7 delegates: £995
• 8 delegates: £1045

Training Location Options

This course is offered for your convenience either at one of our bespoke training centres in London, Manchester and Glasgow or onsite at your offices anywhere in the UK. Just let us know what would work best for you or your team.

The location details of our bespoke training centres are shown below:

LONDON
5 St John’s Lane
Clerkenwell
London
EC1M 4BH

St John’s Lane is located in the heart of Clerkenwell close to the junction of Farringdon and Clerkenwell Road. Farringdon tube & train station is just a few minutes away and the training centre can also be accessed from Chancery Lane and Barbican tubes in about 10 minutes. There is also easy direct access by bus from Waterloo (243) and West End (55) with nearby stops.

MANCHESTER
Piccadilly House
49 Piccadilly
Manchester
M1 2AP

Piccadilly House is located in central Manchester directly next to the Piccadilly Gardens transport interchange with excellent bus and tram connections and is easily accessed from Piccadilly train Station (5 mins). Victoria station is also close by (around 10 mins).

GLASGOW
Centrum Business Centre
38 Queen Street
Glasgow
G1 3DX

The Queen Street training centre is located in central Glasgow within easy walking distance of the 3 local train options of Central Station, Queen Street and Argyle Street offering excellent transport connections.

Courses are run between 10am and 5pm with an hour break for lunch and both mid morning and mid-afternoon refreshment breaks.

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

• 1 delegate: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £845
• 5 delegates: £895
• 6 delegates: £945
• 7 delegates: £995
• 8 delegates: £1045

Bespoke Course Enquiry

If you are considering this Apple iWork Course but would like further information simply send us your query quickly & easily with the form below. Whether you would like to check date availability, pricing, course suitability or just need further information about a course send us your query and we will get you a swift reply, usually within 2 business hours!

If you would prefer to check course details by phone please call us on 0345 363 1130.

Course Name:	Bespoke iWork Numbers 2016 - 1 Day Introduction
Location Preference:	--Please Choose-- XChange - London XChange - Manchester Onsite at my offices Undecided
Knowledge level of delegate(s):	--Please Choose-- Beginner Some Notions Intermediate Advanced
Number of delegates:	--Please Choose-- 1 2 3 4 5 6 7 8 9 10+
Nature of enquiry:	--Please Choose-- Check Date Availability Course Information Request Price Enquiry Course Suitability Other
Lead contact name:
Email address:
Telephone number:
Company (if applicable):
Specific query details:
XChange Training respects your privacy. By entering your information, you agree to the terms of our company Privacy Policy.

 

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

• 1 delegate: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £845
• 5 delegates: £895
• 6 delegates: £945
• 7 delegates: £995
• 8 delegates: £1045

Related Courses

Bespoke Apple iWork Training Courses

Apple iWork Keynote 09 - 1 Day Introduction Course

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

• 1 delegate: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £845
• 5 delegates: £895
• 6 delegates: £945
• 7 delegates: £995
• 8 delegates: £1045

Scheduled Apple iWork Training Courses

We currently do not offer any public scheduled classes for this application however our bespoke courses will be able to suit your requirements.

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

• 1 delegate: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £845
• 5 delegates: £895
• 6 delegates: £945
• 7 delegates: £995
• 8 delegates: £1045

Testimonials

Good very clear instructing, especially given that this was the first time I used the software. Excellent.

Sarah Tennant, Christie’s, Bespoke Apple Keynote 1 Day Introduction

The instructor was great - very knowledgeable and patient. Explained things very simply.

Emma Pearson, Fremantle Media, Apple Keynote 1 Day Introduction

We learnt all the relevant skills and extra techniques to enable us to work Keynote. Also all the extra quick links and the free Training Book will be very useful. Thank you.

Laura Kirby, M-IS, Bespoke Apple Keynote 1 Day Introduction

Had an absolutely fantastic tutor and session - covered everything I asked and didn't know to ask!! So happy with the aftercare support as well and would love the opportunity for another relevant course in future.

Emily Theodore, Catersales, Illustrator - 1 Day Advanced

Highly enjoyable session - having had no previous experience with Illustrator it proved very easy to pick things up under guidance. Thank you XChange!

William McPhail, Sothebys, Illustrator - 2 Day Introduction

Excellent course which was easy to follow.

Carlo Gonzalez, Ldo Creative, Adobe DPS - 2 Day Introduction

Great training over the 2 days with an excellent teacher. I am so much more informed about the digital CAD world and more prepared for my creative career as a designer. I will gladly recommend this on to other students seeking creative professional careers.

Peter Johnson, University of Arts London, Vectorworks - 2 Day Introduction

Good basic introduction to Photoshop but included some advanced elements that could be expanded on with further reading/training.

Karen Hartley, J Murphy & Sons, Photoshop - 2 Day Introduction

I found the training went at a great pace and the instructor was extremely helpful and answered all the questions that were thrown at him, plus a good few tips and pointers. Very Pleased.

Antony Frangos, Pentland Brands, Cinema 4D - 2 Day Introduction

This was a first-class course, delivered by a first class trainer in a first-class training environment. Having attended a number of courses at XChange it seems that top quality course delivery is the norm not the exception. Many thanks.

Steve Linehan, The Stationary Office

Bespoke Training Prices

The regular course pricing is indicated below for a range of delegate numbers. Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.

• 1 delegate: £595
• 2 delegates: £695
• 3 delegates: £795
• 4 delegates: £845
• 5 delegates: £895
• 6 delegates: £945
• 7 delegates: £995
• 8 delegates: £1045