Excel 2007 PivotTables Recipes: A Problem-Solution Approach
Chapters 1 to 10 contain manual solutions to common pivot table problems, and they alert you to the situations where no known solution exists. Chapter 11 has sample code, for those who prefer a programming solution to their pivot table problems, and for the settings that can only be adjusted prog...
Đã lưu trong:
| Tác giả chính: | |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
Apress
2012
|
| Những chủ đề: | |
| Truy cập trực tuyến: | http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31144 |
| Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
| Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
|---|
| id |
oai:scholar.dlu.edu.vn:DLU123456789-31144 |
|---|---|
| record_format |
dspace |
| spelling |
oai:scholar.dlu.edu.vn:DLU123456789-311442014-01-20T06:18:23Z Excel 2007 PivotTables Recipes: A Problem-Solution Approach Dalgleish, Debra Technologies Chapters 1 to 10 contain manual solutions to common pivot table problems, and they alert you to the situations where no known solution exists. Chapter 11 has sample code, for those who prefer a programming solution to their pivot table problems, and for the settings that can only be adjusted programmatically. The following is a brief summary of the material contained in each chapter. • Chapter 1, Creating a Pivot Table: Issues you should consider when planning a pivot table and preparing the source data. Using data from multiple worksheets. Creating an Excel Table from the source data and understanding the new PivotTable Field List. • Chapter 2, Sorting and Filtering Pivot Table Data: Understanding how data sorts in a pivot table, creating custom sort orders, and ensuring new items sort correctly. Filtering labels for text, dates, and values; applying multiple filters to a field; filtering for top items; and applying dynamic filters. • Chapter 3, Calculations in a Pivot Table: Using the summary functions and custom calculations, creating calculated items and calculated fields to expand the built-in capabilities, modifying formulas, listing all formulas, and adjusting the solve order. 2012-08-06T09:09:07Z 2012-08-06T09:09:07Z 2007 Book 1-59059-920-9 978-1-59059-920-4 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31144 en application/pdf Apress |
| institution |
Thư viện Trường Đại học Đà Lạt |
| collection |
Thư viện số |
| language |
English |
| topic |
Technologies |
| spellingShingle |
Technologies Dalgleish, Debra Excel 2007 PivotTables Recipes: A Problem-Solution Approach |
| description |
Chapters 1 to 10 contain manual solutions to common pivot table problems, and they alert
you to the situations where no known solution exists. Chapter 11 has sample code, for those
who prefer a programming solution to their pivot table problems, and for the settings that can
only be adjusted programmatically. The following is a brief summary of the material contained
in each chapter.
• Chapter 1, Creating a Pivot Table:
Issues you should consider when planning a pivot table and preparing the source data.
Using data from multiple worksheets. Creating an Excel Table from the source data and
understanding the new PivotTable Field List.
• Chapter 2, Sorting and Filtering Pivot Table Data:
Understanding how data sorts in a pivot table, creating custom sort orders, and ensuring
new items sort correctly. Filtering labels for text, dates, and values; applying
multiple filters to a field; filtering for top items; and applying dynamic filters.
• Chapter 3, Calculations in a Pivot Table:
Using the summary functions and custom calculations, creating calculated items and
calculated fields to expand the built-in capabilities, modifying formulas, listing all formulas,
and adjusting the solve order. |
| format |
Book |
| author |
Dalgleish, Debra |
| author_facet |
Dalgleish, Debra |
| author_sort |
Dalgleish, Debra |
| title |
Excel 2007 PivotTables Recipes: A Problem-Solution Approach |
| title_short |
Excel 2007 PivotTables Recipes: A Problem-Solution Approach |
| title_full |
Excel 2007 PivotTables Recipes: A Problem-Solution Approach |
| title_fullStr |
Excel 2007 PivotTables Recipes: A Problem-Solution Approach |
| title_full_unstemmed |
Excel 2007 PivotTables Recipes: A Problem-Solution Approach |
| title_sort |
excel 2007 pivottables recipes: a problem-solution approach |
| publisher |
Apress |
| publishDate |
2012 |
| url |
http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31144 |
| _version_ |
1757670958933475328 |