All articles with 'Office Tips' Tag
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
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | 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…
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 RibbonContinue »
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
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 »