Derived knowledge points-catalogue
Chapter 1 Understanding Excel2007
The function of 1. 1Excel
1.2 Start and exit Excel2007
1.2. 1 Start Excel2007
1.2.2 Exit Excel2007
Introduction of 1.3Excel2007 Interface
1.3. 1 title bar
1.3.2 Function Tab and Group
1.3.3 button
1.3.4 Name box and edit bar
1.3.5 Worksheet area
1.3.6 status bar
Three Elements in 1.4Excel and Their Relationships
1.4. 1 workbook
1.4.2 worksheet
1.4.3 battery
1.4.4
View mode of 1.5Excel2007
1.5. 1 normal view
1.5.2 Page Layout View
1.5.3 Pagination preview view
1.5.4 full screen view
Common viewing methods of 1.6 Excel 2007
1.6. 1 Split window
1.6.2 comparison window
1.7 User Guide
1.8 for help
1.8. 1 Click on the required content to find it.
1.8.2 Enter keywords to search.
1.9 basic example-by helping the system understand new functions.
1. 10 Basic exercises
Start and exit Excel2007
1. 10.2 Switch views.
1. 1 1 summary of this chapter
Knowledge association
Chapter 2 Operating Workbooks and Worksheets
2. 1 new workbook
2. 1. 1 Create a new blank workbook.
2. 1.2 Create a new workbook from the template
2.2 save the workbook
2.2. 1 Save the new workbook.
Save as workbook
2.2.3 Automatically save settings.
2.3 Open the workbook
2.4 Close the workbook
Press the button to close the workbook.
2.4.2 Close the workbook through the taskbar.
2.5 Operation of Worksheet
2.5. 1 Select worksheet
insert worksheet
Rename worksheet
2.5.4 Move and copy worksheets
Hide and Show Worksheets
delete sheet
2.6 Basic Example-Working with the Report Workbook
2.7 Basic Exercise-Creating a New Sales Report Based on a Template
2.8 Overview of this chapter
Knowledge association
Chapter 3 Editing Worksheets
3. 1 Select a cell
3. 1. 1 Select a single cell.
3. 1.2 Select multiple cells
3.2 Input content
3.2. 1 input data
incoming symbol
3.3 Fill in the data quickly
3.3. 1 Fill in the data through the control handle
3.3.2 Use shortcut keys to fill in data.
3.3.3 Fill in data through the "Sequence" dialog box.
3.4 Modify cell data
3.4. 1 Modify all the data in the cell
3.4.2 Modify some data in the cell.
deleted data
3.5 copying and moving data
3.5. 1 copy data
3.5.2 Mobile data
3.6 Inserting and Deleting Cells
3.6. 1 Insert Cell
Delete cells.
3.7 Undo and Restore Operations
3.7. 1 Undo operation
Resume operation
3.8 Finding and Replacing Data
3.8. 1 Find data
Replacement data
3.9 Basic Example-Editing the Contents of a Cell
3. 10 basic exercises
3. 10. 1 Edit "Employee Sales Table 1"
3. 10.2 Edit "Employee Sales Table 2"
3. 1 1 Summary of this chapter
Knowledge association
Chapter 4 Beautify the Worksheet
4. 1 format cell
4. 1. 1 Set the number type
4. 1.2 Set the alignment mode
4. 1.3 Set the font
4. 1.4 Add border and shadow
4. 1.5 Fill cells
4.2 Merge and Cancel Cell Merge
4.2. 1 Merge Cells
4.2.2 Cancel cell merging
4.3 Change the row height and column width
4.3. 1 Change line height
4.3.2 Change the column width
4.4 Application of tabular format
4.4. 1 application format
4.4.2 Format of Undo Application
4.5 Set the background of the worksheet
4.6 Basic Example-Establishing Employee Information Table
4.7 Basic Exercise Report Form
4.8 Overview of this chapter
Knowledge association
Chapter 5 Enriching Tables with Objects
5. 1 Use of graphic objects
5. 1. 1 clip art
5. 1.2 AutoShape
5. 1.3 external picture
5. 1.4 Editing Graphic Objects
5.2 the use of smartart graphics
Insert SmartArt graphics
Design SmartArt graphics
Set SmartArt graphics
5.3 the use of artistic vocabulary
5.3. 1 Insert WordArt
5.3.2 Editing WordArt
5.4 Basic Example-Beautifying after-sales questionnaire
5.5 Basic exercises
5.6 Overview of this chapter
Knowledge association
Chapter VI Printing Forms
6. 1 Theme Settings
6. 1. 1 Set the print theme.
6. 1.2 Set theme color and font
6. 1.3 Set theme effect
6.2 page setup
6.2. 1 Set page layout mode
Set margins
6.2.3 Setting the Header and Footer
Insert separator
Options for worksheets
6.3 Print Workbook
6.3. 1 Print some contents in the worksheet.
6.3.2 Print the whole workbook.
Print worksheet
6.4 Basic Example-Print Employee Information Form
6.4. 1 Set the print theme
page setup
6.5 Basic exercises
6.6 Overview of this chapter
Knowledge association
Improve the article
Chapter 7 Calculating Data with Formulas
7. 1 cognitive formula
7. 1. 1 What is a formula?
7. Common Operators of1.2 Formula
7.2 Input formula
Enter formulas through cells
7.2.2 Input formulas through keyboard and mouse.
7.3 Edit formula
7.3. 1 Modified formula
Copy formula
Delete formula
7.4 Reference battery
7.4. 1 reference style
Relative references
7.4.3 Absolute quotation
7.4.4 Reference cells in other workbooks
7.5 Formula review
7.5. 1 Display formula
7.5.2 Tracking references and dependent cells
Error checking
7.6 Improved Example-Calculating Students' Grades with Formulas
7.7 Improve practice
7.8 Overview of this chapter
Improve knowledge question and answer
Chapter 8 Calculating Data with Functions
8. The function of1in data processing
8. Simplified formula of1.1
8. 1.2 Implementing special operations
8. 1.3 Realizing intelligent judgment
8. 1.4 Improve work efficiency
8.2 Cognitive function
8.2. 1 function definition and structure
8.2.2 Functional parameters
8.2.3 Functional classification
8.3 Input and modification functions
8.3. 1 Input function
Nested use of functions
Modify function
8.4 define cell names
8.4. 1 User-defined cell name
8.4.2 Use defined cells
8.5 Improved Example-Calculating Personal Income Tax by Function
8.6 Improve practice
8.7 Overview of this chapter
Improve knowledge question and answer
Chapter 9 Common Functions of Excel
9. 1 Common logic functions and text functions
9. 1. 1 logic function
9. 1.2 text function
9.2 Common date function and time function
9.2. 1 date function
Time function
9.3 Common mathematical functions and statistical functions
9.3. 1 mathematical function
Statistical function
9.4 Improved Example-Timed Parking Timer
9.5 Improve practice
9.6 Overview of this chapter
Improve knowledge question and answer
Chapter 10 Financial Function of Excel
10. 1 Calculate depreciation value
10. 1. 1 Calculate depreciation value with DB function.
10. 1.2 Calculate depreciation value with AMORDEGRC function.
10. 1.3 Calculate depreciation value with SYD function.
10. 1.4 Calculate depreciation value with SLN function.
10. 1.5 Calculate depreciation value with VDB function.
10.2 Calculate the payment amount
10.2. 1 Calculate the payment amount of each installment with PMT function.
10.2.2 Find the principal part of the repayment amount with PPMT function.
10.2.3 Use the IPMT function to find the interest paid by an investment in a given period.
10.2.4 use ISPMT function to find the interest to be paid in a specific investment period.
10.3 application of investment budget function
10.3. 1 Find the actual annual interest rate with the effect function.
10.3.2 use FV function to calculate the future value of fixed interest rate investment.
10.3.3 Calculate the nominal annual interest rate with a nominal function.
10.3.4 Calculate the number of investment cycles with NPER function.
10.3.5 Calculate the return on non-fixed investment with NPV function.
10.3.6 Calculation of fixed investment return by photovoltaic function
Application of 10.4 yield function
10.4. 1 Find the internal rate of return of continuous cash flow with IRR function.
10.4.2 modified internal rate of return of cash flow with MIRR function.
10.4.3 using XIRR function to find the internal rate of return of irregular cash flow.
10.5 calculation of securities
10.5. 1 Use the YIELDMAT function to find the annual income of bonds that pay interest at maturity.
10.5.2 Use the ACCRINT function to calculate the accrued interest of the securities that pay interest regularly.
10.5.3 Find the total investment type with the receiving function.
Bond amount
10.5.4 Find the discount rate of bonds with discount function.
10.5.5 Find the interest rate of full investment bonds with the INTRATE function.
10.5.6 Use COUPDAYS function to find the interest payment days including the transaction date.
10.6 improvement example-calculating depreciation value of office appliances
10.7 improvement exercise
10.8 Summary of this chapter
Improve knowledge question and answer
Chapter 1 1 uses charts to visualize data.
1 1. 1 What is a chart?
11.1.1chart structure
Classification and application of 1 1. 1.2 chart
1 1.2 Create a chart
1 1.3 Edit the chart
1 1.3. 1 Modify chart data
1 1.3.2 Change the chart type.
1 1.3.3 Change the position and size of the chart.
1 1.3.4 Adjust chart elements
1 1.4 beautify the chart
1 1.4. 1 layout
1 1.4.2 Select a style.
1 1.5 improvement example-edit sales table chart
1 1.6 improvement exercise
1 1.7 Summary of this chapter
Improve knowledge question and answer
Proficient in articles
Chapter 12 Better Operation of Excel2007
12. 1 User-defined interface
12. 1. 1 Add Quick Access Toolbar Button
12. 1.2 Delete the quick access toolbar button.
12. 1.3 Custom operation interface color
12. 1.4 number of custom worksheets.
12.2 input special data
12. 2. 1 Enter a number starting with "0"
12.2.2 Enter the ID number.
12.3 data validity
12.3. 1 Set the validity of the data.
12.3.2 Delete the validity setting of data.
12.4 quick beautification form
12.4. 1 Create a new style
12.4.2 Set the conditional format.
12.5 workbook operation skills
12.5. 1 Open the workbook.
12.5.2 Workbook security settings
12.6 proficient in sample making and protecting address book.
12.6. 1 Making "Address Book"
12.6.2 Protect Address Book
12.7 proficient in exercises
12.8 Summary of this chapter
Chapter 13 data management skills
13. 1 data sorting
13. 1. 1 single column content sorting
13. 1.2 Multi-column content combination sorting
13. 1.3 user-defined sorting
13.2 data screening
1 automatic filtering
13.2.2 custom filter
13.2.3 advanced screening
13.3 classification summary
13.3. 1 Create category summary
Show or hide subtotals.
13.3.3 Clear classification and summary
Hypothesis analysis of 13.4 data
13.4. 1 program manager
13.4.2 univariate solution
13.4.3 data sheet
13.5 master the sales statistics and sample preparation of Xia Qing Clothing City.
13.6 proficient in exercises
13.7 Summary of this chapter
Chapter 14 data analysis skills
14. 1 Understanding PivotTables and PivotCharts
Create and delete pivottables.
14.2. 1 Create a PivotTable report
14.2.2 Delete PivotTable fields
14.2.3 Delete PivotTable report
14.3 Setting up a PivotTable report
14.3. 1 Set PivotTable options
14.3.2 Design Pivot Table
14.4 Create and move perspective.
14.4. 1 Create a PivotChart
14.4.2 moving perspective
14.5 trend line
14.5. 1 Add Trend Line
14.5.2 Set the trend line
14.6 error line
Add error bars
Edit error line
14.7 grasp the example-making salary data perspective.
14.7. 1 Insert PivotTable report
14.7.2 Insert PivotChart
14.8 proficient in exercises
14.9 Summary of this chapter
Chapter 15 Chart making skills
15. 1 automatically displays extreme values in the chart.
15.2 skills of setting charts
15.2. 1 Set the filling effect.
15.2.2 Set border effect
15.2.3 Set the text style
15.2.4 chart display and hide
Add a scroll bar to a chart
15.4 Create a snapshot for the chart.
15.5 Skilled example-making order pre-registration form
15.6 proficient in exercises
15.7 Summary of this chapter
Chapter 16 Excel2007 Network Usage Skills
16.1* * Enjoy the workbook.
16. 1. 1 Create a workbook for * * *
16. 1.2 Edit * * * Enjoy the workbook.
16. 1.3 revised edition * * * Enjoy the workbook.
16. 1.4 Stop * * * enjoying the workbook.
16.2 Links and Embedding between Office Components
16.2. 1 Insert embedded object
16.2.2 Modify the embedded object
The application of 16.3 hyperlink
16.3. 1 Insert and edit hyperlinks
16.3.2 send the form by email.
16.4 form content proofreading
1 spell check
16.4.2 translation
16.5 Conversion between Simplified Chinese and Traditional Chinese
16.6 Proficiency Example-* * * Enjoy the sales table
16.6. 1 embedded object
16.6.2*** Appreciate and proofread the workbook.
16.7 proficient in exercises
16.8 Summary of this chapter
Chapter 17 Creating and Using Macros
17. 1 What is a macro?
17.2 Create a macro
17.2. 1 recording macro
17.2.2 Creating Macros with VisualBasic
17.3 Run Macro
17.3. 1 Press the shortcut key to run the macro.
17.3.2 Run the macro through the macro dialog box.
17.3.3 Run the macro through the quick toolbar.
17.3.4 Set the macro to run automatically.
17.4 macro management
17.4. 1 Edit Macro
17.4.2 Delete macro
Security settings of 17.5 macro
17.6VisualBasic editor
17.7 grasp the example-create a production table workbook
17.8 proficient in exercises
17.8. 1 Edit "After-sales Questionnaire"
17.8.2 Edit "Employee Data Table"
17.9 Summary of this chapter
Chapter 18 VBA programming
What is VBA?
18.2VBA syntax
18.2. 1 data type
18.2.2 Constants and variables
Operator of 18.3VBA
18.3. 1 arithmetic operator
18.3.2 comparison operator
18.3.3 Join the operator
18.3.4 logical operator
18.3.5 operator's priority
18.4VBA program control statement
18.4. 1If statement
18.4.2If and Else statements
18.4.3 multiple If statement
18. 4. 4 selection and case statement
18.4.5For and Next loop statements
18.5VBA object
1 application object
18. 5. 2 Workbook object
18. 5. 3 worksheet object
Common functions of 18.6VBA
18. 6. 1 input box function
18.6.2MsgBox function
18.7 custom function
18.7. 1 Locate the largest cell.
18.7.2 judging data type
18.8 grasp the example-use VBA to customize the chart
Create a chart
65438+
18.9 proficient in exercises
18. 10 Summary of this chapter
Actual combat article
Chapter 19 Application of Excel in Financial Statistics
19. 1 Making employee payroll
19. 1. 1 Example description
Key points of making 19. 1.2
1.3 production process
19.2 make the company's expenditure table
19.2. 1 Example description
19.2.2 key points of production
19.2.3 production process
19.3 Outward Bound Training
19.3. 1 Edit "Company Expense Table"
19.3.2 Edit "1 Monthly Payroll"
Chapter 20 Application of Excel in Production and Sales
20. 1 Make daily production report
20. 1. 1 Example Description
20. 1.2 key points of production
20. 1.3 production process
20.2 make product sales analysis table
20.2. 1 Example Description
Key points of production
production process
20.3 development exercises