How Do I Choose the Best Computer Training Software?

This book focuses on the actual needs of computer office software application skills. Through a series of highly instructive practical links, it guides readers to quickly master the basic knowledge of office software, office software application skills and related work experience and skills.

Computer office software application practice tutorial

Author: Series Editorial Board

This book focuses on the actual needs of computer office software application skills. Through a series of highly instructive practical links, it guides readers to quickly master the basic knowledge of office software, office software application skills and related work experience and skills.

The book first introduces the basic knowledge of computer operation and text input; then introduces the application of office software such as Word, Excel, PowerPoint, and realizes the training of office software skills through a large number of examples; Finally, it introduces networked office and common Knowledge and typical applications of office tool software.

The book is very suitable for students of all levels and schools who are about to move to work. It is not only an ideal teaching material for related computer office software application training, but also a rare practical teaching material for colleges and vocational schools. It is also the best self-study for computer enthusiasts. ^[1]

With the development of computer information technology, network communication and other technologies, the voice of intelligent office and paperless office is getting higher and higher in domestic government departments and enterprises. Especially with the development of computer and network technology, many Office application software, thereby freeing office staff of various government departments and enterprise organizations from the tedious and traditional labor, and providing a good intelligent office environment for the scientific and efficient processing of various office affairs and improving the overall efficiency of office work.

Among the many computer office software books, how do you choose the textbook that suits you? The editor sincerely tells the reader friends, please choose this book. This is because many of today's computer books are lacking in practicality, pertinence, and intelligibility. In order to allow readers, especially students at all levels and schools who are about to go to work, to smoothly move from school to career, we have compiled this book based on years of teaching methods and training experience of outstanding teachers. Compared with traditional textbooks, this book highlights the following features:

1. Targeted

This book is mainly based on the characteristics of students at all levels and various schools, and the computer foundation. According to the work needs of computer office staff, taking into account the rapid development of computer software and hardware technology, carefully arranges and organizes practice-centered content. Make readers apply what they have learned, and learn from them.

2. Practical

This book does not use the old theory and teaching method, but completely integrates the actual work skills that computer office staff must master into a series of practical training links, comprehensive and concise. Starting from the "skill goals" and "work goals" that need to be mastered, general explanations and specific guidance are provided through practical sections such as "practical content", "practical guidance", "practical quiz", and "work guidance", and finally through " "Consolidation of practice" for deepening and strengthening training can enable learners to quickly master all knowledge and apply it to actual work and life.

3 Strong career guidance

Traditional office software application textbooks focus on the comprehensiveness and systematicity of knowledge, while ignoring the professional guidance of book content. For example, a lengthy introduction to software functions and some esoteric theories is generally difficult for most office workers to get involved with. The content of this book is centered on "practice" from the beginning to the end, simulating the actual work scene, and using practical projects to strengthen the training, so the career guidance is very prominent.

4 Readable

On the specific content of this book, pay attention to arranging a gradual and inherited knowledge and skills structure, and strive to reflect the modern education thought of the practice-oriented approach and the student-centered teaching model. The book consists of 10 chapters. Chapter 1 reinforces the basic computer operations and text input practice. Chapters 2 and 3 introduce the practical application methods and experience of Word in the office. Chapters 4 to 6 introduce The practical application of Excel in office transaction processing; Chapters 7 and 8 introduce the application of PowerPoint in the office; Chapter 9 introduces the basic knowledge and practical application of networked office; Chapter 10 introduces common office tool software Use method and experience.

About this book and this series are explained below.

Contents of the series: This series of teaching materials mainly includes the following contents.

"Computer Office Software Application Practice Tutorial"

"Computer Assembly and Maintenance Technology Practice Course"

"Web Design and Production Practice Tutorial"

"Network Construction and Management Practice Tutorial"

"Chinese version of AutoCAD graphic design practice tutorial"

"3DSMAX Decoration Design Practice Course"

"Multimedia Design Practice Tutorial"

"Television Animation Design Practice Tutorial"

"VB.NET programming practice tutorial"

"ASP.NET and Website Development Practice Tutorial"

"Pro / E Modeling and Application Practice Tutorial"

"Chinese version of Photoshop and CorelDRAW graphic creative design practice tutorial"

In addition, we will continue to launch other new books to meet the needs of our readers.

Who is it for? This series of textbooks introduces the latest, most practical, and most commonly used knowledge and skills in practical computer technology. It will clearly identify the readers at various institutions of higher learning, vocational schools and computer training schools, and computers that hope to find an ideal job through learning Lovers. ^[2]

Chapter 1 Basic Computer Operations and Text Input 1

1.1 Practice Objective 1

Skill Objective 1

Goal 1

1.2 Practice 1

1.2.1 Powering On and Off 2

1.2.2 Using the Mouse 3

1.2.3 WindowsXP basic operationThree

1.2.4 Management File 7

1.2.5 Annex 13

1.2.6 Text Input 15

1.3 Practical Guidance 16

1.3.1 Adding New Fonts 16

1.3.2 Adding a Printer 17

1.4 Practice Questions and Answers 20

1.5 Work Instruction 21

1.6 Practice consolidation 22

Self-Test Question 22

Practice Question 22

Chapter 2 Word Document Arrangement and Printout 24

2.1 Practice Objectives 24

Skills Goal 24

Goal 24

2.2 Practical Content 25

2.2.1 New and Saved Documents 25

2.2.2 Entering Documents 27

2.2.3 Editing Documents

2.2.4 Formatting Characters

2.2.5 Formatting Paragraphs

