Dan Parish Program Manager Microsoft OFC305 Excel Services Thin Rendering View and interact Author and publish spreadsheets in Browser Open Spreadsheet or Snapshot Excel 2007 Client Microsoft Office Excel 2007 Web Services Access Custom Applications Authoring Exploration and consumption.
Download ReportTranscript Dan Parish Program Manager Microsoft OFC305 Excel Services Thin Rendering View and interact Author and publish spreadsheets in Browser Open Spreadsheet or Snapshot Excel 2007 Client Microsoft Office Excel 2007 Web Services Access Custom Applications Authoring Exploration and consumption.
Dan Parish Program Manager Microsoft OFC305 Excel Services Thin Rendering View and interact Author and publish spreadsheets in Browser Open Spreadsheet or Snapshot Excel 2007 Client Microsoft Office Excel 2007 Web Services Access Custom Applications Authoring Exploration and consumption Architecture Web Front End Excel Web Access Web Front End Excel Web Services Excel Web Excel Web Services Access Web Front End Excel Web Access Web Front End Excel Web Access Excel Web Services Excel Web Services Application Server UDFs UDFs Excel Calculation UDFs Excel Calculation Services Application Server Application Server Services Application Server Excel Calculation Services External Databases UDFs SharePoint Content Database Excel Calculation Services Solution Overview Site for contractors to enter hours worked Dashboard page for contractors, and one for managers as well Includes: SharePoint Lists Excel Services User Defined Functions Excel Web Access Web Part Step 1: Create SharePoint List and Form SharePoint List Step 2: Create User Defined Function (UDF) SharePoint List UDF Step 3: Create Spreadsheet SharePoint List UDF Step 4: Publish the Workbook to the Server SharePoint List UDF Step 5: Create Contractor Dashboard Contractor Dashboard SharePoint List UDF Step 6: Create Manager Dashboard Contractor Dashboard SharePoint List Manager Dashboard UDF Wrap-Up Secure, scalable, server-based rendering and calculation of Excel workbooks Web Service API to integrate Excel business logic into your custom applications User-defined functions can be used to extend the functionality of Excel Services Excel Web Access can be seamlessly integrated into web part pages for rich BI dashboards Excel Blog http://blogs.msdn.com/excel Resources www.microsoft.com/teched www.microsoft.com/learning Sessions On-Demand & Community Microsoft Certification & Training Resources http://microsoft.com/technet http://microsoft.com/msdn Resources for IT Professionals Resources for Developers www.microsoft.com/learning Microsoft Certification and Training Resources Track Resources Spin the Wheel: Attend SharePoint breakout sessions Mon-Thurs and collect the picture of the day. Come by the booth for a chance to spin the SharePoint wheel. Collect all 4 pictures and enter to win a Microsoft Arc Mouse, drawing 11:30am on Friday, game cards at the booth. Product Info http://www.microsoft.com/SharePoint SharePoint Conference 2009 www.mssharepointconference.com Dev Resources SharePoint MSDN Web Site: http://msdn.microsoft.com/sharepoint SharePoint Developer Resources: http://mssharepointdeveloper.com/ ITPro Resources SharePoint Tech Center: http://technet.microsoft.com/en-us/office/sharepointserver/ SharePoint Best Practices: http://technet.microsoft.com/enus/office/sharepointserver/bb736746.aspx Collect the SharePoint Session Picture of the Day Attend any SharePoint Breakout Session day 1 – 4 and check the last slide for a daily picture. Come to the TLC yellow area, SharePoint booths OFC 4 & 5 to spin the wheel for a chance to win a prize. The wheel only spins when the SharePoint spotlight is flashing. One spin per person. Wednesday’s Picture is: Collect all four daily SharePoint pictures and enter to win a Microsoft ARC Mouse. Game cards can be picked up at the booth. Drawing for Mice on Friday at the wheel at 11:30AM. Box shot Attend an Interactive Theater Session and enter to win a Microsoft ARC Mouse Complete an evaluation on CommNet and enter to win! © 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.