650+ tips on Excel, PowerPoint, Outlook & Windows

I just discovered this immense catalog of tips made by Karen Roem.

This is a collection of more than 650 tips (654 tips at the date of this post) to make you better at all the Windows and Microsoft Office tools.

Here are my favourite 3 tips from Karen:

1) Top 10 Microsoft Outlook shortcuts

1. CTRL + 1 and CTRL + 2 – Toggle between Mail and Calendar – tip_259.php
2. CTRL + F – Forward a mail message
3. CTRL + G – Go to a specific date – tip_485.php
4. CTRL + K – Check names in address fields and resolve them against the Address Book – tip_211.html
5. CTRL + K – Insert Hyperlink – tip_431.php
6. CTRL + SHIFT + 8 – Show/Hide paragraph marks and other hidden formatting symbols – tip_394.php
7. F3 – AutoComplete Quick Parts – tip_335.php
8. F4 – Find text in an email message – tip_108.html
9. SHIFT + F1 – Reveal Formatting – tip_498.php
10. SHIFT + F3 – Toggle between UPPER CASE, lower case and Sentence Case

 

2) Create a bulleted list in Excel

1. Select the cell where the list is to appear.
2. Press ALT + 7 on the numeric keypad.
3. Type your text.
4. Press ALT + ENTER if you want to insert another bullet in the same cell.
5. Repeat steps 2 – 4.

 

3) Shortcuts in Windows

WIN + D can be used as a toggle to minimize and maximize all windows? But what if you just want to have a quick peek at something on your desktop? Check out the preview shortcut!

Here’s how:

1. Press and hold down the WIN key (the one next to your spacebar) and press the spacebar.
2. Release the WIN key to return to your last used window.

 

If you like this post, check the 50 time saving Excel Shortcuts.