BannerAnuncios

Mostrando entradas con la etiqueta Excel Online. Mostrar todas las entradas
Mostrando entradas con la etiqueta Excel Online. Mostrar todas las entradas

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.