Learn Pivot Table - Tutorial & Magical Quotes

How to add follow by mail or Subscribe button in blogger (blogspot)? How to use Feedburner ? Step By Step

2018-05-18T07:13:00.001-07:00

How to add follow by mail or Subscribe button in blogger (blogspot)?

Step 1:
Goto
http://feedburner.google.com/fb/a/myfeeds
Type your blogspot URL with .com as extension as below
http://proudhindudharma.blogspot.in.com
or
http://proudhindudharma.blogspot.in
Click next

Step 2:
Now
select
Sanathanadharma - RSS: http://proudhindudharma.blogspot.com/feeds/posts/default?alt=rss
click Next

Step 3:
If you get Your feed filesize is larger than 1024K message,
go back to 1st step, i.e.,
Goto
http://feedburner.google.com/fb/a/myfeeds
Type your blogspot URL with .com as extension as below
http://proudhindudharma.blogspot.com/feeds/posts/default?max-results=26
Click next

If you get same filesize error, goback to step 1 and try with <26 and try till we clear this message.
i.e.,
http://proudhindudharma.blogspot.com/feeds/posts/default?max-results=25

Lets say, Finally it worked for value 10 as below
Goto
http://feedburner.google.com/fb/a/myfeeds
Type your blogspot URL with .com as extension as below
http://proudhindudharma.blogspot.com/feeds/posts/default?max-results=10.
Click Next,

Step 4:
It shows with feedtitle as "Sanathanadharma"
and Feed Address as http://feeds.feedburner.com/ "Sanathanadharma"
Click Next

Step 5:
You will see congrats message with below message:
Subscribe to your feed (and share with others!) at:
http://feeds.feedburner.com/Sanathanadharma
Click next

Step 6:
Click Next (check box the items if you want)

Step 7:
Finally it comes to home page of feedburner for your blog page.
Click "Edit Feed Details" Link in that page.
You will see
Feed Title as "Sanathanadharma"
Original Feed as "http://proudhindudharma.blogspot.com/feeds/posts/default?max-results=10"
Feed Address as Feed Address:
http://feeds.feedburner.com/Sanathanadharma

Step 8:
Now
Click Optimize Tab -> Summary Burner.
In the teaser textbox, just type something like
Hi Friends, Visit my blog https://proudhindudharma.blogspot.in for more interesting topics
and Click Activate.

Step 9:
Now
Click Optimize Tab -> Smart feed.
Click Activate.

Step 10:
Now
Click Publicize Tab -> NoIndex
Uncheck the options shown and click Activate.

Step 11:
Now
Click Publicize Tab -> PingShot
click Activate.

Step 12:
Now
Click Publicize Tab -> Feedcounts
click Activate.
You will see HTML code and below showing
Use as widget in,select "Typepad". With Go button.
Copy the HTML Code.
Now goto blogger.com and login in to your blogsite.
Click Layout.
Click Add A Widget.
Select "HTML/JavaScript". Click Save.
You will see this new Widget added in your layout.
Click Edit of this HTML/Javascript new Widget. Copy the Code you have copied.
Click Save.
Done. Now, open your blogspot site. You will see feed is showing in your page :)

Step 13:
Now
Click Publicize Tab -> Email Subscription
Click Activate.
Under Subscription Form Code section
You will see HTML code and below showing
Use as widget in,select "Typepad". With Go button.
Copy the HTML Code.
Now goto blogger.com and login in to your blogsite.
Click Layout.
Click Add A Widget.
Select "HTML/JavaScript". Click Save.
You will see this new Widget added in your layout.
Click Edit of this HTML/Javascript new Widget. Copy the Code you have copied.
Click Save.
Done. Now, open your blogspot site. You will see Email Subscription option for your blog reader to subscribe and follow u :)

Step 14:
Final Step:
In Your Blogger login page,
Goto Settings -> Other -> Click Add in "Post Feed Redirect URL".
Paste your feed address we created. i.e., here we paste below URL
http://feeds.feedburner.com/Sanathanadharma
Save settings.

Done. You will see more traffic to your blogsite. Congrats.

Compare two columns in Microsoft Excel and Use conditional formatting

2017-12-19T07:56:00.000-08:00

Compare two columns in Microsoft Excel and Use conditional formatting:

Let’s say we have below data in excel:

Here, we are going to use conditional formatting in column C comparing column B and understand which is falling down, going up and neutral.

Let us use a simple formula here called “offset”.

To understand the functionality of offset, I have given the offset formula with a same reference to cell B2, and navigate from row 0, column 0, then row 1, column 0, then row 2, column 0, then row 3, column 0 as shown below for easy understanding using a concatenate function in cell E2
Formula I have used is:

