31 March 2009
Using Microsoft Excel 2007's Freeze Panes Command
by 1 otherMany of the worksheets that are created Excel contain headings in the top row of the sheet. Normally, when we scroll down the sheet, any headings at the top will disappear. Similarly, if we scroll to the right, any headings on the left will disappear. ...
24 March 2009
Creating Split Worksheet Views In Microsoft Excel
by 1 otherThe Split command can be found in the View Tab of the Excel Ribbon. It allows you to split an Excel spreadsheet window into either two or four individual panes and is particularly useful for comparing data in different parts of a large worksheet.
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...
09 March 2009
COUNTIF AND COUNTIFS functions In Microsoft Excel 2007
by 1 otherThe COUNTIF function is used to count the number of cells in a given range which satisfy a condition. COUNTIFS does the same. However, here, we can specify multiple criteria. For example, let's say we have a worksheet containing four columns: the date,...
24 February 2009
Changing Formats In The Same Cell In Microsoft Excel
by 1 otherWhen formatting text within an Excel worksheet, you have the choice of working at the cell level or at the text level. If you wish to work at the cell level you simply highlight one or more cells and choose your format settings. Any formatting that you...
19 February 2009
Customising Text Alignment Microsoft Excel 2007
by 1 otherThe alignment section of the Home Tab of the Excel ribbon contains a number of options relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this section are the three rela...
Text Alignment Options In Microsoft Excel 2007
by 1 otherThe alignment section of the Home Tab of the Excel ribbon contains a number of options relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this section are the three rela...
1
(8 marks)
