Excel:The syntax of functions

Excel:The syntax of functions

 

Excel:The syntax of functions : YOUR OBJECTIVE

You probably already know how to carry out calculations using formulas, but now you’d like to perform some more complex calculations. Excel’s many functions permit you to do just that. In addition, you want Excel to automatically decide, depending on certain values, whether or how to carry out specific actions. Excel is equipped with more than 200 powerful functions that you can use for such purposes.

This learning module “ Excel: Syntax of functions ” will show you the general principles of using Excel’s functions. [Read more...]

The excel MID function

The excel MID function

 

YOUR OBJECTIVE

You are developing a list of products that your company sells. Already included in the list are article codes and article groups. Now you want to add a column for the sales regions. The sales-region code appears in the 3rd and 4th positions of each article code. To complete the Sales Region column, you would like to use an Excel function to read just those two characters from each article code and insert them in the corresponding sales-region cell. [Read more...]

Excel: The COUNT and COUNTA functions

Excel: The COUNT and COUNTA functions


Excel COUNT and COUNTA function: YOUR OBJECTIVE

You are using Excel to compile a list in which you want to keep track of how many entries have been made in a certain column. To determine how many cells within a defined range contain content, you can use the excel  COUNT and COUNTA functions. [Read more...]