Commonly Used Excel Functions

Description:

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 
Submitted On:
02 Apr 2018
File Size:
551.58 Kb
Downloads:
105
Submitted On:
02 Apr 2018
Rating:
Total Votes:0



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.

Keywords : Excel Formulas tutorial, Excel Formulas basics in pdf for beginners, Excel Formulas course in pdf, Excel Formulas training support in pdf, Download Excel Formulas tutorial in pdf.


Download File

How to use formulas in Excel calculation

With this PDF tutorial you will learn how to use the Formulas in Excel to compile, claculate and manage data, free training document by OWL.

Download

Formulas & Functions in Microsoft Excel

Download Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott.

Download

Basic Formulas in Excel

Download basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks.

Download


Be the first to comment! Please sign in or register.