Posts Tagged ‘ tutorial ’

Excel allows you to change the order of worksheets within a workbook at any time. There are two ways of achieving this, the first of which is simply to drag the tabs representing each worksheet left or right. As well dragging individual tabs, it is also possible to highlight several tabs and drag them...
Read more »

Microsoft Excel offers a number of different ways of inserting new sheets into your workbooks. One of the most straightforward methods is to use the Insert Worksheet button. This can be found to the right of the worksheet tabs. Irrespective of which worksheet is active, clicking this button will always insert a worksheet as...
Read more »

The COUNTIF function is used to calculate the number of cells in a given range which satisfy a condition. COUNTIFS does pretty much the same. However, this time, we can specify multiple criteria. By way of illustration, let's say we have a worksheet containing four columns: the date, the number of phone calls received,...
Read more »

Microsoft Excel offers us a number of different ways of changing the width of columns and the height of rows. The width of columns is expressed as the number of characters the cell can hold. By default, Excel gives each column a width of just over eight characters. This means, for example, that if...
Read more »

In this article, we will examine some of the more useful Excel selection techniques; namely those which involve using the mouse in conjunction with the keyboard. One of the most useful is click then Shift-click. This is particularly handy for selecting a large range of data since it allows you to simply click on...
Read more »