Introduction to Excel 2003 including a sample training video:
When you start Microsoft Excel a page or ‘sheet’ with many cell like structures appears. Each Excel cell has an ‘address’, indicating its position in the Excel worksheet. The cell address specifies the Excel column number and the row number. For example a cell address ‘A1’ specifies column ‘A’ and row ‘1’. A Microsoft Excel 2003 worksheet has 256 columns and 65536 rows (256×256). Excel 2007 has 1,048,576 rows by 16,384 columns. You can enter text, numbers including dates and formulas in the cells. The data in the cells can be formatted using standard procedures. Using the values at the cell addresses you can perform calculations. For example, if the value at cell address ‘A1’ is 25 and the value at cell address ‘B1’ is 4, then if you write the formuala ‘=A1*B1’ at cell address C1, the resultant value at cell address C1 will display ‘100’. Now assume for a moment you made a mistake. You wanted to actually enter ’35’ in cell ‘A1’. Click on Excel cell ‘A1′, enter ’35’ and check the result in cell ‘C1’. The value at cell address C1 has automatically been updated to ‘140’! You can access values at addresses in other Excel sheets also and perform the required calculations. This is what makes Microsoft Excel so powerful.
What other things can you do in Microsoft Excel?
- You can create sales invoices, purchase orders and packing lists.
- You can create a cash flow statement, income statement, profit and loss statement and a balance sheet. It is one of the most versatile programs to perform financial analysis.
- You can create budgets, for example, a party budget, a retirement budget or an R&D budget.
- You can forecast growth of a company or you can report the actual performance of a sales person compared to her expected performance.
- You can use Excel to plan a marriage party or create a marketing plan for a quarter.
- You can track the number of hours worked per week by each of your staff using the time function.
- You can use Excel like a calendar with date functions to, for example, track milestones.
- Using Gant charts you can monitor the progress of a project
- Some programmers have created quizzes and games in Excel
- There are others who have used the software in Engineering like designing a complete cooling system for a laboratory along with the cost.