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
Evaluating Information Retrieval and Access TasksDownload free course Evaluating Information Retrieval and Access Tasks, pdf file on 225 pages by Tetsuya Sakai, Douglas W. Oard, Noriko Kando....
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....
Publisher 2016 tutorial pdfDownload free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....
Quick guide to Word 2010A 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...
Excel VBA tutorial for professionalsDownload free VBA tutorial course in PDF, training file in 31 chapters and 128 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
Office 365Download free course Office 365, pdf file on 680 pages by Matthew Katzer, Don Crawford....
The Beginner’s Guide to Microsoft ExcelThis is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics. ...
Basic Formulas in ExcelDownload basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks....
PowerPoint PresentationThis PDF tutorial introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment....
PowerPoint 2010 AdvancedDownload advanced tutorial in PDF about PowerPoint 2010, free course under 201 pages by Stephen Moffat....