OpenOffice.org OpenOffice - 3.3 manuels

Manuels d'utilisation et guides de l'utilisateur pour Logiciel OpenOffice.org OpenOffice - 3.3.
Nous fournissons des manuels en pdf 2 OpenOffice.org OpenOffice - 3.3 à télécharger gratuitement par type de document : Guide de l'utilisateur, Guide de base

Openoffice org OpenOffice - 3.3 Guide de l'utilisateur (248 pages)

marque: Openoffice-org | Catégorie: Logiciel | Taille: 6.50 MB |

Anglais

Table des matières

Impress Guide

1

Copyright

2

Feedback

2

Contents

3

Chapter 1

6

Introducing Impress

6

What is Impress?

7

Starting Impress

7

The main Impress window

8

Tasks pane

9

Workspace

10

Toolbars

10

Status bar

10

Workspace views

11

Outline view

12

Notes view

12

Handout view

13

Slide Sorter view

13

Creating a new presentation

15

Formatting a presentation

19

Modifying the slide elements

21

Modifying the slide show

22

Running the slide show

23

Using Impress on a Mac

24

Chapter 2

25

Using Slide Masters

25

Styles, and Templates

25

Designing a presentation

26

What are slide masters?

26

Working with slide masters

27

Modifying a slide master

29

Adding background objects

32

Slide master styles

33

Modifying default text areas

35

Adding text to all slides

37

Working with templates

38

Creating your own templates

39

Setting a default template

40

Modifying a template

41

Organizing templates

42

Importing a template

43

Exporting a template

43

Chapter 3

44

Working with text boxes

45

Moving a text box

46

Resizing a text box

47

Deleting a text box

47

Inserting text

48

Inserting special characters

49

Using styles to format text

51

Applying a presentation style

52

Formatting characters

53

Font Effects page

54

Position page

54

Formatting paragraphs

55

Indents and Spacing page

56

Alignment page

57

Tabs page

58

Asian Typography page

58

Creating a new outline level

60

Customize page

62

Using tables

64

Creating a table

65

Modifying a table

66

Using fields

70

Using hyperlinks

71

Editing text hyperlinks

73

Chapter 4

74

Pictures

74

Inserting pictures

75

Managing the Gallery themes

78

Formatting pictures

80

Applying filters

82

Creating an image map

85

Chapter 5

87

Managing Graphic Objects

87

Creating lines and shapes

90

Grouping shapes together

91

Moving graphic objects

92

Resizing graphic objects

93

Applying special effects

93

Rotating graphic objects

94

Flip an object

96

Mirror copies

96

Distorting an image

97

Set in circle (perspective)

98

Set to circle (slant)

98

Aligning shapes

99

Arranging shapes

101

Working with connectors

101

Managing glue points

102

1 2 3 4 5 6 7 8 9 10 11 12

102

Working with 3D shapes

103

Animating images

106

Animated image in one step

107

Using Fontwork

108

Using the Fontwork toolbar

109

Line and Filling toolbar

110

Chapter 6

111

Formatting Graphic

111

Formatting objects

112

Formatting lines

112

Creating line styles

114

Creating arrow styles

116

Line shadow

116

Formatting the fill area

117

Uniform color

118

Fill with a gradient

118

Fill with an image

119

Using the Area dialog box

120

Creating new area fills

121

Creating gradients

123

Creating hatching patterns

125

Working with bitmap fills

126

Property Meaning

127

Formatting shadows

129

Transparency formatting

130

Advanced gradient controls

131

Formatting text

133

Text animation

134

Formatting connectors

135

Working with graphics styles

135

Linked graphics styles

136

Creating graphics styles

136

Modifying a graphics style

138

Applying graphics styles

139

Deleting graphics styles

139

Chapter 7

140

Including Spreadsheets

140

Charts, and Other Objects

140

Using spreadsheets in Impress

141

Editing a spreadsheet

142

Navigating the spreadsheet

143

Entering data

144

Formatting spreadsheet cells

145

Inserting a chart

146

Choosing a chart type

148

Entering chart data

150

Formatting the chart

151

Resizing and moving the chart

153

Moving chart elements

153

Inserting other objects

154

Movies and sound

155

OLE objects

156

Other OLE objects

157

Formulas

158

