All articles with 'Office Tips' Tag

Use mail merge to create custom letters, invoices, labels and more

Published on Aug 17, 2015 in Excel Howtos
Use mail merge to create custom letters, invoices, labels and more

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.

Continue »

CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger

Published on Aug 14, 2014 in Chandoo.org Podcast Sessions
CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger

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…
Continue »

Use CTRL+F1 to collapse ribbon [super-mini-quick-tip]

Published on Dec 9, 2009 in Learn Excel
Use CTRL+F1 to collapse ribbon [super-mini-quick-tip]

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

Continue »

Pin Frequently Used Documents to File Menu to Save Time

Published on Sep 4, 2009 in Learn Excel
Pin Frequently Used Documents to File Menu to Save Time

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.

Continue »

How to Change Shapes in Microsoft Office 2007

Published on Feb 25, 2009 in Excel Howtos, Office Tips
How to Change Shapes in Microsoft Office 2007

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.

Continue »