One the downsides to having all kinds of templates and style sheets in MS Excel is that you pretty much get locked in to creating sheets that look like everyone else’s; which doesn’t do much for creativity or inspirational ideas. This is why it’s a good idea to learn how to use Excels formatting tools.

Read more:
How to Manually Format Spreadsheets in Excel 2010

Oftentimes, users of Excel find they’d like to be able to import data from an external source such as a web page, this is particularly true of web sites that list stock information. What many people don’t know is that Excel does have a facility for doing just this.

See the rest here:
How to Use Live External Web Data in Excel 2010

Although Excel is capable of calculating a number of descriptive and inferential statistics for you, it is often better to show a visual representation of data when presenting information to a group. Using Excel’s built in trendline function, you can add a linear regression trendline to any Excel scatter plot. Inserting a Scatter Diagram into Excel Suppose you have two columns of data in Excel and you want to insert a scatter plot to examine the relationship between the two variables

View post:
Add a Linear Regression Trendline to an Excel Scatter Plot