<Back to main knowledgebase index>

How do I analyze my Excel spreadsheet by Contact, Project, Billable, etc.?

The best way to do this is by using Filters which is a feature within Excel. Filters enable you to select only rows with (for example) Contact A, or Contact A and Project B, or Contact A and Project B and Billable Time, then you can see those records and total them up. It takes seconds to do.

There are two good overviews of how filters work at

http://www.contextures.com/xlautofilter01.html

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=60

If this doesn’t answer your question please complete a Support form.

<Back to main knowledgebase index>