September 2010
no image
Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.
Inflation is defined as a sustained increase in the general level of prices for goods and services. It is measured as an annual percentage increase. As inflation rises, every dollar you own buys a smaller percentage of a good or service.

The value of a dollar does not stay constant when there is inflation. The value of a dollar is observed in terms of purchasing power, which is the real, tangible goods that money can buy. When inflation goes up, there is a decline in the purchasing power of money. For example, if the inflation rate is 2% annually, then theoretically a $1 pack of gum will cost $1.02 in a year. After inflation, your dollar can't buy the same goods it could beforehand.

There are several variations on inflation:
Deflation is when the general level of prices is falling. This is the opposite of inflation.
Hyperinflation is unusually rapid inflation. In extreme cases, this can lead to the breakdown of a nation's monetary system. One of the most notable examples of hyperinflation occurred in Germany in 1923, when prices rose 2,500% in one month!
Stagflation is the combination of high unemployment and economic stagnation with inflation. This happened in industrialized countries during the 1970s, when a bad economy was combined with OPEC raising oil prices.

In recent years, most developed countries have attempted to sustain an inflation rate of 2-3%.

Causes of Inflation
Economists wake up in the morning hoping for a chance to debate the causes of inflation. There is no one cause that's universally agreed upon, but at least two theories are generally accepted:

Demand-Pull Inflation - This theory can be summarized as "too much money chasing too few goods". In other words, if demand is growing faster than supply, prices will increase. This usually occurs in growing economies.

Cost-Push Inflation - When companies' costs go up, they need to increase prices to maintain their profit margins. Increased costs can include things such as wages, taxes, or increased costs of imports.

Costs of Inflation
Almost everyone thinks inflation is evil, but it isn't necessarily so. Inflation affects different people in different ways. It also depends on whether inflation is anticipated or unanticipated. If the inflation rate corresponds to what the majority of people are expecting (anticipated inflation), then we can compensate and the cost isn't high. For example, banks can vary their interest rates and workers can negotiate contracts that include automatic wage hikes as the price level goes up.

Problems arise when there is unanticipated inflation:
Creditors lose and debtors gain if the lender does not anticipate inflation correctly. For those who borrow, this is similar to getting an interest-free loan.
Uncertainty about what will happen next makes corporations and consumers less likely to spend. This hurts economic output in the long run.
People living off a fixed-income, such as retirees, see a decline in their purchasing power and, consequently, their standard of living.
The entire economy must absorb repricing costs ("menu costs") as price lists, labels, menus and more have to be updated.
If the inflation rate is greater than that of other countries, domestic products become less competitive.

People like to complain about prices going up, but they often ignore the fact that wages should be rising as well. The question shouldn't be whether inflation is rising, but whether it's rising at a quicker pace than your wages.

Finally, inflation is a sign that an economy is growing. In some situations, little inflation (or even deflation) can be just as bad as high inflation. The lack of inflation may be an indication that the economy is weakening. As you can see, it's not so easy to label inflation as either good or bad - it depends on the overall economy as well as your personal situation.

Inflation: How Is It Measured?

Measuring inflation is a difficult problem for government statisticians. To do this, a number of goods that are representative of the economy are put together into what is referred to as a "market basket." The cost of this basket is then compared over time. This results in a price index, which is the cost of the market basket today as a percentage of the cost of that identical basket in the starting year.

Consumer Price Index (CPI) - A measure of price changes in consumer goods and services such as gasoline, food, clothing and automobiles. The CPI measures price change from the perspective of the purchaser. U.S. CPI data can be found at the Bureau of Labor Statistics.
Producer Price Indexes (PPI) - A family of indexes that measure the average change over time in selling prices by domestic producers of goods and services. PPIs measure price change from the perspective of the seller. U.S. PPI data can be found at the Bureau of Labor Statistics.

