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 | |
| Downloads | 1081 |
| Created | 2018-04-02 |
Others Excel Formulas tutorials
Others related eBooks about Commonly Used Excel Functions
-
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....
-
Excel Data Analysis
Download free course Excel Data Analysis, pdf file on 358 pages by Hector Guerrero....
-
Microsoft Excel 2013
Download free Microsoft Excel 2013 Tutorial , a PDF training file under 12 pages for beginners....
-
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...
-
Guide PowerPoint 2013
Guide of Microsoft Powerpoint 2013 in PDF a quick references card to learn the basics of PowerPoint,a free tutorial for download and training document under 2 pages designated to begginers....
-
Full list of Excel functions
Download the complete list.of Microsoft Excel functions, free training document in pdf....
-
Excel 2016 Functions Tutorial
Download Excel 2016 Functions Tutorial, free PDF document intended to anyone wants to learn the basics of Excel functions....
-
Basic Excel Skills
This course is not intended to serve as a beginner's tutorial on Excel. Those who are new to Excel and who need a tutorial should work through abook or a CD, or take an online course....
-
Formulas & Functions in Microsoft Excel
Download Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott....
-
Office 365: Migrating and Managing Your Business in the Cloud
Written for the IT professional and business owner, this book provides the business and technical insight necessary to migrate your business to the cloud using Microsoft Office 365. This is a practical look at cloud migration and the use of different technologies to support that migration. Numerous ...