=CONCATENATE(OFFSET(B2,0,0), " ", OFFSET(B2,1,0)," ",OFFSET(B2,2,0)," ",OFFSET(B2,3,0))

It gave the values from cell B2, B3, B4, B5 as shown below

By understanding the usage of Offset function, lets us use this formula in our excel.

Highlight the Cell C2 alone. And under HOME tab -> select Conditional formatting -> Icon Sets -> More Rules as below

It will open up the New formatting Rule window as below.

Here select your Icon Style as shown below.
Change the Type to Number.

For Green Icon, change Symbol to > as shown below and type the formula

=offset($B$2,row()-2,0)

For Neutral Icon, change the symbol to >= as shown below and type the same formula

=offset($B$2,row()-2,0)

Note: You can’t use B2. You should use $B$2 here.

For red, any thing < will auto apply anyway. So you will have data as shown below:

Click OK.

You will see that, selected cell C2 reflects the expected result by comparing Cell B2.

Now, to use same formatting, you need to highlight cell C2, and Doubleclick the format painter icon as shown below:

(NOTE: You should not do single click.. But double click the format painter. Very important).

Now just click on cell C3, you will see that the formatting applies to C3 cell as well.

Instead of doing each cell one at a time, by selecting C2 cell and double format painter and then to click Cell C4 and again repeating steps for C5 cell, we can now,

Select both cell C2 and C3 and Double Click Format Painter icon as below:

Since we have copied 2 cells under format painter,

Now, just drag over 2 cells (C4, C5) to use the format.

Now you will see, all cells have required conditional formatting as expected:

Thanks for spending your time in my blog: Happy learning.

Magic 9

2017-11-29T05:04:00.000-08:00

Your mind wants you to forget the unpleasant.

That’s why, It really is easy to forget the unpleasant, if we simply refuse to recall it

You take a big step forward toward conquering fear when you refuse to remember negative, self-deprecating thoughts

Develop an understanding attitude with others. Tell yourself, when you talk to someone "Underneath he's probably a very nice guy. Most folks are."

Many criminals are captured not because any clues point to them but because they act guilty and self-conscious. Their guilt feeling puts them on the suspect list. So, have a desire to be right, think right, and act right

To think Confidently, act confidently

We can change our attitudes, by changing our physical actions.

Confident action produces confident thinking

Magic 8

2017-11-29T04:59:00.002-08:00

Much lack of self-confidence, can be traced directly to a mismanaged memory

Deposit only positive thoughts in your memory bank

Unsuccessful and successful people deal with these situations in directly opposite ways

Unsuccessful people take them to heart, so to speak. The unpleasant situation is the last thing they think about.

Successful people specialize in putting positive thoughts into their memory bank

Negative, unpleasant thoughts deposited in your mind affect your mind the same way.

Negative thoughts produce needless wear and tear on your mental motor

Negative thoughts create worry, frustration, and feelings of Inferiority

Negative thoughts put you beside the road while others drive ahead

When you're driving your car or eating alone or alone, recall pleasant, positive experiences. Put good thoughts in your memory bank

Just before you go to sleep,

Deposit good thoughts in your memory bank.

Count your blessings.

Recall the many good things you have to be thankful for: your wife or husband, your children, your friends, your health.

Recall the good things you saw people do today.

Recall your little victories and accomplishments.

Go over the reasons why you are glad to be alive

Destroy the negative thoughts, before those thoughts become mental monsters

A person can make a mental monster out of almost any unpleasant happening

Think of and write down three specific reasons you felt happy during past times

Whether the psychological problem is big or little, the cure comes when one learns to quit drawing negatives from one's memory bank and withdraws positives instead

When you remember situations of any kind, concentrate on the good part of the experience; forget the bad. Bury it.

If you find yourself thinking about the negative side, turn your mind off completely.

Magic 7

2017-11-29T04:56:00.003-08:00

How old we are, is not important. It's one's attitude toward age that makes it a blessing or a barricade/obstacle

Make your team and family members feel, they are working for a team captain, not a dictator

Think, 'I’m still young," not 'I’m already old."

Practice looking forward

Life is actually longer than most people think

Invest future time in doing what you really want to do

Stop thinking "I should have started years ago.". Start Now at least. Tell Yourself “I’m going to start now, my best years are ahead of me”

Accept the law of cause and effect

You'll find that, not luck but preparation, planning, and success-producing thinking precedes good fortune

Mr. Success, if receives a setback; he learns and profits,

But when Mr. Mediocre loses, he fails to learn

Success comes from doing those things and mastering those principles that produce success

Magic 6

2017-11-29T04:50:00.002-08:00

We can't do much, to change the amount of native ability, but we can certainly change the way we use, what we have

Knowledge is power, when you use it constructively

The great scientist Einstein was once asked how many feet are in a mile. Einstein's reply was "I don't know”

