Hello everyone , I'm Menghai , Today, I'm going to teach you some office skills , Hope that through systematic learning , We can improve the office efficiency as much as possible , Save time to do what you like .Excel It's the most common office tool in our work , Whether you're an office worker , Or financial workers , Or planning statisticians , As long as you're not ready to put someone else to work ,Excel Forms are office tools that must be learned . In view of the copyright issue , Many big companies are not allowed to use Microsoft Office Of , Therefore, the following explanations are based on WPS As a template .WPS As domestic free software , It's no less powerful than Microsoft Office, And the design is more in line with the usage habits of Chinese people . Don't talk much , Let's go straight to the point .1、 We install the software through WPS Download good software from the official website , It can be used directly after installation , Generally, an icon will appear on the desktop after installation , As shown in the figure ：
This icon is a comprehensive shortcut icon , Whether it's Excel、Word still PPT Presentation , Can be opened through this icon , This is better than Microsoft Office Some advantages .2、 Create a new workbook first, let's create a new one , Right click on the desktop , In new, select new XLS A worksheet or XLSX Worksheet ,XLS The worksheet is 97-2003 edition ,XLSX The worksheet is a new version , What's basically common now is XLSX Format sheet . The icon on the new desktop is as shown in the figure ：
3、 Distribution of workbooks and worksheets double click the left mouse button to open this workbook ,Excel The form page is right in front of us , The page is shown in the figure below ：
We can see , A new workbook has three blank worksheets , This can be added or deleted according to your own needs .4. Introduction to tools for worksheets （1） Above the table is the toolbar , Below the toolbar are tool options , Include start 、 Insert 、 The page layout 、 The formula 、 data 、 Review 、 View 、 Development tools, a few tags . There are many different tools under each tag .（2） There are several separate icons on the left side of the toolbar , We can open it and see that this is “ Customize the Quick Access Toolbar ”, Generally we can print 、 Print preview 、 Save and other common tools that are not in the toolbar are added here . The custom toolbar can be set through the drop-down arrow , It can also be in “ file ”-“ Options ” Set in .（3） On the left side of the table 1、2、3、4 Such numbers are line marks , Represents the first line of the table ; Upper side A、B、C、D Such letters are column marks , Represents the column of the table .（4） The bottom of the table is called the status bar , You can set the state to be displayed by yourself .（5） There is also one on the top left of the table “ file ” And the drop-down arrow , This is the overall setting item of the worksheet , It also includes some of the tools we just mentioned 、 For example, convert to PDF、 preservation 、 Save as and so on .（6） The top of the worksheet , There is also a search box behind the toolbar , Is a more practical function , We can use this search box to search for functions that are not easy to find , There are also some videos about functions . I'll show you the specific location through a picture , You can open your own software for comparison .
Okay , That's all for today's talk , Want to learn more intuitively , Please pay attention to the author , Watch the video tutorial with the same name . tip ： The version used by the author is wps2019 edition , Use Microsoft office My friends may differ in a few details .