Join David Rivers for an in-depth discussion in this video Importing spreadsheet data, part of Numbers 3 Essential Training.
In the previous movie we started a brand new…spreadsheet from scratch,…and input some basic data.…But here's a common scenario,…maybe you already have the data somewhere else.…Maybe it's in a table in a Pages document,…or maybe it's an Excel spreadsheet…that someone's handed to you.…You want to bring it into Numbers.…No problem.…Let's look at both of those scenarios.…Now we'll start though with a fresh spreadsheet.…Let's go to the file menu,…and select new or use command N on the keyboard.…And from the template chooser,…we'll double click blank.…
That launches a brand new file with the default table…and the default formatting.…Notice the cell that's selected is cell B2.…It's the first empty cell under the header row…and to the right of the header column.…That's important if we're going to bring data…into the existing table.…That's one option.…Let's see how it works out for us.…First though, we'll need to switch to Pages.…So you can launch Pages and open up this file,…KEcoBudget0202.…If you don't have pages,…you'll just have to watch and see what's happening.…
Author
Released
6/25/2014- 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
Duration
Views
Related Courses
-
Mac OS X Mavericks Essential Training
with Nick Brazzi7h 59m Appropriate for all -
Wayne Winston on Analytics
with Wayne Winston50m 38s Appropriate for all -
Keynote 6 Essential Training
with David Rivers4h 10m Beginner -
Pages 5 Essential Training
with David Rivers4h 23m Beginner
-
Introduction
-
Welcome57s
-
-
1. Getting Started with Numbers
-
Numbers templates3m 3s
-
Exploring the user interface6m 53s
-
-
2. Working with Spreadsheets
-
Creating a basic spreadsheet5m 18s
-
Importing spreadsheet data6m 26s
-
Saving spreadsheets3m 24s
-
Working with sheets4m 7s
-
-
3. Working with Tables
-
Adding a table5m 12s
-
Modifying tables5m 15s
-
Using controls5m 31s
-
Adding images to cells3m 46s
-
Working with table cells4m 48s
-
Reorganizing table data6m 26s
-
-
4. Working with Table Styles
-
Using table styles4m 25s
-
Modifying a table's style4m 14s
-
Using text styles in a table3m 22s
-
-
5. Using Formulas and Functions
-
Using formulas6m 39s
-
Using functions6m 20s
-
Using cell references3m 34s
-
Using operators5m 6s
-
-
6. Working with Charts
-
Adding a chart5m 57s
-
Modifying chart data2m 6s
-
Formatting 3D charts4m 50s
-
Using interactive charts3m 42s
-
-
7. Working with Text and Numbers
-
Conditional highlighting2m 47s
-
Using special characters4m 45s
-
Using hyperlinks3m 42s
-
Autocorrect options4m 8s
-
Checking spelling6m 31s
-
Using Find & Replace3m 58s
-
8. Working with Objects
-
Using text boxes6m 32s
-
Copying text to a text box2m 27s
-
Working with shapes5m 14s
-
Adding and arranging images4m 19s
-
Masking and adjusting images3m 50s
-
Using Instant Alpha1m 46s
-
Adding audio and video9m 50s
-
-
9. Creating Your Own Templates
-
Designing a template3m 41s
-
Providing input options5m 11s
-
Creating media placeholders2m 50s
-
Saving a custom template2m 50s
-
-
10. Sharing Your Spreadsheets
-
Printing and page setup5m 38s
-
Exporting to an Excel file5m 32s
-
-
Conclusion
-
Next steps38s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Importing spreadsheet data