Free Book Online
Book Excel ADVANCED: Report Development

Pdf

Excel ADVANCED: Report Development

3.5 (2852)

Log in to rate this item

    Available in PDF - DJVU Format | Excel ADVANCED: Report Development.pdf | Language: ENGLISH
    Timothy Zapawa(Author)

    Book details


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

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

3.2 (10381)
  • Pdf

*An electronic version of a printed book that can be read on a computer or handheld device designed specifically for this purpose.

Formats for this Ebook

PDF
Required Software Any PDF Reader, Apple Preview
Supported Devices Windows PC/PocketPC, Mac OS, Linux OS, Apple iPhone/iPod Touch.
# of Devices Unlimited
Flowing Text / Pages Pages
Printable? Yes

Book details

  • PDF | 504 pages
  • Timothy Zapawa(Author)
  • John Wiley & Sons; 1 edition (29 July 2005)
  • English
  • 6
  • Computing & Internet

Read online or download a free book: Excel ADVANCED: Report Development

 

Review Text

  • By Schnoggle McGee on 25 December 2013

    A previous reviewer stated you need to have North Wind database from Access installed to gain use from the book. As an Office 365 subscriber I have Access and North Wind database as a part of my subscription. It was not until I downloaded the book and started reading through it, I discovered it was written based on Excel 2003. Excel 2003 is a Windows XP compatible piece of software and my understanding Microsoft is no longer support XP?In addition being a Windows 8.1 user Excel 2003 is not compatible and changes from Excel 2003 - Excel 2013 is many. If the price of the book was under £5 I would have made the translations to Windows 2013 but for £17 I expect that the book is written for more recent Excel version. Since I discovered it contained information regarding Excel 2003 I returned it for a refund and I discourage anyone who uses Excel 2007 or later to purchase a book with more recent information. It is my hope the author either removes the book from Kindle or updates for at least Excel 2010.

  • By P. Connolly on 18 October 2008

    Useful explanation of the Excel functionality that is available to extract & manipulate data stored mostly in non-Excel & non-Text files.The main drawback to the book is that you need Microsoft Access / SQL Server to benefit from the many worked examples - something that I wasn't aware of before I bought the book. I was hoping to explore the powerful features of Excel's 'data mining' tools by experimenting on large (over 66,000 records) text files - which are readily available on all PCs without the need for Access / SQL Server. However, early on in the book you are advised to install the Access Northwind SQL database to enable you to work through the many worked examples. If you don't have this (Access) then I think you are stuffed. I found that many of the SQL commands didn't work on text files.Therefore, I would advise against buying this book if you don't have Access / SQL Server. I'm no expert - so if someone could tell me how to get all the SQL exercises to run on a PC without Access / SQL Server then I will gladly update this comment.


  • Name:
    Email*:
    The message text*: