NAKBOOK.COM – Tutorials for Software and Hardware

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 relating to the horizontal position your data: left, centre and right. However you'll notice that when you click in the cells of an unformatted worksheet, none of these three icons is highlighted, which indicates that none of them is the default. The reason for this is that Excel treats data differently depending on the data type.

If you type text in a cell, your text is aligned on the left; if you type a number, the number is aligned on the right; if you type a date, it is also aligned on the right. To set the horizontal alignment, you can either select a range of cells or click on a column letter to highlight the entire column then click on one of the alignment icons.

Haven chosen one type of horizontal alignment, you can change it in two ways. You can either click on a different form of alignment or click again on the already selected alignment. For example, if your text is centred and you click on the Centre button a second time, this deactivates centre alignment and returns you to the default alignment which, for text, is left. Thus we have, effectively, four types of horizontal alignment: left, centre, right and unspecified (or default), which is the alignment that applies when none of the alignment buttons is highlighted.

Microsoft Excel also allows you to specify the vertical alignment of your text. This setting becomes apparent when you increase the height of the cell and there is a definite default; text is normally aligned at the bottom of the cell. This default vertical alignment applies to text, dates and numbers alike.

To change vertical alignment, either make a selection or click on the row number to select the entire row then click on one of the buttons to make the change: align middle, align top and so forth.

Disclosure and Disclaimer

The alignment option also includes the ability to change the orientation of text within the cell. This is particularly useful in those situations where the headings are wider than the data within the cells. To change the vertical orientation of your text, you simply select the cells in question and then choose the appropriate orientation in the Alignment dialogue.

If you rotate your column headings by 90 degrees, you can usually make the columns much narrower. Excel has a very useful way of doing this: simply select all the columns that contain data then in the Cell group of the Home Tab of the Excel Ribbon, choose Format then AutoFit Columns. This command makes each of the highlighted columns no wider than it needs to be in order to display all the data it contains.

For more information on Excel VBA training courses, visit Macresource Computer Training, a UK IT training company offering Excel VBA Classes at their central London training centre.

categories: Microsoft Excel 2007,VLookup,functions,formulas,Excel 2007 training courses,Excel 2007,Microsoft Office 2007,tutorial,training,computer software,computers,software programs

Just about every person owns a computer but if you ask them they will tell you that there are many programs that they don't even use because they don't know how to use them such as Microsoft Excel, a lot of people don't use it because they don't know what it is but now with Microsoft Excel Training you can learn all the features in no time.

Computers are full of programs that some of us don't even know about because it just isn't an everyday program that we use. With Microsoft Excel Training you can now learn these programs and how to use them for what they are worth.

With training in Excel it can be helpful and useful that enables you to learn how the program works and operates.

There are a variety of ways that you can get Excel training such as videos, classes or a private instructor can all be very helpful and useful and allow you to learn about the Excel program how it works, operates and what all can be done with it.

If you are one that learns with the hands on way or needs more time from an instructor or teacher then by hiring a private instructor you will get one on one attention that is catered just to you.

Sometimes by talking with your local library or community college they can point you in a right direction of Excel classes sometimes these classes are offered through them or they have a way of knowing where they are going to be offered and when.

Rather an online class, instructional DVD or video is your choice it is strictly up to you on which one best suits your needs and how you want to learn.

Microsoft Excel training has many pros and cons it is up to you to determine which one are right for you.

You can get up to date information on Excel and Excel VBA training courses, visit On Site Training Courses . Com, an independent computer training web site offering Excel Classes all over the UK.

To create a chart in Microsoft Excel 2007, begin by selecting the data that you wish to plot including any headings. You then have the choice of creating either a stand-alone chart or an embedded chart. To create a stand-alone chart, simply right-click on one of your worksheet tabs and choose Insert. Next, click on the chart icon and click OK. Excel creates a chart using the default chart type.

Having just created a chart, Excel will display three contextual tabs headed "Chart Tools". The contextual tabs consist of Design, Layout and Format. The Design contextual tab enables you to change the chart type and the basic information about the chart such as the underlying data.

The Layout tab offers you a more intricate level of control over the various elements within your chart. For example, by default, Excel adds a legend to each new chart. If a chart has only one series of data, we don't need a legend to tell us what the chart colours mean. We can therefore click on the Legend drop-down menu and choose None.

The Format contextual tab gives us the most primitive control over your chart elements. It is here that we are able to click on individual items and change them at the object level. In other words, we are working on these elements purely as drawing objects rather than as elements of a chart. However, even at this primitive level, Excel still indicates the relationship between the chart elements and the underlying data. Thus, for example, when an individual data point is highlighted, Excel displays the corresponding worksheet address in the formula bar.

When creating standalone charts, you are not given the option of choosing the chart type during the chart creation process. If you want to change the chart type, you must do so at a later stage by choosing a Chart Type option in the Design contextual menu.

As for the chart sheet which contains the chart, it behaves in much the same way as a worksheet. It can be renamed or deleted by right-clicking the sheet tab and choosing Rename or Delete from the context menu.

If you would like to learn more about Excel and Excel VBA training courses, visit On Site Training Courses . Com, a UK IT training web site offering Excel training courses all over the UK.