Beginning Excel Services (Programmer to Programmer) (Paperback)

~ (Author), Eran Megiddo (Author), Craig Thomas (Author)
Key Phrases: workbook distribution, unattended account, workbook parameters, Excel Services, Try It Out, Excel Web Access (more...)

Editorial Reviews

Product Description

Written by Microsoft’s lead developers of Excel Services, this book shares their insights into the benefits and usage of Excel’s new server technology so that you can solve business problems. You’ll learn what Excel Services is for and how it is used, how to deploy an evaluation copy of the server and effectively administer it, and gain an understanding of how the server works. You’ll also get step-by-step guidelines for using the server in each of the scenarios for which it was designed.

From the Back Cover

Given the prominent role Excel plays in today's companies, the need for users to better manage, distribute, and incorporate spreadsheets in larger applications is greater than ever. Written by Microsoft's lead developers of Excel Services, this book shares their insights into the benefits and usage of Excel's new server technology so that you can solve business problems. It walks you through all of the functionality of Excel Services and details how to incorporate it in your solutions.

You'll begin with the basics, learning what Excel Services is for and how it is used. The authors also show you how to deploy an evaluation copy of the server and effectively administer it. You'll delve into the server's architecture and get an in depth understanding of how the server works. You will then find step-by-step guidelines for using the server in each of the scenarios for which it was designed.

What you will learn from this book

• Methods for publishing a workbook to the server and viewing it in the browser

• How to use Excel Services to control the workbook distribution

• Ways to leverage Excel Services for reporting, interacting with data, dashboards, and key performance indicators (KPIs)

• Tips for offloading calculation-intensive workbooks to a server Farm

• How to develop applications leveraging the Excel Server's web services API

• How to query data from external databases into Excel Services

• Techniques for configuring Excel Services to mitigate security threats

Who this book is for

This book is for anyone who wants to learn what Excel Services is, what it does, what the benefits are, and how to get started. You should have an understanding of Excel, basic knowledge of Excel 2007, and familiarity with Windows SharePoint Services.

"Excel Services provides a powerful solution for management of mission-critical spreadsheet applications by centralizing workbook content and calculations, and by providing controlled web browser access to Excel applications and data. If you want to learn more about Excel Services, you must get this book."
—Peter Bennett, Principal, Capital Markets, HCL, Former CIO of London Stock Exchange

"This book will guide you through everything you need to know about the great new functionality in Excel Services. Microsoft Office SharePoint Server 2007 is Microsoft's platform for business applications. Excel Services provides great new business intelligence functionality and helps users control and manage their spreadsheets."
—Kurt DelBene, Corporate Vice President, Office Business Platform Group, Microsoft Corporation

"Excel Services is a critical enhancement to the analysis tool that the world knows and loves. This is the definitive book on Excel Services, from the team that dreamed it up, and built it."
—Bill Baker, Distinguished Engineer, General Manager Business Intelligence, Microsoft Corporation

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

See all Editorial Reviews

Product Details

• Paperback: 432 pages
• Publisher: Wrox; illustrated edition edition (March 12, 2007)
• Language: English
• ISBN-10: 0470104899
• ISBN-13: 978-0470104897
• Product Dimensions: 9.2 x 7.4 x 1.1 inches
• Shipping Weight: 1.3 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon.com Sales Rank: #140,076 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

1 of 1 people found the following review helpful:

5.0 out of 5 stars Everything you need to know about Excel Services, December 21, 2008

By	Farouq Abu-khamireh "F.S.A." (Greendale, WI) - See all my reviews (REAL NAME)

Amazon Verified Purchase

This is a comprehensive book that covers almost every aspect of Excel Services. The only thing I would change about this book is it's title; it should be"Excel Services End to End". I didn't care for the heavy use of acronyms throughout the book.. but that is minor.