Archive for April, 2009

Array Formulas and Average Calculations

April 30, 2009

I read a couple of excel tips today that could be quite useful under certain circumstances.  One of the tips involved arranging search keywords in excel using Array Forumlas.  Basically, if you need to know how frequent a word or group of keywords appear, you can use this formula.  The step by step tutorial was easy to follow along.

The other article discussed calculating averages that change.  It mentioned use for this tool in stock trading, as the average of various stocks and values change on a regular basis.  The author includes a simple and easy to follow tutorial.

VLOOKUP

April 28, 2009

I read an excel tutorial today about the VLOOKUP function in excel.  You can locate what you need quickly on your spreadsheet using this tool.  This function can be very useful for businesses that need to sort through a great deal of information.  Click Consulting also has a very detailed tutorial for using the VLOOKUP function.

Excel Colors and Terms

April 24, 2009

There are many neat features to be used in Excel.  I recently read an article on changing the colors in a range (http://blogs.msdn.com/excel/archive/2009/04/16/modifying-conditional-formatting-color-ranges-in-excel-2007.aspx).  It seems that Excel 2007 allows for new color shades, including pastel shades.  This makes for a more professional look on your spreadsheet.  There is a certain way to create colors, combining the hue, saturation, and luminosity.

Sometimes knowing the proper term for use in a spreadsheet can be confusing.  There are many terms, and using them the correct way means everything when you are trying to get a task done fast and efficiently.  If you would like to know the various terms, they are explained in great detail on this post http://spreadsheets.about.com/b/2009/04/22/ten-common-spreadsheet-terms.htm.  It is a very helpful reference tool, whether you are a beginner to excel or just need a quick answer.

Excel Ad-Ons

April 21, 2009

There are many neat ad-ons to excel.  For example, I just read an artcicle that you can now post your tweets to your Twitter account directly from Microsoft Excel (http://download.cnet.com/Post-To-Twitter/3000-2077_4-10907916.html?tag=feed&subj=newreleases&part=rss).  You first need to install it, and then it’s there for your convenience.  It’s nice that so many computer programs and websites are becoming intermingled, making it even easier for the user.  There is another add on called the Chart Tamer (http://download.cnet.com/Chart-Tamer/3000-2077_4-10913424.html?tag=feed&subj=newreleases&part=rss).  This feature makes useful charts available and allows you to create more effective charts.  You can try it for free, or purchase the product for a fee.