Home » Excel Advanced Report Development by Timothy Zapawa
Excel Advanced Report Development Timothy Zapawa

Excel Advanced Report Development

Timothy Zapawa

Published February 11th 2011
ISBN : 9781118080153
ebook
504 pages
Enter the sum

 About the Book 

If youre 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 onMoreIf youre 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. Youll thoroughly examine the main features of Excels reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components. With notes, tips, warnings, and real-world examples in each chapter, youll be able to put your knowledge to work immediately. This book includes: Single-source coverage of Excels report development featuresExtensive and in-depth information on PivotTable and Spreadsheet report features, functions, and capabilitiesThorough documentation of the Microsoft Query program included with ExcelComprehensive information on Excels client-based OLAP cube tools for processing very large datasets from OLTP data sourcesDetailed information on creating and working with web-enabled Excel reports