by @nicholasware | Mar 26, 2018 | Uncategorized
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...
by @nicholasware | Mar 19, 2018 | Uncategorized
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...
by @nicholasware | Mar 12, 2018 | Uncategorized
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,...
by @nicholasware | Mar 5, 2018 | Uncategorized
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...