May 21, 2011 | bkdtharanga | Excel | No Comments
Sometimes when working in Excel, it can be handy to set it up in a way that you would most commonly use. In other words, change its default options. To do this, go to Tools>Options.(Please Don't use this excel 2007/2010) This will display the Options dialogue box. On this dialogue
[ read more ]
May 21, 2011 | bkdtharanga | Excel | No Comments
When working in Excel, there are times that you may need to insert an entire new row, an entire new column or only a single cell. Although the term Inserting gives the impression that you are actually adding another row, column or cell, you are in fact NOT. You may remember that in the first lesso
[ read more ]
May 21, 2011 | bkdtharanga | Excel | No Comments
By default, when you Copy and Paste the content of any cell(s), Excel will Paste all cell formatting. We can, however, use what is called Paste Special to nominate the attributes of the copied data we wish to Paste. To do this, again Copy the cell(s) in any of the above methods (e
[ read more ]
Sometimes when working in Excel, it can be handy to set it up in a way that you would most commonly use. In other words, change its default options. To do this, go to Tools>Options.(Please Don't use this excel 2007/2010) This will display the Options dialogue box. On this dialogue
[ read more ]
When working in Excel, there are times that you may need to insert an entire new row, an entire new column or only a single cell. Although the term Inserting gives the impression that you are actually adding another row, column or cell, you are in fact NOT. You may remember that in the first lesso
[ read more ]
By default, when you Copy and Paste the content of any cell(s), Excel will Paste all cell formatting. We can, however, use what is called Paste Special to nominate the attributes of the copied data we wish to Paste. To do this, again Copy the cell(s) in any of the above methods (e
[ read more ]
Excel has yet another way to Copy (not Cut) data in cells and this is via the Fill Handle . You may have noticed that when you select a cell or range of cells the bottom right of the outlined cell or range has a small black square. This is called the Fill Handle. The Fill Handle can be used
[ read more ]
Copying, Cutting and pasting is something you will no doubt be doing an awful lot of when working in Excel, especially when you Start to use formulas to perform calculations. The reasons for this will become more apparent when we cover the basics of Excel formulas in later lessons. For now, we
[ read more ]
In a spreadsheet the CELL is defined as the space where a specified row and column intersect. Each CELL is assigned a name according to its COLUMN letter and ROW number. The method that Excel uses to reference these cells (as a default) is called the A1 style reference. When we refer to
[ read more ]
All Workbooks must contain at least one Worksheet. The maximum number of Worksheets a Workbook can contain is limited only by the available memory of the PC. As a default, Excel places three blank Worksheets in front of you. Each one of these has the default name Sheet1, Sheet2, Sheet3 at th
[ read more ]
The Toolbars in Excel are where all of Excel’s features can be accessed. They contain both text and icons (pictures). The main toolbar in Excel is called the Worksheet menu bar and it is normally found under the Title bar. On this toolbar you will find nearly all the options available for yo
[ read more ]
Before we go into any detail at all we need to know how to Start Excel. Starting Excel is no different to Starting any other Microsoft applications (Word, PowerPoint, Publisher, Access etc. ) and can be done in any number of ways. The three most common ways to Start Excel are: From th
[ read more ]
Spreadsheets have been in use on personal computers now for some years. They are used in nearly every office environment in the world for any number of reasons. In the past they were used only to perform basic math, such as adding, multiplying, subtracting and dividing. Today's spreadsheet
[ read more ]
The Toolbars in Excel are where all of Excel’s features can be accessed. They contain both text and icons (picture...
Spreadsheets have been in use on personal computers now for some years. They are used in nearly every office envir...
Before we go into any detail at all we need to know how to Start Excel. Starting Excel is no different to Starting a...
elearningweb.net