Accessing and Analyzing Data with Microsoft Excel (Bpg-Other) [Paperback]

Paul Cornell (Author)

Book Description

Series: Bpg-Other | Publication Date: March 12, 2003

Master the tools that transform the information in spreadsheets, databases, and servers into faster, better business decisions. Packed with expert insights and practical Your Turn exercises, this essential guide shows how to use the data analysis capabilities in Microsoft® Office applications to capture data, analyze trends, identify risks—and seize opportunities. It covers everything from mastering the basics of sorting, filtering, and formatting data to performing sophisticated what-if scenarios, analyzing multidimensional data, and even creating automated data-analysis solutions.

Discover how to turn data into results!

• Help numbers tell the story with compelling, well-designed Excel charts, graphs, and reports
• Use PivotTable® and PivotChart® dynamic views to detect patterns and evaluate trends
• Use Data Analyzer to perform detailed analyses and present information in dynamic pie charts, bar graphs, and other views
• Publish and analyze data over the Web using Office Web Components
• Learn techniques to interpret—and exchange—XML data
• Analyze large databases using the OLAP features in Microsoft Excel
• Write code to automate data analysis and reporting solutions
  
• Implement a database maintenance plan that helps keep data accurate, accessible, and secure

Get tools and sample files on CD, including:

• Add-ins for Microsoft Access and Excel, including Report Manager, XML Spreadsheet, and OLAP CubeCellValue
• Dozens of sample PivotTables and PivotCharts to experiment with
• Office XP Web Component Toolpack
• Multimedia Data Analyzer tutorial
• Fully searchable eBook
• More code, databases, and extras to put your data to work!

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [e-mail].

Editorial Reviews

About the Author

Paul Cornell has been with Microsoft for five years, serving as an inside sales representative, a sales trainer, and a documentation specialist. For the last two-and-a-half years he has been working as a writer and an editor in Office User Assistance. He also currently works for the MSDN Online Office Developer Center and the Microsoft Office Business Intelligence initiative. His projects have included work on the Microsoft Office XP Visual Basic® for Applications Language Reference, the Microsoft Office XP Web Services Toolkit, the Microsoft Office XP Fabrikam 2.0 Solution Sample, and the Microsoft Data Analyzer Tutorial.

Product Details

• Paperback: 416 pages
• Publisher: Microsoft Press (March 12, 2003)
• Language: English
• ISBN-10: 073561895X
• ISBN-13: 978-0735618954
• Product Dimensions: 8.4 x 7.4 x 1.3 inches
• Shipping Weight: 1.8 pounds
• Average Customer Review: 3.5 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #1,462,068 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

16 of 17 people found the following review helpful:

3.0 out of 5 stars Good book but for very advance users only, May 20, 2003

By 

Vincent Wong (Toronto, ON CAN) - See all my reviews

This review is from: Accessing and Analyzing Data with Microsoft Excel (Bpg-Other) (Paperback)

This book is for IT professional only.
Don't expect this is a step by step series book.

The author leaves you to investigate the concepts on already built worksheets from the disc that comes with the book. Doing so leaves a lot of assumptions that you know what you look for to begin with.

However if you are very advance users, you might find it better that way since the number of pages reduce a lot.
It means you can finish the book much sooner and the book can be a good comprehensive reference.

To general public, it is a 3 stars,
but I would give it a 4.5 stars because I do learn something from it.

2 of 3 people found the following review helpful:

5.0 out of 5 stars Simply the best book in Excel Data Analysis, August 28, 2004

By 

Junu Thomas "www.pilgrimsmap.com" (Memphis, USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Accessing and Analyzing Data with Microsoft Excel (Bpg-Other) (Paperback)

This book is the number one in Excel Data analysis. Very comprehensive and the best of all its all about doing data analysis real time. The book has taken a practical approach with real data from business which helps one immensely to grasp the logic.

Excellent buy. Would recommend it to anyone.

5.0 out of 5 stars My rating is Excellent, May 31, 2003

By 

Sue Dough "ohhenree" (NY United States) - See all my reviews

This review is from: Accessing and Analyzing Data with Microsoft Excel (Bpg-Other) (Paperback)

I appreciated the advanced level that this book offers. It has been a source of reference for me at work and has opened new vista's for me in where I want to be professionally. I would have liked to have seen more automation via code behind the scenes; but this book delivered what is was intended to do explore the analysis of data using Excel. He opens another door for the user with Data Analyzer and I look forward to more publications by this author, because of his knowledge of the material covered. He is not just another writer who reads a few help files and puts out a book, he is a developer in every sence of the word. I also found some good articles by this author on the MS web site which should give you a good indication of his writing and Excel abilities. The articles are what influenced my decision to purchase this book. Another thing I liked about the book was it comes in eBook form on the CD which helps if you want to read along as you do the exercises. Paul, how about another that goes even higher, maybe with Data Analyzer and SQL?