|
Excel Advanced Report Development |  | Author: Timothy Zapawa
Publisher: Wiley
List Price: $39.99
Buy New: $11.98
as of 11/22/2009 02:15 CST details
You Save: $28.01 (70%)
New (35) Used (14) from $11.98
Seller: thebookguyz
Rating:  14 reviews
Sales Rank: 56776
Media: Paperback
Edition: Book and CD-ROM
Pages: 504
Number Of Items: 1
Shipping Weight (lbs): 1.7
Dimensions (in): 9.1 x 7.3 x 1.1
ISBN: 0764588117
Dewey Decimal Number: 005.54
EAN: 9780764588112
ASIN: 0764588117
Publication Date: July 29, 2005
Availability: Usually ships in 1-2 business days
| |
| Features:
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
If you're a SQL programmer or an experienced Excel user, here at last is the ultimate resource on developing reporting solutions with Excel. Focused on report development using OLTP databases, this book is packed with comprehensive information on both technical and strategic aspects. You'll thoroughly examine the main features of Excel's reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components. With notes, tips, warnings, and real-world examples in each chapter, you'll be able to put your knowledge to work immediately. This book includes: - Single-source coverage of Excel's report development features
- Extensive and in-depth information on PivotTable and Spreadsheet report features, functions, and capabilities
- Thorough documentation of the Microsoft Query program included with Excel
- Comprehensive information on Excel's client-based OLAP cube tools for processing very large datasets from OLTP data sources
- Detailed information on creating and working with web-enabled Excel reports
|
| Customer Reviews:
Showing reviews 1-5 of 14
 Not a bad book, SQL skills would help August 30, 2009
Mr. Michael Najarian (Glen ROck, N.J. USA)
0 out of 1 found this review helpful
This book was far less then I expected, it delves a bit into the "watch the video" online realm - Why would I buy the book if I wanted to watch TV?.
Its not very in depth like I desired but the author takes on Pivot table reporting which is difficult at best and a considerable challenge.
I did not rate it as well as other books mostly due to the fact that it was NOT a worthy buy, the book sells for more than it provides in useful information in the core function of Excel!, The book rather refers to SQL programming to generate reports and advanced web forms when more of the book should have addressed advanced Excusive EXCEL methods of reporting, if I wanted to learn sql reporting I would get a book called "excel reporting using SQL" (which I did).
That and the raw information packed in the book was light for its value, but not a bad book by any means!
Duftopia
 Better have an SQL server installed on your computer... May 5, 2009
J. Evans
2 out of 2 found this review helpful
This is a great book. I had no idea that Excel could do so much. Now that I know, I prefer to make reports in Excel than struggle to perform the same tasks in Access. My life is much simpler now!
There is one downside. Throughout the book the author makes use of a sample database in Access called "Northwinds". In order to follow along with the examples you have to: (1) have an SQL server program installed on you computer, (2) know how to configure it to access a remote server and import the Northwinds data. Failing that, you're going to need someone who is an SQL database administrator who can do it for you. Without this capability you're going to have trouble following the examples in the book.
 "Advance" means for DBAs Level July 4, 2008
A. Golts (San Francisco, Ca)
2 out of 6 found this review helpful
Ok...guys...I got this book today and I spend all day just to understand how I can apply available files on Author's web site by reading the text at the same time. It's very hard and complicated process!!!! Owww my god!!!! Text is nice, but files are horrible. The way author drives you through his material ... let me say easy: you have to possess some knowledge about SQL Server 2000 and SQL ,and Access ,and about many other aspects of software. Guys on the bottom are correct: this book covers some very comprehensive topics about Excel, but you less likely will use it, which probably most books don't!!!!! This is book for the Computer Science (DBAs) guys...not for people who want to learn some advance functions of Excel (book represent angle of DBA). Don't buy it if you not planning to become DBA or/and you are not DBA, but because I spend money on it I will keep it for the future, just in case. Who knows maybe life will drive to become one of them.
 Help for Business Application Sufferers November 10, 2007
Chai and a Good Book (USA)
3 out of 3 found this review helpful
This book is an immense help to someone at a small- to medium-sized company who is laboring to create to create printed reports using their business application's report-writing tools. The author shows you how to use SQL Query to access the database directly from Excel to create electronic reports with drill-down functionality. My users love them, and it is so Lean not to waste people's time re-entering information from a printed report.
The chapters on pivot tables are better than some books devoted entirely to pivot tables.
Very Good... June 15, 2007
C. Clark (Upstate NY USA)
10 out of 10 found this review helpful
This book covers all the tricks I've picked up slogging through trying to create pivot table reports for the company I work for - and then some. Boy, do I wish I had it before I spent all that time.
Clearly written and easy to follow I think this a good book for users of all levels. You do need some knowledge of Excel and SQL - but not as much as you might think.
Showing reviews 1-5 of 14
|
|
|
|
Return to Math.com | |
