CZK
USD
GBP
EUR
Čeština
Slovensky
English
French
German
Log in
Register
Shopping cart
(0)
You have no items in your shopping cart.
Home
About Courses
Course Design
What makes our courses so unique
Course Manager
Assessment
Tutorial
Excercises
Quiz
Localization
Advantages
Why you should choose us
Individual Customers
Details about studying on your own
Corporate Customers
Details about training your employees
Distributors
Detailed information for our valuable partners
Product Catalog(e-Shop)
Microsoft Office 365
Microsoft Office 2021
Microsoft Office 2019
Microsoft Office 2016
Microsoft Office 2013
Upgrade courses
MOS 2019
MOS 2016
MOS 2013
Free Courses
My Account
Impersonations
Setup who can manage your account
My Courses
Start your study online
My Account
Edit your profile, change the password or apply for a discount
My Orders
See all your orders
Support
FAQ
Has anybody asked your question already?
About Purchase
A guide to the order process from our e-shop
Purchase Conditions
Purchasing Procedure
Course Licensing
System Requirements
Will it run on my computer?
LMS Compliance
Contact
Contact us
About Gopas
All you wanted to know about us
Menu
Home
About Courses
Course Design
What makes our courses so unique
Course Manager
Assessment
Tutorial
Excercises
Quiz
Localization
Advantages
Why you should choose us
Individual Customers
Details about studying on your own
Corporate Customers
Details about training your employees
Distributors
Detailed information for our valuable partners
Product Catalog(e-Shop)
Microsoft Office 365
Microsoft Office 2021
Microsoft Office 2019
Microsoft Office 2016
Microsoft Office 2013
Upgrade courses
MOS 2019
MOS 2016
MOS 2013
Free Courses
My Account
Impersonations
Setup who can manage your account
My Courses
Start your study online
My Account
Edit your profile, change the password or apply for a discount
My Orders
See all your orders
Support
FAQ
Has anybody asked your question already?
About Purchase
A guide to the order process from our e-shop
Purchase Conditions
Purchasing Procedure
Course Licensing
System Requirements
Will it run on my computer?
LMS Compliance
Contact
Contact us
About Gopas
All you wanted to know about us
>
Product Catalog(e-Shop)
>
Microsoft Office 2019
>
MS Excel 2019: Intermedio
Courses catalog
Microsoft Office 365
Microsoft Office 2021
Microsoft Office 2019
Microsoft Office 2016
Microsoft Office 2013
Upgrade courses
MOS 2019
MOS 2016
MOS 2013
Free Courses
Recently viewed products
MS Excel 2019: Intermedio
MS Excel 2019: Intermedio
Instruction Language:
Spanish
Application Language:
Spanish
In the course MS Excel 2019: Intermediate, the presented interactive lessons focus mainly on performing various calculations. You will broaden your basic knowledge by the application of logical and text functions. You will get acquainted with the principles of referencing to the values in other cells. You will learn to fill cells with series of data. You will familiarise yourself with the advanced options of sorting and filtering data or searching for specific values in extensive tables. You will also examine how to split longer text entries in tables into individual data placed into several columns.
Product code:
ES-Exc19-Exc2
Try demo lesson
Online
Price
£ 15.00
£ 18.15 incl. VAT
Online Access Duration
*
30 days
90 days
12 months
24 months
36 months
Action
*
Assign it as New to my study account
Add it to my online licence list in my user profile only
Buy
×
Add to cart
MS Excel 2019: Intermedio - Online
List of lessons
Screenshots
Included in Packages
Specifications
Personalización de la barra de herramientas
Personalización de la cinta de opciones
Trabajo avanzado con múltiples hojas y libros
Opciones avanzadas de pegado
Copiar múltiples objetos
Pegar datos externos en Excel
Formatos numéricos avanzados
Formatos numéricos personalizados
Proteger una hoja de cálculo
Opciones avanzadas de tablas
Uso de referencias en fórmulas
Comparar y conectar valores usando operadores
Referencias de celdas
Reglas del formato condicional
Uso de fórmulas en el formato condicional
Biblioteca de funciones
Funciones de texto
Funciones avanzadas de texto
Funciones matemáticas
Funciones estadísticas
Funciones de fecha y hora
Funciones lógicas y cálculos condicionales
Funciones anidadas
Errores en celdas y su comprobación
Nombrar rangos de celdas
Validación de datos
Serie de relleno avanzada
Ordenar datos de manera avanzada
Filtrar datos
Usar segmentaciones para filtrar datos
Buscar y reemplazar valores específicos
Eliminar datos duplicados
Dividir texto en columnas
Relleno rápido
Esquema
MS Office 2019 – Biblioteca de 13 cursos interactivos
MS Excel 2019 – Conjunto de 4 cursos interactivos
Products specifications
System Requirements
ProductType
Single courses
ApplicationLanguage
Spanish
EducationLanguage
Spanish
Notice:
GOPAS e-learning needs your consent to the use of cookies on this web site. We use only the necessary technical cookies. Our website cannot be displayed without these cookies and they cannot be deactivated.
AGREE
×
Map
×
Demo lesson
×
Remove the company
Do you really want to remove the company?