Tag Archives: Best Practices

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

Did you know: You can change all the menus in Office?

I am amazed to see how many people don’t know this. Do you wish Insert menu had Insert Comment option?

Don’t wish. Do it.
Create new tabs or modify existing ones. Share it with your colleagues.

Powerful, useful and delightful!

how to customize Office menus - change all the menus in office - Dr. Nitin Paranjape

Estimated reading time 5 min

Continue reading Did you know: You can change all the menus in Office?

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

How to create a formal document in Word?

This is the last article in the series on Word Sections. You must read these articles to follow the concepts explained in this article.

Be stylish – Use Word Styles
Unknown but extremely useful: SECTIONs in Word
Word Sections – Part 2 – Partial Multiple Columns
Word Sections – Part 3 – Headers and Footers

What is a formal document? It contains a title page, table of contents and the actual content. Page numbers start only from the actual content. Numbers start with 1. But the page number is not shown on the first page. We will see how to create such a document template in this article.

how to create a formal document in Word - Dr. Nitin Paranjape

Continue reading How to create a formal document in Word?

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!

Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!

I am sure we see these everyday across almost all Excel files. But do you know the meaning and significance of these green marks?

These are WARNINGS – it is Excel’s way of telling you NOT to trust what you see. Billions of people are ignoring these green marks for over a decade. If you are one of them, please read this article and share it with everyone who matters to you.

green marks in Excel by Dr. Nitin Paranjape

Continue reading Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!