Microsoft Excel Guide for Beginner

In this free ebook you will find and learn tips and tricks for your favorite spreadsheets for both the experianced and begginers alike.

Convert rows to columns
You can convert rows to columns (and columns to rows) by highlighting the cells you want to switch around, clicking on Edit, Copy, selecting a new cell and then going to Edit, Paste Special… Finally, place a tick in the Transpose box on the dialog box and click on OK.

Calculate time between dates
Enter in a cell the formula =A2-A1, where A1 is the earlier date, and A2 the later one. Don’t forget to convert the target cell to number format – do this by highlighting the cell, clicking on Format, Cells…, picking on the Number tab and selecting Number from the Category: list.

Enter URLs as text, not hyperlinks
To prevent Excel from converting written Internet addresses into hyperlinks, add an apostrophe to the beginning of the address.

Remove hyperlinks from your work
If Excel has already converted your written URL into a hyperlink, you can cancel it by right-clicking on the offending address and selecting Hyperlink, Remove Hyperlink from the menu that pops up.

Outlook, PowerPoint, and Publisher
Bringing up the rear are Microsoft’s email client, presentation, and DTP software. Here are the hottest 15 tips and 35 shortcuts…

Find the contact you’re after quickly
To locate a contact from just a fragment use the Find a Contact input box on the main toolbar. Just click on the box and enter what you remember of the contact’s name. Outlook will find the contact and open his or her details in a dialog box.
Shred your waste, don’t bin it.

Outlook doesn’t really delete messages, it places them in the Deleted items folder. To delete them click on Tools, Options..., select the Other tab, and place a tick in the Empty the Deleted

Items folder upon Exiting tick box.
Resize objects using central origin
To keep the centre of an object in the same place while you resize it, hold down [Ctrl] while you are dragging the object’s handles.

For details this E book can be downloaded here :
Microsoft Excel Guide for Beginner.pdf