You can think of price indexes as large surveys. Each month, the U.S. Bureau of Labor Statistics contacts thousands of retail stores, service establishments, rental units and doctors' offices to obtain price information on thousands of items used to track and measure price changes in the CPI. They record the prices of about 80,000 items each month, which represent a scientifically selected sample of the prices paid by consumers for the goods and services purchased.

In the long run, the various PPIs and the CPI show a similar rate of inflation. This is not the case in the short run, as PPIs often increase before the CPI. In general, investors follow the CPI more than the PPIs.
no image
Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.
Many times people say things like, "I don't have time to exercise," what they really should be saying is, "I don't have time not to exercise."

If you lose your health and sense of well-being, you won't make it to work at all. In the long run, it takes far less time to take care of yourself than it does to lose your ability to function well.

One should eat well, exercise, get plenty of rest, have regular physical checkups, and partake in other healthy habits. In addition to the obvious problems associated with ignoring these commonsense health habits, you can see that it's also a horrible waste of time in the long run. Each cold or flu costs you days of productive work time. Who knows how many years of time you will save by simple taking care of yourself?

Take care of yourself – physically and emotionally. You can let go of your fear that you'll fall behind because, in fact, you'll be more productive and have a longer, happier life. So keep yourself healthy – physically and emotionally.
no image
Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.

It's hard being a teenager and trying to resist the images you're bombarded with daily: the hot-looking guy or gal in the magazine; the sexual jokes in movies (even Shrek!) or the pervasive pornography and ad banners that pop up while you may simply be checking your e-mail or researching something for school. How do we protect ourselves from all of this? Below is a list of tips that can help. You can add in comments what works for you:

Tip #1: Know what's Halal and what's not

Remember this rule of thumb: whatever is Haram (forbidden) to do, is Haram to watch.

All scholars of Islam agree that pornography is absolutely Haram and a clear sin.

Some may think, however, that only hard-core pornography is Islamically unacceptable. This is not true. Watching improperly dressed men and women in sexual situations, as well as engaged in various types of foreplay and dirty jokes are also not acceptable.

If you need a more detailed argument against it, read our article based on the Quran and Hadith.

Tip #2: Surf the Web or Watch T.V. When Others are Around

The living room or study room are better places to keep the computer since others are nearby and can see what you're looking at. The temptation to sneak a look at dirty pictures or that bikini-clad babe is heightened when you're alone in your room watching television or surfing the internet. Try to avoid late night TV and surfing. Instead, check out the tube or the web when others are around so you can resist the urge to sneak a peek, thinking no one's watching.

It is a good idea not to have a TV or computer in the bedroom anyway.

Tip #3: Remember Allah is Watching You

If no one is watching, Allah is watching you. He is always there. He is Al Baseer, All Knowing and All Aware. He is the One Who has given us life. He is the One Who has told us right from wrong and given us a choice. He loves to see us successful in our test to bless us with the Everlasting life. He does not rest or sleep. He loves to see us do good and has promised rewards for it.

Tip #4: If It Happens, Seek Forgiveness & Don't Insist on doing it

"É[Good people are those who] when they have committed a shameful deed (fuhsha) or have harmed themselves, remember God and pray that their sins be forgiven-for who but God could forgive sins?-and do not knowingly persist in doing whatever wrong they may have done." (Quran 3:135).

Allah loves to see us asking for His forgiveness.

Tip #5: Just get up and leave

If you feel unable to control looking at the screen or the magazine, leave the situation. Get out of the living room, your bedroom where the internet is or where you've been reading the magazine. Take a walk. Just do something to physically get out of the situation.

Tip #6: Remember the Day of Judgment

You cannot assume looking at this stuff is no big deal. Your eyes will testify about what you looked at on the Day of Judgment. God is Most Just and Merciful, and He rewards us for the good and holds us responsible for the bad we do. His angels are around you who love to note down each good dead and hate to watch you do shameful things which they still must report. Every tiny act we do is noted down. May Allah make our accounting on the Day of Judgment easy.

