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