March 2009
Microsoft Excel 2007 Selection Techniques
by 1 otherIn this article, we will look at Excel selection techniques which involve using the mouse in conjunction with the keyboard. One of the most useful is click followed by Shift-click. This is particularly useful for selecting large ranges of data since it...
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,...
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...
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...
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...
Changing Formats 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 at the cell level or at the text level. To work at the cell level you simply highlight one or more cells and choose your format settings. The formatting that...
Concatenating Data In Microsoft Excel
by 1 otherConcatenation is the process of stringing together different pieces of information to form a new piece of data. For example, if we have columns containing people's title and first name and another containing their last name, we could use concatenation ...
Common Mistakes Made by Users of Microsoft Word
by 1 otherEverybody knows Microsoft Word. It's on almost every PC in the world and fair few Macs as well. However, a lot of users have picked up bad habits, things that detract from the usefulness of the document being created. This article looks at the most com...
January 2009
Select Text With The Mouse In Word 2007
by 1 otherBefore you can edit or format a block of text in Microsoft Word 2007, you need to select it. Selecting the text is a way of telling Word that you want to work with a certain piece of text. (Selecting is also referred to as Highlighting.)
Using Custom Lists And AutoFill In Excel 2007
by 1 otherExcel\'s AutoFill feature relies on the program\'s ability to recognize patterns in the data that you enter. For example, if you type \"Week 1\" in a cell, you can have the program automatically fill in \"Week 2\", \"Week 3\", etc. by using the AutoFil...
December 2008
Excel 2007 Number, Currency And Accounting Formats
Often, when you enter numbers into a spreadsheet, you need to ensure that the number format is consistent. For example, if these numbers are prices, you may want to display the currency symbol or you may simply want to specify that the number of decima...
Excel 2007 Number, Currency And Accounting Formats
by 1 otherWhen entering numbers into a spreadsheet, you sometimes need to ensure that the number format is consistent. For example, if the numbers in question represent prices, you may want to display a currency symbol or you may simply want to make sure that th...
1
(12 marks)
