Author: Tong Fengyi, etc.

Publisher: Tsinghua University.

Publication date: 2008

ISBN:9787302 168 157

Version: Version 1

Binding: paperback

Pricing: 39.00 yuan. Chapter 65438 +0. Understand Office 2007 1.

Introduction to Office 2007 2

1.2 Features and new functions of Office 2007 2

Create a professional document 2

1.2.2 security * * * Enjoy the document 4

1.2.3 Add digital signature or signature line 4

1.2.4 exceeds file 5.

1.2.5 Office 2007 Diagnosis and Recovery 6

1.3 Office 2007 application and its application

Function introduction 7

1.3. 1 guozi 2007 7

1.3.2

1.3.3

1.3.4 Outlook 2007 8

1.4 Language Function 8

1.4. 1 translated text 8

1.4.2 English Assistant 9

1.4.3 Simple and complex transformation 9

Chapter II Basic Operation of Word 1 1

2. 1 Understanding Word Window 12

2. 1. 1 Word window interface 12

2. 1.2 Word window consists of 12.

2.2 Basic operation of documents 16

2. 2. 1 Create a new document 16

2.2.2 Open the document 18

2.2.3 Save the document 19

2.2.4 Close the document21

2.2.5 Document word count 2 1

2.3 Text Operation 22

2. 3. 1 input text 22

2.3.2 Selection of text

2.3.3 Text Insertion and Rewriting 26

2.3.4 Copying and Moving Text 26

2.3.5 Undo and Restore Text Operation 28

2.4 Document viewing mode 29

2.4. 1 normal view 29

2.4.2 Website Layout View 30

2.4.3 Page Browsing31

2.4.4 Outline View 3 1

2.4.5 Reading Layout View 32

2.4.6 File Structure Diagram 33

2.5 Find and Replace 34

Find and Replace Text 34

2.5.2 Find and Replace Formats 36

Text positioning 38

2.6 Experimental Guidance: Making Copybook for calligraphy 39

2.7 experimental guidance: making red-headed documents 40

2.8 Experimental Guidance: Promotion Plan 43

2.9 Thinking and Practice 46

Chapter III Word Format 48

3. 1 Set font format 49

3. 1. 1 Set the character format 49

3. 1.2 Set the character spacing 52

3.2 Setting Paragraph Formatting 53

3.2. 1 Paragraph Alignment 53

3.2.2 Setting Paragraph Indentation 54

3.2.3 Setting segment spacing and line spacing 56

3.3 Numbers and bullets 57

3.3. 1 Use line number 57.

3.3.2 Application Points 59

3.3.3 Application of multilevel symbol 6 1

3.4 Add Borders and Shadows 63

3.4. 1 Add border 63

3.4.2 Add Shadow 65

3.5 Style 66

3.5. 1 Create Style 67

Application style 68

3.5.3 Changing and Deleting Styles 69

3.6 Special Characters and Chinese Layout 69

3.6. 1 special text 70

3.6.2 Chinese Layout 7 1

3.7 Contents and indexes 72

3.7. 1 Create Document Directory 72

3.7.2 Update the file directory

Mark index entry 74

3.7.4 Creating an index

3.8 Experimental Guidance: Making Music Score 77

3.9 Experimental Guidance: Making a Briefing 80

3. 10 experimental guidance: making children's literacy cards 83

3. 1 1 experimental instruction: extracting document directory 86

3. 12 thinking and practice 88

The fourth chapter Word typesetting technology 90 pages

4. 1 pagination and segmentation 9 1

4. 1. 1 paging function 9 1

4. 1.2 piecewise function 92

4.2 Setting Column 93

4.2. 1 Use the default column setting of 94.

4.2.2 Using the Column Dialog Box to Column 94

4.3 Document Form 95

4.3. 1 Create Form 95

4.3.2 Draw a diagonal title 97

4.3.3 Basic operation of forms 97

4.3.4 Set the alignment mode 10 1.

4.3.5 Applying table styles and

Add border 103

4.4 Graphic Operation 105

4.4. 1 insert picture 105

4.4.2 Set the picture format 105.

4.4.3 Insert Clip Art 109

4.4.4 Insert the text box 1 10.

4.4.5 Insert shape 1 10

4.4.6 Use the shape 1 1 1.

4.4.7 Insert WordArt 1 12.

4.4.8 Insert intelligent graphics 1 13.

4.5 Set the header and footer 1 13

Insert headers and footers

4.5.2 Edit header and footer 1 14

4.6 Set the document background 1 15

