sharepoint lists 101

46
SHAREPOINT LISTS 101 Thomas Duff 12/13/2013

Upload: thomas-duff

Post on 21-May-2015

566 views

Category:

Technology


0 download

DESCRIPTION

This presentation was used in our company's internal SharePoint User Group for some training opportunities.

TRANSCRIPT

Page 1: SharePoint Lists 101

SHAREPOINT

LISTS 101Thomas Duff – 12/13/2013

Page 2: SharePoint Lists 101

Agenda

• What are Lists?

• What kind of data can be stored in a List?

• How do you view the data in a List

• Questions

Page 3: SharePoint Lists 101

Everything is a List in SharePoint

Page 4: SharePoint Lists 101

You’ll see the word List in many places to remind you.

Page 5: SharePoint Lists 101

A List is made up of fields known as Columns

Page 6: SharePoint Lists 101

Views are used to show the List Items in your List

Page 7: SharePoint Lists 101

To see all the Lists in your site, use All Site Content

Page 8: SharePoint Lists 101

There are various types of Lists and Libraries

Page 9: SharePoint Lists 101

This was the List I created for the Views 101 session

Page 10: SharePoint Lists 101

The list of templates are mostly List templates

Page 11: SharePoint Lists 101

Using a Custom List template for our demo

Page 12: SharePoint Lists 101

SharePoint creates the new List for you

Page 13: SharePoint Lists 101

You are now the proud owner of a new List

Page 14: SharePoint Lists 101

These are the default columns for a Custom List

Page 15: SharePoint Lists 101

The Title column is required (but can be renamed)

Page 16: SharePoint Lists 101

Creating a Multiline Column

Page 17: SharePoint Lists 101

Options for a Multiline Columns

Page 18: SharePoint Lists 101

Here’s how your new column looks in the List

Page 19: SharePoint Lists 101

Creating a Choice Column

Page 20: SharePoint Lists 101

Options for a Choice Column

Page 21: SharePoint Lists 101

Creating a Number Column

Page 22: SharePoint Lists 101

Options for a Number Column

Page 23: SharePoint Lists 101

Creating a Currency Column

Page 24: SharePoint Lists 101

Options for a Currency Column

Page 25: SharePoint Lists 101

Creating a Date and Time Column

Page 26: SharePoint Lists 101

Options for a Date and Time Column

Page 27: SharePoint Lists 101

Creating a Lookup Column

Page 28: SharePoint Lists 101

Options for a Lookup Column

Page 29: SharePoint Lists 101

Creating a Yes/No Column

Page 30: SharePoint Lists 101

Options for a Yes/No Column

Page 31: SharePoint Lists 101

Creating a Person or Group Column

Page 32: SharePoint Lists 101

Options for a Person or Group Column

Page 33: SharePoint Lists 101

Creating a Hyperlink or Picture Column

Page 34: SharePoint Lists 101

Options for a Hyperlink or Picture Column

Page 35: SharePoint Lists 101

Creating a Calculated Column

Page 36: SharePoint Lists 101

Options for a Calculated Column

Page 37: SharePoint Lists 101

All the columns we created for this List

Page 38: SharePoint Lists 101

Do you need the columns reordered?

Page 39: SharePoint Lists 101

Filling out the default form for the List Item

Page 40: SharePoint Lists 101

Filling out the default form for the List Item

Page 41: SharePoint Lists 101

Some column features in specific fields

Page 42: SharePoint Lists 101

Some column features in specific fields

Page 43: SharePoint Lists 101

And here’s what the view of your List looks like…

Page 44: SharePoint Lists 101

And here’s what the view of your List looks like…

Page 45: SharePoint Lists 101

And if you want to export your List to Excel…

Page 46: SharePoint Lists 101

Questions?

• Email: [email protected]

• This presentation and associated Word document with

this information will be posted for all to use.