Key Components Of An Excel 2007 Chart.

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

by Lynn Kramer

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 represented. In this article we will examine the various components of an Excel chart.

The first requirement is a set of data which can easily be converted into a readable chart. It is normally best to plot data which is a summary of your information. It is also useful if your data is arranged in columns or rows with headings at the top of columns or on the left of rows.

Click this line to read the rest of this article.

Transferring Excel Worksheets From One Workbook To Another

by Andrew Whiteman

Article: 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 all at the same time.

Not only can you move worksheets around within the same workbook, it is also possible to move worksheets from one workbook to another. For example, suppose we have a workbook containing a worksheet for each month of the year ("Jan", "Feb", etc.) and that we now would like to split this into four smaller workbooks, one for each quarter: the first containing "Jan", "Feb" and "Mar"; the second containing "Apr", "May" and "Jun"; and so on.

Click this line to read the rest of this article.

Using Different Formatting In The Same Cell In Microsoft Excel

by Carol Alexander

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 choose will then apply to all text within the cell or cells.

For example, if you wish to change the font size of your data in Microsoft Excel, you can of course use the drop-down menu next to the font name and choose one of the preset sizes. Another method of changing the size is to use the Grow Fond and Shrink Font buttons located on the right of the font size. These two buttons simply use the same preset sizes available on the preset size drop-down. Having activated the font size text box, you can also use the cursor keys on your keyboard to move through different sizes. Yet another method is to enter a particular size then press the enter key. When you do so, you are permitted to enter decimals, such as 10.5.

Click this line to read the rest of this article.

Inserting And Deleting Cells In Microsoft Excel 2007

by Carol Alexander

Whenever new cells are inserted into a worksheet, existing cells have to shift in order to make room to the newly inserted cells. When you insert entire rows or columns, the direction in which data will be moved is predetermined. If you insert an entire column, existing data is shifted to the right. If you insert an entire row, any existing data is shifted down. However, when you insert cells rather than entire rows or columns, Excel will always ask you in which direction we want the existing data to be shifted: to the right or down.

Click this line to read the rest of this article.

How to Separate Names/Data in an Excel Column.

I want to demonstrate in this article how you can separate the first name from a column with full names in it. This is a question we receive quite often. You can do this by using the SEARCH function.

How to Separate Names/Data in an Excel Column.

The first step is to create a column with full names.

Seperate-data-column-pic1

Now select the cells B2:B15

Seperate-data-column-pic2

Do you want to see more? This is related...

Essentials Of Formulas And Functions In Excel 2007

by Andrew Whiteman

As most of us know, to create an Excel formula, you start by typing an equal sign: this distinguishes it from other types of data. A formula is made up of a series of expressions. There are three main components in these expressions: mathematical operations, such as addition and subtraction; functions; and cell references.

To create a formula which gives us the total of two of the numbers in a spreadsheet (say 24 and 12), we could simply type "=24 + 12". When we press the Enter key, we would get the correct result. However, the formula would have no link to the two cells containing the numbers. If the content of the cells were to change, the formula would still return the old result.

Click this line to read the rest of this article.

Save Time With Cell Styles in Excel 2007

by Carol Alexander

Excel boasts a very wide variety of formats that you can apply to your cells. Naturally, when creating your worksheets you want your formatting to be consistent. Cell Styles provide you with an excellent way of achieving this.

Cell Styles are located in the Style section of the Home Tab of Excel’s Ribbon. When you click the Cell Styles button, the categorised Cell Styles gallery is revealed. The gallery provides a live preview; just hover over any of the styles to temporarily change the current selection within your worksheets, giving you a preview of what your data will look like if you choose that particular style.

Click this line to read the rest of this article.