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: | 1036 |
| 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
Others related eBooks about Commonly Used Excel Functions
Microsoft Excel 2007 : Essential GuideThe purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007....
Introduction to Excel VBA Macro programmingIntroduction 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...
How to use formulas in Excel calculationWith this PDF tutorial you will learn how to use the Formulas in Excel to compile, claculate and manage data, free training document by OWL....
Guide PowerPoint 2013Guide 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....
Basic Excel SkillsThis 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....
Excel 2016 PivotTables and PivotChartsLearn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download....
Formulas & Functions in Microsoft ExcelDownload Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott....
Introduction to Microsoft PublisherDownload Introduction to Microsoft Publisher in PDF, free training document about how to create a perform basic tasks and creating business and greeting card....
Office 365: Migrating and Managing Your Business in the CloudWritten 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 ...
VBA Tutorials for professionalsDownload free VBA tutorial course in PDF, training file in 46 chapters and 202 pages. Free unaffiliated ebook created from Stack OverFlow contributor....