Office: This paper mainly introduces the general skills of the whole Office system, and briefly introduces Word, Excel and PPT.
High efficiency: high frequency, obvious use effect, and the disease can be eliminated by medication.
Tip: It's easy to learn and learn. After reading the tutorial, skills Get√.
By the way, the content of this article is relatively basic, and it is more about popularizing the existence of some functions without too much expansion. There are many skills that won't slow you down. Let's have a look. Maybe there are surprises ~
This is a magical brush, which is actually quite conspicuous. It looks like this:
Function:
Copy the format of object A to object B, where the object can be text or shape (you can't take it home to your parents. ...
Usage:
& lt 1 & gt； Selected object a
& lt2> Click or double-click the Brush Format button, and the cursor will change to a brush shape. If you click the format brush, the format brush can only be applied once; Double-click "Format Brush" for continuous use.
& lt3> Select object B with the brush cursor.
Extension: Its shortcut key is Ctrl+Shift+C/Ctrl+Shift+V.
Don't panic about batch modification, find a replacement to help you.
The function of finding substitutes goes far beyond changing nouns, especially after knowing "wildcards". But this function need not be complicated to learn. What you need is a sense of substitution. Then you can learn to use it when you encounter batch modification problems now ~
By the way, there is a function of "replacing fonts" in PPT ~
In PPT and Word, tables can be used for typesetting.
After inserting the content in the cell, set a borderless line on the table ~
The convenience of table typesetting is particularly obvious in Word. For example, it is difficult to align many horizontal lines on a paper cover. Try it with a table ~
Here, that's the top bar ~
Put the commonly used operations here, and the efficiency biubiu will rise. Needless to say ~
Everyone knows the benefits of shortcut keys, but the question is:
Too spicy!
If I can only introduce one shortcut key, I will introduce F4. Its function is to repeat the previous operation.
F4, let you become an office expert with one click.
I can't remember!
If you want to remember commonly used shortcut keys, you can read this story:
Huashan's "key" theory-the most vivid encyclopedia of shortcut keys in history
You will definitely come back to praise!
There are too many advanced games in Excel, but doesn't VBA mean that you can only knock on cells one by one?
You should master "functional consciousness". When encountering routine content, we must first find ways to improve efficiency. A simpler method is to use functional formulas.
Formula won't matter, ask Du Niang!
Sue (residence) (case) (reason) (son):
In Excel, all files in a folder should have hyperlinks. Well, it's about 50 … you can add them manually one by one, of course, if you're not too tired …
But I have a hyperlink function (it doesn't matter if I don't understand, I am Doby):
Then I just need to copy and paste the file path. Although it is not fully automatic, it is much faster than right-clicking one link at a time ~
By the way, there is a way to input all the file names of a folder into Excel, but it is not a function. If you are interested, you can check Baidu ~ If there are many people, I will think about the tutorial again ~
At this time, the tutorial written before will be provided:
Cheats 02 Unknown Words Hiding Skills
Cheating 03Word technology document merging
Document Merge Cheats 04Word Skills (Continued)
As a PPTer, isn't this part of the skill easy for three days and three nights?
Main settings, plug-in installation, reference line definition ... these contents can be found in my last article.
Master a few small habits and do PPT unconsciously.
Laziness in daily work may be the driving force to improve efficiency. Laziness depends on whether you feel lazy ~