catraining

 

Microsoft Partner

Apple Numbers

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.

Course Duration: 1 day(1)

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

Course Location:This Apple Numbers training course is delivered at our training centre in London situated close to Liverpool Street station, training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

 

After completing this course, students will be able to:access training london
  • 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 Content

print this page
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
Microsoft

Call us now for further information Tel:08001601666
Access training london delivering all your training needs

VENUE
We offer a state of the art training venue in the heart of London, with a variety of dedicated training and conference rooms. We can also provide training at client sites.
TRAINING FACILITIES  
At our training venue, every student is provided a 23” Touch screen monitor. All rooms have ceiling mounted projectors and facilitators’ computers. We also have a dedicated Apple training room.
For onsite courses in the London Postcode area, we can supply up to ten laptops to support training courses if required .

TRAINING MATERIALS
On completion of our courses students will be given unlimited access to our online materials.