Microsoft SharePoint Training
Toronto, Mississauga, GTA, SW Ontario
Customized SharePoint training will enable you to understand what the different components of SharePoint are and what they can do. How is it possible to modify the settings in SharePoint libraries and lists to suit your needs. Your training is “hands on” you create sites, libraries and lists (Not just listen to the theory). Work with your SharePoint sites and organize them to ensure easy navigation.
By working with your SharePoint site (or similar sample site) you will build sites, libraries, lists and pages that are relevant to your needs.
Below is a suggested list of topics but these can be modified to suit your needs.
Get information or a quote on SharePoint Training
Send us an email Call 905.271.1119
Level 1 Basics of SharePoint Training Outline
Topic 1: Microsoft SharePoint Overview
- SharePoint: What is it and what can it do?
- Navigation in a SharePoint website
- Site hierarchy & architecture
Topic 2: SharePoint Lists, Columns & Views
- Filter & sort a SharePoint list
- Add new items to a SharePoint List
- Modify lists & SharePoint views
- Add new information columns (Meta Data) to a list
- Column types: Text, numbers, dates, dropdowns etc.)
- Benefits of SharePoint List views
Topic 3: Add a Custom SharePoint List
- Create a Custom List & Custom SharePoint Views
- Add a new Custom List
- Create a Custom View in a Share Point List
- Add extra SharePoint List columns in the View
- Modify a Custom View
Topic 4: Create Libraries
- Add a SharePoint library
- Word & Excel Libraries
- Upload an Excel or Word file
- Create a SharePoint alert
- Content types in Libraries
Topic 5: Working with Documents in Libraries
- Add new documents to a SharePoint library
- Open and/or check out documents
- Edit existing documents: Online or with full version of Excel etc.
- Co-Authoring or exclusive use
- Add document metadata to enhance search
Topic 6: Link Excel with a List
- SharePoint & Excel Lists
- Link an Excel worksheet to SharePoint
Topic 7: Create sites and sub sites
- Create a new team Site
- Set the navigation options
- Create Public Views
- Create a Survey
Topic 8: Wikis
- Work with Wikis
- Create Custom Wiki Pages
Topic 9: Communicate with the Team
- Communicate with Team Members
- Participate in a Discussion Board
- Contribute to SharePoint Blogs
Topic 10: Customize the Settings
- Customize Your SharePoint Environment
- Customize Settings (Personal and Regional)
- Create an Alert
- Subscribe to an RSS Feed
Topic 11: Site Administration
- Perform Basic Site Administration
- Manage Users and Groups
- Manage Site Look and Feel
- Perform Basic Content Management
Microsoft SharePoint Services Training Level 2 – Advanced
Topic 1: Create Site Collections & Pages
- Create a Site Collection with sub sites
- Manage the sites
- Add sub sites (child sites)
- Create a Page with Web Parts
- Moving and modifying the Web parts
Topic 2: Options for Lists
- Create a Custom List
- Customize the List Settings
- Add a dropdown column from another table (
- Connect one list to another)
- Create a Project Task List (Gantt Chart)
Topic 3: Discussion Boards
- Create Discussion Boards
- Manage Discussion Boards
- Customize existing Discussion Boards
- Email Feedback to Discussion Boards
Topic 4: Document Library Settings & Content Types
- Customize document libraries settings
- Activate Document Versioning
- Create Content Types
- Add Content Types to a library
- Create Library Templates
- Organize documents and folders in a Library
- Share Documents
- Make a copy of the library in Outlook
Training Topic 5: Site Permissions & Groups
- Manage site permission
- Assign Permissions for Groups (such as read only, edit or owner)
- Manage User level Permissions
- Site Level Security Settings
Training Topic 6: Work Flows in SharePoint
- Create a Workflow to automate document flow
- Activate a Work flow
- Manage Workflows
- Modify or add to a Workflow
Training Topic 7: Search & Index
- Search and Index SharePoint
- Index List Content
- Enable Search Options
Topic 8: Site Monitoring
- Manage Site Usage
- Set Site quotas
Topic 9: Site Maintenance & Backup
- Manage Site Maintenance
- Perform a Backup
SharePoint Site Architecture
Folders or No Folders
It is usually better to have little or no folders or sub folders in libraries and instead use more custom data (called Meta Data) to separate different document types . If there are folders avoid nesting multiple folders as this makes files difficult to find.
Limit the number of Sub Site Levels
While it is good practice to have sub sites (a1 and a2 are sub sites of A etc.) – do not have more than 2 or 3 levels. If there are too many levels it will be difficult for people to navigate to the sub site they need.
Sub Site Naming Conventions
Give sub sites a short and descriptive name – just enough so that it is easy to remember and type so that most people will know what it is for (site.ca /HR). Note that you can give a sub site a different title but it will be impossible to change the name afterwards. Note do not use spaces as these show as %20.
Using Microsoft SharePoint more effectively
Give permissions to a Group not to individuals
It is possible to give a person permission to access a site or library but this will be very difficult to keep track of after a few weeks. It is much better practice to add a person to a Group and the Group has permissions on the Site or library. If the person joins with a team working on Plan A then the person would be added to the Group “Plan A Group”. If the person leaves they are removed and if “Plan A” is complete then the group is also removed – all the people at once.
Use Adding a drop down or choice to a custom column of meta data
Task When adding a custom column to track what kind of document it is (quote, contract, meeting etc.) it is better to create a drop down. With a drop down people can choose form a list and this reduces spelling errors and lets the users know all the options. Note that a entry such as “Other” could be added to cover documents which do not fit any of the criteria.
Create Views to segment data
SharePoint comes with a few default views but many more views can be created. Views can apply a filter so if you only want to see ‘contracts” then apply a filter on that column. Views can also group the data, so the contracts could be grouped by City. A SharePoint view can be personal (for you only) or public so all people with permissions to library can see it.
Give permissions by Sub Site or Library
While it is possible to give permissions on individual documents this will be very time consuming and difficult to update after a few weeks. Only share the entire library or sub site with Groups. It will be easy to see who has access to the library.
Turn on Version Control History if editing manuals etc.
Be For library where people are editing documents and you may want to go back to an earlier version turn on the version control. Go to Library Setting and there find the option to enable version control. If fact it is possible to have Major and Minor versions.
Only give the minimum permission level to any group of SharePoint users. If they only need to see the documents then Read level is sufficient. Never give Owner permission unless the group really needs it as they could delete the site and/or documents.
Create Alerts to warn you of changes
If you need to know when a document is changed create an Alert on it. This means when someone changes the document you will get an email or a text message.Do not create alerts on too many files as this would generate far too many emails in your inbox.
Link Task list to Outlook
SharePoint Task list can be linked to your desktop version of MS Outlook – change s made to the list will be visible in Outlook.
Work Flows on Documents
If a document always goes to the same path for approval etc. then consider a work flow. SharePoint comes with some work flows (depending on the version) but there is usually a Document Approval work flow. This could be set up so that it is started by a user or automatically once the document is uploaded to SharePoint library. Usually the document is send to other people and they accept or reject it (once rejected the work flow stops), if accepted it may continue to a manger for approvel.
SharePoint Library linked to MS Outlook
You can link a SharePoint library to Outlook, this means you can click on a document and you actually go to SharePoint. Note htis way your documents are safe and other people can also access them – if you give them permissions.
Do not make URL over 256 characters
Some The limit in SharePoint for URLs is 256 characters so do not try to exceed it as it is not possible.
Microsoft is always adding features to SharePoint and it is not every 3 to 4 years as in the past. Now the updates are every couple of months or so.
Components of SharePoint Architecture
Organizing a SharePoint site and managing the content is a challenging job and most of the groups using the sites should have input. Microsoft SharePoint offers the following building blocks:
Site Collections: Top level sites which are containers with a unique name used to store a collection of sub sites.
Sites (and subsites): This is the core (and most visible element) of SharePoint. Sub Sites are the containers which will store libraries, lists and pages. Links can be made directly to the homepage of this site
Libraries: These are contained within sites and store files (such as Word or Excel docs, pictures, videos and PDFs etc.).
Lists: These are similar to libraries but instead of storing files they store ‘items’. An item is like a record in a table or database.
Folders: These are located in libraries and lists, folders are sub containers with names Note that it is not advised to have too many folders – better to use Metadata (see next point).
Metadata: This is Data about Data – properties that are applied to items inside libraries or lists (such as Region, City and Category)
Managed metadata: This is centralized version of metadata that can be managed in an enterprise way.
Content Types: Controls the type of item being added to the library and what metadata see above) is needed for a type of document, or when and if the documents can be deleted.
Note there is no absolutely correct way to arrange all the parts of a SharePoint site to satisfy all users, it should be organized to suit the majority of users.
About our Training
Onsite fully customized training targeting your specific needs in MS SharePoint – not just a pre-set fixed list of topics. The training can be with your own SharePoint Site and this means you are productive even on the training day (the library or list you create can be used immediately.) We work with you and build your training agenda based on your training objectives and goals. Microsoft SharePoint has many options. While most people will use a library and the default settings, other people will modify the settings to suit their needs. A vast amount of custom views can be created and these can be either personal or public views.
We provide onsite MS SharePoint training in the GTA, Toronto, Mississauga, Oakville, Burlington, Hamilton, Niagara, Kitchener, Waterloo, Guelph, Vaughan, Concord, Markham, Pickering, Barrie areas. Training is done on your location so you and your team do not have to drive across town – no wasted time. Note that often a hotel meeting room can be used for training – people just need to bring their laptops. We offer customized MS SharePoint training for Employees, Managers, Executives involved in Financial, Accounting, Marketing, Sales etc. in Toronto, Mississauga, Brampton, Ontario, Kitchener, Waterloo, Hamilton, and Cambridge, Canada.
We provide courses on Microsoft Excel, PowerPivot, Access, Microsoft Project, Office 365 & SharePoint End-User. In Microsoft Excel courses the agenda covers pivot tables, MS Excel data analysis, VLOOKUP, , etc. PowerPivot training in Toronto covers importing and linking tables & DAX formulas. MS PowerPoint covers creating and organizing slides. Microsoft Project training covers Gantt charts & Scheduling in Mississauga GTA etc. Training on SharePoint End-User Toronto covers Lists & libraries. Microsoft Office 365 covers OneDrive, Sites, Outlook, Calendar We also offer onsite training in other Microsoft Office software: PowerPivot, MS Project, MS PowerPoint, MS Word, MS Outlook, MS Access, Office 365 and SharePoint end-user training. MS Access queries, forms linking tables
Call 905-271-1119 or Email for Info or a quote[/two_third_last]
Create custom Views to see just the documents you need to see and also group them
Read Only Access
You can grant “read-only” to specific libraries – people can see the documents but not edit them
Add Custom Columns
Add custom columns to libraries and lists to enable easy organizing and search