Objects First With Java or Excel Pivot Tables and Pivot Charts

Objects First With Java: A Practical Introduction Using BluJ

Author: David J Barnes

The BlueJ development environment was specifically designed to support introductory teaching of object-orientations and helps users grasp the complicated concepts of class structure. Unlike most books on the subject, this text uses BlueJ to get readers started on object-oriented programming from day one. Uses a spiral approach that introduces a topic in a simple context early on, then revisits it later to increase understanding; Offers an abundance of projects for hands-on practice; Chapters are ordered around software development concepts rather than language features; Language-feature introduction is naturally driven by problems to be solved; Chapters are based around distinct projects for more variety; Does not cover traditional topics like control structures. A useful reference for programmers.

Look this: Good Housekeeping Step by Step Cookbook or Cookies

Excel Pivot Tables and Pivot Charts: Your Visual Blueprint for Creating Dynamic Spreadsheets

Author: Paul McFedries

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key techniques for creating PivotTables and PivotCharts, including:

• Building a basic PivotTable® report


• Pivoting fields to different areas


• Filtering PivotTable data


• Organizing PivotTable data into groups


• Formatting a PivotTable


• Changing the summary calculation


• Creating custom calculations


• Publishing a PivotTable to the Web


• Creating a PivotChart® from a PivotTable


• Building a PivotTable from external data

"I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."

—Rob L. Meerscheidt (The Woodlands, TX)

• High-resolution screen shots demonstrate each task


• Succinct explanations walk you through step by step


• Two-page lessons break big topics into bite-sized modules


• "Apply It" and "Extra" sidebars highlight useful tips

Table of Contents:

1	Understanding PivotTables	2
2	Building a PivotTable	14
3	Manipulating your PivotTable	26
4	Changing the PivotTable view	56
5	Customizing PivotTable fields	86
6	Setting PivotTable options	102
7	Performing PivotTable calculations	116
8	Creating custom PivotTable calculations	132
9	Creating a PivotChart	144
10	Building more advanced PivotTables	170
11	Building a PivotTable from an OLAP cube	188
App. A	Building formulas for PivotTables	206
App. B	Using Microsoft Query with Excel PivotTables	220
App. C	Importing data for PivotTables	238
App. D	Learning VBA basics for PivotTables	256
App. E	Glossary of PivotTable terms	274