A01 Getting Started with Numbers ’09 3:13

Numbers ’09 > next

1
00:00:00,600 --> 00:00:03,770
Getting started with Numbers ’09

2
00:00:03,770 --> 00:00:06,139
Welcome to Numbers ’09

3
00:00:06,172 --> 00:00:09,976
Numbers Spreadsheets contain tables, charts,

4
00:00:09,976 --> 00:00:14,114
graphic and even photos on a freeform canvas.

5
00:00:14,114 --> 00:00:17,117
This short video will show you the
basic behind Numbers.

6
00:00:17,117 --> 00:00:19,619
So let's get started.

7
00:00:19,619 --> 00:00:22,622
When you launch Numbers,
you'll see a template chooser,

8
00:00:22,622 --> 00:00:25,458
where you can browse
categories of templates,

9
00:00:25,458 --> 00:00:29,129
for personal needs,
or business needs.

10
00:00:29,129 --> 00:00:32,132
There are even templates for education.

11
00:00:32,132 --> 00:00:35,535
You can start with a template
or a blank document

12
00:00:35,535 --> 00:00:38,705
to create your own custom spreadsheet.

13
00:00:38,705 --> 00:00:41,975
Customizing your Numbers spreadsheet is easy.

14
00:00:41,975 --> 00:00:45,979
You can resize tables by dragging
on the lower right corners.

15
00:00:45,979 --> 00:00:50,784
And move them around by clicking
and dragging at the upper left.

16
00:00:50,784 --> 00:00:52,952
You can add as many tables as you like

17
00:00:52,952 --> 00:00:55,355
by clicking the table button in the toolbar,

18
00:00:55,388 --> 00:00:58,258
and then choosing a table type.

19
00:00:58,258 --> 00:01:00,860
Once added, you can re-size it and

20
00:01:00,860 --> 00:01:03,963
place it in a different spot on your canvas.

21
00:01:03,963 --> 00:01:07,934
You can also apply styles to
your tables so they look great.

22
00:01:07,934 --> 00:01:10,203
To do that, just select your table,

23
00:01:10,236 --> 00:01:14,641
and then click a style in the styles pane.

24
00:01:14,641 --> 00:01:18,678
To enter data, just click on a cell,
and start typing.

25
00:01:19,679 --> 00:01:21,448
Once your data is in,

26
00:01:21,448 --> 00:01:24,350
you can make changes
to the layout of your table.

27
00:01:24,350 --> 00:01:27,620
And because tables and
numbers are truly independent,

28
00:01:27,620 --> 00:01:29,389
when you make changes to one,

29
00:01:29,422 --> 00:01:31,958
it won't affect the others.

30
00:01:31,958 --> 00:01:36,529
Sorting a column is easy to,
it only takes a click.

31
00:01:36,529 --> 00:01:38,498
You can easily format your data,

32
00:01:38,498 --> 00:01:40,733
by selecting the cells that you want,

33
00:01:40,767 --> 00:01:44,370
and then simply clicking
buttons in the format bar.

34
00:01:46,573 --> 00:01:49,709
Numbers gives you over 250 functions.

35
00:01:49,709 --> 00:01:51,911
When you select a group of cells,

36
00:01:51,945 --> 00:01:53,880
you'll see the most common functions

37
00:01:53,880 --> 00:01:57,250
and the results in the bottom
left of the window.

38
00:01:57,283 --> 00:02:00,253
Putting the sum in the total row
couldn't be easier.

39
00:02:00,286 --> 00:02:05,425
Just drag and drop the sum calculation
onto the cell where you want to appear.

40
00:02:05,458 --> 00:02:08,595
Adding a chart to your spreadsheet is easy to.

41
00:02:08,628 --> 00:02:10,930
Just select the cells that you want to use,

42
00:02:12,298 --> 00:02:14,000
click "Chart" in the toolbar,

43
00:02:14,000 --> 00:02:16,202
and then choose a chart type.

44
00:02:17,871 --> 00:02:19,906
Just like any other object in Numbers,

45
00:02:19,906 --> 00:02:22,842
you can move your chart anywhere you like.

46
00:02:22,842 --> 00:02:25,778
And you can quickly re-size it or its legend,

47
00:02:25,812 --> 00:02:27,947
by simply dragging on the handles.

48
00:02:29,782 --> 00:02:33,019
To title the chart, just double
click the default title,

49
00:02:33,019 --> 00:02:36,055
and then type in your own.

50
00:02:36,055 --> 00:02:38,458
To add a simple title to your spreadsheet,

51
00:02:38,491 --> 00:02:42,028
just choose a shape from
the shape menu in the toolbar.

52
00:02:42,028 --> 00:02:43,897
Then drag it where you want it,

53
00:02:43,897 --> 00:02:48,468
and re-size it using the handles on the sides.

54
00:02:48,501 --> 00:02:51,638
Double-click inside the shape to add text.

55
00:02:54,340 --> 00:02:57,377
Then with the text selected,
you can adjust the font,

56
00:02:57,377 --> 00:03:01,614
font size, and alignment using
the tools in the format bar.

57
00:03:03,783 --> 00:03:06,286
After spending a little time with Numbers,

58
00:03:06,286 --> 00:03:09,489
you'll be building beautiful,
informative spreadsheets

59
00:03:09,522 --> 00:03:10,990
in no time.
All videos are copyright by Apple Inc.; transcriptions, subtitles and translations are volunteer efforts by members of this wiki.