Excel Advanced Report Development

Excel Advanced Report Development, 9780764588112 (0764588117), John Wiley & Sons, 2005

If you're 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. You'll thoroughly examine the main features of Excel's reporting technology— PivotTable reports, Spreadsheet reports, parameter queries, and web components. With notes, tips, warnings, and real-world examples in each chapter, you'll be able to put your knowledge to work immediately.

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

Timothy Zapawa is a project director atAdvantage Computing Systems, Inc., where he leads teams of engineers, developers, and managers through long-term software implementations. He has developed software training programs and has obtained several professional and technical certifications, including Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Database Administrator (MCDBA).

Comments

Amazing Books

Apple Training Series : iWork 06 with iLife 06

Peachpit Press, 2006

The second generation of Apple's iWork productivity suite is poised to allow mac users to create, present and publish their work with style! iWork '06 features two powerful applications for creating everything from newsletters to business presentations. With Pages 2 you can quickly create a wide variety of stunning documents and with Keynote 3 you...

Android Cookbook

O'Reilly, 2012

Jump in and build working Android apps with the help of more than 200 tested recipes. With this cookbook, you’ll find solutions for working with the user interfaces, multitouch gestures, location awareness, web services, and device features such as the phone, camera, and accelerometer. You also get useful steps on packaging...

Data Mining and Knowledge Discovery via Logic-Based Methods: Theory, Algorithms, and Applications

Springer, 2010

There are many approaches to data mining and knowledge discovery (DM&KD), including neural networks, closest neighbor methods, and various statistical methods. This monograph, however, focuses on the development and use of a novel approach, based on mathematical logic, that the author and his research associates have worked on over the...

Visual Basic Game Programming for Teens

Course Technology PTR, 2010

Visual Basic Game Programming for Teens, Third Edition teaches teens and other beginners how to create their own 2D role-playing game (RPG) using the free to download and easy to use Visual Basic 2008 Express. The game is built step-by-step throughout the book as readers learn new skills and build upon them. This new edition features almost...

Scaling Software Agility: Best Practices for Large Enterprises (The Agile Software Development Series)

Addison Wesley, 2007

Agile development practices, while still controversial in some circles, offer undeniable benefits: faster time to market, better responsiveness to changing customer requirements, and higher quality. However, agile practices have been defined and recommended primarily to small teams. In Scaling Software Agility, Dean...

Python Projects for Beginners: A Ten-Week Bootcamp Approach to Python Programming

Apress, 2019

Immerse yourself in learning Python and introductory data analytics with this book’s project-based approach. Through the structure of a ten-week coding bootcamp course, you’ll learn key concepts and gain hands-on experience through weekly projects.

Each chapter in this book is presented as a full week of...