# MS Excel Functions Tutorials

Tutorials Shared by the Internet Community

 Top Tutorials New Tutorials Submit Login Register

 Basic Concepts (16) Charts and Graphs (3) Data Entry (2) Functions (18) General Development (3) General Formatting (4) Interfaces (0) Security (0) Using Macros (0) Misc (1)

• ### MAX Function Usage

The Excel MAX function returns the largest numeric value in a range of values.
https://www.excelbuddy.com/excel-tutorial-database/max-function/
• 552 Hits
• Rating

• ### INDIRECT Function

The INDIRECT Function converts a text string into a cell reference.
https://www.excelbuddy.com/excel-tutorial-database/indirect-function/
• 461 Hits
• Rating

• ### Rank Function Numeric Value Rank

The Excel Rank function returns the numeric value when compared to a list of numeric values.
https://www.excelbuddy.com/excel-tutorial-database/rank-function/
• 469 Hits
• Rating

• ### Lookup Use a Letter to Represent a Value in Excel

This tutorial will show you how to use a letter to represent a specific value.
https://www.excelbuddy.com/excel-tutorial-database/how-to-use-a-letter-to-represent-a-valu...
• 592 Hits
• Rating

• ### SUMPRODUCT and EXACT Formula

Learn to use the sumproduct and exact formulas.
https://www.excelbuddy.com/excel-tutorial-database/sumproduct-exact-formula/
• 552 Hits
• Rating

• ### EXACT Function in Excel

The exact function compares two strings of text.
https://www.excelbuddy.com/excel-tutorial-database/exact-function-excel/
• 570 Hits
• Rating

• ### AVERAGEIFS Arithmetic Mean Multiple Criteria

In this example, we will be using the AVERAGEIFS function. We will be finding the average of a data set if it meets multiple criteria.
https://www.excelbuddy.com/excel-tutorial-database/averageifs-arithmetic-mean-multiple-cri...
• 540 Hits
• Rating

• ### Index Function Learn how to use in Excel

The Index Function returns the value of an array given a specific row and column.
https://www.excelbuddy.com/excel-tutorial-database/index-function/
• 545 Hits
• Rating

• ### Index and Match Replace vlookups in Excel

Before reading this tutorial, please make sure you understand how to use the INDEX and MATCH function.
https://www.excelbuddy.com/excel-tutorial-database/index-match-replace-vlookups/
• 506 Hits
• Rating

• ### FV Function Future Value Calculation in Excel

The FV Function is built into Excel. It is a financial function used to calculate the Future Value of an investment.
https://www.excelbuddy.com/excel-tutorial-database/fv-function-future-value/
• 388 Hits
• Rating

• ### CUMIPMT Function 15yr Mortgage

The CUMIPMT Function in Excel is a financial function designed to calculate and return the cumulative interest paid on a loan.
https://www.excelbuddy.com/excel-tutorial-database/cumipmt-function-15yr-mortgage/
• 373 Hits
• Rating

• ### IPMT Function Calculate Interest of a loan

Ever want to know how much interest you are paying for a current loan for any specific period?
https://www.excelbuddy.com/excel-tutorial-database/ipmt-function-calculate-interest-loan/
• 344 Hits
• Rating

• ### Statistical Function in Excel: AVERAGE, AVERAGEIF, MODE

In this article you will learn about Statistical Function in Excel that includes AVERAGE, AVERAGEIF, MODE, MEDIAN, Standard Deviation, MIN, MAX, Large
http://www.certiology.com/tutorials/excel-tutorial/statistical-function-in-excel.html
• 6867 Hits
• Rating

• ### The ROUND Function in Excel: The ROUND, ROUNDUP and ROU

There are three functions to round numbers in MS Excel. The ROUND, ROUNDUP and ROUNDDOWN function. The ROUND function is used to round the fraction va
http://www.certiology.com/tutorials/excel-tutorial/the-round-roundup-and-rounddown-functio...
• 5519 Hits
• Rating

• ### Lookup and References in Excel: VLOOKUP, HLOOKUP, MATCH

Lookup and Referencing is a very important feature of MS Excel.
http://www.certiology.com/tutorials/excel-tutorial/vlookup-hlookup-match-index-and-choose-...
• 7651 Hits
• Rating

• ### Text Functions in Excel: Concatenate, Left, Right and M

String Manipulations in MS Excel facilitates its user to perform within string extraction. In this article you will learn about Text Functions in Exce
http://www.certiology.com/tutorials/excel-tutorial/text-functions-in-excel.html
• 5259 Hits
• Rating

• ### Find and Select in Excel: Replace and Go to Special Fea

MS Excel provides you the flexibility to use select, Find and Replace features to find specified text and replace it with your desired text.
http://www.certiology.com/tutorials/excel-tutorial/find-and-select-in-excel.html
• 4876 Hits
• Rating

• ### Date and Time Function in Excel

MS Excel supports multiple formats for data inputs. It also support date and time as a format and has the provision to apply various function over the
http://www.certiology.com/tutorials/excel-tutorial/date-and-time-function-in-excel.html
• 3980 Hits
• Rating

• ### Logical Functions in Excel: IF, AND &amp; OR Function in MS

MS Excel supports logical and conditional functions which enables the user to perform conditional evaluations. In this article you will learn about IF
http://www.certiology.com/tutorials/excel-tutorial/logical-functions-in-excel.html
• 5590 Hits
• Rating

• ### Count and Sum Function in Excel: CountA, CountBlank, Co

The count and sum function is MS Excel is very important. In this tutorial you will learn count and sum functions, CountA, CountBlank, CountIFs, SumIF
http://www.certiology.com/tutorials/excel-tutorial/count-and-sum-function-in-excel.html
• 5145 Hits
• Rating

• ### Share Data in MS Excel: How to Share Excel Data with Wo

MS Excel is highly versatile and supports sharing its contents with other programs. Contents can be shared from MS Excel to MS Word, MS PowerPoint and
http://www.certiology.com/tutorials/excel-tutorial/how-to-share-ms-excel-data.html
• 4837 Hits
• Rating

• ### Print in Excel: Print Gridlines in a Excel Worksheet

In this tutorial, you are going to learn about how to setup your Excel sheet for printing. You will learn how to set margins, setting the printing pre
http://www.certiology.com/tutorials/excel-tutorial/print-gridlines-in-an-excel-worksheet.html
• 4585 Hits
• Rating

« Previous 1 2 Next »