Archive for the ‘Narrow Focus’ Category

Excel Quick Tip Tutorial on Calculating Standard Deviations

Standard Deviation: The usual variation from a mean (~average) in a group of numbers.  The average variation from the average.

If you’re thinking there should be a simple way to calculate the standard deviation of  a column in excel you’re right there is!  The formula is:

=STDEV(A1,A2)

or generically:

=STDEV(cell range)

 

Here are some examples of how STDEV() can be used:

Read the rest of this entry »

Tags: , , , ,

No Comments


How to Merge Text Into One Cell

Combining two or more strings and values into one cell by gluing them together is know as concatenation.  In Excel concatenation can be express in two ways:

=CONCATENATE(A1,A2)

OR

=A1&A2

Where the arguments can be upto 30 cells and / or custom strings enclosed by quotes.

Here are some examples of how it can be used:

Read the rest of this entry »

Tags: , , , ,

No Comments


How to Calculate Totals Using SUM() in Excel

Totaling the values within a group of cells, columns, or rows is done using the SUM() function. It looks like this:

=SUM(A1,A2)

Here are some examples of how it can be used:

Read the rest of this entry »

Tags: , , , ,

No Comments


How to Find an Average in Excel

Finding an average of a group of cells in Excel is done using the AVERAGE() function.  It looks like this:

=AVERAGE(A1,A2)

Here are some examples of how it can be used:

Read the rest of this entry »

Tags: , , ,

No Comments


How to Calculate the Difference Between Two Date in Excel

Guide to Simple Date Operations in Microsoft Excel

Calculate the number of days between two dates
Calculate the number of work days between two dates
Calculate the number of months between two dates
Calculate the number of months between two dates in different years
Calculate the number of years between two dates
Why don’t my results look right and end in the year 1900?

Read the rest of this entry »

Tags: , , ,

No Comments



SetPageWidth