Category 'Microsoft Office'

25
Mar

Dr. Seuss

Microsoft Office, Windows | Comments Off on Dr. Seuss

I have a class designated as “lab” for county employees to ‘drop in’ with their questions and get them addressed. Problem is, the ‘class’ is offered only one half day a month, and employees are required to sign up to indicate that they’ll be there. The first class was offered in February, and nine people […]

1
Mar

Grouping Dates in PivotTables

Excel, Microsoft Office, PivotTables | Comments Off on Grouping Dates in PivotTables

 I have a client that is tracking sales. We have over 100 individual records, and the data source is going to grow through out the year. With multiple sales each day, we’ll want to be able to sum total sales at each week. PivotTables are the obvious answer. We need to group by calendar week, […]