Category 'Excel'

3
Jan

Excel Spreadsheets

Excel, Microsoft Office, PivotTables | Comments Off on Excel Spreadsheets

Local Support with Excel Spreadsheets: The Power of Excel A spreadsheet is little more than columns and rows, comprised of lists and lists. The real power in Excel spreadsheets is when you use Formulas and/or Functions. Formulas and Functions aren’t the same Contact us using the form below or give us a call if you […]

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, […]