Home »
Resources » Archive by tag 'Spreadsheets'
Microsoft Excel is a spreadsheet application for Windows and Mac. Its features include powerful calculation tools and graphing capabilities. It has been the most widely used spreadsheet application since 1993.
Over the years Excel has become an integral part of the accounting functions of many businesses, but can used be anyone who needs to organise data or figures effectively. It provides an easy and effective way to format and manage data, giving the user the ability to create a chart or graph with ease. Understanding and being able to use Excel is now a basic necessity for many companies.
Excel can seem complicated and intimidating at first. The aim of the tutorial that follows is to guide you through the basics. You can follow each stage step by step, or dip in to particular sections to learn a specific tool.
For a really comprehensive coverage of Excel we’d recommend attending one of our instructor-led training courses which are delivered by experienced industry professionals.
The courses available include:
Read more
Posted by Alistair Wylie in Excel 2007 Tutorial on May 1st, 2009 | No Comments »
Microsoft Excel Workbooks are made up of Spreadsheets. A Spreadsheet is organised into rows and columns of cells. The columns lettered and the rows are numbered. These numbers and letters combine to give each cell an address (e.g A1). All of this is covered in our Beginners Excel Training Course.
The contents of each cell can be entered via the formula bar. This is divided into two parts: the left side of the formula bar shows the cell address, and the right side shows the information that the cell is holding. If you can’t see the formula bar, select the “view” tab in the top menu and click the formula button in the show/hide section.
You can also see the total, mean, maximum or minimum of any numbers or cells by highlighting them and looking at your status bar. This is located at the very bottom of your excel window. If you wish you can also change the information the status bar gives by right clicking on the status bar and choosing its options in the Customize Status Bar Menu.
Excel Status Bar
Read more
Posted by Alistair Wylie in Excel 2007 Tutorial on May 1st, 2009 | No Comments »
The first thing that you will need to learn is how to move around a Spreadsheet. One way of doing this is to use the arrow keys on your keyboard to highlight a particular cell. The highlighted cell has a thicker black border than the others. Using the arrow keys you can move the selected cell up, down, left or right one cell at a time. You can also use the page up or page down keys to move a whole page at a time. All of this is covered in our Beginners Excel Course.
It’s easy to lose track of where you are in a spreadsheet – at any time you can hold the “Ctrl” key the “Home” keys together to return the selected cell to the top left of the sheet (cell A1). If you are new at this then it is worthwhile practicing this for a few minutes before continuing so as to get a better feel for moving around.
For a quick and easy way to locate a cell press the F5 key. This will open the “go to” box, where in you can enter the address of the cell that you want to go to, and be taken there immediately. Alternatively, you may find it easier to use the left part of the Formula bar at the top of your spreadsheet. Just type the address of the cell (e.g A1 or C4 etc…) and press enter
Read more
Posted by Alistair Wylie in Excel 2007 Tutorial on May 1st, 2009 | No Comments »
OK – we now know how to highlight cells, but we still don’t have any data in them!
Cells can hold all sorts of data, including text, numbers and calculations.
In order to enter data into a cell, first select it. After you have highlighted the cell you want, you can add data to it either just by starting to type straight away, or by clicking the in to the right hand side of the formula bar and typing there:
To delete any unwanted or incorrect information simply press backspace. If you highlight a cell that already has data in it and start typing, the original data will be wiped. If you want to edit the data that is already in the cell, highlight that cell and press F2.
After you are satisfied that you have put what you want to in the cell, press enter to finish or if you prefer use the directional key buttons or mouse to move to another cell or area.
All of this is covered in our Beginners Excel Course.
Read more
Posted by Alistair Wylie in Excel 2007 Tutorial on May 1st, 2009 | No Comments »
The basic mathematical formulae that you will need in a spreadsheet are as follows:
Formula
|
Keystroke
|
To add
|
+
|
To subtract
|
-
|
To divide
|
/
|
To multiply
|
*
|
Important: When entering any formula in to a cell, you must always start with a “=” sign
For example, lets say that in cell A4 you wanted to show the result of the numbers in cells
A1 and A2 added together. You would need select cell A4, type in “=A1+A2″ and press enter.
The result will then display as follows:
Note: Cell A4 now displays the result of the calculation.
If you look in the formula bar when you have the cell selected, it will display the formula.
Try changing the numbers in cells A1 and A2, and watch the result of the calculation on A4 change automatically.
This same method is used with each of the other four basic calculations.
Let’s change the formula in A4 to a multiplication instead of an addition. Select the cell, and click your cursor in to the formula bar above the spreadsheet where it currently says “A1+A2″. Replace this with “A1*A2″
and press enter. The result of the sum is now a multiplication.
The equation you choose can be as complicated as you want and can just contain numbers as well as call names: = 15+15. In the case of a more complicated equation excel will work out division and multiplication before and then move on to adding and subtracting. To prevent this you will need to tell it to do the adding or subtracting first. The way you do this is to put the bit you want done first in brackets, i.e. (1+2)/3< ><–>
All of this is covered in our Beginners Excel Course. Once you have mastered these skills you will be ready to attend our Advanced Excel Course, and really advanced might want to try VBA for Excel.
Read more
Posted by Alistair Wylie in Excel 2007 Tutorial on May 1st, 2009 | No Comments »
OK – so we can add the numbers in two cells together which is a good start.
Let’s say we want to add together a whole row of numbers. One way to do it would be to write a long formula – something like “=A1+A2+A3+A4+A5″. But that’s a right pain!
That’s why Excel has the “Auto Sum” button – it looks like this:
Try it out by entering a list of numbers that you want to add together in different cells one below the other – say A1-A4. Now highlight the cell below your list (in this case A5) press the Auto Sum button and hit enter. Excel will automatically add up the list of numbers by adding a formula to the cell. If you look in the formula bar, you’ll now see “=SUM(A1:A4)”.
Auto Sum also lets you add together numbers from a wider area. To do this, highlight the cell you want the result to appear in and press Auto Sum again. Now, instead of hitting return straight away, click your mouse cursor on another cell and drag to select a range of cells. Once you’ve selected the area you want to add up, hit return and Excel will write the formula for you.
Click image to view full size
Tip: A quick way to write any equation rather than having to type in every cell, is to select the cells you want with the mouse.
To try this out, type “=” into a blank cell, which from now on will hold your equation, and then click on a cell with a number in it. When you have highlighted this, press “+”. You will then see that this has been added to your formula bar. Now click on another cell with the mouse and see that Excel adds the cell reference to the formula. You can keep adding “+” and more cells as much as you like. When you’re done, simply hit enter to finish the formula.
Once you have mastered these skills you will be ready to attend our Advanced Excel Training Course, and really advanced might want to try VBA for Excel.
Read more
Posted by Alistair Wylie in Excel 2007 Tutorial on May 6th, 2009 | No Comments »
A number is never just a number! Numbers can represent currency, percentages, dates, times and a range of other things. We may also want to display a certain number of decimal points or other aspects of the way our numbers appear on a spreadsheet.
The “Number” section of the Excel ribbon provides a range of options which you can choose from in the drop down menu bar and even more if you select the “More Number Formats” button at the bottom.
The Number formatting section is located in the middle of the ribbon. Simply highlight the cell or cells containing the numbers you want to format, and then select the correct formatting option from the “Number” drop-down list.
Once you have mastered these skills you will be ready to attend our Advanced Excel Course, and really advanced might want to try VBA for Excel.
Read more
Posted by Alistair Wylie in Excel 2007 Tutorial on May 6th, 2009 | No Comments »
Customising Borders
In addition to the standard templates in Excel 2007, you can also customise your borders, adjusting their width, colour and line style. These options are contained in the Formatting section of the ribbon and the Border Options button. All of this is covered in our Beginners Excel Training Course.
You can also, as in Microsoft Word, change the font and style of the figures and words that you put into your cells, as well as being able to change their size and underline them. Simply highlight the cells you want to format and then select the appropriate border, font and text formatting options you require from the Formatting section.
Changing Cell Size
We’ve already explored how to wrap text to make it fit in to a small cell – however it is also possible to change the width and height of the cell columns and rows themselves.
To alter the row height, move your cursor over the column on the far left of your screen, to the left of A1, where the numbers of the rows are shown. Hover the mouse arrow over the division between two cells, i.e. the top of A2 and the bottom of A1, until it changes to an icon shaped like a cross with directional arrows at either end. Now all you need to do is click and hold the left mouse button and drag the up or down and the height of the cell row will change. The same method is used for changing the width of the cells, by clicking on the divisions between the columns at the top of the spreadsheet.
Once you have mastered these skills you will be ready to attend our Advanced Excel Training Course, and really advanced might want to try VBA for Excel.
Read more
Posted by Alistair Wylie in Excel 2007 Tutorial on May 6th, 2009 | No Comments »
