Microsoft Excel Training Videos

Concept of a 'cell address' and an introduction to what you can do in Microsoft Excel


When you start Microsoft Excel a page or 'sheet' with many cell like structures appears. Each Excel cell has an 'address', indicationg 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). 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 can you do in Microsoft Excel?
  1. You can calculate, analyze and share data in Excel. At the most basic level you can calculate your expenses and monthly payments
  2. Solution optimization using the Solver
  3. Advanced modeling and numerical simulation in Microsoft Excel
  4. Create games with Microsoft Excel
  5. More Excel applications
  6. Creating Excel applications



Custom Search
Back to List of Microsoft Excel Training Videos