Word Best Practices Video

Another video in the 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!

image

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.

Uncommon Common Sense: Summary should appear BEFORE the data

See any report – data comes first and then the grand total (or other summary calculations). What does the viewer of the report want to look at first? The Grand Total. Should that not be shown in the beginning? Obviously yes.
Resist that urge of putting summary after the data. Put it in the beginning.

Data should be tabular – headings followed by data. Convert it to an Excel table first. Select data – Insert – Table. Now you see Table Tools – Design menu on top. In that give the data a name (default name will be Table1, Table2, etc.). Let us say the name is mydata. Put a few blank rows BEFORE the data and add a formula on top to see the summary. That’s it!

image

Editing Office Documents – which method to use when

With the launch of Office for iPad, we have yet another method of viewing and editing Office documents. You may not have realized, but over time many different ways of viewing and editing Office documents.

There are two problems. Firstly, you may not be aware of ALL these options. Secondly, you may not have a clear cut understanding of which is suitable in which scenario.
In this article, I will address both these aspects.

image

Continue reading