Would you like to enhance your Microsoft Excel 2010 skills? If so, join us October 12 at 3:00pm EDT.  If you missed this date our event is now available on-demand.

Product(s): Microsoft Excel 2010
Duration: 60 Minutes
Start Date: (This event is now available on-Demand!)
Previously held Live on October 12th, 2011

Event Overview: This entire session is
centered on a single notion. Excel is a powerhouse. Many of us have only
scratched the surface of its potential. Formulas and Functions are the gateway
to this functionality. Utilize the built-in formulas that Excel has to offer and
get accurate results in a snap! We’ll discuss the difference between a formula
and a function and unlock the power contained in these tools. This session is a
must for moderate to heavy Excel users and those looking to expand their Excel
IQ.

This Free Live Event, is not availabe on-demand. Access this webinar and 1000′s of other related topics for Microsoft Office applications at Log on to Learn. www.logontolearn.com.
Complete access to all of our content is included in the $59 fee.

In this session, we will show you how to Freeze and Split panes in Excel 2010. Freeze panes allow you to freeze columns and rows making them visible as you scroll within a worksheet. Split panes allow you to split your worksheet into multiple views, letting you scroll in one pane of the worksheet, while other panes remain static.

Brand new to Excel 2010, Sparklines are tiny little charts located in a single cell that provides a visual representation of data.  This allows you to, in most cases, view your data and the chart at the same time. In this session we will show you how to add and remove Sparklines from an Excel worksheet.

Like this tip? Follow us on Facebook, www.facebook.com/knowledgewave for more great tips.

Link or Embed Excel Data into Microsoft Project

You can insert data from Microsoft Office Excel into Microsoft Project as a linked object that will be updated dynamically by changes made in the source file. You can also embed the data independent of its original file.

1. In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then click Copy.
2. In Project, on the View tab, click the view that you want.

To use a view that is not on the View tab, click the arrow on Other Views, then select More Views. From the list on the More Views dialog, select the view that you want, and then click Apply.

3. In Project, select the location where you want to insert the data.
4. Right-click to select Paste Special.
5. On the Paste Special dialog, do one of the following:
* To paste the data, without a link to the source document, click Paste.
* To link the inserted data to the data in the source document, click Paste Link.
6. From the list, select Text Data and then click OK.