Chapter 8

159

Adding and Formatting

159

Slides, Notes, and

159

Handouts

159

Introduction

160

Adding a new slide

161

Duplicating a slide

162

Renaming a slide

163

Expanding a slide

163

Creating a summary slide

164

Deleting a slide

164

Modifying slides

167

Printing slides

168

Adding comments

170

Adding and formatting notes

172

Formatting notes

173

• Header area

174

• Date and Time area

174

• Footer area

174

• Slide number area

174

Printing notes

175

Creating handouts

176

Changing the layout

177

Formatting handouts

178

Printing handouts

179

Chapter 9

181

Slide Shows

181

Putting together a slide show

182

Chapter 9 Slide Shows 189

183

Hiding slides

184

Chapter 9 Slide Shows 191

185

Using slide transitions

186

Chapter 9 Slide Shows 193

187

Using slide animation effects

188

Applying an animation effect

189

Starting an animation effect

189

Chapter 9 Slide Shows 197

191

Chapter 9 Slide Shows 199

193

Chapter 9 Slide Shows 201

195

Advanced animation effects

196

Using interactions

197

Running a slide show

198

• Press the Spacebar

199

Chapter 10

200

Printing, e-mailing

200

Quick printing

201

Controlling printing

201

Selecting slides to print

203

• What size to print slides

204

Printing a brochure

205

Exporting to PDF

206

Figure 198: Initial View page

209

Exporting as a Flash file

212

E-mailing a presentation

216

Removing personal data

217

Chapter 11

220

Setting Up and

220

Customizing Impress

220

User Data options

221

Print options

221

Color options

222

Appearance options

222

Choosing options for Impress

223

Text objects section

224

New document section

224

Settings section

224

Start presentation section

224

Compatibility section

224

View options

225

Grid options

225

Snap section

226

Customizing the menu font

228

Customizing menu content

228

Creating a new menu

229

Modifying existing menus

229

Adding a command to a menu

230

Customizing toolbars

231

Creating a new toolbar

232

Adding a command to a toolbar

232

Saving changes to a file

235

Resetting the shortcut keys

235

Installing extensions

236

Using extensions

236

Appendix A

238

Keyboard Shortcuts

238

Function keys for Impress

240

Shortcut Keys Effect

241

Shortcut keys in slide shows

243

Index 251

244

Index 253

246

Index 255

248

Openoffice org OpenOffice - 3.3 Guide de base (434 pages)

marque: Openoffice-org | Catégorie: Logiciel | Taille: 8.62 MB |

Anglais

Table des matières

OpenOffice.org 3.3

1

Calc Guide

1

Copyright

2

Contents

3

Note for Mac users

8

Chapter 1

9

Introducing Calc

9

What is Calc?

10

Parts of the main Calc window

10

Title bar

11

Menu bar

11

Toolbars

12

Moving toolbars

13

Formatting toolbar

14

Formula Bar

15

Right-click (context) menus

16

Individual cells

16

Sheet tabs

16

Status bar

17

Starting new spreadsheets

18

• Press the Control+N keys

19

Opening existing spreadsheets

20

Opening CSV files

21

Saving spreadsheets

22

Password protection

24

Going to a particular cell

26

Moving from cell to cell

26

Moving from sheet to sheet

28

Selecting cells

29

Selecting columns and rows

30

Selecting sheets

31

Working with columns and rows

32

Working with sheets

33

Viewing Calc

34

Freezing rows and columns

35

Splitting the screen

36

Split screen bar

37

Using document properties

40

Chapter 2

43

Entering, Editing, and

43

Formatting Data

43

Entering dates and times

45

Entering special characters

45

Speeding up data entry

46

Using a fill series

47

Defining a fill series

48

Using selection lists

49

Validating cell contents

50

Editing data

52

Formatting data

53

Using manual line breaks

54

Formatting numbers

55

Formatting the font

56

Choosing font effects

56

Formatting the cell borders

58

In each

58

Defining a new AutoFormat

59

Using conditional formatting

60

Hiding and showing data

61

Outline group controls

62

Sorting records

63

Finding and replacing in Calc

65

Finding and replacing text

67

Chapter 3

69

Creating Charts and

69

Creating a chart

70

Choosing a chart type

72

Selecting data series

