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...
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/
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
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...
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
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
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
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
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
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
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
The protection level implemented in MS Excel is password protected and hence, without a correct password, it cannot be unlocked. To make your Excel fi http://www.certiology.com/tutorials/excel-tutorial/protecting-a-workbook-in-ms-excel-with-...
In MS Excel, you have plenty of keyboard shortcuts available that will help you performing your tasks in a quicker way. This tutorial will discuss the http://www.certiology.com/tutorials/excel-tutorial/excel-keyboard-shortcuts.html
Microsoft Excel provides the flexibility to use these formulas and functions in an entirely convenient manner. As long as you have the understanding a http://www.certiology.com/tutorials/excel-tutorial/formulas-and-functions-in-ms-excel.html