Array Formulas and Average Calculations

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: