-
Anonymous users2024-02-07Let's talk about how to become a master.
-
Anonymous users2024-02-061. Create an XLS worksheet.
2. Open the Xinjiang XLS worksheet and click Data.
3. Some templates will appear on the right side, find the template you need and click Apply.
4. Fill in your own content in the template that appears, and you're done.
Precautions
-
Anonymous users2024-02-051. Excel Introduction Excel Introduction Input and Autofill Function Excel is an Excel introductory tutorial in the office series of office software produced by Microsoft, to be precise, it is an electronic ** software, which can be used to make electronic **.
2. Before learning excel functions, we need to have the necessary understanding of the structure of functions. There are 11 types of Excel functions, including database functions, date and time functions, engineering functions, financial functions, information functions, logical functions, query and reference functions, mathematical and trigonometric functions, statistical functions, text functions, and user-defined functions.
3. The structure of the function begins with the name of the function, followed by the opening parentheses, the comma-separated arguments, and the closing parentheses. If the function appears as a formula, type an equal sign (=) in front of the function name The formula palette will provide relevant assistance when creating a formula that contains a function.
4. Formula palette - a tool to help create or formulas, and also provide information about functions and their parameters. When you click the formula button in the bar, or click the Paste Function button in the common toolbar, the Gongwu State Portability palette appears below the bar. When you need to analyze whether the values in the data inventory meet certain conditions, you can use the database worksheet function.
5. For example, in a data list that contains sales information, you can calculate the total number of all rows or records with sales values greater than 1,000 and less than 2,500. Microsoft Excel has a total of 12 worksheet functions for analyzing data stored in a data inventory or database, and these functions are collectively called dfunctions, also known as d functions, and each function has three identical parameters: database, field, and criteria.
6. These parameters point to the worksheet area used by the database function. where the parameter database is the area on the worksheet that contains the data list. The parameter field is the flag for the column to be summarized.
The criteria parameter is the area on the worksheet that contains the specified criteria.
-
Anonymous users2024-02-041. Basic operations need to be practiced more, such as: there are many ways to implement copy and paste, it is recommended to practice each way, and use different methods in different situations, which can improve efficiency; There are some skills that cannot be learned in textbooks, so you can exchange skills and experiences with colleagues, and there are many tips that can be learned online.
2. To learn the use of functions, it is recommended to learn the relevant introductory knowledge, such as: operators, etc.; These are generally mentioned in the first few chapters of the textbook, although the knowledge points are very boring, but the master must be proficient.
3. Understand the knowledge of a programming language, be familiar with computer algorithms, such as: C language, VB, can be, Excel built-in VBA programming language (it belongs to the extension of VB language), learn to write some simple VBA is the beginning of Excel's wonderful functions.
-
Anonymous users2024-02-03At work, some people's Excel use efficiency is very high, not those complex and difficult functions, VBA, etc., but these people make good use of shortcut keys, these 10 super practical shortcuts shared today, if you know 5, it means that the level and quite good.
enterenter is one of the keys that you are familiar with, so do you know that enter has a paste function in excel?
To select the content, press Ctrl+C, usually Ctrl+V or right-click to paste, but few people use Enter to paste.
After copying, just press enter.
Press the tab key directly in the tab worksheet to make the active cell pan one box, but when entering functions, the tab key can help you quickly type.
For example, enter a function letter, =s, and then press the tab key to enter search and the opening parentheses.
Ctrl+yNo one knows about the function of undoing Ctrl+Z, but few people have used the redo undo, and Ctrl+Y does just that.
For example, if you delete an area, press Ctrl+Z to undo the deletion, and if you still decide to delete it, press Ctrl+Y to restore the deletion.
Ctrl+Shift+L filtering is one of the commonly used functions in Excel, so how to quickly enter the filter state?
Select the data in the worksheet, press CTRL+SHIFT+L to enter the filter state, and press again to cancel the filter.
Alt+Shift+arrow keys combination shortcut, select the columns you want to combine, Alt+Shift+Right Arrow can be combined with one click.
Alt+Shift+Left Arrow to ungroup.
Ctrl+9 0Ctrl+9 is a shortcut to hide rows, and Ctrl+0 is a shortcut to hide columns.
Ctrl+1Excel is the most frequently used operation is the setting of cell formatting, many times we use the method of right-clicking to open, the shortcut key of this operation is Ctrl+1, which is very convenient to operate.
Ctrl+P to quickly open the printing interface, is it not often used? It's faster than a file to print.
Ctrl+- (minus sign) to quickly delete a line, if the speed is high when deleting multiple times in a row, then press Ctrl+Shift+Plus to insert a line.
Ctrl+F1Sometimes in order to display the needs, hide the ribbon above, generally right-click in the blank space of the ribbon, select Collapse Ribbon, if you want to come faster, press Ctrl+F1.
Before playing, take a serious look at the official website In fact, the task system of each online game is almost the same, just running around The difficulty is slightly higher, you need skills, you have to find your own rules, don't blindly click the mouse mechanically, read the task introduction carefully, inside the copy, figure out your own positioning, such as mt to ensure the safety of teammates, especially the safety of doctors, at least see that there are monsters attacking teammates, to re-establish hatred and pull monsters over, such as doctors, on the premise of their own good blood, give priority to ensuring the life of mt, and then there are thugs, such as thugs Under the premise of not ot maximum output, these must be very aware of their own attack power skills and the additional role of skills, In general, you must have a sense of playing your own Don't rely on teammates for everything, and it's very important to note that you don't ask for preferential treatment everywhere because you're a girl, when you can do everything by yourself, you can get recognition when you enter a wild team when you form a team, and you know it, and it's a sense of accomplishment ps: I'm a girl, but I've always played the male number, MT relies on himself for everything, It feels good ( o ) There are a lot of very good friends in the game.,PK or something, because I'm a MT relationship, I'm going to rush to the front.,Dead and alive.,But it's not bad to protect friends ( o ) No matter what, it's most important to be happy If you really don't like to fight and kill, it's not bad to be a good life player.,In short, it's OK to be self-reliant.
It is recommended to play first, each hero is played, whether it is to fight with people, or to play with the computer, to be familiar with the skill characteristics of each hero and the synthesis of items, and then focus on choosing a few heroes to play, whether you like it, others recommend it online, play dozens of times, understand the order of the hero's points and the choice of equipment, and then read some professional knowledge on the Internet, only if you are familiar with the hero first can you understand what is said on the Internet, otherwise you don't know what to say like reading the book of the sky, recommended** is dota, The highlights above and the bar buddies' posts are useful. Secondly, there is an even game.,U9 can also be used.,But it's mostly from the top of the even game.。 >>>More
Practice the basics first. Familiarize yourself with the basic tools you commonly use. >>>More
He is a master of communication, and the requirements for measures are really high. >>>More
First: Make good use of your morning time.
2.Meditation, you can do meditation after waking up in the morning, meditation has many benefits, modern people are held back by all kinds of short-term desires, and forget to do long-term things. Lin Zexu said: >>>More