Tip #7: Connect With Your Salat

If you are not praying, start now. Salat actively discourages pornography and fornication (fuhsha). Here is what Allah says about it: "É and be constant in prayer: for, behold, prayer restrains man from loathsome deeds and from all that runs counter to decency; and remembrance of God is indeed the greatest [good]. And God knows all that you do." (Quran 29:45)

Tip #8: Learn About Haya in Islam

Haya is a beautiful concept in Islam. Sometimes translated as modesty or shame, there is no one word in English that fully describes what it means. It is a quality in character that makes a believer shine. Satan does not want you to have it. Pornography destroys Haya.

Tip #9: Avoid those involved in pornography

If one of your friends is into pornographic magazines, websites, dirty jokes etc. either help him/her change through gentle and sincere advice (see etiquettes of enjoining the good and forbidding the evil) or abandon frequent contact with them. Their addiction might affect you, so it's best to stay as far away as possible, by remembering the danger to yourself and your relationship with God.

Tip #10: Avoid things that lead to sin

Too often, it's easy to dismiss that billboard with the spandex-and-bikini-top-clad blonde girl advertising gum, or the guy in tight leather pants and no shirt advertising perfume. When you see it, remember the omnipresent God, and lower your gaze. Do the same for television and the internet. If you keep doing this, it'll become a habit to avoid looking at these things.

Remember God is kind. An unintentional look is not Haram if you turn away as soon as you realize it.

Tip #11: Develop a More Productive Schedule

Learn to manage your time more productively. Develop a personal plan for yourself. If you don't occupy your mind with good works, Satan will think of something bad for you. Think of wal Asr, Innal insane lafi khusr.. (Quran 103)

Tip #12: Are You Involved?

Surround yourself with spiritual influences. Join a study circle, volunteer for a good cause, become active in a Muslim youth group like MYNA or your Muslim Students' Association. Good company is likely to have good influence on you. The involvement will also make good use of your time, sparing little for Satan.

Tip #13: Feeling overwhelmed? Remember Allah

In situations where you feel overwhelmed and can't get yourself to switch the channel, close the browser window or turn your eyes away from the billboard, ask Allah's help. You don't necessarily need any heavy duty, long prayers. Just say La hawla wa la quwwata illa billah (there is neither power nor strength except with God). It is short, simple and reminds you of Who is really in control and can help you out of this. Or if you cannot remember this, just move away saying Allah, Allah. Or bring any popular song about Allah to your lips.

Tip #14: Less TV is better

Although actors in a TV program may be "dressed," if the show is about playing sexual games in public, is it worth watching? Less TV is always better. One of my American friends calls it the 19-inch Satan in our living rooms. She would rather not have it at all. A few broadcast channels are better than cable or satellite. Watching together as family is better than watching alone. Choosing through a TV guide what to watch is better than  channel surfing.

Tip #15: Satan is the Enemy: Seek refuge in God

Satan lured you into this mess. He is the big part of our tests in this life. Seeking refuge in Allah (saying Aoutho billahi minash Shaytan ir Rajeem), will help you resist him and his whisperings to continue looking at the material.

Tip #16: Remember others will Follow You

If you have younger brothers and sisters, think of the bad example you're setting for them. What message are you sending them if they barge into your room and catch you watching Temptation Island or flipping through Playboy magazine?

Tip #17: Look for alternative entertainment

Playing sports is better for your health than watching. We have become way too dependent on electronic entertainment. It is unhealthy and leading our nation to obesity and health problems. Let's stop being couch potatoes. Let's build our bodies through sports and outdoor activities.

Tip #18: Surround yourself with the Quran

Make the Quran a part of your bedroom decor. Put paintings of your personal selection of these beautiful verses from God. Maybe commission a calligrapher to scribe your favorite verses in Arabic and English. I had one drawn with pencil and it sits in front of my desk. One of my daughters asked me to write one for her and she hung it up in front of her laptop.

