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 
Size : 551.58 Kb
File type : pdf
Downloads: 1036
Created: 2018-04-02

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others Excel Formulas Tutorials

Basic Formulas in Excel

Formulas & Functions in Microsoft Excel

How to use formulas in Excel calculation

Others related eBooks about Commonly Used Excel Functions

Excel 2016 Math with Dates and Times

With this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016. Training documents courses on 17 pages for beginners....

Excel 2016 Functions Tutorial

Download Excel 2016 Functions Tutorial, free PDF document intended to anyone wants to learn the basics of Excel functions....

Microsoft Word 2103 Step by Step

This PDF tutorial provides invaluable handson experience for who want to learn about new features in Word 2013 .It's a free and complet training document under 576 pages for download....

PowerPoint 2013 course

Download Microsoft powerpoint 2013 courses for student, free training document in PDF designated for brginners....

Formulas & Functions in Microsoft Excel

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

Basic Formulas in Excel

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

Guide Excel 2010

A little guide in PDF,it will clarify the new basics features added to Microsoft Excel 2010 ,free training tutorial under 24 pages....

VBA Excel 2010, 2013 and 2016 Tutorial in PDF

Download VBA Excel 2013 Tutorial in PDF, free training document intended to beginner users on 10 pages....

Microsoft Excel 2013

Download free Microsoft Excel 2013 Tutorial , a PDF training file under 12 pages for beginners....

Quick guide to PowerPoint 2010

This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....