Category 'Excel'

1
Jul

Relative vs Absolute Cell References

Excel, Microsoft Office | Comments Off on Relative vs Absolute Cell References

Cell references When creating formulas, we use cell references rather than actual values to show Excel which cells to use in the calculation. By referencing which cell to use in a formula. when the value of the cell changes, the result of the formula updates automatically. By default a cell reference is relative, which allows […]

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