- Paperback: 504 pages
- Publisher: Wiley; 1 edition (July 29, 2005)
- Language: English
- ISBN-10: 0764588117
- ISBN-13: 978-0764588112
- Product Dimensions: 7.4 x 1.1 x 9.2 inches
- Shipping Weight: 1.6 pounds
- Average Customer Review: 19 customer reviews
- Amazon Best Sellers Rank: #442,831 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Excel Advanced Report Development 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
All Books, All the Time
Read author interviews, book reviews, editors picks, and more at the Amazon Book Review. Read it now
Customers who bought this item also bought
What other items do customers buy after viewing this item?
From the Back Cover
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.
- 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
Companion web site
Example files for all the exercises in the book are available for download at www.wiley.com/go/excelreporting, where you can also watch videos illustrating various lessons.
About the Author
Timothy Zapawa is a project director atAdvantage Computing Systems, Inc., where he leads teams of engineers, developers, and managers through long-term software implementations. He has developed software training programs and has obtained several professional and technical certifications, including Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Database Administrator (MCDBA).
Top customer reviews
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.
If you are still on 2003 and connecting to a SQL 2000 database, this book is exceptional. If you are using Excel 2007 and a SQL 2005 database, there is a newer version of this book just for you. Let's hope the author updates to Excel 2010 and SQL 2008 in the near future... especially since SQL 2012 is hitting the market!
The chapters on pivot tables are better than some books devoted entirely to pivot tables.
There is a work around for this. The problem is that the author uses the CASE SQL command, which is not available in Access. All he is doing is reformating the data (0 and 1 become "available" or "unavailable"). Edit out the CASE command so that it just grabs the raw data.
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.