Numbers – Apple Numbers Training

Numbers Training Course – Apple

Maryland, Virginia, Washington D.C., & On-Site

Apple Authorized Training Provider Logo

Numbers Training Course Description:

In this one-day hands-on course, students become familiar with the key features and functionality of Numbers. Students work with real-world content and scenarios to learn practical approaches to creating spreadsheets. Upon completion of the Numbers course, students will be able to: Store, analyze, and present data in an informative and interactive format using formulas, charts and graphs, and rich media. This class is designed for anyone who wants to create professional quality spreadsheets.  This course will prepare you for the Apple Certified Pro – Numbers Exam (9L0-905).

Prerequisites for Attending Numbers Training:

Students must have a good working knowledge of computers, operating systems—Knowledge of OS X—using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications, files, as well as navigate to other folders.

Projects that Use Numbers:

Budget Graph and Charts
Invoices
Calendars
Time Sheets
Spreadsheets

Locations for Numbers Training:

In Person at ThinkB!G’s Office in Columbia, MD (next to the Columbia Mall)
Private Custom Training On Site or at Your Location
Project Based Training On Site or at Your Location

Times for Numbers Training:

In Person: 8:30AM-3:00PM ET / 5:30AM-12:00PM PT (30 Minute Lunch)
Private Custom & Project Based Training: Your preference
*Please click the Dates To Register tab above to see all dates & times available.*

Numbers Training Class Includes:

Hands-On Training Led by Certified Instructors
Print and/or Digital Courseware
Certificate of Completion
Continental Breakfast Every Day (In Person Only)
Catered Gourmet Deli Lunch Every Day (In Person Only)
Unlimited Snacks and Refreshments (In Person Only)
Notebook & Pen (In Person Only)
Free Parking (In Person Only)

Software Versions:

ThinkB!G open enrollment classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 301-362-2250.

Related Training and Certification Courses:

Final Cut Pro X 10.3 Professional Post-Production
iOS Deployment Essentials
Keynote
Logic Pro X 10.3 Professional Music Production
Motion 5
Pages
Support Essentials 10.12 – macOS Sierra 101
Server Essentials 10.12 – macOS Sierra 201
Support and Server Essentials 10.12 – macOS Sierra 101 & 201

Apple Numbers Training Outline

1. Getting Started:
Learning Methodology
Understanding course structure
System requirements
Downloading and installing lesson files
Additional resources

2. Discovering Common Features:
Before you start
Opening Pages
Swapping between open applications
Choosing themes
Editing text in Pages
Customizing your workspace
Repeating image styles
Reverting documents
Distributing your work
Working with tables
Illustrating data using charts
Adding comments
Adding photos
Adjusting layouts
Trimming a movie clip
Securing your files

3. Organizing Data Using Numbers:
Assessing templatesWorking with sheets
Making a budget sheet
Adding calculations
Working with multiple tables
Printing from Numbers

4. Making Interactive Spreadsheets:
Opening and upgrading a Numbers ’09 document
Opening and editing an Excel workbook
Formatting tables
Referencing data
Evaluating data formats
Adding conditional highlighting
Using password protection

5. Making Customized Calculators:
Understanding relative and absolute cell referencing
Concatenating cells
Sorting tables
Filtering tables
Making a pricing calculator

6. Illustrating Data Using Charts:
Opening a CSV file
Creating a stacked bar chart
Making a mixed chart
Using interactive chart types
Showing a margin of error
Building a scatter chart
Saving a template

7. Numbers for iOS:
Signing in to iCloud
Working with tables
Adding photos and video
Setting a document password

8. Moving Between iOS, iCloud, and OS X:
Opening an iOS document on your Mac
Moving a Mac document to iCoud Drive
Using Numbers forms on iOS
Tidying up

Disclaimer:

All course objectives and outlines are a guide for students.  To ensure student satisfaction, these course topics and order may be modified or added to ensure the latest information is covered to support real world use of the technology.

We have instructors ready to teach this class, but we do not currently offer it on our open enrollment schedule. If you are interested in this class, please fill out the form below and we will contact you shortly about your training options!