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.
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
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.
Simple. Find glaring mistakes in spreadsheets created by other people. Obviously you have an upper hand now! Of course, you need to know how to find mistakes in spreadsheets. Read this article and learn the skill.
Photo credit: Alex E. Proimos / Foter / CC BY-NC
Have a look. Take the mouse cursor to the Like icon in Facebook chat window, press the left button but don’t release it immediately – keep it pressed – and see what happens. It works with extended touch also on FB Messenger app.
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.
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).
Thanks to my friend, Raj Chaudhuri, for figuring out this brilliant one-line macro
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.
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?
Yes. This is possible. Just add Pivot Charts from the Analyze (or Options) menu of Pivot Table. Multiple charts can be added. Choose different visualization for each chart to get varied views of the same data. For example, column chart for comparison and 100% column chart for viewing the relative distribution.
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.
Yes. I did reserve my Microsoft Windows 10. But it is still my discretion as to EXACTLY WHEN I want to install it.