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:	1032
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

How to use formulas in Excel calculation

Basic Formulas in Excel

Formulas & Functions in Microsoft Excel

Others related eBooks about Commonly Used Excel Functions

Microsoft Excel Tips & Tricks

These are some of my favorite tips and power features that’ll get you well on your way to ‘Excel Guru Status’ giving you not only the recognition you deserve, but also making your work more enjoyable....

Full list of Excel functions

Download the complete list.of Microsoft Excel functions, free training document in pdf....

PowerPoint Presentation

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

Microsoft Excel 2013 for beginner

Download free Microsoft Office Excel 2013 Tutorial course material, tutorial training, PDF file on 25 pages....

Introduction to Excel VBA Macro programming

Introduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface...

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

VBA Tutorials for professionals

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

Microsoft Excel 2016 Tutorial

Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages...

Microsoft Excel 2016 Academic Course

...

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