Brilliant Excel 2007 Solutions: Pivot Tables
(häftad)av Bill Jelen, Michael Alexander
- Format:
- Häftad (paperback)
- Utgiven:
- 2007-12-01
- Språk:
- Engelska
Brilliant Excel 2007 Pivot Tables
What you need to know and how to do it
Excel is one of the most powerful office and business productivity tools available but do you know how to harness its full potential? Do you want to get a better understanding of its full capabilities and potential, and develop the Excel skills that you need to produce solutions to all of your business needs/ Brilliant Excel 2007 Pivot Tables will deliver increased office productivity and improved results by unleashing your inner Excel expert! This book is for the savvy Excel user who wants to understand and then use the advanced features of Excel but doesnt want to dedicate their life to it.
Develop your Excel 2007 expertise instantly with proven techniques
Pivot tables are the most powerful feature in Excel 2007. A basic pivot table will allow you to summarize 500,000 rows of transactional data in 30 seconds with just a few mouse clicks. You can make changes to your data analysis in seconds by dragging a few fields around the pivot table field list. Business productivity would skyrocket if everyone knew how to use pivot tables. However, only 12% of people using Excel can create a basic pivot table. Of this group only a small percentage actually harness all the power that pivot tables afford them.
Thisbook consolidates all the best functionality of pivot tables into one guide that that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems. Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing reports in minutes instead of hours. By Chapter 6, you will learn how to use pivot tables to quickly highlight your top 10 customers or bottom 5 products in profitability, or to compare sales by period, product or region in a few mouse clicks, and without knowing any formulas. By the end of the book, you will truly be a pivot table guru, automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that your managers can answer their own queries with a few mouse clicks.
Brilliant Excel 2007 Pivot Tables will show you how to .
Create powerful summary reports in seconds
Build ad-hoc query tools with ease
Enhance your Executive Reporting
Filter reports to top 10 customers or products
Add dynamic charts to reports
Quickly summarize daily data by month, quarter, or year.
Bill Jelen is Mr. Excel! He is principal behind the leading Excel website, MrExcel.com and a...
(Computer Bookshops Limited)
Passar bra ihop
|
De som köpt den här boken har ofta också köpt Pro Excel 2007 VBA (häftad) av Jim Demarco | |||
|
Pris för båda:
659:-Köp
|
Fler böcker av författarna
|
|
|
|
|||
Pivot Table Data Crunching: Microsoft Excel 2010Bill Jelen, Michael Alexander (häftad) |
Excel Dashboards and ReportsMichael Alexander, John Walkenbach (häftad) |
PowerPivot for the Data Analyst: Microsoft Excel 2010Bill Jelen (häftad) |
VBA & Macros For Micorosoft Office Excel 2007Bill Jelen, Tracy Syrstad (häftad) | |||
|
238:- Köp
|
200:- Köp
|
238:- Köp
|
265:- Köp
|
Kundrecensioner
Bloggat om Brilliant Excel 2007 Solutions: Pivot Tables
Övrig information
Paul McFedriesis well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams).
(Computer Bookshops Limited)
Innehållsförteckning
Introduction
- Pivot Table Fundamentals
- Creating a Basic Pivot Table
- Customising a Pivot Table
- Controlling the Way You View Your Pivot Data
- Performing Calculations Within Your Pivot Tables
- Using Pivot Charts and Other Visualizations
- Analysing Disparate Data Sources with Pivot Tables
- Sharing Pivot Tables with Others
- Working with and Analyzing OLAP Data
- Enhancing Your Pivot Table Reports with Macros
- Using VBA to Create Pivot Tables
- Common Pivot Table Issues and Questions
A Finding Pivot Table Commands on the Ribbon
Index
(Computer Bookshops Limited)
