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: | 1031 |
| 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
Formulas & Functions in Microsoft Excel
Others related eBooks about Commonly Used Excel Functions
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....
Excel Data AnalysisDownload free course Excel Data Analysis, pdf file on 358 pages by Hector Guerrero....
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...
Beginning Excel 2019Download 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....
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....
Excel 2016 Math with Dates and TimesWith 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....
Advanced Microsoft Excel 2013Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for beginners....
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....
Pivot Tables in Microsoft ExcelThe following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners....
Microsoft Excel Tips & TricksThese are some of my favorite tips and power features that’ll get you well on your way to ‘Excel Guru Status’ giving you not only the recognition you deserve, but also making your work more enjoyable....