Excel Advanced

Capacitación: Alta Dirección   Duracion: 08Hrs.

THIS COURSE IS MEANT FOR

All people, in general from service or manufacturing companies.

DEVELOPING COMPETENCIES:

Performance orientation, continuous improvement, critical capacity.

OBJECTIVE

At the end of the course, the attendant will be able to apply correctly the skills in Excel program as dynamic tables, and use of Macros.

TOPICS

I. CONSOLIDATE INFORMATION

A. Multiple work

II. IMPORT DATA

A. From text

B. From Web

C. Access

D. ODBC

III. GET EXTERNAL DATA

A. Import data

B. New Web Query

C. New data base query

IV. ANALYSIS AND YES

A. Seeking a purpose

B. Scenarios

C. Solver

V. TABLES AND DYNAMIC GRAPHICS

A. Design area, line, column, page, and data

B. Create an Excel table

C. Format

D. Filters

E. Calculated fields

F. Create a Dynamic Graphic

VI. MACROS

A. What is a Macro?

B. Macro recorded

C. Different ways to execute a Macro

D. Create a personalized function

E. Automate a report

F. Create an application of Macros

BENEFITS

  • At the beginning a diagnostic test shall be applied to know the audience levels
  • A manual shall be delivered for each attendant
  • The course includes practices for each topic
  • At the end of the course shall be applied a test about the knowledge of the explained topics

 

 

Temarios Cursos- Español

¡Recibe información Completa en tu correo!
  • This field is for validation purposes and should be left unchanged.