Excel | Geekgirl's

Spreadsheeting II: Good Spreadsheet Design

What makes a good spreadsheet? Two things: good design and good data. This may sound obvious, but it’s all too easy to dive into creating a spreadsheet without putting much thought into its design. And a poorly designed spreadsheet is bound to make it harder to enter...

How to use a spreadsheet to create a simple budget

Basic Computing, Excel, Featured, Office Apps

Creating a budget is of one the simplest and most useful tasks you can do using a spreadsheet. By using a spreadsheet, any changes you make to your budget are instantly updated across the whole budget, with totals calculated for you. This tutorial shows you how to...

Spreadsheeting I: Basic concepts

Basic Computing, Excel, Office Apps

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 –...

Shading every other row in Excel

Excel, Office Apps

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...

Understanding Excel references

Excel, Office Apps

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...