How to set up a sheet for Histogram

 Suppose we have a series as shown in A. so first we set up B

The formula for Bin and frequency is as follows:

The formula for cumulative frequency is as follows:

How to remove Be careful! Parts of your document may include personal information that can't be removed by the Document Inspector

 here's how you fix it: Goto File in the upper left hand corner, then Options > Trust Center > Trust Center Settings > Privacy Options > then un-check the check box that says "Remove personal information from file properties on save", then hit OK. 

How to Extract the first letter of Every word in a sentence in excel

 Use this code

------

Function ExtractFirstLetter(text) As String

mystring = Left(text, 1)

For i = 2 To Len(text) - 1

If Mid(text, i, 1) = " " Then

    mystring = mystring & Mid(text, i + 1, 1)

End If

Next i

ExtractFirstLetter = WorksheetFunction.Substitute(UCase(mystring), " ", "")

End Function

--------------

Use it like this:

-------------------

How to Pull the distinct values from a column

 Regular distinct formula, just drag the cursor to get all the distinct values:

=IFERROR(INDEX($A$2:$A$10, MATCH(0, INDEX(COUNTIF($B$1:B1, $A$2:$A$10), 0, 0), 0)), "")

Where:

• A2:A10 is the source list.

How to subtract month from a date

 You can use the EDATE function to quickly add or subtract months from a date. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument. For example, =EDATE("9/15/19",-5) returns 4/15/19.