进修excel必读(国外英语资料).docVIP

学习excel必读(国外英语资料) Excel must read (no regrets) So let me just say that excel is a spreadsheet program, and spreadsheet software is not just one. For example, WPS, lotus 1-2-3, and some open source spreadsheet software on Linux on open source systems. In todays world, however, excel is unique, the leader of the spreadsheet world. Think of a company that doesnt use excel, and when it comes to Windows, its almost always excel. The use of excel is very high, in any industry, as long as it is done. Why is that? Well, its because of the utility of excel, which is able to quickly sort out all sorts of complex data, put it together, and analyze it. You dont have to immerse yourself in the data. Maybe a lot of companies go to ERP, ASP, these advanced systems. But some of these systems cant be done for the time being. You can only do it in excel. Im not saying that excel is more than an ERP, SAP is an ox. In fact, there is no conflict between them, but rather a mutually reinforcing relationship. In the company, we use ERP as the main and excel as the auxiliary. Cooperate to finish the work. And for some small and medium-sized businesses, excel can be used more. We know we need a set of ERP, SAP. At least one hundred and twenty thousand. For small and medium-sized enterprises. Thats a lot of money. And later maintenance. So a lot of small and medium-sized enterprises consider using excel to do the management of the business. If your enterprise has a large amount of data, consider using excel VBA + database technology. This way, you can solve the problem of slow data access, and you can easily manipulate excel (excel most people do). Kill two birds with one stone. Here are some of the most common features of excel: basic operations, functions, charts, pivot tables, and VBA. One by one. First, basic operations. The basic operation is the ability to play the excel menu. A lot of people think that if you learn the usage of each menu, you will be able to excel in excel. In fact, w