Introduction To Mac Numbers - Philippines

Introduction to Mac Numbers​ Course Outline

Number Tools and Techniques

• Spreadsheet Templates
• The Numbers Window
• Zooming In or Out
• Sheets Pane and Print View
• The Toolbar
• The Format Bar
• The Inspector Window
• Formula Tools
• The Styles Pane
• The Media Browser
• Colours, Fonts, and Warnings Window
• Keyboard Shortcuts and Shortcut Menus

Create, Save, and Organise Numbers Spreadsheet

• Creating a New Spreadsheet
• Import a Document from Another Application
• Using CSV or OFX Files in a Spreadsheet
• Opening an Existing Spreadsheet
• Password-Protecting a Spreadsheet
• Saving Spreadsheets
• Using Sheets to Organise a Spreadsheet
• Dividing Sheet into Pages

Working with Tables and Table Cells

• Introduction to Tables
• Select Tables and their Components
• Row and Columns in Tables
• Putting Content into Table Cells
• Display Content Too Large for Table Cell
• Conditional Formatting to Monitor Table Cell Values
• Add Images or Colour to Table Cells
• Merge and Split Table Cells
• Format Table Cell Borders
• Copy and Move Cells
• Add Comments to Table Cells
• Format Table Cell Values for Display

Exploring Table Styles

• Using and Applying Table Styles
• Modify Table Style Attributes
• Using the Default Table Style
• Create New Table Styles
• Rename and Delete a Table Style

Using Formulas in Tables

• Elements of Formulas
• Performing Instant Calculations
• Using Quick Formulas
• Creating Own Formulas
• Removing Formulas
• Referring to Cells in Formulas
• Operators in Formulas
• Copy or Move Formulas and their Computed Values
• Viewing Formulas in Spreadsheet
• Find and Replace Formula Elements

Creating Charts from Data

• Define Charts
• Create a Chart from Table Data
• Formatting Charts

Working with Text

• Adding and Selecting Text
• Delete, Copy, and Paste Text
• Format Text Size and Appearance
• Setting Text Alignment, Spacing, and Colour
• Setting Tab Stops to Align Text
• Setting Indents and Creating Lists
• Text Boxes and Shapes to Highlight Text
• Using Hyperlinks
• Insert Page Numbers and Changeable Values
• Automatically Substituting Text
• Insert a Nonbreaking Space
• Check for Misspelled Words
• Work with Spelling Suggestions
• Search for and Replace Text

Working with Shapes, Graphics, and Other Objects

• Working with Images
• Creating Shapes
• Using Sound and Movies
• Manipulate, Arrange, and Change Look of Objects
• MathType

Add Address Book Data to a Table

• Using Address Book Fields
• Map Column Names to Address Book Field Names
• Add Address Book Data to an Existing Table
• Add Address Book Data to a New Table

Sharing Number Spreadsheet

• Printing a Spreadsheet
• Export Spreadsheet to Other Document Formats
• Send Numbers Spreadsheet to iWork.com Public Beta
• Send Spreadsheet Using Email
• Send Spreadsheet to iWeb
• Share Charts, Data, and Tables with other iWork Applications

Designing Own Numbers Spreadsheet Templates

• Designing Template
• Table Styles for Custom Template
• Reusable Tables for Custom Template
• Default Charts, Text Boxes, Shapes, and Images for a Custom Template
• Create Initial Spreadsheet Content for a Custom Template
• Save Custom Template