How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Median Function in Excel - Excel tutorial
The median is widely used in statistics where might be seen as a better indication of central tendency than arithmetic mean.
More cool Excel tutorials:
Prevent Case Sensitivity in VBA Code
By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words.
The ISERROR function in Excel
The ISERROR function allows you to test whether a cell has generated an error message. This is particularly useful for division by zero (#DIV/0!) errors and is often combined with an IF statement to provide an alternate action if an error is generated.
Consolidating Data from Different Worksheets
Excel's Consolidation feature makes short work of combining numerical data in tables stored on several different worksheets or even different workbook files.
Basics of Spreadsheets
This article will show you the basics of spreadsheet.
Current Date & Time
The following two forumula are extremely useful. As simple as they may seem, they can play a vital role in many Excel documents.