Group items tagged

We're bringing Yammer to a city near you with Yammer on Tour-a free event series that brings together customers, partners and thought leaders for a unique opportunity to hear our vision for enterprise social, network with like-minded peers, and learn directly from customers how to usher in success in today's rapidly changing business environment. Yammer on Tour features an action-packed half-day agenda including: Keynotes and appearances by Yammer co-founder Adam Pisoni and customers Breakout sessions featuring product insights and expert discussions on enterprise social success Hands-on training and certification Networking and demos from Yammer and our partners in the expo hall Join us at Yammer on Tour in the following cities: New York-April 9: Register today Chicago-April 16: Register today Dallas-May 15: Registration opening soon We look forward to seeing you at one of these events!

Forms are the cornerstone of business applications, and plenty of options exist to create a form in SharePoint. Which one you use will depend on your needs, technical skill and the version of SharePoint you are using. In this article we'll explore seven ways to build forms in SharePoint along with some of the pros and cons of each. All these options will be storing the data in an existing SharePoint list. SHAREPOINT LISTS Default forms are available for any SharePoint list. Create a list and you have a corresponding form to add and modify items. Options are available to organize the order of fields, format them, validate input, add basic calculations and attach files. There are also more advanced options such as limiting permissions to item owners and enabling workflows. You can modify all of these under List Settings for the list. These generic SharePoint forms are a good choice for simple applications that don't have too many columns or records and that only require basic functionality. Lists also offer a data sheet view to edit a limited set of columns, much like a spreadsheet. What you see is what you get with these basic forms. If you need to break fields up into multiple tabs, or perhaps have business logic run on them in real time, you'll need to keep on reading. And although theoretically a list can store millions of items, you can only access up to 5,000 items in any view (in reality the numbers are far lower before performance degrades considerably). Basic Sharepoint list form - www.office.com/setup SHAREPOINT DESIGNER Creating a custom form in SharePoint Designer is relatively easy. You take an existing SharePoint list and use Designer to create a new .aspx page which renders and controls the form. There are files used by a list to create forms, one each to add, edit and view. These are located in the same folder as their associated SharePoint list. With Designer you can show or hide fields based on certain criteria, change the layout, use va

Liam Bastick has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many internationally recognized clients, providing and reviewing strategic and operational models for various key business assignments. You can check out Liam's previous articles at www.sumproduct.com/thought, where you can also subscribe to the monthly tips and tricks newsletter. Ever had to sum data based on multiple criteria situated in different Microsoft Excel worksheets? This article provides a quick tour of INDIRECT references and Table functionality while combining qualities of the SUMPRODUCT function with the SUMIFS function, providing a solution to the mother-of-all Multiple Criteria problems. The functionality is best explained by walking through an example: Ivana: Car Sales has four divisions, cunningly called North, South, East and West. Each quarter, the four divisions are required to submit sales reports detailing the month of sale, the sales person, the car color and the price the car was sold for. www.office.com/setup The question is: how can you determine how many red cars Charlie sold in February in total across all four divisions? The answer would be fairly straightforward if the data were all on one worksheet. For a single criterion, SUMIF would cope admirably well, while for several criteria, SUMPRODUCT could be used to generate the answer (for further information see my blog posts on the SUMPRODUCT function and approaches to addressing multiple criteria in one worksheet).

This website gives virtual video tutorials which is great for people who need to visually see how things are done through Photoshop. There is also a forum where people leave their questions and comments about Photoshop.