The article directories
- Summary of key and difficult points in Word
- Excel summary of key and difficult points
- Summary of key points and difficulties in PPT
Summary of key and difficult points in Word
1. Font Settings (if the topic provides a sample picture for you to set, modify as similar as possible, as long as the modification can be scored).
2. Paragraph Settings (note the indentation of the first line, paragraph spacing in units of lines and pounds, which can be entered manually, fixed values in line spacing and multiple line spacing).
3. New, modified, copied, endowed styles, and the use of style sets (high frequency, large amount of questions).
4. Replace is the focus of the exam (batch modify content, style, batch delete content).
5. Select the rectangle in the selection and select text of similar format.
6. Selective pasting (pasting Excel tables into documents and automatically updating them as the data source changes).
7. Insert the system self-belt cover (delete the date field control and time control before moving the cover).
8. Insert tables into the document and format them. Convert text to tables and repeat header lines.
9. The complex chart (pay attention to the setting of primary and secondary coordinate axes) is the key and difficult point in the chart part.
10. Create a resume using picture shapes and SmartArt.
11. Insert hyperlinks (links to files, websites, and locations in this document) with ctrI+ K. The shortcut to cancel hyperlinks in batches is CTRL + Shift + F9.
12. The header and footer section is by far the most important and most difficult part of a Word document:
Basic: uniform header footer, add a broad line at the top and a narrow line at the bottom for the header, add the company logo.
Upgrade version: odd page is different, the home page is different, set page format.
Ultimate edition: different chapters show different headers, multiple page number formats, combined with odd and even page differences and home page differences.
13. Insert the text box template, draw the text box, set the text box format, use the text box to make a paper cover.
14. Insert document attributes, insert fields (fields of type document information, styleref fields), save the selected content to the document part library, and modify the domain code (it is difficult to modify page numbers using the domain code).
15. Insert art characters (curved text effect), sinking characters, system date inserts (automatic update), symbols inserts (checkmark, pentagram, etc.).
16. Apply theme, theme color and font Settings.
17. Page setting: margin, binding line, paper direction/size, page number range (symmetrical margin, page spelling), header footer distance from the boundary, set the line ribbon, set the number of lines.
18. Column section: set column number, dividing line, column spacing, column character, table and chart column center.
19. The separator section, with emphasis on the separator (next page, consecutive, even pages, odd pages).
20. Distinguish the difference between the watermark and the page background, and the way to print the background.
21. The setting of page border, artistic border is often checked, please pay attention to the page border, paragraph border, character border difference.
22. Automatically generate directories, insert directories of specific levels, set directory formats, update directories.
23. In the footnote section, insert the footnote endnote, set the footnote format, and convert the footnote and endnote to each other.
24. In the annotation part, this knowledge point is often examined at the same time as multi-level list, with relatively high difficulty coefficient. The insertion of annotations, modification of annotation style, cross-reference, and insertion of table catalog.
25. Index section, mark index items, insert indexes, delete indexes in batches, automatically mark indexes according to files.
26. Mail merge part (note the difference between the original document and the result document, note the Settings for editing the recipient list, and the Settings for rules).
27. Simplified and complex conversion of Chinese text, new annotations, document protection.
28. Use of outline view, use of navigation pane, display scale adjustment.
Excel summary of key and difficult points
1. Table grid format adjustment (row height, column width, border, shading).
2. Cell formatting adjustments (alignment and numbers, which should be noted as cross-column merging centered, custom formatting Settings).
3. Selective pasting (transpose pasting) of data.
4. Jiang quotes in pairs, relative quotes, and mixed quotes.
5. Conditional format setting (the difficulty is to use the conditional format determined by the formula).
6. Use a table format.
7. Define names for data areas and convert tables to areas.
8. Custom sort (note that sort by stroke descending, by custom, by color).
9. Screening (automatic screening and advanced screening, automatic screening is used more, need to pay special attention to advanced screening).
10. Insert charts (compound charts are still important, and miniatures are also important).
11. Page Settings (paper size, paper direction, page margins, among which zooming printing is the key).
12. Access to external data (from websites, from text highlights).
13. Disaggregated use.
14. Data validity setting (integer decimal date sequence text length formula).
15. Combined calculation.
16. Classification and summary (emphasis, special attention should be paid to sorting by category fields before classification and summary, if not, please convert the table to common areas).
17. Insert pivottables (note the use of grouping and report filter pages), insert pivotcharts.
Simulate the use of operation tables and scheme managers.
Special topic on functional formulas
Five calculation functions: sum, average for average, Max for maximum, min for minimum count for number.
Conditional judgment function :if note the use of multiple layers of nesting typical.
Please pay attention to the referencing problem.
Conditional calculation functions: sumif single conditional summation, sumifs multi-conditional summation, countif single conditional number, countifs multi-conditional number.
Date functions: date, today, datedif, year, month, day, weekday.
Numerical functions: mod for remainder, int for integer, round round function, roundup. Rounddown, large, small.
Text functions: Left, Right, Mid, Len, Text, &.
Query function: vlookup, lookup.
Array functions are one of the hardest things to do. Note that the shortcut for running array functions is CTRL +shift+ enter
Copy the codeSummary of key points and difficulties in PPT
1. Create new slides (from outline, reuse slides).
2. Set the layout, and rename sections.
3. Convert text to SmartArt.
4. Replace fonts.
5. Insert hyperlinks to different objects.
6. Insert date and time, slide number, footer, and set the title slide not to be displayed.
7. Insert audio (Set background music, preferably with a small headset during the test, some computers will not be able to insert audio without audio player.)
8. Set the slide size, orientation, apply the slide theme, and set the background style.
9. Set the slide switching effect and automatic slide changing time.
10 Set animation for different objects, animation sequence and start mode. Pay particular attention to chart animation and smartArt object animation Settings.
11. Create custom slide show schemes.
12. Hide slides.
13. Set slide show mode and show options.
14. Master view Settings.
15. Delete all remarks at one time.