1 / 60

May 11 th , 2011

May 11 th , 2011. SharePoint & Office – Better Together. Raymond Mitchell, Don Donais, Nick Stillings. Agenda. Introductions Office 365 Beta Word, Excel, PowerPoint Visio, OneNote, Office Mobile Break Access Services & Office Web Apps Good, Better, Best Wrap-up and Giveaways.

meadow
Download Presentation

May 11 th , 2011

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. May 11th, 2011 SharePoint & Office – Better Together Raymond Mitchell, Don Donais, Nick Stillings

  2. Agenda • Introductions • Office 365 Beta • Word, Excel, PowerPoint • Visio, OneNote, Office Mobile • Break • Access Services & Office Web Apps • Good, Better, Best • Wrap-up and Giveaways

  3. User Group Goal / Objectives Develop and support a local community focused on Microsoft SharePoint Technologies Educate user group members about SharePoint Technologies Transfer knowledge within the community Communicate best practices Introduce new products / solutions

  4. Introductions – MNSPUG Sponsors Avtex (www.avtex.com) • Technology consulting company • Practice area focused on SharePoint Benchmark Learning (www.benchmarklearning.com) • Training on many technologies Microsoft (www.microsoft.com) WroxPress (www.wrox.com) O’Reilly (www.oreilly.com)

  5. www.SharePointMN.com • Website for user group • SharePoint resource documents • SharePoint resource links • RSS Feeds • Meeting Schedule • Past User Group Presentations • info@sharepointmn.com www.sharepointmn.com

  6. Social Networking • Linked In group – The most interactive… includes job postings… http://www.linkedin.com/groups?gid=1878792 • Facebook group http://www.facebook.com/home.php?#/group.php?gid=27333305456 • Twitter tags - @MNSPUG and #MNSPUG

  7. Upcoming Schedule • Next Meeting June 8h 9:00 AM to 11:30 AM Microsoft’s Bloomington Office Topic: SharePoint in the Cloud Check www.SharePointMN.com for updates! • Ongoing Schedule 2nd Wednesday of every month 9:00 to 11:30 am Microsoft’s Bloomington Office

  8. Local and Online Events SharePoint 101 – May 19, 2010 9:00 AM *FREE*http://www.benchmarklearning.com/Resources/Events.aspxBenchmark Learning – Edina, MN ScarePoint Saturday – October 29th (tentative) http://www.sharepointsaturday.org/twincities/default.aspxNormandale College– Bloomington, MN Microsoft Webcast Calendar of Events http://www.microsoft.com/events/webcasts/calendar/monthview.aspx#filter SharePoint ShopTalk (Online) – Every Thursday @ 11:30 AM http://sharepointshoptalk.blogspot.com/

  9. Conferences TechEd, North America – May 16-19th, 2011 http://northamerica.msteched.com/ Atlanta, GA SPTechCon– June 1-3rd, 2011 http://sptechcon.com/Boston2011/ Boston, MA SharePoint Saturday – The Conference – Aug 11-13th, 2011 http://www.spstc.org/Pages/default.aspx Washington, DC

  10. Announcements SharePoint Diagnostic Studio • SharePoint Administration Toolkit • http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=971 SharePoint. Microsoft.com /blog

  11. Giveaways!

  12. Minnesota SharePoint User Group – 7 Years Old MNSPUG http://www.sharepointmn.com

  13. Meeting #1 May 2004 User Group Kick-Off with guest speaker: Chris Capossela

  14. Meeting #11 May 2005 Designing / Branding SharePoint 2003

  15. Meeting #21 May 2006 SharePoint and Office 2007

  16. Meeting #33 May 2007 Site Templates and Site Definitions "Fab 40" Community Kit for SharePoint

  17. Meeting #44 May 2008 SharePoint Implementations – Real World Examples

  18. Meeting #50 January 2009 Back to Basics: WSS First recorded session!

  19. Meeting #66 May 2010 Office 2010 Launch! Live stream of event

  20. Meeting #78

  21. Top 7 • Kickoff meeting with Chris Capossela • “Web Part of the Month” - XML Web Part • The Demo Server - MNSPUG with the screwdriver • Birthday SPUG – Tom Moen: “he’s old enough to drive now” • MNSPUG at the SharePoint Conference • Nick Stillings – Live Meeting, the Roundtable, everything • 2800+ registered users

  22. Presenters

  23. Quick Intro Raymond Mitchell • Senior SharePoint Consultant • Author • @iwkid • www.iwkid.com

  24. Quick Intro Don Donais • SharePoint Consultant • Drummer • @ddonais • talesfromitside.wordpress.com

  25. Quick Intro Nick Stillings • Business Productivity Technology Specialist • Talking Head • nickst@microsoft.com

  26. Office 365 Beta • Evolution of BPOS • Email & Calendar • Office Web Apps • SharePoint Online • IM/Online Meetings (Lync)

  27. Office 365 Beta • Two beta programs: E3 for larger, enterprise organizations P1 for organizations < 25 employees

  28. Demo!

  29. Office 365 Beta • 3rd Party Tool: MetaVis Migrator • Download a Free 1GB License of MetaVis Migrator for Office 365 and Begin Migrating Content to the Cloud Today!* http://www.metavistech.com/product/migrate-to-office-365-sharepoint-online

  30. Word, Excel, PowerPoint

  31. Word Integration • Connect to Document Library Workflow Versioning Check-Out Connect to Office • Co-Authoring Office Web App: Excel & OneNote Rich Client: Word, PowerPoint & OneNote Up to 10 Simultaneous Users

  32. Document Information Panel (DIP) • Associated with Content Types and Metadata • Allows Metadata to be displayed in Rich Client • DIP fully customized with InfoPath • Metadata can be added from within document

  33. Excel Integration • Connect to Document Library • Export to Excel Saves as Microsoft Excel Web Query Files (.iqy) Use Excel to analyze content Retains connection to SharePoint • Import Spreadsheet Prep before import Site Template • Export Table to SharePoint List Similar to Import Spreadsheet Does not retain a connection to SharePoint

  34. Excel Services • Only Available in Enterprise 2007 & 2010 • Component of Microsoft BI Report Center 2007 Business Intelligence Center 2010 • Functionality PivotTable and Charts Ability to Interact with Spreadsheet SharePoint 2010 can add formulas • Display content in Excel Web Access Anywhere within Site Collection • Used to Render Excel in Office Web App

  35. PowerPoint Slide Library • SharePoint List Template Found in all versions of SharePoint • PowerPoint Integration Reuse Individual Slides • Once Connected to SharePoint Slide Library Keep Source Formatting Update When Slide Changes

  36. PowerPoint Broadcast Slide Show • PowerPoint Broadcast Site Collection Specific SharePoint groups created • Broadcast Administrators • Broadcast Presenters • Broadcast Attendees • Need Access to Broadcast Site Collection • Pre-requisite Browser needs Silverlight installed • Presentation only No audio or video files

  37. Visio, OneNote, Office Mobile

  38. Visio Workflow • Business users design workflows in Visio • Information Workers / Developers import Visio into SharePoint Designer to create workflow

  39. Visio Services • External Data Connections • Visio Web Access • SDK Samples

  40. OneNote • Create Notebook on Network (SharePoint)

  41. Office Mobile • Windows Phone 7, Windows Mobile 6.5 • Word Mobile • Excel Mobile • PowerPoint Mobile • OneNote Mobile • SharePoint Workspace Mobile Intranet requires NTLM (device must be on network) Internet requires Basic Authentication via UAG Publishing

  42. Break!

  43. Access Services & Office Web Apps

  44. Interface One Version of the Truth Deployable / Updateable Easy / Reliable to get to Data One Version of the TruthBacked-Up Permissioned VersionedAuditableRecycle Bin

  45. Simplest – Link the TablesUpload the File

  46. SharePoint Server Access Client ACCDB SharePoint Lists

  47. Demo

  48. Better – Access Services

More Related