Record Keeping

Inputting data in a spreadsheet

Excel® Pro Tip: Sumif

August 23, 2018
The "Sumif" app in Excel may be just what you need to sum data from individual fields within a category. Rather than restructure your data, this tool allows for customization.

Read more

Excel example

Excel Pro Tip: Conditional Formatting

April 11, 2018
This series — Excel Pro Tips — covers some of the best formulas, tables, conditional formatting, and other processes to help users manage their record keeping more efficiently. This week it looks at conditional formatting,which can change the formatting of cells to provide fast visual cues to potential discrepancies.

Read more