How many copies and translations of the Quran do you own? Buy more. Become a collector.

If you are into listening the Quran on audio, keep changing your reciter of the Quran. It breaks the monotony and brings focus back to the words of God.

Tip #19: Remember your Mom and sister

Disgusting right? Exactly. No one in his right mind would look at his mom or sister the way pornographic magazines and websites depict women. Remember your mom and your sister, and that may help you stop.

Tip #20: Have someone watch over you

If you really feel you're becoming addicted to this kind of material, try to watch TV, surf the internet with someone else. You don't have to tell them why you're doing this, but this method can perhaps keep you in check and help you avoid looking at pornography or other similar material. After all, Satan tempts us most easily when we're alone. Sitting in the company of a family member or trusted friend will help.

Tip #21: Fasting helps

The Prophet Muhammad advised us to fast to cool passions. This should be a method we use to handle the desire aroused by pornography and similar material. Peace and blessings of Allah be upon the Prophet.

Tip #22: Life is full of tests

We human beings are weak people. We sometimes make mistakes. We are not perfect. When you fail, don't despair. You can get away from sin by defeating a Satanic suggestion the next time around. Sometimes we don't mean to watch but end up doing it anyway. But as soon as a thought comes to your mind that you are doing wrong, stop right there. If you persist, that will be become a sin which you have chosen intentionally.

Don't feel guilty if you did not plan to watch it. Sometimes the web and email technology force this filth on you. Just move away as fast as you can.

Tip #23: Get Married

Yes. You heard me right. Get married. The real thing is better than the fakeness of pornography which destroys you mentally, physically, and spiritually. In Muslim families, we see many younger people getting married while they are still in school. Texas law allows persons as young as 13 to get married with parental consent and a judge's order. Other states require at least 16 years of age for a marriage license. Talk to your parents. I am personally against very young people marrying, but it is certainly better than them having sinful relationships with each other or with the fictional characters brought to them through the web, magazines and films. There is no shame in talking to your parents and Imams about it. Make a decision with Shura if you want to get married early.

Marriage helps you overcome the destructive directions of a blessing of God called sex.

Tip #24: Use technology to help

There are many filters and spam stopping technologies which are available through different internet providers as well as for your email client. Use technology to close doors for pornography, a heinous crime against humanity.

Tip #25: It is not a Sin if you did not mean it

Sometimes we are just surfing the internet and something else pops up. It may show up in emails despite all the filters. As long as you did not mean to watch and move away immediately it is not a sin. Thank God, Alhamdu lillah. He does not hold us accountable for unintentional things.

Tip #26: Do Tauba, Repent and Return to Allah

He loves to see us come back. If you do end up watching the bad stuff, repent to Allah. Seek His forgiveness, reaffirm your faith in Him, and do good deeds to compensate for what you've done. He is All-Forgiving as long as you are sincere.

Tip #27: Repent Again and Fine Yourself

If you lapse, repent again. God is All-Forgiving as long as we mean it. But then you need to discipline yourself by promising that if you do it again, you will pay this much in charity or fast for a day.

The message is: don't give up on yourself. Keep trying. Struggle is life. Satan can get you down, but you can and will beat him with God's help if you are serious about changing.

Tip #28: Pray, Pray and Pray

Never underestimate the power of prayer. Dua is the essence of worship. You connect to God through prayers. Talk to Him. He listens. While there, pray for this author and Sound Vision as well.

Tip #29: Fight Against Pornography

You will be blessed in your struggle if you speak and fight against pornography. It is not one person's problem. It is a problem that is hurting many people.

By Abdul Malik Mujahid



Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.














no image
Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.

