Advanced-data-view-web-part-sorting-grouping-and-filtering

http://blogs.catapultsystems.com/tlingenfelder/archive/2009/07/29/advanced-data-view-web-part-sorting-grouping-and-filtering.aspx

Delete User from Site Collection

Hint:
Only site collecton administrators can make this changes.

Steps:
1. Go to top level site
2.

3. Click on "People and Group" 

4. Notice at the URL. At the end of the URL change MembershipGroupId=(whatever) to MembershipGroupId=0 

4. Click Actions 

5. Select the user and delete user from site collection

Open 2 excel files in separate windows

start - run - regedit:

Left column
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/commend:
Right column {adding (space)"%1"}
Double Click on (Default) and write - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Right Click on Command – choose "rename" and add something to the name  - for example 2 (commend2).

Left column
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:
Right Click on the folder ddeexec and choose "rename" and add something to the name  - for example 2 (ddeexec2)

Left column
HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/commend:
Right column {adding (space)"%1"}
Double Click on (Default) and write - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Right Click on Command – choose "rename" and add something to the name  - for example 2 (commend2)

Base ID, List Template ID, Content Type ID

http://joelblogs.co.uk/2011/06/16/sharepoint-2010-base-types-list-template-and-definition-ids-and-content-types-ids/

Color-Coding SharePoint Calendar Events

http://sharepointsolutions.com/sharepoint-help/blog/2012/10/color-code-events-on-a-sharepoint-calendar/

Hint: Filter the Calendar view as "category" is blank

Repeating Section in a List

By default, there is no option to insert repeating section in a customize form from the list.
The trick is copy and paste the control from other form that has repeating section already and it works.

SharePoint Nintex Words Quick Parts

http://docupoint.blogspot.com/2006/12/content-types-document-information.html

This helps to inject the properties in the word document directly.