Excel – Creating a New Workbook

When you open a new file in Excel it is called a workbook. Workbooks are made up of columns which are labelled with letters, and rows which are labelled with numbers. Where a column and row intersect is called a cell. E.g the cell which is in the 3rd column across and the 3rd row down is called C3. When you click on it the row and column label are highlighted and the name appears in the white box, seen highlighted with a pink box in the picture below.

C3

Adding information into cells

You can add text, numbers or a mixture of both into cells. If you wish to perform calculations you can only use numbers. To type into a cell, click on it to highlight it and type away

In the picture below the text has been entered into column A but as there is no text in column B it flows over it making it look as if it also contains text. When you click on a cell you can see in the white box above (labelled fx) all the information it contains.

cell alignment

When you add text it automatically aligns to the left. Numbers automatically align right.

Dates – to enter a date for the current year, all you need to add is this the date in this format 08/06 and it will display it like this:

date

Again when you click on it, the full date including the year will appear in the fx box

Spell Checking

Unlike other members of the Office family, Excel doesn’t underline text you have spelt incorrectly as you go, you have to manually run a spell checker. To find this click on the ‘Review’ tab and the spelling button is on the left.

spell checker

To learn how to do this and more in a classroom environment come along to our Excel Essentials training

 

Share on LinkedInShare on FacebookTweet about this on TwitterShare on Google+Email this to someone

Related courses