16 March 2009
Excel 2007 Selection Techniques
by 1 otherIn 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...
14 March 2009
Adjusting Row Height In Microsoft Excel 2007
by 1 otherMicrosoft Excel measures row height in points, the same units used to measure font size. When creating reports this makes it easy to relate the height of rows to the required line spacing. This means that you can increase the line spacing simply by inc...
Excel 2007 Selection Techniques
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...
12 March 2009
Using The COUNTIF Function in Microsoft Excel 2007
by 1 otherThe 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 co...
24 February 2009
Using Different Formatting In The Same Cell In Microsoft Excel
by 1 otherWhen changing the appearance of text within an Excel worksheet, you have the choice of working on the entire cell or at the text level. To work at the cell level you simply highlight one or more cells and choose your formats. The formats that you choos...
19 February 2009
Customising Text Alignment Microsoft Excel 2007
by 1 otherThe alignment section of the Home Tab of the Excel 2007 ribbon is home to a number of options relating to the way in which your data is position within the cell. The most familiar and most frequently used icons in this section are the three relating to...
Creating Cell Styles in Microsoft Excel
by 1 otherIn addition to using and modifying Excel's built-in cell styles, you also have the facility of creating your own. A convenient method of doing this is to highlight a range of cells and apply all the formatting attributes that you would like your style ...
1
(7 marks)
