Category Archive for 'Excel'

Simple Formulae

All formulae in Excel begin with an = sign.
Suppose you wish to add the contents of cell A1 and A2 and display the answer in cell A3, put the formua into cell A3:
=A1+A2
To add a column of numbers from A1 down to A10, and put the total in cell B1, you could put
=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10
in cell B1, but [...]

Cell References

Excel references each cell, co-ordinate style: With absolute references, letters denote columns and numbers are used for rows.  Hence B4, is the second column along (from the left) and the fourth row down.
(There is another style of cell referencing, called relative referencing)
To reference a range of cells (for example, the column of cells starting aown [...]

Menus, Toolbars, Mouse and Keyboard Shortcuts

As with many other Microsoft applications, there are several ways of doing things.
Excel’s commands can be accessed through the menubar at the top.
Clicking the righthand mouse button, while the cursor is in a cell, brings up a mini menu of mainly formatting options.
There are keyboard short cuts (such as [CTRL] and [SHIFT] and $ applies the currency [...]

Excel Basics

Excel works in a similar way to all other Microsoft Office products, with the familiar menu bar (by default, it starts with File, Edit, View etc…) at the top, plus a range of other toolbars that can be added, removed or customised. (the standard and formatting toolbars are shown by default)
An Excel workbook can contain several [...]

Using Excel for Accounts and Bookkeeping

The great thing about MS Excel (and others say it’s greatest downfall) is that it is so adaptable and because it normally comes bundled with the PC you bought for your business, it’s cheaper than buying accounting software.
For start ups and possibly for the sole trader or small limited company, it’s a very easy way of keeping track of [...]

« Prev