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