Excel 2016 - Tabelas Dinâmicas (Pivot Tables)

Excel 2016 - Tabelas Dinâmicas (Pivot Tables)

4.159 visualizações 897 downloads

Detalhes

  • Categoria: Excel
  • Assuntos: Curso de Excel, Excel, Excel Básico, Microsoft Excel, Microsoft Office, Pivot Tables, Tabelas Dinâmicas no Excel
  • Autores: Tim Hill
  • Quantidade de Páginas: 68
  • Data de Inclusão: 23/03/2016
  • Formato do Arquivo: PDF
  • Tamanho do Arquivo: 3.141 KB

You can use Excel’s pivot tables to quickly create concise, flexible summaries of long lists of raw values, without having to write new formulas, copy and paste cells, or reorganize rows and columns. Pivot tables are dynamic: if you create a pivot table from, say, census data, then you can drag your mouse to rearrange the table so that it summarizes any variables of interest—age, gender, location, education, income, and so on. Rearranging a pivot table by swapping or moving rows and columns is called pivoting: turning the same information to view it at different angles. The jargon associated with pivot tables (“n-dimensional cross tabulations”) makes them look complex, but they’re really no more than an easy way to build flexible summary tables.

Comente Aqui

Subir ao topo