Who it's for: Beginners and anyone who wants to learn more about Apple Numbers.
What it is: Apple’s highly-regarded spreadsheet app, a cornerstone of their iWork Suite and similar to Microsoft Excel or Google Sheets.
What you'll learn: We’ll start with the basics like opening spreadsheets, adding tables, and using columns and rows. Then, we'll jump into working with data using tools like pivot tables, conditional formatting, formulas, functions, charts, and more. Next, we'll go over sprucing up your spreadsheets with images, borders, colors, and more. Finally, we'll cover collaboration with sharing, working together, and iCloud integration.
Exercise Files - Download Before Starting the Course
Available in
days
days
after you enroll
Course
Available in
days
days
after you enroll
- Introduction (1:38)
- Opening Numbers (0:56)
- Creating Spreadsheets (0:44)
- Numbers Interface (1:08)
- Changing Backgrounds (0:39)
- Opening, Closing, and Saving (1:36)
- Personalizing Templates (2:45)
- Creating and Managing Custom Templates (1:29)
- Using Sheets (1:15)
- Search (0:57)
- Printing (0:38)
- Customizing Apps (0:43)
- Adding and Removing Tables (1:14)
- Selecting Cells, Rows, and Columns (0:18)
- Adding or Modifying Rows and Columns (0:43)
- Merging and Unmerging Cells (0:30)
- Modifying Table Appearance (1:19)
- Resizing, Moving, and Locking Tables (0:38)
- Adding Text and Objects to Cells (1:48)
- Working with Different Types of Data (2:14)
- Wrapping Text (0:36)
- Conditional Highlighting (1:21)
- Filtering (1:02)
- Sorting and Alphabetizing (0:48)
- Organizing Data Into Categories (0:26)
- Pivot Tables (1:52)
- Quickly Calculating Sum and Average (1:11)
- Calculating Values Using Data in Cells (4:09)
- Formula Help (0:29)
- Adding and Removing Charts (0:57)
- Moving and Resizing Charts (0:18)
- Modifying Chart Data (0:37)
- Modifying Chart Appearance (0:45)
- Selecting Text and Placing Insertion Points (0:34)
- Adding and Editing Text (0:15)
- Text Formatting (0:24)
- Using Paragraph Styles (0:40)
- Applying Styles with Keyboard Shortcuts (0:22)
- Formatting Characters and Punctuation (1:05)
- Aligning, Spacing, and Formatting Lists (0:35)
- Adding and Editing Equations (0:49)
- Adding Links (0:43)
- Adding Highlight Effect (0:36)
- Adding Lines to Separate Text (0:45)
- Introduction to Images and Objects (0:57)
- Images (0:22)
- Shapes (0:27)
- Lines and Arrows (1:05)
- Audio and Video (0:36)
- Image and Video Formats (0:46)
- Animating Drawings (1:21)
- Positioning Objects on Sheets (0:30)
- Resizing, Rotating, and Flipping (0:29)
- Filling Objects with Color or Images (0:31)
- Changing Transparency (0:19)
- Adding Borders (0:21)
- Adding Reflections and Drop Shadows (0:33)
- Adding Titles or Captions (0:27)
- Using Object Styles (0:38)
- Undo and Redo (0:39)
- Looking Up Words (0:35)
- Find and Replace (0:49)
- Check Spelling (0:38)
- Comments (0:44)
- Introduction to Collaboration (1:28)
- Sending Spreadsheets (1:16)
- Inviting Others to Collaborate (0:35)
- Collaborating on Shared Spreadsheets (0:29)
- Sharing Settings (0:29)
- Shared Folders (0:53)
- iCloud and Transferring Between Devices (0:48)
- Importing Excel or Text Files (0:27)
- Reducing File Size (0:27)
- Packing Files (0:24)
- Restoring Previous File Versions (0:44)
- Password Protection (1:00)
- Keyboard Shortcuts (2:02)
- Conclusion (0:36)