Join David Rivers for an in-depth discussion in this video Designing a template, part of Numbers 3 Essential Training.
When you put a lot of time and effort into…the design and creation of your spreadsheets…here in numbers, and realize, this is…something you want to use over and over again,…why not create a template out of it?…That's exactly what we're going to do.…Here's a good example, our [KinEd]…EcoBudget we've been building throughout this course,…this is something we'll want to use again…next year, for next years data…and the year after that.…We can create a template that will allow…users to not worry about the design of…the spreadsheet, just getting the data in there.…
We're going to take this file, KEcoBudget0901,…you can open it up from the chapter nine…folder of your exercise files.…We're going to think about what needs to…be included and what does not.…Starting on our profit loss summary page here,…you can see we have a table, our annual budget…overview, and all of this data comes from elsewhere.…There are formulas in here gathering data…from other sheets and giving us the results.…This is an example of a table we don't want…
- 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.