Excel

Create

Group Worksheets and Design Several at Once. You can group worksheets and everything you do on one is duplicated on the others you've selected.

Transpose. When you create a spreadsheet and realize the rows should be columns or vice versa.

Turn Off Automatic Hyperlinks. If it bothers you that every time you type the @ symbol or a Web page it turns into a hyperlink, you can turn this feature off.

Repeat Heading Rows Across Pages. This command will automatically print the column headings as the spreadsheet expands onto two or more pages.

Remake

Split Information in One Cell Into Two. You have information in one cell that should be in two or more. Example is Full Name instead of being split into First Name    Last Name.

Concatenate - Combine Information From Two Cells Into One. This is the opposite situation of splitting cell data. You have information in two cells and you need it put together. This is especially helpful when you download information from Web-based services and it comes in with no logical format.

Rearrange Column Layout. Quickly rearrange the order of the columns. This comes in especially handy when you need to combine information from other worksheets and you want everything to be consistent.

TRIM and CLEAN. These functions can be used together to get rid of extra spaces and unprintable characters in cells, especially after you do an Import. TRIM will remove all spaces except those in between words.

Navigate

Freeze Panes. You may want to keep the column and row headings visible as you scroll through your worksheet.

AutoFilter. Quickly filter data and display only what you need to see at any given time, as in all the people in a certain city or state.

Sort by Several Criteria. You're not limited to sorting a list using one criteria. Use up to three.

Share

Email One Worksheet Out of a Workbook. You may have several worksheets in a workbook and need to email one of them.

Other

Mail Merge Using Excel as the Data Source - And Add Artwork to Label. Create mailing labels with mail merge and add your company logo to them. You can use this same technique to create name badges, tent cards, and so on. In Word, display your rulers by clicking View, Ruler.

View Math Calculations on the Taskbar. Data will calculate when selected with the results appearing on the Taskbar.