Cursos y Masters de EAE Distancia Semipresencial Cursos y Masters de DEUSTO Salud Cursos y Masters de UOCx Cursos y Masters de ITAE, Escuela de Negocios Cursos y Masters de Universidad San Jorge Cursos y Masters de Nett Formación Cursos y Masters de Teleformación Online Cursos y Masters de Aulacat Cursos y Masters de CEUPE - Centro Europeo de Postgrado y Empresa Cursos y Masters de HOME ENGLISH - Enseñanza de Idiomas a Distancia

Course of OpenOffice Calc - Advanced Leaf of Calculation

Precio 90 € - Cursos de especialización, OnLine de 50 horas - Titulación Emitida por el centro
Curso de Ofimática con OpenOffice.org Calc Hoja de Cálculo - Nivel Avanzado Curso de OpenOffice Calc - Avanzado  Folla de Cálculo Curs d“OpenOffice Calc - Avançat  Full de càlcul Curso de OpenOffice Calc - Avançado Folha de Cálculo   Course of OpenOffice Calc - Advanced  Leaf of Calculation   Cours d“OpenOffice Calc - Devancée  Feuille de Calcul
 
Justificación/Descripción del curso:

This application of leaf of calculation has a big practical utility to the hour to elaborate all type of documents where have to apply calculations so much simple, as more complex. With Calc will be able to no only have of multiple tools for the edition and presentation of data type text, numerical, dates... But also you will have the possibility to realise charts that represent of way more attractive and ordered the data contained in the leaf of calculation.

OpenOffice.org Calc Is a leaf of similar calculation to Microsoft Excel, with a rank of characteristics more or less equivalent. His size is a lot lower and provides a number of characteristics do not present in Excel, including a system that automatically defines series to represent gráficamente based in the disposal of the data of the user. Calc Also is able to export leaves of calculation like files PDF, has filters, car filters and can do groupings in dynamic tables that Lotus 123 in his previous versions did not do, possibly the version 9.8 of Lotus 123 have these possibilities.

Calc Can open and save the leaves of calculation in the format of files of Microsoft Excel. The format by defect of OpenOffice.org Calc Can fix so that it was the one of Microsoft Excel, or the format Open Document Format (ODF) .

Totally configurable, can modify any option of page, buttons, bars of tools and other options of language, autocorrección, spelling, etc.

The student will learn atrabajar cone the options advanced of OpenOffice Calc:


Work, protect and desproteger books and leaves of OpenOffice Calc

Works in series and in blouqes with OpenOffice Calc.

Work with formats and formulas advanced in OpenOffice Calc.

Work with Databases, generate charts advanced and handle macros that allow automzatizar procesor and generate complex reports.

Configure to the complete the leaf of calculation and other actions advanced that it allows us the program.

The process of learning base in the reading comprensiva of the different didactic units that comprise the course, visualisation in video of an explanation detailed of the treated in the unit, realisation of a practice in real time on an on-line simulation of the own program in the system and systematic realisation of the test of autoevaluación, besides the course is focused in an essentially practical sense with innumerable examples for each separated in which poses the most suitable form to explode the different options of the program, along the course. To surpass the course, the student will have to realise several practical cases posed by the tutors and surpass a final examination in the platform of and-learning.

Requisitos de acceso al curso:

There is not.
Headed to companies and particular that want to implant technologies Open Source for his usual tasks of creation and edition leaves of calculation and financial calculations

Temario cubierto por el curso:

1. BOOKS And LEAVES IN CALC
1.1. Select an or several leaves
1.2. Add and delete leaves in a book of calc
1.3. Change the name to a leaf of calculation
1.4. Copy and move leaves of calculation
1.5. Hide and show leaves of calculation
1.6. Protect leaves
1.7. Protect books
1.8. Save a file of calc

2. SERIES And DRAG FORMULAS
2.1. Fill up a group of cells
2.2. Create series of data
2.3. The use of the button of filled in formulas

3. FORMATS ADVANCED
3.1. Styles
3.2. Conditional formats

4. You FORMULATE ADVANCED
4.1. Introduction
4.2. References to cells
4.3. References to cells of other leaves or books
4.4. Copy and move references
4.5. Utilisation of names in the formulas
4.5.1. Administer the names

5. WORK WITH DATABASES IN CALC
5.1. Introduction
5.2. Ordenación Of a database
5.3. Filters
5.3.1. The automatic filter
5.3.2. The filter predetermined
5.3.3. The special filter
5.4. Subtotales
5.5. Agrupar And diagram of data
5.6. Ranks of data
5.7. Validation of data
5.8. Autocompletar
5.9. Consolidate data

6. FORMATS ADVANCED OF CHARTS
6.1. Create a chart
6.2. Elements of the chart
6.3. Modify a chart.
6.3.1. Change of type of chart
6.3.2. Format of the elements of a chart
6.3.3. Show/hide the cuadriculas of a chart
6.3.4. Realise changes to the legend
6.3.5. Add elements to the chart
6.3.6. Change the scale of the vertical axis
6.4. The circular charts
6.4.1. The labels of data
6.4.2. Change the perspective of a grafico circular in 3d and highlight a sector
6.5. Recommendations for the realisation of charts

7. I HANDLE OF MACROS
7.1. Introduction
7.2. Record a macro
7.3. Select and execute a macro
7.4. Show a macro like a button in a bar of tools
7.5. Security of the macros

8. CONFIGURE And PRINT LEAVES OF CALCULATION
8.1. Configure the leaf of calculation
8.1.1. Format of page
8.1.2. Edges
8.1.3. Bottom
8.1.4. Header and foot of page
8.1.5. Leaf 92
8.2. The preliminary sight
8.3. Previsualización Of the jump of page
8.3.1. Jumps of row and of column
8.4. Impression of a leaf of calculation
8.4.1. Impression of several leaves of a book
8.4.2. Impression of several cells selected
8.5. Use print ranks
8.5.1. Define a rank of impression
8.5.2. Remove a rank of impression
8.5.3. Print rows and columns in all the pages

9. IMPORTANT ACTIONS OF CALC
9.1. Export a document of Calc to format pdf
9.1.1. Introduction to the format pdf
9.1.2. Export a document of Calc to format pdf
9.2. Configuration of the language for the application
9.3. Orthographical correction of a document
9.4. Autocorrección
9.5. Impression of a leaf of calculation

Cursos relacionados con el actual por su contenido:
Puede ver otros cursos relacionados en las categorías:
Otros datos del Curso:

El curso Course of OpenOffice Calc - Advanced Leaf of Calculation está en nuestro Buscador de Cursos y Masters desde el 14/11/2011.

Etiquetas del curso:
Términos relacionados: