Archive for November, 2008

How to Create a Pareto Chart in Excel

Posted on November 20th, 2008 by Joseph Harris

Creating Pareto Charts

F4 Function Key in Excel

Posted on November 20th, 2008 by Joseph Harris

To quickly ad the $ symbol around your cell references simply select the cell references in the formula bar and press f4. For example, if you have =A1 in the formula bar and you highlight and then press f4, the result will be =$A$1. A quick way to create an absolute cell reference. Joseph Harris [...]

Excel CELL () Function

Posted on November 20th, 2008 by Joseph Harris

The CELL function can be used to find out information about a cell such as formatting, size and contents. Format: cell(info type, range) “info type” is the type of information you would like to retrieve from the cell. “info type” can be any of the following values: “address” Reference of the first cell in reference, [...]

Excel Concatenate Function

Posted on November 20th, 2008 by Joseph Harris

The Excel concatenate function can be used to combine multiple cells into one. Syntax CONCATENATE (text1,text2,…) Text1, text2, are items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references. Real world example: Cell A1 contains: I Cell A2 contains: Love Cell A3 contains: Concatenate Type [...]

Dashboarding Best Practices

Posted on November 16th, 2008 by Joseph Harris

Best practices for creating dashboards

Excel Function “AND”

Posted on November 16th, 2008 by Joseph Harris

AND function use