Skip to main content
Programa

Office Information Technology Essentials

¿QUIERES SOLICITAR INFORMACIÓN?
Registration
Category:

Entorno Económico y Operaciones

Mode: Presencial


Information

Goals and Student Profile

After completing the course the participant will be able to:

  • Organize and properly structure the measurable information in the company.
  • Plan and troubleshooting the most optimal way possible, without loss of time.
  • Use, at advanced level, a tool essential for the handling of numerical data of the company.
  • Represent numerical data graphically through diagrams of different types and enable the company responsible for a better diagnosis of it.
  • Perform data crosses using a tool “Dynamic Tables” that provide a more comprehensive state of the company.
  • Solve diagnosis using a tool “Solver”, which allows the simulation of different situations you might encounter and how to fix in the company.

Curriculum

INTRODUCTION

  1. Definition
  2. Elements of Excel 2007
  3. Data entry, formulas and some functions
  4. Formatting boxes
  5. Learning to move in the spreadsheet effectively
  6. Copy and move data to implement calculations quickly
  7. Use absolute references
  8. Use auditing tools to get formulas, functions and to locate errors quickly.
  9. Learn how to work with large spreadsheets.
  10. Printing options.

WORKING WITH DIFFERENT SPREADSHEETS

  1. Using multiple spreadsheets
  2. Learning to work in group and format to fill several spreadsheets at once
  3. Enter formulas and functions that contain references to cells that are in different boxes.
  4. Appoint spreadsheets
  5. Add spreadsheets
  6. Remove spreadsheets from workbooks

CONDITIONAL AND SEARCH FUNCTIONS

  1. The conditional functions
  2. The search

GRAPHICS

  1. Learning to build
  2. Change
  3. Format
  4. Interpret different types of Excel charts

TABLES IN EXCEL

DATABASE IN EXCEL

  1. Sort a database by one or more columns
  2. Find and filter data
  3. Use advanced filter to copy to another part of the spreadsheet data from a database that meet certain condition.
  4. Use the subtotals option to group records by a particular field or column and apply functions of addition, average etc…on the value of one or more fields.
  5.  Build dynamic tables, these serve to summarize and group data quick for their analysis and calculations that can be used to review or forecast trends.
  6. Statistical Functions

TARGETING

  1. Search for targets within formulas
  2. Advanced tool: SOLVER
  3. Practical examples

SCENARIOS

  1. Create, view, delete and Scenario Manager.
  2. Practical examples

WORKING WITH DIFFERENT BOOKS

INTRODUCTION TO MACROS IN EXCEL

Faculty

MARTINEZ DE DUEÑAS, ALFREDO PABLO
Degree in Information Technology, Faculty of Information Technology Studies, University of Malaga.
More details
Director of the IT Department at Pyme Sistemas Informáticos, a company dedicated to the support and maintenance of corporate computer networks, and Secondary School teacher at Colegio Cipriano Galea Professor at Enae Business School in the Programming and Office Software areas of the MBA and Master in Legal Counseling. Implementation of Computer Systems in companies such as Olimpic Import, R & D Asistencia,, Assur Asesores, Coteca Consulting, Viajes Diana, Cajamurcia Agrícola..

Specified time period and Place

Specified time period:  This course has and extension of 20 contact hours at ENAE premises.

Timetable: This course is delivered on Wednesday and Thursday from 16:30 h. to 21:30h.

Place and Address:

Edif. ENAE. Campus Universitario de Espinardo 30100 Espinardo Murcia- Spain


Ver mapa más grande

Methodology

  1. Theoretical presentations alternated with practical exposure so as to see their relationship with results in business. The interrelation between theory and practice is a methodology in which students must be involved. This methodological issue will be used for both business executives and professionals, and for recent graduates who want to join the same course.

  2. Several case studies are sent from those that companies have been facing in real life for students, with the relevant knowledge acquired, to do the analysis between the different lines of action that may arise and choose the one considered more realistic and adjusted to the case. The student should become accustomed to making decisions and understand the implications of them.

  3.  Case studies and readings will be sent to participants through the virtual campus. At the same time chat forums or debate centres may be created on campus or virtual in which the views of the participants will be contrasted. . These tools will be used by the students to contrast their different points of view.

  4. Virtual Campus is a tool that allows a much more fluid relationship between students and teachers at personal and on line level.

  5. Teaching the course will take into account how the student intends to apply the knowledge acquired to the final project at the end of the Master.

Terms of Payment and Scholarships

Are you interested? Obtain the following benefits:

Price: 390 €

ENAE Business School offers the following discounts:

Partner companies of FUERM, their workers, and the members of Asociacion de Antiguos Alumnos of ENAE Business School will obtain a 10% of discount.

See if your company is a member of FUERM and ENAE

Scholarships

If the amount of the program is paid by your company through the credit offered by the Tripartite Foundation you may recover all or part of the amount of the program in ENAE Business School, discounting the amount to be credited for the payment of social insurance.

Part of the amount paid of our training programs, in-person and In Company, could be recovered through the Tripartite Foundation (only Spanish companies).

Ask us for more information. We make the process for obtaining the discounts to all those students who request it, at no additional cost to your training.

Admission Process

This program is part of a Master that has limited availability. Taking this course will provide you great oportunities for expanding your professional networks. Final admission decision is reserved to ENAE Business School on the basis of prerequisites established for the course, room availability and specific group profile required.

FACULTY

PROG-OP-INF-GESTION-
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Throughout our 25 years of life,
more than 13,000 students have trusted
the excellence and quality of training of ENAE Business School.

COMPÁRTELO