210 likes | 289 Views
The New Watercooler. SharePoint: Where Office Comes to Mingle. Brittany Kwait SPS Omaha ’13 Protiviti @ b ritkwait. Thank You!!!!. For Sponsoring the Information Worker Track. Agenda. Introductions Adage SharePoint and Office: Total BFFs Qs & As. Why are you here?.
E N D
The New Watercooler SharePoint: Where Office Comes to Mingle Brittany KwaitSPS Omaha ’13Protiviti@britkwait
Thank You!!!! ForSponsoring the Information Worker Track
Agenda • Introductions • Adage • SharePoint and Office: Total BFFs • Qs & As
Why are you here? • I am an information worker • I am The SharePoint Guy • And use SharePoint 2013 • And use SharePoint 2010 • And use Office 2013 • And use Office 2010 • And use Office 2007
Why is Protiviti here? • Over 15 years of effective technology solution implementation • 12-time Microsoft Gold Certified Partner helping over 250 clients world-wide achieve business goals • Have released a commercial work, project and portfolio management product on Microsoft from SharePoint 2007 through 2013 • Organizer of the annual SharePoint Conference .ORG and facilitates the largest SharePoint Group on LinkedIn, as well as a private user group • As a global leader in consulting and internal audit, leverages deep technical capabilities with a wide range of subject matter expertise to develop value-adding, customized solutions www.protiviti.com
Why am I here? • I ♥ SHAREPOINT! • And want you to, too! • Working with SharePoint since 2007, because of Office • Senior SharePoint consultant with Protiviti specializing in information architecture, business process automation, project management, and user experience • No-Code Solution Architect for 50+ clients across the Americas
:( Your SharePoint environment has gone through an update that it couldn’t handle, and now it needs to destroy everything you’ve worked so hard to build.
OWA 2013 • Your favorite productivity suite, only sweeter • Excel, OneNote, PowerPoint, Word
Content types • Any type of file, Office or otherwise (pdf content type) • Or any type of file • Special powers for the Office posse • Process automation • Information Panel
Co-Authoring • It’s the future—today!
Word • Word Automation Services (On Prem) • Save any file that can be opened in Word in any other file format that can be opened in Word • .doc → .docx; .rtf → .pdf • Compatability mode • New! Let SharePoint bridge your document Stream • Executes auto-update actions; e.g. ToC, indecies • Timer Job or On Demand • Blog editor
Visio • Visio Services – View & refresh diagrams within SharePoint • Workflow Creation (Premium/Pro) • Create real SPD workflows in Visio with a special drawer of shapes! • Or export SPD workflows to Visio for others to view • Visio Process Repository (site definition/template) • Simple site with single library. Most Visio template types installed as CTs some extra columns for diagram status, etc.
Access • Access Services: For publishing Access applications to SharePoint as an interactive web part • Access web app – Requires SQL Server to be installed and the Access app to be installed in its own site collection • Open with Access—set up sync / Access View
Outlook • Your outlook for success looks bright if you start here • Site mailboxes • Sync: • >Tasks!< • >Calendar!< • >Document libraries • < with Site Mailbox
Project • i • Bi-directional sync (Professional 2010/2013) • Schedule the project! Don’t let the project schedule you • Open/Export task list
OneNote • Site Notebook (feature!)
Excel • Excel Services = “’Excellent!’ said the Executives.” • Excel Services = Enterprise Only • Publish an Excel workbook to SharePoint • Pivots too! • Published data can be accessible to web services • PerformancePoint = Excel plug in for swanky SharePoint BI • Import Spreadsheet (not recommended)
Conclusions • What happened to PowerPoint?! • Get your teams to the watercooler • Get your files to socialize! • Office: Smoothly flowing from C:\ to Cloud • Give this presentation to your peers! • Plan the topiary, create the topiary, maintain the topiary
@britkwaitbrittany.kwait@protiviti.com Qs? OR Cs?