Category Archives: best practices

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.

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 for Summary

Efficiency Test 5 Solution: PowerPoint : How to delete notes across all slides in 5 clicks

The question is simple. How to delete notes across all the slides in the most efficient way? The answer will not only surprise you, it will protect your interests.

powerpoint how to delete notes across all slides

Estimated reading time 4 min

Continue reading Efficiency Test 5 Solution: PowerPoint : How to delete notes across all slides in 5 clicks

Green Marks Part 2: Formulas showing wrong results!

Green mark in top left corner of Excel cells is an indication that something is wrong with the data you see. Read this article first to understand the concept: Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!

In this article, we will discuss the most important and potentially dangerous error which is commonly ignored. Read on and share it with as many people as you can.

image

Continue reading Green Marks Part 2: Formulas showing wrong results!

Editing Office Documents – which method 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.

Editing Office Documents - poster

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.

Continue reading Editing Office Documents – which method when