Home » Excel » Page 14

Excel

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

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, …

Pivot Tables Read More »

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 …

PMT Function Read More »

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 …

SUMIFS Function Read More »

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 …

SUMIF Function Read More »

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”. …

If Function Read More »

Scroll to Top