The most important functions include:
| 
 =SUM()  | 
 Adds a series of cells together.  | 
| 
 =AVERAGE()  | 
 Calculates the average of a series of cells.  | 
| 
 =IF()  | 
 checks if a condition is met and returns a value if YES and a value if NO  | 
| 
 =MIN()  | 
 Provides the minimum value in a series.  | 
| 
 =MAX()  | 
 Provides the maximum value in a series.  | 
| 
 =LARGE()  | 
 Returns the k-th largest value in a series.    | 
| 
 =SMALL()  | 
 returns the k-th smallest value in a series  | 
| 
 =COUNT()  | 
 counts the number of cells in a range that contain numbers  | 
| 
 =VLOOKUP()  | 
 looks for a value in the leftmost column of a table and returns in the same row from a column you specify  | 
See also:
Free Training Course: Lesson 1 - Excel Fundamentals
See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.