73

Editing charts

74

Data labels

76

Trend lines

77

Mean value lines

78

Y error bars

78

Formatting charts

79

Moving chart elements

80

Formatting 3D charts

82

Appearance

83

Illumination

84

Formatting the chart elements

85

Formating data labels

86

Hierarchical axis labels

86

Resizing and moving the chart

88

Gallery of chart types

89

Pie charts

90

Donut charts

91

Area charts

92

Line charts

93

Scatter or XY charts

93

Bubble charts

94

Net charts

95

Stock charts

96

Column and line charts

97

Chapter 4

98

Using Styles and

98

Templates in Calc

98

What is a template?

99

What are styles?

99

Types of styles in Calc

99

Accessing styles

100

Applying cell styles

101

Applying page styles

102

Modifying styles

103

Cell style options

104

Page style options

105

Creating new (custom) styles

106

Copying and moving styles

107

Deleting styles

109

Creating a template

110

Editing a template

111

Caution

112

Setting a default template

113

Organizing templates

115

Importing a template

116

Exporting a template

116

Chapter 5

117

Using Graphics in Calc

117

Graphics in Calc

118

Adding graphics (images)

118

Drag and drop

119

Linking an image file

120

Modifying images

123

Icon Name Behavior

124

Choosing a graphics mode

125

Using graphic filters

125

Adjusting colors

126

Setting transparency

126

Cropping pictures

126

Resizing an image

128

Rotating a picture

128

Position and Size

129

Original Size

129

Description

129

Using Calc’s drawing tools

130

Positioning graphics

133

Arranging graphics

134

Anchoring graphics

135

Creating an image map

136

Chapter 6

138

Printing, Exporting, and

138

E-mailing

138

Quick printing

139

Controlling printing

139

Selecting sheets to print

141

Using print ranges

142

Removing a print range

143

Editing a print range

143

Defining a custom print range

144

Page breaks

145

Inserting a page break

146

Deleting a page break

146

Headers and footers

148

Header or footer appearance

149

Exporting to PDF

151

Exporting to XHTML

157

Saving as Web pages (HTML)

157

E-mailing spreadsheets

157

Digital signing of documents

157

Removing personal data

158

Chapter 7

159

Using Formulas and

159

Functions

159

Introduction

160

Setting up a spreadsheet

160

Creating formulas

161

Operator types

163

Arithmetic operators

164

Comparative operators

164

Text operators

164

Reference operators

166

Range operator

167

Intersection operator

168

Relative referencing

169

Absolute referencing

170

Order of calculation

171

Calculations linking sheets

172

Understanding functions

175

Nested functions

177

Function Wizard

178

+ vt - ½at

180

Finding and fixing errors

182

Examples of common errors

183

Color coding for input

184

The Detective

184

Examples of functions

187

Simple statistics

188

Rounding off numbers

189

Advanced functions

192

Chapter 8

193

Using the DataPilot

193

Advantages

198

Example 2: Timekeeping

201

Solution

203

Differences and advantages

207

Figure 188: Import settings

209

Figure 189: Raw data in Calc

209

Solution with the DataPilot

210

DataPilot functions in detail

214

Data source

215

The DataPilot dialog

216

More options

217

Data fields

219

Row and column fields

221

Page fields

224

Start the dialog

224

Grouping rows or columns

224

(Number of Days) as 7

226

Sorting the result

228

Drilling (showing details)

230

Filtering

231

Multiple data fields

232

Function GETPIVOTDATA

236

First syntax variation

238

