Commonly Used Excel Functions

Here are some basic formulas that are easy to do and that can give some life to an Excel sheet!

Excel offers many functions, modules and other assistants whose purpose and facilitate the creation and layout of tables. In this new article, we will see how a calculation formula works in Excel, what it can be used for and how to use the wizard.

Excel offers a very large number of formulas, some of which are extremely complex. It is therefore impossible to list all the proposed formulas. The purpose of this article is to explain how to use a calculation formula and not to list the formulas available (the list of formulas is given in Excel).

Table of contents

• Introduction  
• Formulas and Functions  
• Math and Trigonometry Functions  
• Statistical Functions  
• COUNT, COUNTA, and COUNTBLANK 
• AVERAGE, MEDIAN, MIN, and MAX  
• RAND and RANDBETWEEN  
• Date and Time Functions 
• DATE 
• YEAR, MONTH, and DAY 
• Lookup and Reference Functions  
• VLOOKUP  
• HLOOKUP 
• INDEX 
• MATCH 
• LOWER, UPPER, and PROPER 
• CONCATENATE  
• LEFT, RIGHT, and MID 
• LEN and TRIM 
• TEXT and VALUE  
• Logical Functions  
• COUNTIF 
• Formatting  
• Editing 
• Calculations 

Download file

Others related eBooks about Commonly Used Excel Functions