OpenOffice.org OpenOffice - 3.2 Handbücher

Bedienungsanleitungen und Benutzerhandbücher für Software OpenOffice.org OpenOffice - 3.2.
Wir stellen 2 PDF-Handbücher OpenOffice.org OpenOffice - 3.2 zum kostenlosen herunterladen nach Dokumenttypen zur Verfügung Grundlegende Anleitung, Handbuch

Openoffice org OpenOffice - 3.2 Grundlegende Anleitung (497 Seiten)

Marke: Openoffice-org | Kategorie: Software | Größe: 8.60 MB |

Inhaltsverzeichnis

Calc Guide

Feedback

Contents

Chapter 1

Introducing Calc

What is Calc?

Parts of the main Calc window

Toolbars

Formula Bar

Individual cells

Sheet tabs

Status bar

Starting new spreadsheets

Opening existing spreadsheets

Opening CSV files

Saving spreadsheets

Password protection

Saving as a CSV file

Saving in other formats

Going to a particular cell

Moving from cell to cell

Moving from sheet to sheet

Selecting cells

Selecting columns and rows

Selecting sheets

Working with columns and rows

Deleting columns and rows

Working with sheets

Viewing Calc

Freezing rows and columns

The heavier horizontal

Rows 4 through 13 and

The first three

Splitting the screen

Thus, you

Choosing a drag mode

Chapter 2

Entering, Editing, and

Formatting Data

Entering dates and times

Entering special characters

Inserting dashes

Speeding up data entry

Using a fill series

Defining a fill series

Using selection lists

Validating cell contents

Editing data

Formatting data

Using manual line breaks

Formatting numbers

Formatting the font

Choosing font effects

Formatting the cell borders

Defining a new AutoFormat

Using conditional formatting

Hiding and showing data

Sorting records

Finding and replacing in Calc

Finding and replacing text

Chapter 3

Creating Charts and

Creating a chart

Choosing a chart type

Selecting data series

Editing charts

Changing the chart type

Data labels

Trend lines

Mean value lines

Y error bars

Formatting charts

Moving chart elements

Formatting 3D charts

Rotation and perspective

Appearance

Illumination

Formatting the chart elements

Formating data labels

Resizing and moving the chart

Gallery of chart types

Pie charts

Area charts

Line charts

Scatter or XY charts

Bubble charts

100

Net charts

101

Stock charts

102

Column and line charts

103

Chapter 4

105

Using Styles and

105

Templates in Calc

105

What is a template?

106

What are styles?

106

Types of styles in Calc

107

Accessing styles

108

Applying cell styles

109

Using Fill Format mode

110

Using the Apply Style list

110

Applying page styles

111

Modifying styles

111

Cell style options

113

Page style options

113

Background

115

Creating new (custom) styles

116

Copying and moving styles

117

Deleting styles

119

Creating a template

120

Editing a template

121

Setting a default template

124

Organizing templates

126

Moving a template

127

Deleting a template

127

Importing a template

127

Exporting a template

128

Chapter 5

129

Using Graphics in Calc

129

Graphics in Calc

130

Adding graphics (images)

130

Insert Picture dialog

131

Linking an image file

132

Embedding linked images

133

Modifying images

136

Choosing a graphics mode

138

Using graphic filters

138

Adjusting colors

139

Setting transparency

139

Cropping pictures

140

Resizing an image

141

Rotating a picture

142

Position and Size

143

Original Size

143

Description

143

Assign Macro

144

Using Calc’s drawing tools

145

Positioning graphics

148

Arranging graphics

149

Anchoring graphics

150

Creating an image map

151

Chapter 6

154

Printing, Exporting, and

154

E-mailing

154

Quick printing

155

Controlling printing

155

Printer options

156

Selecting sheets to print

156

Using print ranges

159

Defining a custom print range

161

Page breaks

163

Headers and footers

164

Header or footer appearance

165

Exporting to PDF

167

Window options section

170

Exporting to XHTML

173

Saving as Web pages (HTML)

174

E-mailing spreadsheets

174

Digital signing of documents

175

Removing personal data

176

Chapter 7

177

Using Formulas and

177

Functions

177

Introduction

178

Setting up a spreadsheet

178

Lack of documentation

179

Error-checking formulas

179

Creating formulas

180

Operator types

182

Comparative operators

183

Text operators

184

Reference operators

186

Relative referencing

189

Absolute referencing

190

Order of calculation

192

Calculations linking sheets

192

Sheet containing data

193

Understanding functions

197

Nested functions

198

Function Wizard

200

Finding and fixing errors

205

Examples of common errors

206

Color coding for input

207

The Detective

208

Examples of functions

210

Simple statistics

211

Rounding off numbers

213

Advanced functions

217

Chapter 8

218

Using the DataPilot

218

Solution

220

Advantages

223

Example 2: Timekeeping

227

Differences and advantages

233

Solution with the DataPilot

237

Figure 179: Frequency

240

Figure 180: Relative

240

DataPilot functions in detail

241

Data source

243

The DataPilot dialog

244

More options

245

More settings for the fields

248

Data fields

248

Row and column fields

250

Page fields

253

Start the dialog

253

Grouping rows or columns

253

Sorting the result

257

Drilling (showing details)

259

Filtering

260

Multiple data fields

262

Shortcuts

266

Function GETPIVOTDATA

267

First syntax variation

268

Second syntax variation

269

Chapter 9

271

Data Analysis

271

Consolidating data

272

Chapter 9 Data Analysis 273

273

Creating subtotals

275

Using “what if” scenarios

277

Settings

278

Changing scenarios

279

Changing scenario cell values

280

Using other “what if” tools

