October 2009
Different Forms Of Microsoft Excel Training
There are many different types of Microsoft excel training that can be used for any purpose. You can find extensive training or training on just certain areas of excel. There are individuals that excel at Microsoft excel training and can be scheduled t...
June 2009
Microsoft Excel Navigation Techniques
Each Excel document is called a workbook and each workbook can contain up to 255 worksheets. To navigate to a particular worksheet, click on one of the tabs displayed at the bottom of your screen.
April 2009
Essential Chart Elements in Microsoft Excel 2007
Charts are a quick and easy way of graphically illustrating trends within your data. One glance at a chart can make it very plain where there is a dip in sales figures, a surge in visitor numbers and a host of other trends in whatever data is being rep...
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. ...
Using The For-each Element To Loop In XSLT
by 1 otherExtensible Stylesheet Language (XSL) is an XML-related technology which is used to transform XML data. XML file are used to set the ground-rules for a given body of data and to describe the data itself. XSL allows us to take that data and convert it in...
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 easiest and most useful is click followed by Shift-click. This is particularly handy for highlighting large ranges of...
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...
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...
Using COUNT, COUNTA And COUNTBLANK in Microsoft Excel 2007
Excel contains a wide range of functions which are conveniently arranged into categories. The COUNT functions are found in the statistical category. There are five of them; COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. We will examine the COUNTIF an...
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...
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 ...
Creating Different Formats In The Same Cell In Microsoft Excel
When 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...
Microsoft Excel 2007 Text Alignment Options
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...
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...
Microsoft Excel 2007 Text Alignment Options
The 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...
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 ...
November 2008
Master Cisco Router Keys with Basic Simple Tutorial
Knowledge is power. This is valuable information. A very basic Cisco Router guide for anyone out there that wants to get their feet wet with the Cisco Router. Click here now!
1
(19 marks)
