|
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 (256x256). 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.
|
|