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!