Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Excel Advanced Report Development

Buy
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).

(HTML tags aren't allowed.)

Erlang and OTP in Action
Erlang and OTP in Action

For a long time, the world of Erlang programming had only one book—The Book,1 released in 1993 and revised in 1996. Fanatics can still find it in print, at a price of over $100. A decade or so after its publication, The Book was getting long in the tooth, to say the least. The language had evolved to include several new and...

Cognitive Radio Technology (Communications Engineering)
Cognitive Radio Technology (Communications Engineering)
Cognitive radio technology is a smarter, faster, and more efficient way to transmit information to and from fixed, mobile, other wireless communication devices. Cognitive radio builds upon software-defined radio technology. A cognitive radio system is 'aware' of its operating environment and automatically adjusts itself to maintain desired...
Programming Ruby 1.9: The Pragmatic Programmers' Guide (Facets of Ruby)
Programming Ruby 1.9: The Pragmatic Programmers' Guide (Facets of Ruby)
Ruby is a fully object-oriented language, much like the classic object-oriented language, Smalltalk. Like Smalltalk, it is dynamically typed (as opposed to Java or C++), but unlike Smalltalk, Ruby features the same conveniences found in modern scripting languages, making Ruby a favorite tool of intelligent, forward-thinking programmers and the...

Recent Advances in Computer Science and Information Engineering: Volume 6 (Lecture Notes in Electrical Engineering)
Recent Advances in Computer Science and Information Engineering: Volume 6 (Lecture Notes in Electrical Engineering)

CSIE 2011 is an international scientific Congress for distinguished scholars engaged in scientific, engineering and technological research, dedicated to build a platform for exploring and discussing the future of Computer Science and Information Engineering with existing and potential application scenarios. The congress has been held twice,...

From IT Pro to Cloud Pro Microsoft Office 365 and SharePoint Online (IT Best Practices - Microsoft Press)
From IT Pro to Cloud Pro Microsoft Office 365 and SharePoint Online (IT Best Practices - Microsoft Press)

Modernize your IT skills for the new world of cloud computing!

Whether you are an IT administrator, developer, or architect, cloud technologies are transforming your role. This guide brings together the knowledge you need to transition smoothly to Microsoft Office 365 cloud-only and...

Psychology and Ontology in Plato (Philosophical Studies Series)
Psychology and Ontology in Plato (Philosophical Studies Series)

This edited volume brings together contributions from prominent scholars to discuss new approaches to Plato’s philosophy, especially in the burgeoning fields of Platonic ontology and psychology. Topics such as the relationship between mind, soul and emotions, as well as the connection between ontology and ethics are discussed...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy