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 |
|---|
| Tóm tắt: | 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. |
|---|