Excel is very powerful, is not it? But sometimes you will find that if exce document contains so much data excel will become very slow, it is because for those who excel not need to deal with a large amount of data users and design. If you have a large amount of data to deal with, and the need of many other Excel function of the formula could not be completed, I suggest that you use a database, for example, Access. Access is a desktop database software, although it is not professional, but I think to some extent it meet your request, for example, to deal with those that excel handle more data. And the use of the database language SQL, you can also make some very simple to excel, the more complex tasks, for instance, that you want to excle in a series of all the figures are added another figure in this task in exce more complicated, but the use sql language, you can use a very simple order to complete this task.

Well, you first need to import data from Excel inside out, and this how do Which? Do not worry, you create a document Access, click menu “document”, and then click “access to external data”, and then inside the dialog box pops up to open the file type changes. xls, and then select you want to open the document excel it.