|
Finding and starting of Excel
|
|
Elements of Excel window and setting of form and content of the window
|
|
Moving and marking in worksheet and map
|
|
Inserting, changing and deleting of data in cells
|
|
Archiving and opening files with tables and inserting changes
|
|
Series of data (rows), create and use
|
|
Inserting of rows and columns and calculate new values
|
|
Creating of tables and data inserting: numbers, text, formulas
|
|
Cell format, number of decimals, values, etc.
|
|
Data sorting in the table
|
|
Using of basic mathematical and logical function: SUM, AVERAGE, IF, MIN, MAX
|
|
|
|
Creating of header and footer
|
|
Understanding and using of relative and absolute address in formulas
|
|
Creating different diagrams and charts from tables and analyses of data
|
|
Editing of charts (title and axis, legend, labels)
|
|
Creating formulas between tables
|
|
Using of integral software wich has text processor, data base and graphic software.
|
|
|
| |
|
|
|