Curso Macros y VBA Excel Udemy

sábado, 20 de julio de 2013

Excel 2010. Pivot Tables. Session 01.





Hi everyone.!!!!!!!!!!!!!!!!!!!


First session dedicated to the Pivot Tables in Excel 2010. This tool allows you to analyze and summarize large amounts of information stored on different types of data sources, for example Excel, SQL Server, Access, etc... In this session we explain the first steps to create a PivotTable.

Pivot tables are useful when you need to get statistics from a large amount of data. For example, with the data of deposits in a bank can ask the following questions.
  • How much money has been deposited in each branch?
  • How much money has been deposited in each account type?
  • What is the difference between the year 2010 and 2011?

Well, no problem. To respond to questions such as these, we have the pivot tables. At the end of this video, you will be able to create pivot tables to respond to these questions and many more.


Todos mis vídeos son Gratis, pero si te gusta mi trabajo, puedes realizar una donación para que pueda continuar con este proyecto. Cualquier cantidad desde 1€/1$ es bienvenida. Gracias!!!!!!!!!!!!!!


To follow the explanations of the video you can download the following Excel file.


Here you have the video information and the link to the video:

  • Nombre: Excel 2010. Pivot Tables. Session 01.
  • Level: Intermediate.
  • Version of Excel: US/English.
  • Audio: Spanish.
  • Subtitles: English/Spanish.
  • Total Length: 13m 20s.
  • Length Video 113m 20s.



See you at the next session. ;)

No hay comentarios:

Publicar un comentario