top of page
Image by M. B. M.

Category: Office

Training type: Face-to-face.

Duration: 20 hours

Price: €169

Aimed at: Professionals and students in search of employment

Excel tricks to save hours of work

A 20-hour course oriented to the labor market in which you will learn techniques and tricks of totally practical application to stand out in your work.

The ultimate goal of the course is to learn how to improve daily work by automating processes and saving hours of repetitive work.

To take the course, some basic knowledge of the use of Excel formulas and properties will be required, although it is not mandatory to have used it recently since the first session will consist of a brief reminder on how to perform the main functions of Excel.

The trainer is Sara Míguez, an expert in banking, and working in the securities department of a major bank.  

At the end of the training, a diploma certifying attendance with the medium-high level acquired and the total number of hours completed will be delivered.

Additional information about the Course

Program:

BASIC LEVEL REVIEW:

  • Excel interface

  • Basic formulas of (SUM, COUNT, AVERAGE, IF..),

  • Basic filters, sort

  • Creation of tables

  • Formats

  • Exercises and practical application

 

KEYBOARD SHORTCUTS

 

FORMULAS

  • Conditionals (COUNT.IF, SUM.IF, AND, OR, NOT…)

  • Search and financial (VLOOKUP, HLOOKUP, MATCH, INDEX…)

  • Dates (WORKDAYS, TODAY, TIME..)

  • Exercises and practical application

 

CONDITIONAL FORMATS, ALERTS

  • What is conditional formatting?

  • Types of rules in conditional formats

  • Exercises and practical application

 

GRAPHICS

  • chart types

  • Customize charts

  • Create Templates

  • Combination charts

  • Exercises and practical application

 

DYNAMIC TABLES

  • What is a pivot table?

  • Components

  • Pivot table options

  • dynamic graphics

  • Exercises and practical application

 

WORD CORRESPONDENCE FUNCTION

  • What is the correspondence function?

  • How to combine Word and Excel

  • massive delivery

  • Exercises and practical application

bottom of page