DESCRIPTION:
 

The objective of the course is to provide participants with the knowledge of Excel in a short period of time. Upon completion, the participant will be able to develop spreadsheets using the most efficient techniques available in the program, master an important range of functions, obtain information from databases and use names in their formulas and functions. They will also be able to manage a list or database. The seminar is aimed at people who use Excel in their daily work as a tool for data analysis and for the preparation of summary, financial or statistical tables and need to be highly efficient in the development and presentation of information.

OBJECTIVE:
 

This first course aims to enable the participant to develop spreadsheets using the most efficient techniques available in the program.

AIMED AT:
 

People who use Excel in their daily work and who need to be highly efficient in the development and presentation of information.

CONTENTS:
 
  • Working with the Excel interface

  • Working with a shared file in Excel

  • Improve productivity when working with common models

  • Series creation.

  • Use schemes and groupings.

  • Working with functions.

  • Working with range names.

  • Working with lists.

  • Data protection schemes.

  • Use formats for cells.

  • Use form controls.

  • Pivot Tables.

REQUIREMENTS:
 

Conocimientos de Windows, conocer la interfaz de Excel, tener conocimientos de la operación general del programa.

BLOG ON SIGMA LEVELS

This blog is a quick guide to help HR departments choose the right belt certification for the right professional.

ELEARNING

We havean online learning system

IMPROVEMENT PROJECT

Resultssuccessful