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:	1023
Created:	2018-04-02

Others Excel Formulas Tutorials

Basic Formulas in Excel

How to use formulas in Excel calculation

Formulas & Functions in Microsoft Excel

Others related eBooks about Commonly Used Excel Functions

Microsoft Office 365

Download free course Microsoft Office 365, pdf file on 337 pages by Katherine Murray....

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

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

Microsoft Excel 2016 Academic Course

...

Introduction to VBA in Excel - PDF Tutorial

This is a tutorial showing how to use the macro facility in Microsoft Office—Visual Basic for Applications—to simplify analytical tasks in Excel....

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

Microsoft Excel 2007 : Essential Guide

The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007....

Excel Basics: Microsoft Office 2013

This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system....

VBA API Tutorial

Download VBA API Tutorial on 24 pages intended to advanced level users. Free training document in PDF....

Microsoft Excel 2013 for beginner

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