Einstein taught us a big lesson. He felt it was more important to use your mind to think, than to use it as a warehouse for facts

Henry Ford was never interested in miscellaneous information. He knew that “the ability to know how to get information” from his executives is more important than using the mind as a garage for facts

People who can dream, they can develop the dream into a practical application

An idea man can make money; a fact man can't

Discover your superior talents. Analyze the skills you have.

My attitudes are more important than my intelligence

At work and at home, practice positive attitudes

See the reasons why you can do it, not the reasons why you can't

Use it to find ways to win, not to prove you will lose

Compare - How? Why?

2017-11-29T04:45:00.002-08:00

If given a work to someone. How many people will ask…

1) How to do the work?

2) Why I need to do the work?

Here, work relates to anything. It can be Corporate work, Govt Work, Household work, Social work…. i.e., any work.

When we ask this question to a number of people,

Around 90 out of 100 people will ask How to do the work?

and 10 out of 100, will ask why I need to do the work?

Most people are interested to know how to achieve the work.

But fact says that, those 10 out of 10 people in Why category are guaranteed to complete the work.

But only 10 out of 90 people in How category are guaranteed to complete the work.

Below are 2 scenarios:

Scenario 1:

While passing on a hillside, you see a House, locked inside. An old lady standing outside starts screaming at you, to open the door or even break the door immediately without questioning. i.e., don’t ask why. But she starts explaining how to open the door using different methods/ways.

Highest probability is that, you won’t accept her command/wish to open/break the door.

How actually guarantees to complete a task/work assigned but fails here.

Because reason to do the work is unknown. Pressurizing also does not help to complete a work.

Lowest probability is that you may accept her command and use one of the methods in How to break the door, Without actually knowing the reason why you are breaking the door.

Chances are Old Lady may be telling the truth or she may be just playing a game with you for her personal benefit or the method she had suggested may not work to break the door.

Here, we need to accept the fact that only 10 out of 100 people may/will guarantee to complete a task/work without a reason.

Remaining 90 out of 100 are guaranteed to fail in completing the task/work. That’s why we wonder why people fail, even though they knew how to do the work.

Reason is – They do not find a good reason to do that.

Scenario 2:

While passing on a hillside, you see a House, locked inside. An old lady standing outside starts screaming at you, to open the door or even break the door. She didn’t tell on how to open the door with different methods/ways. But she pointed out a Big Smoke coming out of the window and a child crying inside.

Highest probability is that you will wish to open/break the door.

Even though How to complete a task/work is not explained, but you know the reason why to break the door. Human mind is good enough to find a way in how to break the door, because reason to do the work is known. It does not require Pressure from others to complete a work. If the old lady had some methods in How to break the door, it can be used here.

Very Low probability is that you may not understand the scenario either because you are unfit or irresponsible by nature.

Here, we need to accept the fact that 10 out of 10 people are guarantee to complete a task/work, since they knew the reason to do.

It’s a great responsibility for everyone to understand Why we need to do the work ,than How.

How to assign Actual Work (completed work) in a task (fixed Duration) in...

2016-11-19T03:32:00.001-08:00

How to assign Actual Work (completed work) in a task (fixed Duration).
While assigning the actual work against the task for a week alone in Task Usage, how is the behaviour

You can also watch below link to know How to assign Actual Work (completed work) in a task (fixed unit).
https://www.youtube.com/watch?v=GNeqLNzmKZI

விதுர நீதி - லுப்தம் அர்த்தேன க்ருஹணீயாத்

2016-11-14T02:20:00.000-08:00

வாழ்க்கையில் நாம் பல வித மனிதர்களை சமாளிக்க வேண்டி இருக்கிறது.

சில ஸமயம், இவர்களை போன்றோர்களை சமாளித்து தான் நாம் நம் காரியங்களை செய்ய வேண்டி வரும்.

பேராசை கொண்ட சிலர், நம்மிடமிருந்து பணம் வாங்காமல், நியாயமான காரியங்களை கூட செய்ய மாட்டார்கள், நம்மையும் செய்ய விட மாட்டார்கள்.

விதுரர் (சாக்ஷத் எம தர்மராஜன் அவதாரம்) நமக்கு இவர்களை போன்றோரை சமாளிக்க வழி சொல்கிறார்.

லுப்தம் அர்த்தேன க்ருஹணீயாத் !

க்ருத்தம் அஞ்சலி கர்மணா !!

மூர்க்கம் சந்தானு ருத்தயா ச தத்வார்த்தேன ச பண்டிதம் !!

-விதுர நீதி

விரும்பியோ விரும்பாமலோ, உங்களின் ஒரு நியாயமான காரியம், ஒரு பேராசைகாரனால் தடைபடும் போது, இப்படி பட்ட

