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 […]
Excel
Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.
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”.
Linked Checkbox – True / False
Before starting this tutorial, please ensure that you are familiar with adding a checkbox into an Excel worksheet. Also, it may help to download the demonstration file. Download
Linked Checkbox – True / False Read More »
Summing Only Positive or Negative Values
Learn how to sum only positive or negative values in excel. If you are an avid excel user, you will eventually have a need to only sum either
Summing Only Positive or Negative Values Read More »