4.6. 1 Set solid color background 1 15.

4.6.2 Set the filling effect 1 16.

4.6.3 Set the watermark 1 18.

4.7 Page Setup 120

4.7. 1 Set the margin of 120.

4.7.2 Setting Page Layout 122

4.7.3 File Grid 123

4.8 Print file 123

4.8. 1 Set print preview 124

4.8.2 Printing mode setting 124

4.9 experimental guidance: making e-cards 125

4. 10 experimental guidance: kindergarten enrollment guidance 128

4. 1 1 experimental instruction: Mu An company in 2007.

Book sales statistics 132

4. 12 experimental guidance: book sales statistics 133

4. 13 thinking and practice

Chapter 5 Advanced Content of Word 137

5. 1 using templates 138

5. 1. 1 relationship between template and style 138

5. 1.2 Create template document 138

5. Use of1.3 template

5. 1.4 Replace the existing template 140

5.2 Calculation Table Data 142

5.2. 1 data sorting 142

5.2.2 Calculation data 144

5.2.3 Conversion between text and table 145

5.3 Notes and revisions 146

Note 147

Version 148

5.4 Advanced Application 152

5.4. 1 using content control 152

5.4.2 Insert the mathematical formula 154.

5.4.3 Combined mail 156

5.4.4 Protecting files 159

5.5 Create Macro 160

5.5. 1 macro overview 160

Use the macro 16 1

5.6 Experimental Guidance: Making Mail Merge 163

5.7 experimental guidance: market questionnaire 166

5.8 Thinking and Exercise 168

Chapter VI Basic Operation of Excel 170

6. 1 Understanding Excel 2007 17 1

6. 1. 1 Excel 2007 window interface 17 1

6. 1.2 Composition of workbooks 172

6.2 Basic operation of Excel 2007 172

6.2. 1 Create Workbook 173

6.2.2 Save the current file 173.

6.2.3 Opening and Closing Workbooks 175

6.3 Input cell contents 175

6.3. 1 text input mode 175

Digital input mode 176

6.3.3 Date and time input 176

6.3.4 Data Validity 177

6.4 Editing unit data 179

6.4. 1 Select cell range 179

6.4.2 Cleaning and summary of unit data

Restore 18 1

6.4.3 Moving and copying unit data 182

6.4.4 Modify unit data 184

6.5 Edit Worksheet 185

6.5. 1 automatically fill in data 185

6.5.2 Adjust row height and column width 188

6.5.3 Set the cell alignment mode 188

6.5.4 Display scale 190

6.5.5 Application Style 190

6.6 Management Worksheet 194

Insert or delete worksheet 194

6.6.2 Rename the worksheet 195

6.6.3 Hide and Unhide Worksheets 195

6.6.4 Switch worksheets 196

6.6.5 Move the worksheet 196

6.7 Format Worksheet 197

6.7. 1 Set the display format of data 197.

6.7.2 Set cell border 199

6.7.3 Setting the Fill Color and Pattern 200

6.8 Experimental Guidance: Staff Work Schedule 202

6.9 Experimental Guidance: Making Flowchart 206

6. 10 experimental instruction: making product invoices

Template 209

Thinking and practice 2 13

Chapter 7 Excel Advanced Operation 2 14

7. 1 input formula 2 15

7. 1. 1 Use the operator 2 15.

7. 1.2 Edit Formula 2 17

7. 1.3 battery reference 2 18

7.2 Use Function 2 19

7.2. 1 input function 2 19

7.2.2 Common functions 22 1

7.3 Audit Worksheet 222

7.3. 1 Display error message 222.

7.3.2 Using Audit Tools 223

7.3.3 The search on the worksheet is invalid.

Data 224

7.4 Making charts 225

7.4. 1 Create Chart 225

Chart basic operations 226

Set chart options 228

7.4.4 Change Chart Type 233

7.4.5 Add Trend Line and Error Line 233

7.5 Print Preview Worksheet 236

7.5. 1 Page Setup 236

Preview worksheet 237

Print worksheet 238

7.6 Experimental Guidance: Building the 2008 Olympic Games

Countdown card 239

7.7 experimental instruction: making interactive function image 24 1

7.8 experimental description: hurricane computer accessories

Sales statistics 244

7.9 Thinking and Practice 248

Chapter 8 Data Analysis and Security Settings 250

8. 1 data sorting 25 1

8. 1. 1 sorting tool button 25 1

8. 1.2 Simple Sorting 25 1

8. 1.3 Complex Sorting 25 1

