Excel Advanced Report Development Paperback – July 29 2005
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your mobile phone number.
- Paperback : 504 pages
- ISBN-10 : 0764588117
- ISBN-13 : 978-0764588112
- Item Weight : 717 g
- Publisher : Wiley (July 29 2005)
- Product Dimensions : 18.8 x 2.74 x 23.5 cm
- Language: : English
- Best Sellers Rank: #1,682,031 in Books (See Top 100 in Books)
- Customer Reviews:
From the Back Cover
- 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
Top reviews from other countries
In addition being a Windows 8.1 user Excel 2003 is not compatible and changes from Excel 2003 - Excel 2013 is many. If the price of the book was under £5 I would have made the translations to Windows 2013 but for £17 I expect that the book is written for more recent Excel version. Since I discovered it contained information regarding Excel 2003 I returned it for a refund and I discourage anyone who uses Excel 2007 or later to purchase a book with more recent information. It is my hope the author either removes the book from Kindle or updates for at least Excel 2010.
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.
The chapters on pivot tables are better than some books devoted entirely to pivot tables.
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.
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!