The Importance of Transparency

Nonprofits spend a lot of time in the limelight, whether from government oversight, rating agencies, donors, or the general public. People want to know that charitable giving is being used effectively and that nonprofits are acting responsibly. They’re required by law...

Highlighting and Removing Duplicates in Excel

If you have a list or table with duplicate values, you can highlight or delete them. To highlight duplicates, select the table and use Conditional Formatting. Select Highlight Cells Rules –> Duplicate Values. Select how you want duplicate cells formatted and...

SUMIF Function in Excel

Similar to the COUNTIF function, you can also add up a range of cells that meets a particular criteria. Let’s say you’re preparing a budget and want to see how much you’re paying in salaries for each department.  Using a list of employees, departments, and salaries,...

COUNTIF Function in Excel

In addition to the basic IF function, Excel can also count the number of cells containing certain parameters with the COUNTIF function. Building off the example used in the IF function linked to above, you can count how many people got certain scores on their...