Using Excel Functions Effectively 課程

1. Information Function

• The main usage of information function is to extract information from cell. For example the format of cell and the file name of the link documents.

• Moreover, information function include IS(), which is a function for viewing the status of data. For example whether it is blank; whether it is number or whether it is written words, there will be feedback of ‘True' or ‘False' value.

• To organize information by Excel, most of the time we have to use database. When we need to calculate result within database by using custom criteria, Database Function can bring into full play.

• For example, if you would like to calculate the sum and average of exports in America at the third season, or if you want to calculate the accumulated number of clients in five years from your customer database, the Database Function is critically useful at this moment.

3. Text Function

• The main usage of Text Function is to extract words from cell, which means completing word process. For example, extracting part of the words from cell, merging two groups of word or above or handling search of words and replacement etc.

• It is always hard to find the information you need in database, but if you are familiar with the usage of Lookup and Reference Function, this could absolutely raise your efficiency.

• HLookup and Vlookup are the most popular examples of Lookup and Reference Function.

• Statistical Function is best to handle data analysis, the statistic area include probability, variance and seek for average value etc.

• For example a company has to execute quality control management of products, it request staffs to calculate how well the products are. Statistical Functional can manage to handle such a case easily.

• In the application of Financial Function, most of the functions were used to calculate investment interest, depreciation amount and investment returns etc. For those users who work in company that need to prepare financial report frequently are absolutely useful.

• Apart from the functions we mentioned above, instructor will deliver other kinds of functions in details to perfect our course. For example, Math and Trig Function, Date & Time Function and Logical Function.