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 
File Size:
551.58 Kb
Downloads:
196
Submitted On:
2018-04-02



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.

Download File


Microsoft Excel 2013 course

Download free Microsoft Office Excel 2013 file under 505 pages,step by step to learn Excel and build your skills , course tutorial training on pdf by Curtis D. Frye.

Download

Advanced Microsoft Excel 2013

Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for beginners.

Download

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.

Download

Basic Formulas in Excel

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

Download

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