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!
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.
Spend 30 minutes and save at least 10 minutes every day. Learn powerful time savers and amazing features which work across Word, Excel and PowerPoint. Have a look.
Post your comments. More videos coming up soon.
Office Usage Best Practices
Finally, here is a proven set of best practices to make your Excel usage simpler, faster and more accurate.
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!
This is a simple, useful but unknown feature available in Office.
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.