Excel 2007 Advanced Report Development

Features

• Cover Type: Paperback with 542 pages
• Published by: Wiley March 26, 2007
• Written in: English
• ISBN 10 Number: 0470046449
• ISBN 13 Number: 978-0470046449
• Book Dimensions: 9.1 x 7.4 x 1.5 inches
• Weighs: 1.8 pounds

Book Description
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!

Back Cover Copy
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.

Reader Reviews
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. Comment | | (Report this)