Join David Rivers for an in-depth discussion in this video Creating a basic spreadsheet, part of Numbers 3 Essential Training.
It's time now to create our first spreadsheet…and go over some of the basics.…If you're a seasoned veteran of spreadsheet applications,…like Excel of even Numbers here,…you could probably skip this movie.…But we're going to talk about the elements of a spreadsheet…by first closing up anything that we might have open…from previous movies, no need to save.…And then we'll go up to the File menu, select New…or use the keyboard shortcut, Command + N…and we'll just go with a blank spreadsheet.…The very first one here in the basic category,…with that selected click Choose.…
And as you can see, it is very basic.…We have a single table here, with a set number…of rows and columns, and we're ready to start entering data.…There's three different types of data to be entered.…We could add text or labels if you will.…We can also add numbers and then the third element…would be calculations, so formulas and functions,…that would use the numbers we've added.…So let's start with the labels.…Let's say we're creating a budget for our company here.…
- 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.