MS Excel 2019: Herramientas para expertos

Instruction Language: Spanish
Application Language: Spanish
In the course MS Excel 2019: Expert Tools you will familiarise yourself in detail with various options of external data import from other formats compatible with Excel. You will also learn how to export data from Excel to these formats. The course later focuses on pivot tables and pivot charts, covering also their formatting, sorting and filtering of data as well as using them in further calculations. Beside that you will become familiar with several advanced functions and Excel features that will help you to process data in larger databases.

Product code: ES-Exc19-Exc4


£ 15.00
£ 18.15 incl. VAT info
  • Validación avanzada de datos
  • Función DESREF
  • Filtro avanzado
  • Funciones de base de datos
  • Función SUBTOTALES
  • Funciones SI avanzadas
  • Funciones BUSCARV y BUSCARH
  • Funciones INDICE y COINCIDIR
  • Datos externos de la web
  • Datos externos desde el programa MS Access
  • Complemento Microsoft Power Query
  • Datos externos desde Microsoft SQL Server
  • Datos XML
  • Tabla dinámica
  • Formato de tabla dinámica
  • Ordenar y filtrar elementos de campo
  • Cálculos en tablas dinámicas
  • Otras opciones de la tabla dinámica
  • Modelo de datos
  • Gráfico dinámico
Products specifications

System Requirements

ProductType Single courses
ApplicationLanguage Spanish
EducationLanguage Spanish