Join David Rivers for an in-depth discussion in this video Working with sheets, part of Numbers 3 Essential Training.
Voiceover: One component we should explore…when talking about numbers spreadsheets…are the individual sheets that can be created…to keep you organized when working with data.…For example, in this spreadsheet…that we brought in from Microsoft Excel…you may have noticed the tabs across the top…representing the individual sheets…that existed in that file,…while they exist here on numbers now.…To keep out data organized and separate from one another…we can go to those sheets by clicking the tabs.…For example, when we click expense details,…that's exactly what we see…for the various months and quarters.…
When we go to income details…we see that data separate from the expense data.…Then we have a couple of other tabs here in expense report…that is delivering data based on the contents…and data found in those other sheets.…Even the profit loss summary tab when we click it,…there's a small table on this sheet.…Again, we see calculations based on data…found in the other sheets.…It's an easy way to stay organized…creating these separate sheets.…
- Creating and laying out spreadsheets
- Importing data
- Working with tables
- Adding images to cells
- Performing calculations with formulas and functions
- Creating charts
- Formatting text and numbers
- Including audio, video, and shapes
- Designing templates
- Printing and sharing spreadsheets
Skill Level Beginner
1. Getting Started with Numbers
2. Working with Spreadsheets
3. Working with Tables
4. Working with Table Styles
5. Using Formulas and Functions
6. Working with Charts
7. Working with Text and Numbers
8. Working with Objects
9. Creating Your Own Templates
10. Sharing Your Spreadsheets
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.