Master Apple Numbers, the powerful spreadsheet app from the iWork Suite, in this comprehensive 1-hour 11-minute tutorial. Begin with the basics of creating and managing spreadsheets, then dive into advanced data manipulation techniques using pivot tables, conditional formatting, formulas, and functions. Learn to enhance your spreadsheets with charts, images, and custom styling. Explore collaboration features, including sharing, real-time editing, and iCloud integration. Perfect for beginners and those looking to expand their Numbers skills, this tutorial covers everything from interface navigation to complex data analysis, ensuring you can create professional, visually appealing spreadsheets with ease.
Overview
Syllabus
Start
Introduction
Opening Numbers
Creating Spreadsheets
Numbers Interface
Changing Backgrounds
Opening, Closing, and Saving
Personalizing Templates
Creating and Managing Custom Templates
Using Sheets
Search
Printing
Customizing Apps
Adding and Removing Tables
Selecting Cells, Rows, and Columns
Adding or Modifying Rows and Columns
Merging and Unmerging Cells
Modifying Table Appearance
Resizing, Moving, and Locking Tables
Adding Text and Objects to Cells
Working with Different Types of Data
Wrapping Text
Conditional Highlighting
Filtering
Sorting and Alphabetizing
Organizing Data Into Categories
Pivot Tables
Quickly Calculating Sum and Average
Calculating Values Using Data in Cells
Formula Help
Adding and Removing Charts
Moving and Resizing Charts
Modifying Chart Data
Modifying Chart Appearance
Selecting Text and Placing Insertion Points
Adding and Editing Text
Text Formatting
Using Paragraph Styles
Applying Styles with Keyboard Shortcuts
Formatting Characters and Punctuation
Aligning, Spacing, and Formatting Lists
Adding and Editing Equations
Adding Links
Adding Highlight Effect
Adding Lines to Separate Text
Introduction to Images and Objects
Images
Shapes
Lines and Arrows
Audio and Video
Image and Video Formats
Animating Drawings
Positioning Objects on Sheets
Resizing, Rotating, and Flipping
Filling Objects with Color or Images
Changing Transparency
Adding Borders
Adding Reflections and Drop Shadows
Adding Titles or Captions
Using Object Styles
Undo and Redo
Looking Up Words
Find and Replace
Check Spelling
Comments
Introduction to Collaboration
Sending Spreadsheets
Inviting Others to Collaborate
Collaborating on Shared Spreadsheets
Sharing Settings
Shared Folders
iCloud and Transferring Between Devices
Importing Excel or Text Files
Reducing File Size
Packing Files
Restoring Previous File Versions
Password Protection
Keyboard Shortcuts
Conclusion
Taught by
Learnit Training
