How to Create a Pareto Chart in Excel
Posted on November 20th, 2008 by Joseph Harris
Creating Pareto Charts
Archive for November, 2008
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
ExcelYogi.com
Analyst Resources
Bookmark It
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, as text.
“col” Column number [...]
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 =concatenate(a1,a2,a3) in A4
The result in A4 would [...]
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