Excel 2007 Advanced Report Development and over 2 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
Trade in Yours
For a £1.66 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Excel 2007 Advanced Report Development on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel 2007 Adv Rprt Dvlpmnt wW/S [Paperback]

Timothy Zapawa
4.0 out of 5 stars  See all reviews (2 customer reviews)
RRP: £25.99
Price: £19.51 & FREE Delivery in the UK. Details
You Save: £6.48 (25%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 1 Sept.? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition £18.53  
Paperback £19.51  
Trade In this Item for up to £1.66
Trade in Excel 2007 Adv Rprt Dvlpmnt wW/S for an Amazon Gift Card of up to £1.66, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

23 Mar 2007
Create powerful, innovative reporting solutions with Excel 2007! With this new book, which is significantly updated from the bestselling Excel 2003 version, author Timothy Zapawa provides you with in–depth coverage of Excel 2007’s enhanced reporting capabilities. Discover what you can do with PivotTable and Spreadsheet reports, enhanced conditional formatting and filtering functions, improved data access and management tools, and expanded OLAP features. With notes, tips, warnings, real–world examples, and how–to videos in every chapter, you′ll soon be an expert on Excel report development!


Product details

  • Paperback: 576 pages
  • Publisher: John Wiley & Sons; 1 edition (23 Mar 2007)
  • Language: English
  • ISBN-10: 0470046449
  • ISBN-13: 978-0470046449
  • Product Dimensions: 24 x 19 x 3 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 599,135 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Create powerful, innovative reporting solutions with Excel 2007 In this new book, significantly updated from his bestselling Excel 2003 version, Timothy Zapawa has provided you with in–depth coverage of Excel 2007′s enhanced reporting capabilities. Discover what you can do with PivotTable and Spreadsheet reports, enhanced conditional formatting and filtering functions, improved data access and management tools, and expanded OLAP features. With notes, tips, warnings, real–world examples, and how–to videos in every chapter, you′ll soon be an expert on Excel report development! Understand and use key features of PivotTable® and Spreadsheet reports Access data from SQL and Oracle databases, Web sites, OLAP cubes, and text files Build sophisticated SQL queries using the Microsoft Query program Link several Excel reports together to develop a larger, automated report solution Discover the enhanced Excel 2007 tools for filtering, sorting, and grouping data Companion Web site At www.wiley.com/go/excelreporting/2007, you′ll find sample query files and report examples you can download, up–to–the–minute materials on Online Data Processing, and video walkthroughs of steps explained in the book.

About the Author

Timothy Zapawa is a Project Director at AdvantageComputing Systems in Ann Arbor, Michigan, where he manages implementation projects of enterprise software systems for book and magazine publishers around the world. He holds several professional and technical certifications and has developed training courses on delivering business intelligence, building report solutions, and developing SQL queries and programs in SQL and Oracle databases.

Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

5 star
0
3 star
0
2 star
0
1 star
0
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
3 of 5 people found the following review helpful
Format:Paperback
Very didactic in one of the lesser used - though more powerful - tools of Excel: Pivot Tables. This takes even another dimension with the revamped filtering, conditional formatting and diagram functionalities of Excel 2007. Now add the External Data access tools of Excel 2007, and the Spreadsheet Report tools....., and it is difficult to see the limits of a program that most of us use.
Even if the title seems a little intimidating for non-experts in Excel, Timothy Zapawa makes it just easy.
Thank you Timothy :-)
Comment | 
Was this review helpful to you?
1 of 3 people found the following review helpful
4.0 out of 5 stars Interesting subject, but boooorrriiinnngggg 17 Oct 2009
Format:Paperback|Verified Purchase
I find the Pivot Tables one of the most useful (and unknown) feature of Excel, and I am very grateful for reading that book. I am not interested in the outside data part, but the report writing is most interesting. However, as it is the case with 90% of the computer books, this one follows the rule to be written in an unnecessary pretentious, boring and repetitive style. I also do not understand why they first explain the complex outside data section before going to the easier and more commonly used reporting feature. In the absence of competitive books, I am still pleased to have purchased that one.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.3 out of 5 stars  9 reviews
14 of 14 people found the following review helpful
4.0 out of 5 stars Great Business tool for Excel 27 Jan 2008
By Jonathan C. Anthony - Published on Amazon.com
Format:Paperback
I used this text in my CIS 2640 Business Reports and Analysis class at WMU in Spring 2008. It's a great text for learning Advanced Sklills with Pivot Tables in particular with Excel. There ar elots of diagrams, and the author attempts to make the book seem personable and familiar, not dry and technical. There is lots of support for this book, and excercises you can do on the publishers website, and files to download in concordance with the text. The only drawback is if you have Windows Vista, as this text is designed for Windows XP OS, even though it uses Office 2007. Otherwise, very straightforward, with no advanced knowledge of Excel necessary.
7 of 7 people found the following review helpful
5.0 out of 5 stars A good reference 4 Mar 2010
By M. Ellis - Published on Amazon.com
Format:Paperback|Verified Purchase
I bought this book because I already knew how to use excel but I wanted to be able to utilize some of the more advanced reporting functions. This book walks you through it with practice exercises and screen shots. More then worth the investment.
7 of 7 people found the following review helpful
5.0 out of 5 stars Excel Integration for Dashboarding 14 Nov 2009
By Aiman S. Sadeq - Published on Amazon.com
Format:Paperback|Verified Purchase
I really liked it! for some time I have been looking for a book that will explore different integration techniques. This book takes you through the A to Z, with practical examples. One important note: you must have SQL server 2005 installed on your machines to benefit the most of this book. Microsoft sells SQL Server 2005 for about $50, complete package for consultants and professionals who wants to demo Excel data management techniques. Great Book!
4 of 4 people found the following review helpful
4.0 out of 5 stars "Advanced" or "Seldom Used Features" 22 Oct 2009
By Erwobbie - Published on Amazon.com
Format:Paperback|Verified Purchase
I am an intermediate level Excel user/developer. I was looking for a book that would shed some light on the advanced features of Excel's reporting tools. This book did not provide me any information on what I was looking for.

If you have not used Excel's reporting tools before, this is the perfect book for you. It is very precise and detailed and each step to constructing a pivot table report or graph is very easy to follow. I recommend this book for anyone who is interested in learning about the reporting options that are usually among the "seldom used features" in Excel.
3 of 3 people found the following review helpful
5.0 out of 5 stars Great resource! 2 Nov 2011
By LazyV - Published on Amazon.com
Format:Paperback|Verified Purchase
This book helped me solve some of the tricker issues I had been struggling with in trying to build Excel reports from external data sources, specifically SQL. If you're trying to move beyond simple wizard-built queries, your money will be well spent on this book!
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback