Synopses & Reviews
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.
Excel Services is a new technology being delivered as part of Microsoft Office SharePoint Server 2007. Excel Services will enable managed and secure distribution of Excel reports, incorporating spreadsheets in business intelligence dashboards and portals, protecting the proprietary information in spreadsheets, and building custom applications with Excel-based logic. This book will walk you through the process of understanding what Excel Services is, how your business can benefit from it, and how to incorporate it in your solutions.
This book is designed to be an introduction to Excel Services for all those that want to understand what it is, what it does, what the benefits are, and how to get started. The target audience is IT TDMs and developers that need to come up to speed on the new technologies in Office 2007 and may be responsible for evaluating and deploying Office 2007 and Office SharePoint 2007. This book is also great for all Microsoft partners including system integrators, consulting companies, hosting companies, VARs and independent software vendors that will be building and deploying solutions for their customers based on the new Office technologies. Anyone currently managing or developing solutions with Excel, Windows SharePoint Services, SharePoint Portal Server, or business intelligence solutions should read this book to understand the basics of Excel Services.
Table of Contents:
Part I Overview of Excel Services
1 Introduction to Excel Services
2 Getting Started with Excel Services
Part II Working with Excel Services
4 Workbook Support
5 External Data
6 Capacity and Deployment Planning
7 Administration of Excel Services
Part III How-To Scenarios
9 Sharing a Spreadsheet
10 Using the Browser to Interact with Spreadsheets
11 Building the BI Dashboards
12 Using Office Sharepoint Server 2007
13 Leveraging Servers for Workbook Calculation
14 Building Custom Solutions
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.
Although many people rarely go from Excel into Access or vice versa, you should know that Microsoft actually designed these applications to work together. In this book, you’ll discover how Access benefits from Excel’s flexible presentation layer and versatile analysis capabilities, while Access’s relational database structure and robust querying tools enhance Excel. Once you learn to make the two work together, you’ll find that your team’s productivity is the real winner.
About the Author
is a Principal Development Lead at Microsoft, and currently manages the development of Excel Services (which is part of Microsoft Office SharePoint Server 2007). Asnash has more than 15 years of experience in enterprise-level software development. In the past five years, he has worked on Microsoft Office in areas related to Business Intelligence, Excel, and Excel Services. Prior to joining Microsoft, he was the director of Research and Development at Maximal Innovative Intelligence, a software company that developed data visualization tools for Business Intelligence. Before that, he worked for six years on mission-critical server systems based on UNIX and Oracle technologies. Asnash holds a B.S. degree in Computer Science and an M.B.A. degree. He lives in Bellevue, Washington, with his wife and son.
Eran Megiddo is an entrepreneur at heart and is the Principal Group Program Manager at Microsoft, responsible for the team that defines the functionality and product road map for Excel Services. Megiddo has been designing and developing data analysis software for more than 14 years. Prior to joining Microsoft, he co-founded Maximal Innovative Intelligence, back home in Israel. Maximal developed data visualization and exploration tools that were eventually acquired by Microsoft. The tools were initially released as Microsoft Data Analyzer and are now part of Microsoft Office Excel 2007. The inspiration for Maximal was in student-assessment software developed at Memad Educational Systems, where Megiddo led the software development and product marketing efforts. He began his professional career as an officer in an elite Israeli Military Intelligence unit. Megiddo enjoys spending his free time traveling and hiking with his wife and two daughters. He is an avid theatergoer, but on most nights, you will find him in the kitchen, where he enjoys cooking for family and friends.
Craig Thomas is a Senior Test Lead who works for Microsoft in Redmond, Washington. For the Office SharePoint Server 2007 release, he is the Release Test Lead for Excel Services. He also leads a team of testers who focus primarily on server performance and reliability. Prior to joining the Office team, he was contributing to shipping Exchange Server 2003 with a focus on leading a test team responsible for the Outlook Web Access component of Exchange. Thomas discovered his technology passions later in life, after an 11-year career as a submariner in the United States Navy. He programmed with C and C++ early on, but now prefers C#, and keeps his coding skills fresh by staying involved with tools development, authoring test automation scripts, and, of course, writing custom solutions for Excel Services.
Table of Contents
Part I: Overview of Excel Services.
Chapter 1: Introduction to Excel Services.
Chapter 2: Getting Started with Excel Services.
Chapter 3: Architecture.
Part II: Working with Excel Services.
Chapter 4: Workbook Support.
Chapter 5: External Data.
Chapter 6: Capacity and Deployment Planning.
Chapter 7: Administration of Excel Services.
Chapter 8: Security.
Part III: How-To Scenarios.
Chapter 9: Sharing Workbooks with the Browser.
Chapter 10: Interacting with Workbooks in the Browser.
Chapter 11: Controlling Workbook Distribution.
Chapter 12: Business Intelligence Solutions.
Chapter 13: Offloading Workbook Calculation to the Server.
Chapter 14: Building Custom Solutions.