பேராசைகாரனை, கொஞ்சம் காசை கொடுத்து தான் சமாளிக்க முடியும். பணத்தை வாங்கி பின் நமக்கு உதவியாளன் போல கூட ஆகி விடுவான்.

விரும்பியோ விரும்பாமலோ, உங்களின் ஒரு நியாயமான காரியம், ஒரு கோபக்காரனால் தடைபடும் போது, இப்படி பட்ட

கோபக்காரனை, கொஞ்சம் பணிவால் தான் சமாளிக்க முடியும். கோபக்காரனை பணிவால் (அமைதியாக எதிர்த்து பேசாமல் இருந்தாலே) எளிதாக வசம் செய்ய முடியும்.

விரும்பியோ விரும்பாமலோ, உங்களின் ஒரு நியாயமான காரியம், ஒரு முட்டாளால் தடைபடும் போது, இப்படி பட்ட

மூடனை, அவனிடமே வழி கேட்டு, அவன் சொல்வதற்கெல்லாம் தலையாட்டி (ஆமாம், நீங்கள் சொல்வதே சரி போன்று கூறி) தான் சமாளிக்க வேண்டும். மூடனுக்கு இது கிழக்கு என்றால், இல்லை மேற்கு என்பான். எதற்கும் முடிவில்லாமல் தர்க்கம் செய்வான். தான் சொன்னதே முடிவாக இருப்பான். மற்றவர் உண்மையை சொன்னாலும் மறுப்பான். இப்படி பட்ட மூடனை, அவனிடமே வழி கேட்டு, அவன் சொல்வதற்கெல்லாம் தலையாட்டி தான் சமாளிக்க வேண்டும்.

ஆனால், விரும்பியோ விரும்பாமலோ, உங்களின் ஒரு நியாயமான காரியம், ஒரு நல்லவனிடம், அறிவாளியிடம் தடைபடும் போது, அவனை சமாளிக்க வேண்டிய அவசியமில்லை. அப்படிப்பட்ட அறிவாளியிடம் நீங்கள் உள்ளதை உள்ளபடி சொன்னாலே போதுமானது. அவர் உங்களின் நோக்கத்தை புரிந்து வழியும் காட்டுவார், முடிந்தால் உதவியும் புரிவார்.

பேராசைக்காரனை பணத்தாலும், முன்கோபியைப் பணிவாலும், மூடனை அவன் சொல்வதற்கெல்லாம் தலையாட்டியும், புத்திசாலியை ஞானத்தின் சாரத்தாலும் வசப்படுத்தலாம்.

விதுரர் இவ்வாறு திருத்ராஷ்டனிடம் இந்த அறிவுரை (நீதி) கூறினார். திருத்ராஷ்டன் இதை கேட்ட பின், தான் எந்த வகை சேர்ந்தவன் என்று புரிந்திருப்பாரோ என்னவோ, நாம் எப்படி பழக வேண்டும் என்று நமக்கு புரிந்திருக்கும்.

ஹிந்துவாய் பிறந்ததால், வாழ்க்கையில் பலருடன் பழக, பல நீதிகளும் இது போன்று கிடைக்கிறது.

Magic 5

2016-07-26T01:39:00.000-07:00

Fear explains why millions of people, accomplish little and enjoy little

Truly, fear is a powerful force

No one is born with confidence. All confidence is acquired, developed.

Those people you know,

· who radiate confidence,

· who have conquered worry,

· who are at ease everywhere and all the time, acquired their confidence, every bit of it.

You can, too.

o Action cures fear

o Indecision, postponement, on the other hand, fertilize fear.

Again, Action cures fear. Action does cure fear.

Hope is a start. But hope needs action, to win victories. So, Put the action principle to work

ü Fear of Personal Appearance? Go to Saloon. Improve your look and clothing like professional.

ü Fear of Losing Customer/Friend? Work doubly hard. Give double the service.

ü Fear of Exam? Convert worry time into study time

ü Fear of something beyond your control? Turn your attention, to relieve the fear of others. Pray

ü Fear of getting hurt? Switch your attention to something totally different. Play with children.

ü Fear of what other people may think and say? Make sure that what you plan to do is right. Then do it. No one ever does anything worthwhile, for which he is not criticized

ü Fear of making an investment or purchasing a home? Analyze all factors. Then be decisive. Make a decision and stick with it. Trust your own judgment

ü Fear of people? Put them in proper perspective. Remember, the other person is just another human being, pretty much like yourself. He likes good food, he misses his family and friends, he wants to get ahead, he has problems, he likes to relax. There's no point in being afraid of him

1. Isolate your fear.

2. Pin it down.

3. Determine exactly, what you are afraid of.

4. Then take action.

There is some kind of action for any kind of fear

Remember: Hesitation only enlarges, magnifies the fear