2.2.6 Setting Margins 41

2.2.7 Print Preview

2.2.8 Printing a Document

2.3 Practical Guidance-Entering and Arranging a Document 43

2.4 Practice Questions 46

2.5 Work Instruction 49

2.6 Practice consolidation

Self-Test Question 49

Computer problem 50

Chapter 3 Forms and Graphics in Word 51

3.1 Practical Objectives 51

Skill Goal 51

Goal 51

3.2 Practice Content 52

3.2.1 Creating a Table 52

3.2.2 Editing Cells

3.2.3 Editing Rows and Columns

3.2.4 Editing Forms

3.2.5 Formatting Tables

3.2.6 Drawing Graphics

3.2.7 Insert WordArt 68

3.2.8 Insert Picture 69

3.2.9 Editing Graphics and Pictures

3.3 Practical Guidance-Making an "Installation Configuration Sheet" 74

3.4 Practice Questions and Answers

3.5 Work Instructions 83

3.6 Practice Consolidation

Self-Test Question 84

Computer problem 85

Chapter 4 Excel Spreadsheet Creation and Organization 86

4.1 Practice Objectives

Skill Goal 86

Goal 86

4.2 Practical Content

4.2.1 Creating Workbooks

4.2.2 Opening and Closing Workbooks

4.2.3 Protecting and Saving Workbooks

4.2.4 Creating Worksheets

4.2.5 Selection and switching of worksheets

4.2.6 Renaming and Deleting Worksheets

4.2.7 Hiding and protecting worksheets

4.2.8 Worksheet Copying

4.2.9 Splitting and Freezing the Window

4.2.10 Selecting the operating area

4.2.11 Entering Data

4.2.12 Edit cell 100

4.2.13 Cell Settings

4.2.14 Page Settings

4.2.15 Print Preview and Print 105

4.3 Practical Guidance-Making a "Payroll" 105

4.4 Practice Questions and Answers 107

4.5 Work Instruction 109

4.6 Practice consolidation

Self-Test 110

Computer question 111

Chapter 5 Use of Formulas, Functions, and Charts

5.1 Practical Objectives

Skill Goal 112

Goal 112

5.2 Practical Content

5.2.1 Entering formulas

5.2.2 Editing Formulas

5.2.3 Functions

5.2.4 Creating Charts

5.2.5 Editing Charts

5.3 Practical Guidance-Calculating the "Salary Table" 123

5.4 Practice Questions and Answers

5.5 Work Instruction 125

5.6 Practice consolidation

Self-Test 126

Computer question 127

Chapter 6 Statistics and Management of Excel Data Tables 128

6.1 Practice Objectives 128

Skill Goal 128

Goal 128

6.2 Practice Content

6.2.1 Data Sorting

6.2.2 Data Screening

6.2.3 Classification Summary

6.2.4 Pivot Tables

6.2.5 Conditional Formats

6.3 Practical guidance-analysis and management of the "salary table"

6.4 Practice Questions and Answers

6.5 Work Instruction 143

6.6 Practice Consolidation

Self-Test 144

Computer question 144

Chapter 7 Creating PowerPoint Presentations 145

7.1 Practice Objectives

Skill Goal 145

Goal 145

7.2 Practical Content

7.2.1 Creating a Presentation

7.2.2 View Mode

7.2.3 Entering and Editing Text

7.2.4 Slide Master 153

7.2.5 Making Slides

7.2.6 Slide Reorganization

7.2.7 Organization Chart

7.2.8 Adding Animation Effects

7.2.9 Adding Sounds

7.3 Practical Guidance-Making a "Product Show" Presentation 164

7.4 Practice Questions and Answers 169

7.5 Work Instruction 171

7.6 Practice consolidation

Self-Test 171

Computer question 172

Chapter 8 Slideshow 174

8.1 Practical Objectives

Skill Goal 174

Goal 174

8.2 Practical Content

8.2.1 Simple Slide Show

8.2.2 The Editing Process

8.2.3 Making Animations

8.2.4 Creating Action Buttons

8.2.5 Recording Narration 180

8.2.6 Packaging presentations

8.2.7 Publishing a Presentation on the Internet 183

8.3 Practical Guidance-Screening a "Product Show" Presentation 185

8.4 Practical Questions and Answers

8.5 Work Instruction 189

8.6 Practice Consolidation

Self-Test 189

Computer problem 190

Chapter 9 Network Office Knowledge 191

9.1 Practice Objectives

Skill Goal 191

Goal 191

9.2 Practical Content

9.2.1 Understanding LAN

9.2.2 Office Network Application Basics

9.2.3 Accessing the Internet

9.2.4IE Browser Operation and Settings

9.2.5 Setting Internet Explorer 201

9.2.6 Applying for a Mailbox

9.2.7 Sending and Receiving Email

9.3 Practical Guidance-Sending Email 214

9.4 Practice Questions and Answers

9.5 Work Instruction 215

9.6 Practice Consolidation

Self-Test 215

Computer question 216

Chapter 10 Common Tools in Office 217

10.1 Practice Objectives

Skill Goal 217

Goal 217

10.2 Practical Content

10.2.1 Compression Software

10.2.2 Viewing Software

10.2.3 Multimedia Player Software

10.2.4 Antivirus Software

10.2.5 Network Security Software

10.3 Practical Guidance-Installing and Using Chinese Patch

10.4 Practice Questions and Answers 245

10.5 Work Instruction 246

10.6 Practice Consolidation

Self-Test 247

Questions on the machine 248

Self-assessment reference answer 249 ^[3]