Excel Advanced Report Development

I would highly recommend this book to anyone who is interested in -- or who needs to learn about -- PivotTables, as well as Excel reporting in general. The coverage in this book is comprehensive, providing information on Excel report topics that just isn't available in most other books. Here are just 10 items that I learned about from this book: 1. Prompting the user for parameters in Excel reports (Chapter 11): Parameters can be used with PivotTable lists or Spreadsheet reports, and they can also make the report run much faster and filter the returned dataset to a particular date range, division or product line. 2. Building Report Control Centers (Chapter 11): I learned how to build Spreadsheet report control centers that accept parameters and support a number of helpful functions, including: * Automatic report refreshes when a parameter value is changed * Drop-down lists of valid values that the user can choose to automatically refresh a report * Specific field formats to ensure that the data is entered correctly And, I learned how to do all this through simple, native graphical tools - there was no need for complex VBA programming! 3. Creating ultra-fast client-side OLAP cubes (Chapter 10): Given that I'm not actually data warehouse savvy, nor do I have the time to learn Analysis Services, Excel's client-side OLAP was perfect for me. I've been able to use it to organize data into dimension-level hierarchies for drilling-through data. And I was able to automatically rebuild OLAP cubes directly from Excel. The best part -- all 3 client-side OLAP cubes are covered in extensive detail in this book, unlike most other books on this topic which tend to just cover OLAP cubes in passing. 4. Hiding SQL queries (Chapter 6): I learned how to hide SQL queries from users in order to prevent them from viewing or modifying my report query. 5. Retrieving Data from OLTP databases (Chapter 2-9, 11, and 12): This book provides numerous examples of how data can be extracted from Access, SQL and Oracle databases, which has proved to be invaluable to me at work. And, this book also covers Text files (Chapter 3), OLAP cubes (Chapter 10), Web Sites (Chapter 11) and other data sources (Chapter 3). I even learned how to extract data from multiple databases - on the same or different servers (Chapter 6). 6. Fixing annoying problems with field names (Chapter 7): I learned how field headings from SQL queries can get corrupted - this book explained why this happens and, more importantly, how to fix it. 7. Publishing and using web-enabled reports (Chapter 12): This book dedicates an entire chapter to web-enabled reports. It shows how the best features of PivotTable and Spreadsheet reports are combined into PivotTable lists - and how to navigate through all the new functions, features and tools. 8. Restricting the number of rows returned (Chapter 7): This book showed me how to restrict the number of rows returned in a PivotTable and Spreadsheet reports. 9. Comprehen

The MS Query Program is one of Microsoft's best-kept secrets. It is almost impossible to find *thorough* documentation, much less good examples of how to use it. After struggling for over two years learning to use MS Query by trial and error, I was extremely pleased to find this book. I just wish the author had covered Oracle a bit more, since I have discovered that MS Query doesn't always work as advertised with Oracle, or at least Oracle 8i. For example, you cannot rename columns when accessing Oracle. I am also curious about a statement on page 70, where he is describing the process of setting up a DSN for a CSV file. He states, "WARNING: A software bug in Microsoft Excel requires that fields with a data type of Char be set to LongChar." There is no further explanation for this, except that he mentions that the data may be corrupted. I have used DSNs for text files (CSV and tab-delimited)in MS Query and in other programs for about two years, and have never encountered a problem with this. In fact, I had never heard of "LongChar" before this. Furthermore, I tried to set up a query using a DSN that I had created using this advice, and it did not work. It worked fine once I changed the data type back to Char. But I gave it five stars anyway, because it is the best book available on this subject, which seems to have eluded other Excel users and authors. Marty Ryerson.

This is the first book that I've seen on PivotTable reports that uses SQL for many of the report examples. It also thoroughly covers the Microsoft Query program and using external data sources. Excellent book - I highly recommend it.

I never knew how much reporting capability there was in Excel until I read this book. I have a decent knowledge of SQL, but this guy really shows how it can work with PivotTables, Spreadsheet reports and even web-enabled reports. I finally found out how parameters are used with stored procedures. Very well written and organized.

Wow!! This book has everything in it on PivotTable reports, PivotTable lists, parameter queries and the MS Query program. And the SQL queries that are used in some of these reports are amazing. This is definitely the best book I've read on the topic. Finally a book that has some SQL and more advanced topics of PivotTable reporting. I was especially impressed with the coverage of Excel's client-based OLAP tools. This is also the first book I've seen with videos.