White-collar charging station, 100-day salary increase plan Say goodbye to 007 and 996, and work easily and happily
Time is money, efficiency is life. While others are doing their work with ease, flirting with their girls during work hours and planning where to go on the weekend, you are busy every day, working until late at night before dragging your tired body home from work. This article summarizes how to comprehensively improve the office efficiency of white-collar workers, through learning and understanding and continuing to pay attention to my articles, Xiaobai's work efficiency can be increased several times or even more than ten times, and the overall efficiency of a day can be doubled or even more than 2 times, so that 8 hours of work can be completed in 4 hours or even 2 hours, and then say goodbye to unpaid overtime, farewell to 007 and 996.
In today's IT age, where computers and smartphones are ubiquitous, if you don't learn, you will regress. The workplace is like a battlefield, and if you are slow, you may be eliminated first. If you are far more productive than others, you can spend more time improving yourself, or spending more time with your family, or sharing more work with your leaders, and your career will be smooth.
Below, I combine my years of work experience to explain how to comprehensively improve our office efficiency from the following aspects, which has a very good reference significance for individuals and enterprises.
One is the hardware configuration. The better the configuration, the higher the efficiency of the office equipment, of course, and it is not easy to get stuck, which is common sense. To point out, if there are conditions, it is best for us to use dual-screen office (dual monitors), that is, 1 computer + 1 separate monitor. Because many times we have to view or compare two files at the same time, or do other things while having an online meeting, dual-screen office can greatly improve work efficiency. The dual-screen setup is as follows:
The second monitor TV projector is connected to the computer with an HDMI cable, open the computer settings - display, and select "Extend these displays" in "Multi-monitor settings".
Or shortcut win+p, select Extension:
Once set up, we will drag the open document to the right with the left mouse button holding down the top border, across the right edge of the computer monitor, and the document will be dragged all over to the second display. If you want to drag it back, hold down the top bezel and drag it to the left across the left edge of the 2nd monitor. You can also use the shortcut key shift+win+or shift+win+.
Here's a little trick, if there is no dual screen, we want to compare two files, press the shortcut key win+ or win+, the two documents can be displayed side by side, each occupies the screen in general, so that we are very convenient to compare and copy and paste, as shown below.
The second is the software aspect, which involves many aspects. Let's illustrate them one by one.
1.Skillful use of shortcut keys: Shortcut keys can greatly improve our efficiency. We must not only be proficient in the default shortcut keys of the operating system, but also be proficient in the shortcut keys of office software and other software. For example, pressing F4 in Excel is to repeat the previous operation, such as changing the font format. There is also a smart filling function of CTRL+E, which is very easy to use. And the expert will also customize the shortcut keys for the common functions of the software. I'll dedicate myself to a later article.
2.Excel function Quantitative application of formulas. The use of formulas can realize the functions of automatic calculation, search and filling of cells. Especially in the later versions of Office365, a large number of new functions have been added, most of which have dynamic calculation functions, that is, a formula can complete the calculation of an entire column or row or even an entire area, such as filter, sequence, xlookup functions, etc. Excel function master can set a large number of complex formulas through clever settings, only need to complete a few source data updates and a few simple operation steps, you can achieve Excel automatic calculation to complete a variety of complex and cumbersome data updates, the work that originally took a few hours to complete, can be completed in ten minutes. In the following article, I will introduce the writing, use scenarios and comprehensive application of various function formulas.
3.Excel VBA Programming: When it comes to programming, many novices feel very high and worry that they won't be able to do it. But in fact, VBA programming is easier to learn than other programming languages. VBA programming, even a few simple segments, can greatly improve the efficiency of repetitive work. Therefore, it is necessary to take the time to learn VBA programming for your career. Excel formula + VBA programming is even more powerful. Later, I will also share some VBA** and usage scenarios commonly used in my work.
4.Word documents containing **, try to convert them into excel documents, the reason is very simple, excel has many formulas that can be automatically calculated. The creator of the document may have an average level of excel, so he often uses a word document to develop a document with the main content of the document. Therefore, when using this kind of document, an Excel master can often only obediently enter text or use Ctrl+C and Ctrl+V to complete document editing.
5.Microsoft's OneDrive sharing function, this function can realize multiple people to edit the same document online at the same time, and greatly improve the work efficiency of those documents that need to be edited by multiple people.
6.Convenient and fast input methods and tricks. A lot of us write e-mails and documents and we just play the role of text porters. A good input method can greatly save our time, such as the shortcut phrase function of the Sogou input method introduced in my previous article. The computer's built-in input method does not have this function. The "clipboard" of the new operating system is also very convenient and easy to use, as I introduced earlier.
7.Classic Excel template production: combined with the characteristics of work and output content, make a sophisticated Excel template, the template sets a large number of functions and formulas VBA programming output documents, as well as ingenious design and use, so that the original complex work becomes very simple, the original work that can be completed in an hour, may be completed in ten minutes.
8.Shared altruism among colleagues. A lot of information at work comes from colleagues, and we need to extract information from their files or emails. Therefore, unless there is a special request, we can copy and paste the documents or emails we sent in the past. I often encounter colleagues in my work when sending emails, a **, could have been copied to the body of the email, but he used a screenshot to put it in the text, the former can directly copy the text content, the latter can only be entered manually, of course, the efficiency is slow.
The improvement of work efficiency also involves many aspects, which need to be accumulated in the work. I will try my best to share my good experience and methods with you in the future.
Follow me to learn more office skills, so that you can become faster and stronger, and be like a fish in water in the workplace! If you think it's good, welcome to comment and share, thank you