Microsoft Excel Tutorial 0: Structure, Worksheets, Columns, Rows, Data Editing, Save смотреть онлайн

Excel = spreadsheet application. All information shown here is also applicable to LibreOffice and OpenOffice.

Excel helps us create:
- Calculations
- Charts,
- Databases
- Complex mathematical models
- With VBA even applications.

Basis of all Excel work is the workbook.
Each Excel file is a workbook, containing one or more worksheets aka tables.

Each worksheet or table is independent of the others.
You can reach any table simply by clicking on its name.

The maximum number of worksheets in an Excel file depends on how much RAM your computer got.

Each table's name can be easily changed. Double click its name and enter new name.

Tables' order can altered by dragging tables around to their desired position.

Add more tables by clickin on the Insert Worksheet button.

The four arrows at the left of the table names help navigate through the tables, helpful if Excel contains many tables.

To delete tables: Right click the table name and then select Delete

Each sheet contains columns and rows. The columns have alphabets as identifiers while the rows are identified by numbers.

Maximum Number of columns in a sheet: 16,384
Maximum Number of rows: 1,048,576

Each box is called a cell. Each cell is identified by the column and row identifers.
Ie:
B2
E19

To edit data we have one of three alternatives:
A. Click in cell and replace whole content
B. Double click into cell and edit parts of content
C. Click cell and then edit content in the so-called formula bar