Analysis Based on Size of Letters. The size of the letters is indicative of the following:-
  1. Very Small Writing:- Tiny writing indicates the artistic nature of the writer. People with this style go into the details of whatever they are doing. Generally they specialise in a particular field. They have an aim in life and do not waste either time or energy.
  2. Small Size Writing:- This indicates an intellectual and scholarly person with a keen sense of observation. These people are meticulous and methodical and are destined to do well in life.
  3. Medium / Average Sized Letters:- This is characteristic of a methodical and well-balanced person with a healthy mind. They are suited to business rather than service. Worldly-wise, they can grasp things quickly and well despite being relatively less educated.
  4. Large Sized Letters:- They show an active and restless mind. People with this handwriting are large hearted, self reliant and can influence others quickly. Very talkative, if they concentrate more on themselves, they can succeed easily.
  5. Very Large or Huge Lettering:- People like these feel that they are important. They cannot face criticism and therefore are definitely successful.
  6. Constant / Same Size of Letters:- This is indicative of a methodical mind.
  7. Decrease in Size of Letters:- Writing like this indicates a great level of cunning.
  8. Increase in Size of Letters:- Handwriting that gets larger indicates great frankness.
Analysis Based on Level of Writing
  1. Straight Lines: If lines are straight, the person has will power and determination. If they are absolutely straight, the person could be rigid. If a little irregular, the person has skill in many fields or has the capability to acquire one or more.
  2. Downward Slant: A downward slant is indicative of a dismal outlook. These people are pessimistic, moody and gets discouraged easily. If the writing has a prominent down ward slant, then they should be cautious because they can be foolish. They may try to get others sympathy by expressing this quality. If a person is not well physically and his or her writing has an extreme downward slant, it is not a good sign. It should be taken as a warning.
  3. Upward Slant: People who write this way are usually ambitious. They are also optimistic. If your handwriting has an upward slant, you probably can talk a lot, could be over-confident and sometimes unreliable. If the slant has a slight upward trend, then it is a good sign. If the slant is very steep, all these qualities are exaggerated.
  4. Irregular Lines: If the lines go upwards, but only towards the end of a sentence, particularly near the bottom of the page, they indicate a strong personality. Such people are courageous even in adversity.
  5. Falling Lines: If at the end of a line and at the bottom of a page, your lines fall, it means you get irritated and worried easily. You are weak and prone to stress.
  6. Dipped Lines: Lines which dip in the centre and rise again later indicate a half-hearted approach to work. People with such a hand start on work half-heartedly, with no purpose. Later they get enthusiastic and finish the task well.
  7. Humped Lines: These are lines that rise in the centre like a hump and then dip once again. These people start work enthusiastically but soon get discouraged and leave the task mid way.
The significance of spacing
  1. Line Spacing: This is an important aspect of hand writing analysis. It proves how important it is for the analyst to have a number of samples of a person's writing to provide an accurate judgment of an individual's personality traits.
  2. Close Spacing: If the lines are very close to each other and have no space in between, they show a confused personality with diverse thoughts crowding the mind.
  3. Average Spacing: These people are never in a hurry. They are casual and clear in thought, and in their day- to -day behaviour. They are well balanced and fair in their dealings.
  4. Wide Spacing: Many famous personalities possess this type of spacing. They are methodical careful and intelligent. Overall these are people with strong character.
  5. Connected Writing: When the letters of each word are connected it is called connected writing. These people are firm, bold, clear, and are positive attitude. They work in a refined way and are perfectionists. It is the mark of an outright sceptic.
  6. Broken Writing: Here, a few letters are disconnected. This type of writing indicates an ability to judge human character. Their writing looks rhythmic and signifies a fine flow of thought and interspersed with quick inspirational touches. It is indeed the writing of intelligent people.
  7. Disconnected Writing: Here every letter is separate. These people live in dreams and have a poetic mind. Inevitably, this is a person who loves art and nature. Do not confuse this handwriting with printed letters.
  8. Cramped Writing: When the words are cramped they indicate people who are extremely expressive. Those with this type of writing are cautions about money matters, bargain a great deal and are suspicious by nature.
  9. Spaced Writing: When words are very far apart, they belong to people who expressive but extravagant. Exhibitionists, they are socially active and fond of good life. They can never be systematic and are usually spend thrift. They forget things easily and should be careful in money matters.

