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: | 1027 |
| Created: | 2018-04-02 |
Others Excel Formulas Tutorials
Formulas & Functions in Microsoft Excel
Others related eBooks about Commonly Used Excel Functions
How to Use Microsoft® Excel®How to Use Microsoft® Excel® The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel...
Excel Data AnalysisDownload free course Excel Data Analysis, pdf file on 358 pages by Hector Guerrero....
Microsoft Excel 2013Download free Microsoft Excel 2013 Tutorial , a PDF training file under 12 pages for beginners....
Formulas & Functions in Microsoft ExcelDownload Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott....
Microsoft Excel 2016 Course for BeginnersLooking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf....
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 ....
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 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....
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....