Home » Office » Commonly Used Excel Functions

Commonly Used Excel Functions

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 

Pages :
File type : pdf
Downloads: 725
Submitted On: 2018-04-02
License:
Author(s):

Take advantage of this course called Commonly Used Excel Functions to improve your Office skills and better understand Excel Formulas.

This course is adapted to your level as well as all Excel Formulas pdf courses to better enrich your knowledge.

All you need to do is download the training document, open it and start learning Excel Formulas for free.

This tutorial has been prepared for the beginners to help them understand basic Excel Formulas Office. After completing this tutorial you will find yourself at a moderate level of expertise in Excel Formulas from where you can take yourself to next levels.

This tutorial is designed for Excel Formulas students who are completely unaware of Excel Formulas concepts but they have basic understanding on Office training.

Preview Download

Tutorials in the same categorie :