10 Excel Skills and Top 10 Sites

10 Excel Skills that can help you analyze data like a pro:

1. Sparkline
2. Power Pivots
3. Conditional Formatting
4. Text Formulas
5. Slicers
6. Flash Fill
7. Charts
8. Vlookup
9. IF Formulas
10. Quick Analysis

Top 10 Sites to learn Excel for free:

1. Microsoft Excel Help Center
2. Excel Exposure
3. Chandoo
4. Excel Central
5. Contextures
6. Excel Hero
7. Mr. Excel
8. Improve Your Excel
9. Excel Easy
10. Excel Jet

SharePoint Designer 2010 - Set Variable [Today]-x Days

To set a DateTime field to [Today] + 5 days using a SharePoint Designer 2010 Workflow, this is what I did:


1) Create a Local Variable (ETA Date) of type Number
2) Use a Do Calculation task in the workflow and set:

value: Workflow Context:Date and Time Last Run (As Double)
operation: plus
value: 432000 (number of seconds in 5 days or 60*60*24*5)
Output to: Variable: ETA Date

3) Finally, set the value of the respective field of the current item to the ETA Date variable

In your case, use the subtract operation and the second value is 2419200 (60*60*24*28).

Note: Compare the Date in Workflow, Current Item:ReminderDate equals (ignoring time) Today

Reference Link

Handel Multiple Click on Elements JQuery

I have experience that user on the page try to click multiple time on the button, in case of page delay, this is a short way to handle such issue.


This will remove all event handlers:

$(element).off().on('click', function() {
    // function body
});

To only remove registered 'click' event handlers:

$(element).off('click').on('click', function() {
    // function body
});

Send E-mail from javascript using REST API - SharePoint

In SharePoint 2013 we can send emails using REST API where we can utilize SP.Utilities.Utility.SendEmail for doing the job. 

Note: The recipient is limited to a valid SharePoint user for security reasons.

function sendEmail(from, to, body, subject) { //Get the relative url of the site var siteurl = _spPageContextInfo.webServerRelativeUrl; var urlTemplate = siteurl + "/_api/SP.Utilities.Utility.SendEmail"; $.ajax({ contentType: 'application/json', url: urlTemplate, type: "POST", data: JSON.stringify({ 'properties': { '__metadata': { 'type': 'SP.Utilities.EmailProperties' }, 'From': from, 'To': { 'results': to }, 'Body': body, 'Subject': subject } }), headers: { "Accept": "application/json;odata=verbose", "content-type": "application/json;odata=verbose", "X-RequestDigest": jQuery("#__REQUESTDIGEST").val() }, success: function(data) { alert('Email Sent Successfully'); }, error: function(err) { alert('Error in sending Email: ' + JSON.stringify(err)); } }); } $(document).ready(function () { SP.SOD.executeFunc('sp.js', 'SP.ClientContext', SendEmails); }); function SendEmails() { var from = 'info@domain.com', to = 'toUser@domain.com', body = 'Email using REST API', subject = 'Email FYI'; sendEmail(from, to, body, subject); }

Note: You can add 'CC' and 'BCC' property also to send email, property 'results' having array.