HR, Sales, Marketers: Enhance your credentials with Power View

Yes. That is right. If you have worked with lots of customers, providing a list of customers consumes lot of space and nobody reads it anyway! Why not show the customers you have worked with in a region or globally by plotting them on a map? Here is how you do it in Power View.  It takes just 2 minutes  if you have the data ready.

Continue reading HR, Sales, Marketers: Enhance your credentials with Power View

Word Best Practices Video

Another video in the word best practices series. For Microsoft Channel 9. Have a look. This video shows what EVERYONE should know about Word. So please share it with everyone you work with as well as your loved ones. This is the best gift you can give a child: Knowledge!

Word Best Practices Video

Word Best Practices

View at http://bit.ly/nitinch9word, 35 minutes. View in FULL SCREEN mode at high resolution for maximum learning. Includes links to detailed articles and sample files.

Quick and easy: Backspace and Delete

Recently I noticed that many people don’t know this. So here it is. Look at where your editing cursor is.

If you want to remove things on the LEFT side of the cursor, use BACKSPACE key.

If you want to remove something on the RIGHT side of the cursor, you press DELETE key.

Entire word on either side can be removed by pressing CTRL key along with Delete or Backspace keys.

backspace and delete

Although there is no existing shortcut or Word Command to delete the word under the cursor, a single line of code deletes the current word (without selecting it).

selection.range.words(1).delete

Thanks to my friend, Raj Chaudhuri, for figuring out this brilliant one-line macro Thumbs up

Trainers: How to prevent expectation mismatch

This article is for trainers in general and Office trainers in particular. If you are not careful, there can be expectation mismatch after delivering a training program. This leads to disputes, customer dissatisfaction, loss of credibility and may even affect your fees. Here are some important ways in which you can prevent expectation mismatch and deliver world class training outcomes.

Continue reading Trainers: How to prevent expectation mismatch

Knowledge Pack: Word Sections

This is a very powerful feature in Word which is almost unknown to the world. Here are the articles which explain the practical benefits of using sections in Word.

Unknown but extremely useful: SECTIONs in Word
How to insert landscape page in a regular Word document
Word Sections – Part 2 – Partial Multiple Columns
Word Sections – Part 3 – Headers and Footers
How to create a formal document in Word?

Enjoy!

Did you know: Change Data Labels to any shape

Yes. Data labels have a rectangular shape to start with. But you can change it to any shape. Click on any data label – it will select the entire series automatically. Now choose the Format tab from the menu on top. Choose Change Shape and select the shape you want. All familiar shapes, which are a part of Office, are available here. Choose the one which is most appropriate for the visualization and business context. Very useful for creating Info-Graphics.

change data labels to any shape