Join David Rivers for an in-depth discussion in this video Using controls, part of Numbers 3 Essential Training.
To help with the input of data into your tables…here in Numbers, there are some data formats…that can help.…We're going to explore them now as we continue…with our KEcoBudget sheet here.…If you've skipped to this movie, open up…KEcoBudget0305 and let's go to the expense…details sheet.…Here you can see we have input for the…various months of the year, the quarters, there are…categories, line items you can see, are…repeated throughout and mixed up in this…column, column D.…
If we wanted to make it easier for people…to input, we could add these to a pop up…menu, let's say.…And maybe for numbers they could use…a slider or a stepper.…There are true/false options too with…check boxes, for example, and star ratings.…Let's start with column D, though.…We're going to select everything that's here.…Because we already have the data, it can…save us a little bit of work when creating…the data format.…We'll click from D2 which is the first…line item, office, and scroll all the way…down until we get to the last one here…in row 74, office supplies.…
- 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.