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

Formulas & Functions in Microsoft Excel

How to use formulas in Excel calculation

Basic Formulas in Excel

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

Microsoft Excel 2016 Tutorial

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

Office 365

Written for the IT professional and business owner, this book provides the business and te..., download free Office tutorial in PDF (680 pages) created by Don Crawford ....

Tutorial Access 2016 in PDF

Download free Tutorial in PDF about Microsoft Access 2016 (course, exams and exercises), a complet training document course on 322 pages for beginners by MARY LEMONS....

Formulas & Functions in Microsoft Excel

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

Beginning Excel 2019

Download free course Beginning Excel 2019, pdf file on 387 pages by by Noreen Brown, Barbara Lave, Hallie Puncochar, Julie Romey, Mary Schatz, Art Schneider, Diane Shingledecker....

Pivot Tables in Microsoft Excel

The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners....

Excel 2016 Shortcuts

With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners....

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

Essential PowerShell

This book written to provide clear and concise explanation of topics for programmers both starting to learn the PowerShell programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....