Brilliant Microsoft Excel 2007

Brilliant Microsoft Excel 2007
Author :
Publisher : Pearson Education
Total Pages : 548
Release :
ISBN-10 : 0273714066
ISBN-13 : 9780273714064
Rating : 4/5 (064 Downloads)

Book Synopsis Brilliant Microsoft Excel 2007 by : Paul McFedries

Download or read book Brilliant Microsoft Excel 2007 written by Paul McFedries and published by Pearson Education. This book was released on 2008 with total page 548 pages. Available in PDF, EPUB and Kindle. Book excerpt: Pivot tables are the most powerful feature in Excel. A basic pivot table will allow you to summarize 500,000 rows of transactional data in 30 seconds with just a few mouse clicks. 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. By the end of the book, users will be pivot table gurus automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that managers can answer their own queries with a few mouse clicks. Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.


Brilliant Microsoft Excel 2007 Related Books

Brilliant Microsoft Excel 2007
Language: en
Pages: 548
Authors: Paul McFedries
Categories: Computers
Type: BOOK - Published: 2008 - Publisher: Pearson Education

GET EBOOK

Pivot tables are the most powerful feature in Excel. A basic pivot table will allow you to summarize 500,000 rows of transactional data in 30 seconds with just
Teach Yourself VISUALLY Microsoft Office 2007
Language: en
Pages: 435
Authors: Sherry Willard Kinkoph
Categories: Computers
Type: BOOK - Published: 2008-03-11 - Publisher: John Wiley & Sons

GET EBOOK

Are you a visual learner? Do you prefer instructions that show youhow to do something - and skip the long-winded explanations? If so,then this book is for you.
VBA and Macros
Language: en
Pages: 654
Authors: Bill Jelen
Categories: Computers
Type: BOOK - Published: 2010 - Publisher: Pearson Education

GET EBOOK

Provides a step-by-step guide to using Visual Basic for Applications (VBA) and macros to import data and produce reports in Microsoft Excel 2010.
Professional Outlook 2007 Programming
Language: en
Pages: 479
Authors: Ken Slovak
Categories: Computers
Type: BOOK - Published: 2007-10-08 - Publisher: John Wiley & Sons

GET EBOOK

Written by one of the most popular and knowledgeable Microsoft Outlook MVPs, this book fills a void in the market for a professional-level Outlook programming b
Excel Tables
Language: en
Pages: 171
Authors: Zack Barresse
Categories: Computers
Type: BOOK - Published: 2014-08-01 - Publisher: Tickling Keys, Inc.

GET EBOOK

Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it implies can be intimidating to the uninitiated. In this guide, o