All articles with 'Office Tips' Tag

The idea of mail merge is simple & powerful. Imagine you handle recruitment at a large company. You just hired 300 analysts for the big data division. The next job – generate employment offer letters for each of them. Of course, you don’t want to type these letters one at a time. You have the details of all the 300 offers (name, email, address, offer code, role, benefit package details and date of joining etc.) in a spreadsheet. You also have a template of the offer letter.

Enter mail merge. This powerful feature of MS Word combines (Excel) data with Word document contents to generate all the 300 letters in just few minutes.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 17th session of Chandoo.org podcast, lets leave Excel aside and talk about other MS Office apps.

Thats right. We will be learning 10 tips on how to use Word, Power Point, Outlook etc. Ready?

In this podcast, you will learn,

• About Paul
• Ten tips for MS Office
• 1. Use Excel to communicate instead of just calculations
• 2. Paste Special
• 3. Double click trick!
• 4. Inserting screenshots
• 5. Turning off notifications
• & more…

In office 2007 (and 2010) you can immediately collapse the ribbon by pressing CTRL+F1. Thanks to Loranga for sharing this tip. More ribbon goodness | Free e-book to learn Excel Ribbon

Here is a quick productivity tip if you work with same set of excel (or word or powerpoint) documents everyday. Just pin the documents to recent documents list in the Office Menu in MS Office 2007. See this: More excel 2007 productivity tips & double click tricks.

Ever since we made a switch to Microsoft Office 2007 at work, this has been bothering me.”How to change one shape to another?”

This is very useful feature, especially when you are using PowerPoint.