Current location - Education and Training Encyclopedia - Graduation thesis - Catalogue of advanced application works of office software
Catalogue of advanced application works of office software
1 article advanced word application

Chapter 65438 +0 Layout Design

Application example of 1. 1

1.2 Page Setup

1.2. 1 paper selection

1.2.2 Version Center Settings

1.2.3 Layout Settings

1.2.4 document grid

1.3 view mode

1.3. 1 normal view

1.3.2 Document Structure Diagram and Page View

1.3.3 Outline view and master document view

1.3.4 Page layout view and reading layout view

1.4 separation setting

1.4. 1 line breaks and page breaks

Section 1.4.2

1.4.3 column

1.5 Header and footer

1.5. 1 Create headers and footers

1.5.2 field in header and footer

Page number 1.6

1.6. 1 Create page number

1.6.2 Page number format

1.7 exercise

Chapter 2 Style Settings

2. 1 Application example

2.2 style

2.2. 1 style type

Style and format

Custom style

Use of style

2.3 Document Notes and Cross-references

Footnotes and endnotes

title

cross-reference

2.3.4 Update the note number and cross reference.

2.4 Contents and indexes

2.4. 1 directory

2.4.2 Index

bookmark

2.5 template

2.5. 1 documents and templates

Template type

Templates and plug-ins

Management template

2.6 practice

Chapter 3 Areas and Revision

3. 1 Application example

3. 1. 1 activity notice

3. 1.2 paper revision

3.2 Concept of domain

3.2. 1 What is a domain?

3.2.2 the composition of the field

3.2.3 Domain classification

3.3 Operation of Domain

3.3. 1 Insert field

Edit domain

Update domain

3.3.4 Introduction to the public domain

3.3.5 Shortcut operation of domain

3.4 document revision

3.4. 1 comment operation

Mark revision

View revisions and comments

3.4.4 Review, revision and comments

3.4.5 Print the revision table of the document.

3.4.6 Protect documents for review.

3.4.7 Comparing and merging documents

3.5 practice

The second advanced application of Excel

Chapter 4 Functions and Formulas

4. 1 Excel Example Introduction

4. Establishment of1.1Excel table

4. Data management and analysis in1.2 Excel

4.2 Data input in Excel

4.2. 1 User-defined drop-down list input

4.2.2 Custom Sequences and fill handle

Conditional Formatting

Data input skills

Data rounding method

4.3 Functions and formulas in Excel

4.3. 1 Formula Overview

Battery reference

4.3.3 Creation name and its use

4.3.4 Application of Sum Function

4.3.5 Application of average function

4.3.6 Application of IF function

4.4 the use of arrays in Excel

4.4. 1 array overview

Use array constants

Edit array

4.4.4 Application of array formula

4.5 Introduction to Excel Functions

4.5. 1 financial function

Text function.

Date and time function

4.5.4 Search and reference function

Database function

Other types of functions

4.6 practice

Chapter 5 Data Management and Analysis

5. 1 data list

Create a data list

5. 1.2 Usage Record Table

5.2 Data classification

5.2. 1 general sorting

Custom sorting

Classification rule

5.3 data screening

5.3. 1 automatic screening

advanced filter

5.4 classified summary

5.4. 1 classified summary

Create a subtotal

Delete classification summary

5.5 Using PivotTables

5.5. 1 Overview of Pivot Table

5.5.2 Create a PivotTable report

5.5.3 Modify the PivotTable report

5.5.4 Making data perspective view

5.6 Data Guidance and Export

5.6. 1 Import Web data

Import and export of text files

Import of external database

5.7 practice

The third article PowerPoint advanced application

Chapter 6 demonstrates advanced applications.

6. 1 demo production

6. 1. 1 exhibition design principles

6. 1.2 Demonstration of production steps

6. 1.3 Start the presentation

6.2 materials 1- pictures

6.2. 1 Insert picture

Edit pictures

The use of formulas

Three-dimensional graphics production

The use of graphic symbols

6.3 Material 2- Charts and Tables

6.3. 1 Insert chart

Edit chart

Use of tables

6.4 Material 3- Multimedia

The use of sound

The use of movies

Insert Flash animation

Use of triggers

6.5 Layout and beautification

6.5. 1 layout design

Color selection

6.5.3 Design of Main Formwork

Color scheme

Background setting

6.6 Animation Settings

6.6. 1 animation scheme selection

Custom animation

Action route

6.6.4 Action buttons and hyperlinks

6.7 Demonstration of Projection and Output

6.7. 1 projection settings

slide switch

Custom projection

Rehearsal time

Record the narration.

Use of drawing pen

6.7.7 Packaging and unpacking of presentations

6.8 Case: Design of graduation design defense statement

6.9 practice

Article 4 Advanced Application of Access

Chapter VII Database Application

7. 1 database application example

7. 1. 1 sample functions and interfaces

7. 1.2 sample data source

7. 1.3 data access mode

7.2 Database Overview

7.2. 1 data management technology

database system

data model

Database related terms

7.3 Create a database

7.3. 1 Design databases and tables

7.3.2 Creating databases and tables

7.3.3 Editing databases and tables

7.3.4 Establish the association between tables.

7.4 Establish a query

Create a simple query with a wizard

7.4.2 Creating a Query in Design View

7.4.3 Creating Parameter Matching Information Query

7.5 structured query language SQL

7.5. Overview of1SQL

7.5.2 Select data query statement

7.5.3 Other commonly used statements in SQL language

7.6 Form design

7.6. 1 Form design for displaying form information

7.6.2 Form design of object-driven operation

7.7 Report Design

7.8 example of integrated application

7.9 practice

Article 5 Visio applications

Chapter 8 visio applications

8. Introduction to1Visio

8. 1. 1 Visio History

8.1.2 What's New in Visio 2003

8.2 basic operation of visio graphics

8.2. 1 Basic drawing function

Basic operation of graphics

8.3 Flowchart

8.4 Organization chart

8.4. 1 Overall organization chart

8.4.2 Use the wizard to create an organization chart.

8.5 practice

Article 6 Office Document Security and VBA Application

Chapter 9 Security Settings and VBA Application

9. 1 document security settings

9. 1. 1 security permission setting

9. 1.2 document protection

9. 1.3 Word document form protection

9. 1.4 file security settings

9.2 VBA Macro and Its Application

9.2. 1 Macro concept

9.2.2 VBA Foundation

9.2.3 Simple Application of Macros

9.2.4 Macro Security and Macro Virus

9.3 practice

refer to