engineering applications Excel function tutorials function explain (with examples)|EXCEL skills

English
Chinese

Office software is closely linked to the PDF,the PDF is also must have to control! Set home Page Add to Favorites

Home

OA info

OA application skills

You are here:Home > OA application skills > EXCEL skills

EXCEL skills

engineering applications Excel function tutorials function explain (with examples)

Finishing by: Date:2009-04-11 12:51:33 Popularity: Tags:tutorials

Excel statistical functions and the work function of similar areas of expertise are a function of comparison. Therefore, the author in the text only to introduce the works of several commonly used functions, please refer to Excel more help and professional books. As the name suggests, the project worksheet function is used for engineering analysis of the function. Excel in the past have provided a total of 40 engineering function. Worksheet function works by "analysis tool bank" to provide. If you can not find such a function, it may need to install the "Analysis Tools."

one, "Analysis Tools" installation
as shown

Figure 1

(1) in the "Tools" menu, click the "add-in" command.

(2) if the "add-in" dialog box there is no "analysis tool library", click the "Browse" button, navigate to the "Analysis Tools" add-file "Analys32.xll" where the driver and folder (usually located in "Microsoft Office \ Office \ Library \ Analysis" folder); If you do not find the file, should be run "install" procedure.
(3) Check the "Analysis Tools" check box.

Home Previous12 3 4 5 Next End

Previous:Application of Excel function tutorials explain the external function (with examples)
Next:Application of Excel function tutorials explain financial functions (with examples)

there isArticle InformationsComment Information

Category column

Ranking Information