8.2 Screening data 252

8.2. 1 automatic screening 252

8.2.2 Complex Screening 254

8.3 Classification and summary of data 255

8.3. 1 Create Category Summary 255

8.3.2 Nested Classification Summary 256

8.3.3 Show or hide the summary.

Detailed data 257

8.4 Pivot Table 258

8.4. 1 Create a PivotTable report 258

Edit PivotTable 259

8.5 Protecting Workbooks and Worksheets 260

8.5. 1 Protect Workbook 26 1

8.5.2 Protect Workbook Element 26 1

8.5.3 Protecting Worksheet Elements 262

8.6 Use of Macros 263

8.6. 1 Macro Security Settings 263

8.6.2 Creating Macros 264

Run macro 265

8.7 experimental guidance: students quickly divided into classes 265

8.8 Experimental Guidance: Data Analysis 268

8.9 Experimental Guidance: Employee Information Inquiry System 270

8. 10 Thinking and Practice 276

Chapter 9 PowerPoint foundation 278

9. 1 PowerPoint 2007 window interface 279

9. 1. 1 PowerPoint 2007

Introduction of window 279

9. 1.2 PowerPoint 2007

View switching 280

9.2 Making a Presentation 28 1

9.2. 1 Create Demo 28 1

9.2.2 Save the Demo 283

9.3 Adding and Setting Text 283

Add text 283

9.3.2 Changing the Text Format 284

9.4 Add slide content 286

Insert a chart or table 286

9.4.2 Insert Movies and Sound 289

9.4.3 Insert Hyperlink 292

9.5 Edit Slide 293

Insert and delete slides 293

9.5.2 Managing slides 294

9.6 Design Slide 295

Apply Slide Layout 295

9.6.2 Applying Slide Theme 295

9.7 Print Presentation 297

9.7. 1 Page Setup of Presentation 297

9.7.2 Print Settings 297

9.8 experimental guidance: making furniture advertisements

One of the propaganda 298

9.9 Experimental Guidance: One of the Key Points of Health Knowledge 302

9. 10 experimental instruction: making a Chinese courseware 305

Thinking and practicing 307

Chapter 10 Presentation and Release of Slides 309

Set the appearance of the presentation 3 10

10. 1. 1 Set slide master 3 10

10. 1.2 Set the handout master 3 12

10.10.3 Episode Notes Master 3 13

10.2 Handling of Prompts 3 13

Spell Checker 3 13

10.2.2 Making a black-and-white presentation

10.3 Design slide show effect 3 14

Create the animation effect of slides 3 15

Action setting 3 16

10.3.3 Add an action to the slide.

Button 3 18

10.3.4 Set the switching effect of slides 3 19

10.4 show demo 320

10.4. 1 Start displaying 320

10.4.2 Set the projection mode 32 1

10.4.3 rehearsal time and commentary entry 322

10.5 packaging display 323

Packaging presentation 323

10.5.2 Watch the packaging demonstration 324

10.6 experimental guidance: making the second part of Chinese courseware 324

10.7 experimental guidance: making the third part of Chinese courseware 327

10.8 experimental guidance: the second focus of health knowledge 330

10.9 thinking and practice 333

Chapter 1 1 Receiving and Managing E-mail 335

11.1outlook2007 overview 336

11.1.1What's New in Outlook 2007 336

11.1.2 Introduction to Outlook 2007 Window 337

1 1. 1.3 Outlook for 2007

Type 338

1 1. 1.4 Create a mail account 339

1 1.2 Basic operation of e-mail 340

1 1

1 1.2.2 Read and reply to the email 34 1

1 1.2.3 Forward or move e-mail 342

1 1.2.4 mail archiving 343

1 1.2.5 Import and export mail data 344

1 1.3 e-mail management 346

1 1.3. 1 mail rule 346

1 1.3.2 Add follow-up marker 347.

1 1.3.3 classification 348

1 1.4 using contact 349

1 1.4. 1 new contact information 349

Classify contacts as needed 35 1

1 1.4.3 Filter contact list 35 1

1 1.4.4 Create a distribution list 352

1 1.4.5 Print contact information 353

1 1.5 Use Calendar 354

1 1.5. 1 Arrange an appointment 354

1 1.5.2 Set Event 354

Arrange a meeting 356

1 1.6 experimental guidance: organize according to the prospect.

Democratic voting 358

1 1.7 experimental description: using Outlook to automatically

Reply to e-mail 359

1 1.8 Thinking and Practice 36 1

Thinking and practicing answers 363