Excel Spreadsheets

Excel, Microsoft Office, PivotTables

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…

Relative vs Absolute Cell References

Excel, Microsoft Office

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…