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

Evaluating Information Retrieval and Access Tasks

Download free course Evaluating Information Retrieval and Access Tasks, pdf file on 225 pages by Tetsuya Sakai, Douglas W. Oard, Noriko Kando....

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....

Publisher 2016 tutorial pdf

Download free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....

Quick guide to Word 2010

A course to learn how to use the Word 2010 version, PDF training course to download for free, Microsoft Office Word 2010, training support in 4 pages...

Excel VBA tutorial for professionals

Download free VBA tutorial course in PDF, training file in 31 chapters and 128 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

Office 365

Download free course Office 365, pdf file on 680 pages by Matthew Katzer, Don Crawford....

The Beginner’s Guide to Microsoft Excel

This is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics. ...

Basic Formulas in Excel

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

PowerPoint Presentation

This PDF tutorial introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment....

PowerPoint 2010 Advanced

Download advanced tutorial in PDF about PowerPoint 2010, free course under 201 pages by Stephen Moffat....