PDF-From SharePoint to Office 365

Development The path to your new playground S. Brian Alderman. SES-B325. Who am I?. Brian . Alderman. MCSE. , MCT, MCITP: SQL Server & SharePoint. www.microtechpoint.com. Brian@microtechpoint.com. @brianalderman & @microtechpoint. Co-Author SharePoint 2010 Administrator’s Companion. Brendan Griffin. Me.About. (). http. ://. aka.ms/fromthefield. @. brendankarl. . Senior Premier Field Engineer . @ Microsoft. Microsoft Certified Master: . SharePoint 2010. 10 years . experience with SharePoint. Sajan Parihar. SharePoint Business Planning. SPC181. This slide deck is up-to-date as of . today (Nov 14, 2012). The terms and conditions for how you can use the software are defined in the Product Use Rights (PUR) document, Product List document, and program agreement. The PUR is updated quarterly. Links to the current . Barak Cohen, Neil Wang. SPC073. How IRM works in SharePoint and in Office 365. What is new in SharePoint 2013. IRM and PDF. IRM Programmability. Q&A. Agenda. IRM. : Information Rights Management. Chris O’Brien, Andrew . Salamatov. CODE-B599. CONNECT TO . OFFICE 365 SERVICES. Users and . groups. EXTEND OFFICE . EVERYWHERE. Today. BUILD USING . AN OPEN PLATFORM. What is an . App . for Office?. Vision & Key Facts. Marek . Šamaj. Consultant. Microsoft. Increasing Productivity. SharePoint . Vision. HR, Finance, etc.. Team Collaboration. Personal. Enterprise Portal. Internet Presence. Employees. With Powell 365. Office 365: 100 M Monthly Active Users. SharePoint: 250% growth in cloud data stored. SharePoint / OneDrive: acquired by 85% of Fortune 500 companies. Teams: already adopted by 125,000 organizations. Vesa Juvonen. Principal Consultant. Microsoft. SharePoint Application Evolution. 2003 – What is an Application?. SharePoint was not an Application Platform, except web parts. Investments were in portals and content. Gavin Wall. Technical Architect. Fortescue Metals Group. Why Fortescue chose Office 365. Our SharePoint Online Journey. Challenges and Lessons Learnt. “The future of SharePoint is Online, embrace it”. Spring . 2014. Jasmine Witham. Eric Raznick. v1. WebAccess/Moodle Upgrade. Office 365 Migration. SharePoint Upgrade. Misc. . Changes (. A . Potpourri. ). Agenda. WebAccess 2 . Timeline. Mar 2013 . – Formed . on-premises, . in . the cloud, . and . everything . in between. …. “. “. Bill Baer. Senior Product Marketing Manager. Microsoft Corporation. Bill Baer is a Senior . Technical Product . Manager . 1. Principal Architect. Blue Chip Consulting. Group. http://www.bluechip-llc.com. Microsoft Community Contributor. Technet. Forums. MSDN Forums. Yammer Groups. Contact Information. Email: . Paul.Stork@bluechip-llc.com. Kameron Berget, . Brian Caauwe, Donald Donais, and Lucas Struck. Donald Donais. Agenda. MNSPUG Information. Base Feature Set and Licensing. Connecting with Office 365. Break. Office 365 Environment. More Improvements to Come. This book is for the SharePoint 8220power user8221 who needs a better understanding of how SharePoint formulas work, where they don8217t work, and how they are created. While at first glance SharePoint formulas appear to be simple calculations, they are both quite powerful and have weird limitations. In this book we will explore the basics of creating Calculated Columns and Validation formulas with some boring details, and over one hundred examples. We also explore workarounds for many of the limitations by using SharePoint Designer workflows and a few tricksWhere are formulas used in SharePoint?8226Calculated column formulas derive data from other columns in the same list item. These can be simple calculations and text manipulations, or complex Excel-style formulas.8226Column validation formulas are used to create custom validations for user entered data. These can be used to make sure that quotquantitiesquot are not negative and vacation requests are for dates in the future.8226Column default formulas, while very limited, can auto-fill columns with a date 30 days in the future or a message based on the month or day of the week the item was added.8226List / Library validation formulas are used to check the values from multiple columns to verify the relationship between two or more columns. Examples include making sure a task start date is before the task end date, or to make sure an entry has a quotprice per poundquot or a quotprice eachquot, but not both.Who is this book for?Anyone who works with creating and customizing lists and libraries. These include SharePoint on premise Farm Administrators, Office 365 SharePoint administrators, Site Collection Administrators, Site Owners, Power users, and Developers.Over 100 Examples8226Over 60 Calculated Columns examples8226Over 30 Column Validation examples822611 List/Library Item Validation examples (and every one of the Column Validation examples can be used here.)82267 Calculated Column Default Values examples822615 Workflow 8220workarounds8221 for things SharePoint formulas can8217t doTable of Contents8226Read Me First8226Tips for Formulas8226Calculated Columns8226Calculated Column Examples8226Calculated Default Columns8226Column Validation Formulas8226Column Validation Examples8226List/Library Item Validation8226List/Library Item Validation Examples8226Other Forms of Validation8226Workflow Workarounds8226Error Messages