Excel Tips and Tricks

2010-04-01T05:46:00.000-07:00

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

The 5 Best Excel Tricks

2010-04-01T05:38:00.000-07:00

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

Create a timeline using Microsoft Office Excel

2010-03-22T00:27:00.000-07:00

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 Shortcuts and Functions

2010-03-21T23:46:00.000-07:00

Excel 2007 shortcut keys & Functions

Format All Excel Comments - VBA code

2010-03-21T23:23:00.000-07:00

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

Reset Comments to Original Position - VBA commend

2010-03-21T10:51:00.000-07:00

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

2010-03-21T10:35:00.000-07:00

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

PPost Before “read more”

And here is the rest of it

How to Add Data Labels to a Chart in Excel 2007 - For Dummies

2010-03-21T10:34:00.000-07:00

How to Add Data Labels to a Chart in Excel 2007 - For Dummies

PPost Before “read more”

And here is the rest of it

Formatting the X-axis and Y-axis in Excel 2007 Charts - For Dummies

2010-03-21T10:33:00.000-07:00

Formatting the X-axis and Y-axis in Excel 2007 Charts - For Dummies

PPost Before “read more”

And here is the rest of it

How to Create a Chart in Excel 2007 - Video - For Dummies

2010-03-21T10:31:00.000-07:00

How to Create a Chart in Excel 2007 - Video - For Dummies

PPost Before “read more”

And here is the rest of it

Vocabulary for Excel

2010-03-21T07:56:00.000-07:00

In this tutorial, i have listed some of the main vocabulary for excel. They are ...

Vocabulary for Excel

Active Cell – This is the cell in a spreadsheet where information will be placed. It is the cell that has been selected.

Ascending Decimals – Function that allows the user to increase decimals places of a number typed in a cell.

AutoSum – Function that automatically adds selected cells.

Cell – This is the place where information is held in a spreadsheet.

Cell Address – Use this to know the exact location of a specific cell. Noting the intersection of the column and row forms it.

Column – In a spreadsheet, these are the vertical spaces. Columns are headed with letters.

Descending Decimals - Function that allows the user to decrease decimals places of a number typed in a cell.

Dollar Symbol – Function that changed the contents of a cell to currency. Adds a dollar sign and decimal places

Equation – A mathematical equation typed into a cell.

Entry/Formula Bar – The toolbar on the Microsoft Excel window that shows the text or equations assigned to cells

Merge and Center – Function allowing the user to select a number of cells to create one large cell with the information centered within the large cell.

Microsoft Excel – A spreadsheet application tool that analyzes data in a table format using formulas.

Name box – Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.

Percent – Function that allows the user to change the value of a cell to a percent.

Row – In a spreadsheet, the row is the horizontal group of cells. Rows are named with numbers, i.e.1, 2, 3.

Sheet tabs – Labels located at the bottom of the workbook window indicating the worksheets.

Spreadsheet – A document that is used to crunch numbers and formulas.

Sort – In a database, this function puts the records into a specific order.

Workbook – An Excel document which contains three worksheets by default but can have more than three.

Worksheet – A single sheet contained in an Excel workbook.

"das Lernen ist alles"

Excel 2007 Shortcuts

2010-03-21T06:45:00.000-07:00

In this section, your going to learn shortcuts. By using shortcuts, you may experience a significant increase in your productivity.

In this section, your going to learn shortcuts. By using shortcuts, you may experience a significant increase in your productivity.

Learn to use the combination of Ctrl, Alt, and Shift along with the Arrow Keys to navigate and select text. Everyone's work is different, but if you do a lot of text editing, and particularly if you are an avid spreadsheet user, pay attention to how much you switch from typing to mousing. Back and forth, back and forth ... What a waste! Learning some navigation shortcuts can save a lot of time.

I have provided some links to download these shortcut list.

http://www.scribd.com/full/5626852?access_key=key-2bna014ooaslevo45jjs

This is from Microsoft itself
http://office.microsoft.com/en-us/excel/HP100738481033.aspx

If you have any queries in Excel 2007. Post your questions we will find the answer

2010-03-21T06:20:00.001-07:00

New to Excel 2007?

2010-03-21T05:47:00.000-07:00

Interactive: Excel 2003 to Excel 2007 command reference guide

If your new to Excel 2007, we will be surprised to see the new changes in it. Menus are replaced with Ribbons, Dynamic charts, Pivot tables, this are few. First learn excel 2007 tools, by knowing its new location in Excel 2007. In this section you are going reveal this with a interactive guide from microsoft website, we can even download this guide for your future reference. Lets beginnen

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

or
If you prefer to see a table of all Office 2003 menu and toolbar commands and their locations on the Ribbon in the 2007 Office system. Download this mapping workbook for the microsoft website

http://office.microsoft.com/en-us/templates/TC102128621033.aspx