281

Chapter 9 Data Analysis 283

283

Chapter 9 Data Analysis 285

285

Chapter 9 Data Analysis 287

287

Goal Seek example

289

Using the Solver

290

Solver example

291

Chapter 9 Data Analysis 293

293

Chapter 10

294

Linking Calc Data

294

Why use multiple sheets?

295

Setting up multiple sheets

295

Inserting new sheets

296

Renaming sheets

298

Referencing other sheets

299

Referencing other documents

301

• Path and file name

302

• Sheet name

302

Hyperlinks and URLs

303

Creating hyperlinks

304

Editing hyperlinks

306

Removing hyperlinks

306

Linking to external data

307

Using the Navigator

308

Viewing data sources

314

Editing data sources

314

Embedding spreadsheets

316

Other OLE objects

318

Non-linked OLE object

319

Linked OLE object

319

Dynamic Data Exchange (DDE)

320

DDE link in Writer

321

Chapter 11

322

Sharing and Reviewing

322

Documents

322

Opening a shared spreadsheet

324

Saving a shared spreadsheet

325

Recording changes

326

Recording changes (tutorial)

327

• Buy cheaper baseballs

328

• Only buy 2 spare gloves

328

Adding comments to changes

329

Adding other comments

330

Editing comments

331

Reviewing changes

332

Viewing changes

333

Merging documents

335

Comparing documents

337

Saving versions

337

Chapter 12

340

Calc Macros

340

Using the macro recorder

341

Chapter 12 Calc Macros 343

343

Write your own functions

345

Using a macro as a function

348

Chapter 12 Calc Macros 349

349

End Function

350

Passing arguments to a macro

351

Accessing cells directly

353

Conclusion

356

Chapter 13

357

Calc as a Simple Database

357

Named range

359

Database range

364

Auto filters

367

Standard filters

368

Advanced filters

372

Manipulating filtered data

375

Using formulas to find data

379

Examples

382

ADDRESS(row; column)

383

ADDRESS(row; column; abs)

383

Database-specific functions

387

Chapter 14

389

Setting up and

389

Customizing Calc

389

User Data options

391

Print options

391

Color options

391

Security options

393

Appearance options

395

General Load/Save options

396

Choosing options for Calc

400

Updating section

401

Input settings section

401

View options for Calc

402

Display section

403

Calculate options

404

Iterative references section

405

Date section

405

Other options

406

Sort Lists options

407

Changes options

408

Grid options

408

Customizing the menu font

410

Customizing menu content

410

Creating a new menu

412

Modifying existing menus

412

Adding a command to a menu

413

Customizing toolbars

414

Creating a new toolbar

415

Adding a command to a toolbar

416

Saving changes to a file

419

Resetting the shortcut keys

419

Installing extensions

420

Using extensions

421

Appendix A

422

Keyboard Shortcuts

422

Cell formatting shortcuts

426

DataPilot shortcuts

427

Appendix B

428

Description of Functions

428

Functions available in Calc

429

Mathematical functions

430

Integer_1; integer_2;

432

Base is the base for the

432

Financial analysis functions

435

Several other

449

Date and time functions

458

Month is an

459

Day is an integer

459

Number is a time value

460

Type is

461

Logical functions

462

Informational functions

463

Database functions

466

Array functions

468

Spreadsheet functions

470

Text functions

475

is the number to

476

Find_text is the

478

Add-in functions

479

Places is the

481

The complex number

481

Number is the octal

483

Appendix C

484

Calc Error Codes

484

General error codes

487

Openoffice org OpenOffice - 3.2 Handbuch (34 Seiten)

Marke: Openoffice-org | Kategorie: Software | Größe: 0.41 MB |

Inhaltsverzeichnis

OpenOffice.org 3.2

Administration Guide

Contents

Solaris Sparc/x86

Install

Microsoft Windows

Uninstall

Mac OS X

   C H A P T E R 2

Single user install

Shared user install

Extensions

OpenOffice.org Installation

   C H A P T E R 5

Registration Wizard

7 Accessing Email Clients

 Menus

 Shortcut keys

 Toolbars

 Events

Mapping LDAP User Profiles

Weitere Produkte und Handbücher für Software OpenOffice.org

Modelle	Dokumententyp
OpenOffice - 3.3 for Students	Bedienungsanleitung OpenOffice.org OpenOffice - 3.3 for Students Writer Guide, 44 Seiten
OpenOffice - 1.0	Bedienungsanleitung OpenOffice.org OpenOffice - 1.0 User's Manual, 29 Seiten
OpenOffice - 3.3	Betriebsanweisung OpenOffice.org OpenOffice - 3.3 Impress Guide, 248 Seiten
OpenOffice - 2014	Bedienungsanleitung OpenOffice.org OpenOffice - 2014 Writer Guide, 49 Seiten
OpenOffice - 3.3	Grundlegende Anleitung OpenOffice.org OpenOffice - 3.3 Calc Guide, 434 Seiten
OpenOffice - 1.1	Schnellstart Anleitung OpenOffice.org OpenOffice - 1.1 Quick Start Guide, 56 Seiten
OpenOffice - 1.0	Bedienungsanleitung OpenOffice.org OpenOffice - 1.0 User's Manual, 33 Seiten

OpenOffice.org OpenOffice - 3.2 Handbücher

Openoffice org OpenOffice - 3.2 Grundlegende Anleitung (497 Seiten)

Inhaltsverzeichnis

Openoffice org OpenOffice - 3.2 Handbuch (34 Seiten)

Inhaltsverzeichnis

Weitere Produkte und Handbücher für Software OpenOffice.org

OpenOffice.org Geräte