=GETPIVOTDATA("sales

238

Second syntax variation

238

Chapter 9

240

Data Analysis

240

Consolidating data

241

Creating subtotals

243

Using “what if” scenarios

245

Settings

246

Changing scenarios

246

Changing scenario properties

247

Changing scenario cell values

247

Tracking values in scenarios

248

Using other “what if” tools

249

Chapter 9 Data Analysis 251

251

Chapter 9 Data Analysis 253

253

Goal Seek example

254

Chapter 9 Data Analysis 255

255

Using the Solver

256

Chapter 9 Data Analysis 257

257

Chapter 10

259

Linking Calc Data

259

Why use multiple sheets?

260

Setting up multiple sheets

260

Inserting new sheets

261

Hyperlinks and URLs

267

Creating hyperlinks

268

Linking to external data

270

Using the Navigator

271

Viewing data sources

276

Editing data sources

276

. Once in

277

Embedding spreadsheets

278

Other OLE objects

279

Non-linked OLE object

280

Dynamic Data Exchange (DDE)

281

DDE link in Writer

282

Chapter 11

283

Sharing and Reviewing

283

Documents

283

Opening a shared spreadsheet

285

Saving a shared spreadsheet

285

Recording changes

286

Recording changes (tutorial)

287

Adding comments to changes

288

Editing change comments

289

Adding other comments

290

Reviewing changes

291

Viewing changes

292

Merging documents

294

Comparing documents

295

Saving versions

295

Chapter 12

298

Calc Macros

298

Using the macro recorder

299

Chapter 12 Calc Macros 301

301

Write your own functions

303

Using a macro as a function

305

Chapter 12 Calc Macros 307

307

Passing arguments to a macro

308

Chapter 12 Calc Macros 309

309

Accessing cells directly

310

Chapter 12 Calc Macros 311

311

Conclusion

312

Chapter 13

313

Calc as a Simple Database

313

A B C D E F G

314

Named range

315

0 TOP Select the top border

318

Database range

319

Auto filters

322

Standard filters

323

Advanced filters

326

Manipulating filtered data

329

Using formulas to find data

333

Examples

335

ADDRESS(row; column)

336

ADDRESS(row; column; abs)

336

Database-specific functions

339

Chapter 14

341

Setting up and

341

Customizing Calc

341

User Data options

343

Print options

343

Color options

343

Security options

344

Security options and warnings

345

Appearance options

346

General Load/Save options

347

Choosing options for Calc

350

General options for Calc

351

View options for Calc

352

Visual aids section

353

Display section

353

Calculate options

354

Iterative references section

355

Date section

355

Other options

355

Sort Lists options

356

Changes options

357

Grid options

357

Customizing the menu font

358

Customizing menu content

359

Creating a new menu

360

Modifying existing menus

360

Adding a command to a menu

361

Modifying menu entries

361

Customizing toolbars

362

Creating a new toolbar

363

Adding a command to a toolbar

363

Saving changes to a file

366

Resetting the shortcut keys

366

Installing extensions

367

Using extensions

368

Appendix A

369

Keyboard Shortcuts

369

Shortcut Keys Effect

372

In this mode, you

372

You can also

372

Table 31. Arrow key shortcuts

372

Cell formatting shortcuts

373

DataPilot shortcuts

374

Appendix B

375

Description of Functions

375

Functions available in Calc

376

Mathematical functions

376

Financial analysis functions

381

Date and time functions

401

Syntax Description

402

Number is a time value

402

Logical functions

404

Informational functions

405

Database functions

407

Array functions

408

Spreadsheet functions

410

Text functions

414

Radix is the base of the

415

is the text to

415

(optional) is the

415

Applying the

416

Add-in functions

417

Places is

418

The complex number is

419

The complex_number is

419

Appendix C

421

Calc Error Codes

421

General error codes

424

Index 427

427

Index 429

429

Index 431

431

Index 433

433

Plus de produits et de manuels pour Logiciel OpenOffice.org

Modèles	Type de document
OpenOffice - 1.1	Guide de démarrage rapide OpenOffice.org OpenOffice - 1.1 Quick Start Guide, 56 pages
OpenOffice - 1.0	Manuel d'utilisateur OpenOffice.org OpenOffice - 1.0 User's Manual, 33 pages
OpenOffice - 3.2	Guide de base OpenOffice.org OpenOffice - 3.2 Calc Guide, 497 pages
OpenOffice - 3.2	Manuel OpenOffice.org OpenOffice - 3.2 Administration Manual, 34 pages
OpenOffice - 3.3 for Students	Manuel d'utilisateur OpenOffice.org OpenOffice - 3.3 for Students Writer Guide, 44 pages
OpenOffice - 1.0	Manuel d'utilisateur OpenOffice.org OpenOffice - 1.0 User's Manual, 29 pages
OpenOffice - 2014	Manuel d'utilisateur OpenOffice.org OpenOffice - 2014 Writer Guide, 49 pages

OpenOffice.org appareils