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

This is the second course provided by XChange that I've taken and both were excellent. Our trainer was an expert in Wordpress and I've learned a great deal from this course. Thank you very much!

Danielle Macedo, University of Westminster, WordPress - 2 Day Masterclass

Great start to PitStop Professional, thank you.

Roy Broom, Camping & Caravanning Club, Enfocus PitStop Professional - 1 Day Introduction

I found the instructor very helpful and knowledgeable. I would like to return for further training...

Rebecca Sanderson, Frank Cass, Database Publishing - 1 Day Introduction

Well-paced and was taught the most important processes that will make a real difference to everyday use of InDesign.

Carly Rolfe, Manchester University, InDesign Introduction - 2 Days

It was very good, thoroughly worth it. The tutor was excellent and very efficient.

William Slack, Student, Vectorworks - 2 Day Introduction

Great training experience!

Ian Graham, Huntingdon, Digital Publishing Suite - 2 Day Introduction

Excellent training course and facilities - practical and easy to understand with knowledgeable and helpful Instructor.

Neil Cleary, IMP Planning Ltd, SketchUp - 1 Day Introduction

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