Some Finer Points of Judgement / Analysis Based On Letter Formation.
  1. Rounded Letter: Writing of this type has rounded formations. It seems as if the writer has written in comfort and at leisure. These people are lazy, luxurious, and hate to do hard work. They have all the time in the world to chat but still think that they are busy. However, they are also peace- loving, law-abiding and crave the better things in life.
  2. Block Writing: These letters are plain simple and unadorned. The writing is straight. People of this type are hard-working, meticulous and practical. They are generally busy and are reserved by nature.
  3. Angular Writing: This is distinguished from 'Block' and 'Round' types of writing. People who write this way are full of energy and life. They want to lead people but are aggressive and desire quick results. They do not take criticism well. If the writing is too angular it shows a person as money-minded. If moderately angular the writer could be wise, loving and experienced.
  4. Single Letters: If the size of the letter does not change, it indicates that a person is very careful and conscious. These people never neglect their duties and are careful to finish whatever task is assigned to them. They are usually absorbed in the minutest details of any work that they undertake.
  5. Irregular Letters: Writing of this type is full of large and small letters. These people are rarely reliable and could be fickle. They take the most convenient route to anything.
  6. Small to Large Letters: Writing of this type indicates restrained behaviour. These people are eager to express themselves, work hard and want to get success through honest means.
  7. Large to Small Letters: This shows a tactful and friendly nature. People like this make good use of their connections. They are fair in all their dealings.
Finer Significance of Angle/ Slant
One of the most important aspects of graphology is the angle or slant of a person's writing. This needs special study since the variations though minimal, are significant.  
  1. If a slant is at 60 to 70 degrees, it shows the person as sensitive, emotional and imaginative. They get aggressive at the slightest provocation and have an intense nature. One should be very careful when dealing with them, since they get excited very quickly.
  2. If the slant is at 70 to 80 degrees, these people are very generous and very kind. They can make others happy and this helps them build careers. They share their happiness with others.
  3. A slant of 80 to 90 degrees is very common. This style is widely used and has a slight tilt towards the right. It indicates a cordial nature and a friendly attitude towards others. These people are genuine and usually take things easy. It is not difficult to manage people of this kind.
  4. If the slant is right-angled at 90 degrees, it shows a selfish nature. These people are analytic and unemotional, but could also be sincere and reliable. They always recognise obligations and hence prove good friends.
  5. If the slant is at 100 degrees, it indicates that the person remembers all the good and bad things that have happened in the past. It shows a nature that is suppressed and controlled, and which therefore could collapse when faced with problems and difficulty.
  6. If the slant is at 120 degrees, the person is cold and self-centred, and has no respect or regard towards others.

Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.

Many of us use spreadsheets to manage huge lists of data, like customer data bases, salesperson data bases etc.
Today we will learn a little conditional formatting trick that you can use to search a worksheet full of data and highlight the matching cells.
Search a large spreadsheet of data using conditional formatting
First identify which cell you want to use as search bar. Lets say we choose F4.

Now, Select the data cells you want to search and go to conditional formatting.
Formulas in Conditional FormattingWe will write a simple formula that returns true if a cell has the content you typed in the search bar (F4) and false if the cell doesnt. You can try something like ISERROR(FIND(LOWER($F$4),LOWER(B7)))=FALSE.
But there is a problem with this, it returns true when the search bar is empty, and thus you end up highlighting all cells. So we add a further condition that will highlight the matched cells only if the search bar contains some data.
The formula looks like,
Finally set the formatting you want to use. I choose dull orange color. You can choose blue, green or pink too.
Hit ok and you are good to go.
Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.
Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data.
In plain English, it means, you can take the sales data with columns like salesman, region and product-wise revenues and use pivot tables to quickly find out how products are performing in each region.
In this tutorial, we will learn what is a pivot table and how to make a pivot table using excel.
Excel Pivot Tables: Tutorial
click here to see a video tutorial of making pivot tables in excel

