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
Others related eBooks about Commonly Used Excel Functions
Microsoft PowerPoint 2013 step by stepThis courses is designated to beginning-level and intermediate-level computer users. It teach you some skills that can be used to make a beutiful presentation....
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....
Quick guide to PowerPoint 2010This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....
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....
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....
Microsoft Excel 2007 Advanced - TutorialDownload free Microsoft Excel 2007 Advanced course material and training, a 100 pages pdf documents intended to beginners....
PowerPoint 2013 courseDownload Microsoft powerpoint 2013 courses for student, free training document in PDF designated for brginners....
Excel Data Analysis, 2nd EditionThis book offers a comprehensive and readable introduction to modern business and data ana..., download free Excel Data tutorial in PDF (358 pages) created by Hector Guerrero ....
Office 365Download free course Office 365, pdf file on 680 pages by Matthew Katzer, Don Crawford....
Introduction to Microsoft Word 2013This support shows you in detail all the features of this new version of the popular word Microsoft Word 2013; it is for anyone wishing to discover and deepen all its features....