We Need Diverse Ya Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Lists | June 22, 2015

    Stephen Jarvis: IMG Robert Seymour — 13 Pictures



    1. Self-Portrait. My new novel, Death and Mr. Pickwick, tells the story of the origins of Charles Dickens's first novel, The Pickwick Papers. Its... Continue »
    1. $21.00 Sale Hardcover add to wish list

      Death and Mr. Pickwick

      Stephen Jarvis 9780374139667

    spacer
Qualifying orders ship free.
$11.95
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside Microsoft Windows- Applications

More copies of this ISBN

Excel Advanced Report Development

by

Excel Advanced Report Development Cover

 

Synopses & Reviews

Publisher Comments:

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.

Synopsis:

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. This book includes: 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

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

Table of Contents

Acknowledgments.

Introduction.

Part I: Report Initiation and Source Data.

Chapter 1: Taking a First Look at Excel’s Reporting Tools.

Chapter 2: Getting Started with PivotTables.

Chapter 3: Understanding and Accessing Source Data.

Chapter 4: Using the Query Wizard.

Chapter 5: Getting Started with Microsoft Query.

Chapter 6: Working with SQL in Microsoft Query.

Part II: Advanced Reporting Features.

Chapter 7: Designing PivotTable Reports.

Chapter 8: Managing PivotTable Data.

Chapter 9: Exploring PivotChart Functionality.

Chapter 10: Working with OLAP Cubes.

Chapter 11: Creating and Using Spreadsheet Reports.

Chapter 12” Using Excel Reports on the Web.

Part III: Appendixes.

Appendix A: Configuring Your System.

Appendix B: SQL Reference.

Index.

Product Details

ISBN:
9780764588112
Author:
Zapawa, Timothy
Publisher:
Wiley Publishing
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Business report writing
Subject:
Computer programs
Subject:
Business report writing -- Computer programs.
Subject:
Personal Computers-Applications
Subject:
Microsoft Excel
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
WebSite Associated w/Book
Publication Date:
20050722
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
500
Dimensions:
235 x 188 x 27.4 mm 25.6 oz

Other books you might like

  1. Pivot Table Data Crunching Used Trade Paper $24.00
  2. Writing Excel Macros With Vba 2ND... Used Trade Paper $8.95

Related Subjects

» Computers and Internet » Operating Systems » Microsoft Windows » Applications
» Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel Advanced Report Development Used Trade Paper
0 stars - 0 reviews
$11.95 In Stock
Product details 500 pages John Wiley & Sons - English 9780764588112 Reviews:
"Synopsis" by , 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. This book includes: 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
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.