Example uses of Pivot Tables

As I said before pivot tables are very powerful and useful. There are numerous uses of pivot tables that we can talk about them until Christmas.
Here are some example uses of pivot tables:
  • Summarizing data like finding the average sales for each region for each product from a product sales data table.
  • Listing unique values in any column of a table [learn more]
  • Creating a pivot report with sub-totals and custom formats
  • Making a dynamic pivot chart
  • Filtering, sorting, drilling-down data in the reports without writing one formula or macro.
  • Transposing data – i.e. moving rows to columns or columns to rows. [learn more]
  • Linking data sources outside excel and be able to make pivot reports out of such data.

Excel Pivot Table Tutorial: How to create your first pivot table

Let us make your first pivot table. We will use example data in the following format. Download the excel pivot tables tutorial workbook with the data.
Pivot Tables in Excel - Tutorial

Step 1:  Select the data
Select the data range from which you want to make the pivot table.

Insert Pivot Table in Excel WorksheetStep 2:  Go to Insert ribbon and click on new Pivot table option
To insert a new pivot table in to your spreadsheet, go to Insert ribbon and click pivot table icon and select pivot table option.

Step 3:  Select the target cell where you want to place the pivot table. For starters, select New worksheet.
Excel will display a pivot table wizard where you can specify the pivot table target location etc. Select "New worksheet" option and your pivot table will be placed in newly created worksheet.

Step 4:  Make your first pivot report
The pivot report UI is very intuitive and sandbox like. To make powerful analysis, all you have to do is drag and drop fields in to the pivot table grid area. In excel 2007, you can also control this by using the "Pivot table panel".
The pivot report is divided in to header and body sections. You can drag and drop the fields you want in each area. The body itself contains three parts. Rows, Columns and Cells. You can use any fields in these areas too.
For the above sample data, I have set this criteria:
Pivot Table Settings - Row, Column, Header and content settings
And the outcome is this pivot report.
Example Pivot Report - Excel Pivot Tables
It might be a bit difficult to understand how this works. But believe me, if you have seen any reports or worked with any other reporting systems, then the idea of pivot tables, pivot reports and pivot charts becomes quite simple to you.
You can use the excel pivot table features to make a more complicated pivot report like this in no time.
Example Pivot Report - A very detailed Pivot Table with sub-totals and totals

Some useful tips on Excel Pivot Tables

  • You can apply any formatting to the pivot tables. MS Excel has some very good pivot table formats (and they are better in Excel 2007 and 2010).
  • You can easily change the pivot table summary formulas. Right click on pivot table and select "summerize data by" option.
  • You can also apply conditional formatting on pivot tables although you may want to be a bit careful as pivot tables scale in size depending on the data.
  • Whenever the original data from which pivot tables are constructed, just right click on the pivot table and select "Refresh Data" option.
  • If you want to drill down on a particular summary value, just double click on it. Excel will create a new sheet with the data corresponding to that pivot report value. (This is extremely useful)
  • Making a pivot chart from a pivot table is very simple. Just click on the pivot chart icon from tool bar or Options ribbon area and follow the wizard.

Download the excel pivot tables tutorial workbook and practice yourself

Click here to download the excel pivot tables tutorial workbook. [.zip version of tutorial here]The workbook has sample data and one pivot table in it. You can play with it to learn more.

Checkout the video tutorial to make excel pivot tables

Click here to see a video tutorial of making pivot tables in excel

