Logo

Office 2010 (Beta version) is released with is tag line Ideas are everything, it gives you powerful new tools to express your ideas, solve problems, and connect with people. Connectivity is the key in this version, with rich and powerful new ways to deliver your best work at the office, home, school or anywhere.

See Excel 2010 in action.

Top 10 Benefits of Office 2010 here

Hello friends,
Try these 5 tricks from crabby_office_lady, you will like it.
http://office.microsoft.com/en-us/help/HA010429171033.aspx
The tricks:
1. Skip through your worksheets with a shortcut
2. Stretch out: Insert a line break in a cell
3. Make a style statement with worksheet tabs
4. A change of scenery: Move or copy a worksheet
5. Double-click your way to fast formatting

http://office.microsoft.com/en-us/help/HA010429171033.aspx

Timelines are used to show progress, summarize details, and help users visualize trends and understand the big picture.

This video tutorial is from Microsoft Eduction. [Click here to learn]

Excel 2007 shortcut keys & Functions

Once you have inserted comments in a workbook, you can change the font and font size for all comments in the workbook with the following code.


Sub FormatAllComments()
'http://daily-exceltips.blogspot.com/
Dim ws As Worksheet
Dim cmt As Comment
For Each ws In ActiveWorkbook.Worksheets
For Each cmt In ws.Comments
With cmt.Shape.TextFrame.Characters.Font
.Name = "Times New Roman"
.Size = 12
End With
Next cmt
Next ws
End Sub

If your excel comments have moved out of position, you can reset them to there original position by using the following code:

Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub

How to Create a Pivot Table in Excel 2007 - Video - For Dummies

PPost Before “read more”

And here is the rest of it