/* old script */ /*added 30-11-14 */

Absolutely PC - Making I.T. working for you

call us on: 0117 975 9523

sign up to our newsletter

Full Name (required)

Company

Your Email (required)

Please see our privacy policy

Menu

Category Archives: Microsoft Excel

Excel – Relative and Absolute Cell References

By understanding that Excel treats all references as relative it is possible to take control of the fill down command using absolute references when required. With only a small amount of theory you will be able to build spreadsheets more quickly and accurately by understanding relative and absolute references Continue reading

Posted in Microsoft Excel, Tips | Tagged , , , , , , , , | 1 Comment

Excel – using the fill down command to autofill your spreadsheet

Using the fill down command in Microsoft Excel allows an increase in speed and accuracy but in addition allows formulas to be quickly and easily used throughout a spreadsheet. Continue reading

Posted in Microsoft Excel, Tips | Tagged , , , , , , , , , , | 2 Comments

Excel – using the IF function to tidy up your spreadsheet

The use of the IF function in Microsoft Excel is one way to ensure that zeros and errors are not displayed on a spreadsheet but formulas contine to work. Continue reading

Posted in Microsoft Excel, Tips | Tagged , , , , , , , , , , , , , | 1 Comment