no image
Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.
Most of professionals do not know how to apply for a job even experienced one also here are few tips points you all should remember and apply when you apply for any job.

  1. If you don't meet the criteria DON'T APPLY for that JOB.
  2. If you apply must mention name of the POST Position applied for in SUBJECT of your email e.g NSS Core Network Engineer Huawei & Ericsson Experienced 3 Years experience. This will help the recruiter to sort out your resume easily rather to download and read your resume and then sort you.
  3. While applying for any job must write executive summary of your carrier e.g I have 2.5 years of experience on NSN 1234 BTS 1 Year experience on HUAWEI 456 BTS with your main projects e.g worked for vodafone worked for telenor at least 3-4 lines of your professional experience.
  4. Resumes should be MS-WORD format rather to send PDF file or password protected file because in WORD file each and every department or manager can write comments codes to your file in PDF its impossible.
  5. Apply Once for each position rather to send your resume from all of your email accounts for the same position DOUBLING BAD IMPRESSION.
  6. Don't use logos of multinationals in your resumes. only iff you have the right to do so.
  7. Email address should be professional like rather to have
  8. Resume should be up to date please check twice your resume before applying.
  9. Contact numbers should be working and active all time.
  10. Resume name should start with your name e.g ali_NSS.doc khan_BSS.doc asad_RNP.doc rather to have MY-Resume1 CV-1 New-2010 updated_2010. Please AVOID this other wise 99% chances that your resume could go to TRASH.
  11. TRY to save your time and time of the person who is hiring you he/she doesn't have the time to reply you and tell you your mistakes he/she doesn't have the time to rename your resume he/she doesn't have the time to sort your expertise and resume.
  12. Be Honest in interview and tell truth about your PAY and incentives 99.99% you could be caught either for a local job or International MEMBERS OF THIS GROUP TRIED THIS AND FAILED ;-).
  13. NEVER try to reach Hiring Manager or person directly DON'T Call email him unless he/she allows you to do so.

Self Improvement, Wisdom, Professionalism, Inspirational Stories, Positivity, Leadership, Management, Stress, Optimism and Peace, Productivity.

How to cook a delicious dynamic chart that will have your boss drool (

Link to - Learn Excel & Charting Online

Posted: 31 Aug 2010 01:43 AM PDT
Dynamic charts are like my favorite food, Mangoes. They tempt, tease and taste awesomely. In this post, we are going to learn how to create a dynamic chart using check boxes and formulas. Are you ready for some excel chart cooking?

What our mouth-watering chart will look like when its done:

Dynamic Chart with Check boxes and formulas - Demo


Some data, Few check-boxes, IF formula and a dash of espresso

Instructions for preparation:

  1. First get your data. Make sure its clean and arranged neatly, like below, in the range B4:E11.
    Dynamic Chart - source data
  2. Since our data has 3 series (sales, profits and number of customers), we will take 3 check boxes and place them somewhere on our worksheet.
    Insert check boxes from developer ribbon / forms tool bar (tip: show developer ribbon in excel 2007)
    Insert Check box - Excel
  3. Now, we want the check boxes to tell whether to show or hide a particular series of data in the chart. So, link each check box to one cell, say C13, D13 and E13.
    Set linked cell - check box -excel
  4. We will use IF formula to roast our data based on what the check boxes say. So, create a similar table and load it with IF formulas like this:
    Dynamic chart - processed data based on check box status
  5. Finally, make a chart with the data in this new table you created.
  6. Put everything together and neatly arrange with your favorite colors and labels.
  7. Serve hot and see your boss drool.

Download the prepared chart:

You can download FREE dynamic chart template and serve it instantly.

More recipes on dynamic charts:

Do you use dynamic charts?

I like dynamic charts a lot. They provide a wealth of information in a compact form. I use them whenever possible, especially in dashboards and analytical outputs.
What about you? Do you use dynamic charts often? What techniques do you use when implementing dynamic charts? Share your experience and tips using comments.

Email delivery powered by Google