0
Auto-fill context menu

What makes a good spreadsheet? Two things: good design and good data.

Continue Reading

2
The formatted budget

Creating a budget is of one the simplest and most useful tasks you can do using a spreadsheet. Here’s a step-by-step guide to simple budget creation in Excel.

Continue Reading

0

While word processing programs are the most commonly used office application and browsers are probably the most commonly used application of all, much of the success of personal computers is due to spreadsheets. In 1979, two blokes – Dan Bricklin and Bob Frankston – developed the first spreadsheet. Their creation was called VisiCalc and it […]

Continue Reading

6
Shading Excel rows

I sometimes wonder whether Microsoft spends so much on its programming budget it has little left over to spend on designers. This thought often crosses my mind when working with Office sample files, templates and styles. Take, for example, the auto-formats supplied with pre-2007 versions of Excel. Who designed these things? Not only are they […]

Continue Reading

0

When you refer to a cell in an Excel formula, you can use any of three different ways of referring to that cell, known as relative, absolute and mixed references. Relative cell references are the most commonly used. A relative cell reference in a formula is based on the position of the formula’s cell relative […]

Continue Reading