Data Validation & Cleaning

Data Cleaning Tutorial.pdf

Stress Management

People can learn to manage stress and lead happier, healthier lives

Stress Management.pdf

International Day of Happiness [20 March, 2013]

In 2012, the United Nations (UN) declared March 20 to be observed as the International Day of Happiness.

Aim: The day recognizes that happiness is a fundamental human goal, and calls upon countries to approach public policies in ways that improve the well-being of all peoples. By designating a special day for happiness, the UN aims to focus world attention on the idea that economic growth must be inclusive, equitable, and balanced, such that it promotes sustainable development, and alleviates poverty. Additionally the UN acknowledges that in order to attain global happiness, economic development must be accompanied by social and environmental well-being.

Background: The initiative to declare a day of happiness came from Bhutan – a country whose citizens are considered to be some of the happiest people in the world. The Himalayan Kingdom has championed an alternative measure of national and societal prosperity, called the Gross National Happiness Index (GNH). The GNH rejects the sole use of economic and material wealth as an indicator of development, and instead adopts a more holistic outlook, where spiritual well-being of citizens and communities is given as much importance as their material well-being.

Secretary-General Ban Ki-moon’s Message for the International Day of Happiness, 20 March 2013 - "On this first International Day of Happiness, let us reinforce our commitment to inclusive and sustainable human development and renew our pledge to help others. When we contribute to the common good, we ourselves are enriched. Compassion promotes happiness and will help build the future we want."

Copy of UN Resolution about International Day of Happiness attached herewith.

[Do something good to make others happy]

For more details visit website UN official website http://www.un.org/en/events/happinessday/index.shtml

UN Resolution about Iinternation Day of Happiness.pdf

Having a Sense of RESPONSIBILITY

There is common saying that goes, “He/she fail to take responsibility for his/her action.” This is a true statement. Maybe you and I have sometimes refused to take responsibility for our actions at one time or another. The fact is that we have people that are givers of excuses. They always have excuses for not doing what they are supposed to do. On the other hand, we have people that claim to always take responsibility for their actions either good or bad.
find the complete article

Shading Alternate Rows/Columns Using a Formula and Conditional Formatting

By combining a formula using the MOD and ROW functions with conditional formatting, alternate rows of data can be shaded automatically. As an added bonus, if you add or remove rows, the row shading updates automatically

Steps:

1.      Open new worksheet

2.      Drat select rows upto A10 to highlight them.

3.      Click on the Conditional Formatting icon to open the drop down menu. Choose New Rule… option to open the New Formatting Rule dialog box.

4.    Select “Use a formula to determine which cells to format”, and enter the following formula in to the box below the Format values where this value is trueoption in the bottom half of the dialog box.

=MOD( ROW( ), 2) =0

5.      Click the Format button to open the Format Cells dialog box, now elick the Fill tab to see the background color options. Select a color to use for shading the alternate rows of the selected range. Click OK twice to close the dialog box and return to the worksheet.

6.      Alternate rows in the selected range should now be shaded with the chosen background fill color.

Similarly if you want to shade alternate columns change the ROW formula with COLUMN formula like =MOD(COLUMN(),2)=0

Tip: If you want to highlight the rows of your choice like 3, 6, 9 …. Or any other sequence, you can. For example if you want to highlight every 3^rd  row than change the formula like =MOD(ROW(), 3) = 0