Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.
Frequently Bought Together
Product details
Would you like to update product info or give feedback on images?
|
Customers Viewing This Page May Be Interested in These Sponsored Links(What is this?) |
Excel 2007
microsoft.com/uk/smallbusiness
Insist on the best with Microsoft Office 2007 Small Business Edition.
Product Description
Product Description
Though many consumers know the basics of using Excel, few users understand the powerful capabilities of the PivotTable and PivotChart features. These tools can help turn long lists of unreadable data into dynamically generated, easy–to–read tables and charts that highlight useful and pertinent business information. Companies rely on this type of data from marketing, accounting, and finance to help make better decisions about products, sales and even human resources. Charts are interactive, allowing the consumer to tweak results with the click of a mouse and PivotTables allow you to fuse data from several sources into one document. This book shows users how to work with PivotTables and PivotCharts to make sense of their data. It covers features such as: understanding PivotTable benefits and uses; creating and customizing PivotTables; using PivotTables to analyze business data; building custom calculations; linking to external data sources, including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes; publishing PivotTables to the Web; multiple consolidation of data, for example, summarizing annual fiscal data by quarters; preparing financial reporting, budgeting, and data analysis across departments; and using VBA to create macros that automate frequently used PivotTable tasks.
From the Back Cover
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 130 key techniques for working with PivotTables and PivotCharts, including:
See all Product Description
Though many consumers know the basics of using Excel, few users understand the powerful capabilities of the PivotTable and PivotChart features. These tools can help turn long lists of unreadable data into dynamically generated, easy–to–read tables and charts that highlight useful and pertinent business information. Companies rely on this type of data from marketing, accounting, and finance to help make better decisions about products, sales and even human resources. Charts are interactive, allowing the consumer to tweak results with the click of a mouse and PivotTables allow you to fuse data from several sources into one document. This book shows users how to work with PivotTables and PivotCharts to make sense of their data. It covers features such as: understanding PivotTable benefits and uses; creating and customizing PivotTables; using PivotTables to analyze business data; building custom calculations; linking to external data sources, including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes; publishing PivotTables to the Web; multiple consolidation of data, for example, summarizing annual fiscal data by quarters; preparing financial reporting, budgeting, and data analysis across departments; and using VBA to create macros that automate frequently used PivotTable tasks.
From the Back Cover
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 130 key techniques for working with PivotTables and PivotCharts, including:
- Building PivotTables from Excel ranges
-
Customizing PivotTable field lists
-
Converting PivotTables to regular data
-
Grouping numeric, text, or date/time values
-
Developing various summary calculations
-
Turning a PivotTable into a PivotChart
-
Displaying data tables with a PivotChart
-
Creating an OLAP cube data source
-
Exporting Access® PivotTable® forms to Excel
-
Using Microsoft Query with PivotTables
EXTRA Apply It
-
"Apply It" and "Extra" sidebars highlight useful tips
-
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
See all Product Description
Inside This Book
(Learn More)
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
What Do Customers Ultimately Buy After Viewing This Item?
 |
63% buy Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and Pivot Tables£13.99 |
 |
37% buy the item featured on this page: Excel 2007 PivotTables and PivotCharts: Your Visual Blueprint for Interpreting and Presenting Excel Data£16.99 |
Customer Reviews
There are no customer reviews yet. Create your own review
| |||
Video reviews
|
 |
Look for similar items by category
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
The Body Shop |
More From Paul McFedries
Teach Yourself Visually Windows Vista Are you a visual learner? Do you prefer instructions that show you how...
Read more
|
Treat Someone
With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is). |
||||||||
| |||||
Your Recent History
(What's this?)|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
Continue Shopping: Top Sellers
| ||||
Amazon Home | |
| International Sites: United States | Germany | France | Japan | Canada | China | |
| Business Programs: Sell on Amazon | Fulfilment by Amazon | Join Associates | Join Advantage | |
| Customer Service | Help | View Basket | Your Account | |
| About Amazon.co.uk | Careers at Amazon | |
| Conditions of Use & Sale | Privacy Notice © 1996-2009, Amazon.com, Inc. and its affiliates |