Home » Excel » Page 14

Excel

Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.

Data Validation Techniques in Excel

We are going to cover Data validation techniques in Excel. Data validation is a very important feature of Excel document. This feature helps to prevent user from entering …

Pivot Tables

Overview: Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to display data in a table format with multiple filters, …

DATEVALUE Function

The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text – Date in text format. In the example below, we convert …

COUNTIF Function

The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to use this function. Below we are …

PMT Function

The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate. This formula will not work with a flexible …

SUMIFS Function

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to use one criteria. Criteria is specified using logical …

SUMIF Function

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common operators are >,<,<>, and =. Wildcard operators can …

If Function

The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns one value for “True” and another for “False”. …