Ayurveda, Knowledge of Life has, described the numerous effects of ghee…

1. Action On the Brain
Brain is one of the main sites that ghee acts. Only Fat Soluble substances and alcohol soluble substances can cross the blood brain barrier. Ghee is a fat. Hence it can cross the Blood Brain Barrier. Ghee acts on the brain and increases the receptive power, cognitive power, remembering power. Brain development takes place mostly during the childhood. So giving 1 teaspoon of ghee everyday especially during this age, will enhance the intellectual power of brain. The effect is multiplied a 100 times if medicated ghee like Brahmi Ghritam, Saraswata Ghritam etc is used.
Wonderful effects have been seen in children whose mile stones of development was retarded. In Brain development retarded cases ghee like Kalyanaka, Paishachika, Brahmi Ghrita brings good results. If given in normal children, it will enhance the growth of brain, thus making, child sharper, smarter and with good memory.
Ghee also has immense effects on the psychatric complaints. People with psychatric complaints like mood disorders, schizoprenia etc have good results with Kalyanakam, Paishachika, Maha Kalyanakam, Mahapaishachikam Ghritam etc depending on condtion of patient.
2. Action on the metabolic pathways
Ghee is said be Agni Vardhaka. Agni is that factor which does bio-chemical transformations in body. It may be hormones, enzymes or co-factors. Daily taking 1 teaspoon of ghee on empty stomach in normal healthy state will result in proper production of Agni, thereby making the bio-chemical transformations proper.

3. Action on immunity
Ghee is said to be Bala Vardhaka. Bala is the resistance power of a person. When ghee is given to a person, his immune power increases thereby preventing him from common colds and other diseases. This has especially been seen when Indukantham, Amruthaprasham Ghritam etc is given.
4. Action against allergy
Ghee is a best anti-allergic substance. It has been found that people who were given Indukantham Ghritam, Mahatiktakam Ghritam etc where found to have very little allergic reactions of any kind like excess sneezing, itching around the eyes, allergic asthma, allergic dermatitis etc.
5. Action on GIT – Gastro-Intestinal Tract
Ghee smoothes and nourishes the mucosa thereby preventing the formation of gastric ulcer. It also heals the ulcer in stomach. This also reduces hyperacidity and prevents the burning sensation in chest. Ghee is also good for people who have constant gas formation due to the persistent gastritis. It also makes the digestion normal and increases the quality and functions of the gastric and pancreatic juices thereby providing complete digestion and thus prevents disorders of digestion.
6. Action on Male Reproductive System
Ghee acts on the reproductive system, especially on male reproductive system. Only Fat soluble substances can pass the blood testis barrier. Ghee increases the sperm count, increases the seminal fluid amount and increases the active motility of sperms. In many infertility cases where the reasons is due to the defects in male part treatment with medicated ghee like Phala Sarpis, Kalyanakam Ghritam, Dadimadi Ghritam etc have brought good results.
7. Action on Female Reproductive System
Ghee also has immense action on the female reproductive system. It is usually the medicine of choice in common gynecological conditions like menstrual abnormalities, infections of uterine tract, inferltility, repeated abortions, uterine prolapse and hormonal imbalance induced uterine and vaginal complaints etc. Usually used medication are Phala Sarpis, Dadimadi Ghritam, Satavaryadi Ghritam, Kalyanakam Ghritam depending upon the condition..…..

Ghee is also of special importance during pregnancy i.e ante-natal care. Vaginal deliveries are in decreasing trend and ceserean sections are increasing. Ghee medicated with certain medicinal plants are to be used in the three trimesters of pregnancy for a full term normal vaginal delivery.
8. Action on eyes
Another important site of action of ghee is the eyes. Daily intake of 1 teaspoon Triphala Churnam + 1 Teapsoon Ghee + ½ Teapsoon Honey will prevent all the eye diseases especially the refractive errors like myopia, hypermetropia, ambylopia. Usually in cases with eye complaints, Ayurveda advises to do Netra Tarpana i.e. making the ghee stand on eyes for some times with Jeevantyadi Ghritam, Triphala Ghritam, Satahwadi Tarpana Ghritam etc depending upon the condition of the patient. This has brought good result in a lot of people helping them to improve their vision.
9. Action on throat
Ghee is good for the throat. It is especially good for making the swara i.e. voice good smooth and tuned. It is especially indicated for singers. It also prevents fatigness of throat especially for those who talk for a long time.
10. Action on cuts and burns
It was in earlier times a practice that when ever there is a fresh burn people would immediately apply ghee. The results were very fantastic….they wouldn’t even get a single boil or scar…..the burning sensation and the scar was also absent……similarly in a small cut ghee with honey are applied to the cut area. It would heal the area very fast. In long standing ulcers like venous ulcers application of Jatyadi Ghritam + Honey has proven results..This Jatyadi Ghrita is also an anti-microbial. It prevents the secondary bacterial attack……….It is also used in fissures and fistulas for healing of the wound.
11. Action on the toxins that enters the body
Man is now a constant eater of a lots of toxins and poisons that are harmful to the body….the fruits and vegetables that we get today are covered with lots of insecticides and pesticides…..all the food that we eat are now adultered… meats especially there are lots of hormones in high quantity that causes hormonal imbalance to the body…These all may be compared with gara visha in Ayurveda and ghee is one of the best remover of visha. It will detoxify the body. Tiktakam, Maha Tiktakam, Kalyanakam Ghrita are best among them.
12. Action on Fevers
Each and every day, newer types of fevers are emerging. There are many people with getting attacks of fever repeatedly every month. Main reason for the increased susceptibility to fever is decreased body resistance. Ghee has a very special and important role…Ghee enhances the immune power, increases the body strength and prevents the person from getting recurrent fever. In this context, Indukantham Ghritam is very special.
13. Makes very thin people healthy
Ghee has a special property of increasing the Mamsa dhatus in body. So this is especially good in people who are very thin and weak….Ajamamsa Ghritam, Indukantham Ghritam, Amrithaprasham Ghritam can be used accordingly with milk to increase health.

14. Action on Joints
Ghee lubricates the joints and makes them functionally good. In treatment of osteo-arthritis and rheumatoid arthritis ghee is important. It strenghthens the back bone, knee joint etc thereby reducing pain and other complaints….
15. Actions as an anti aging agent
Ghee is a good anti-aging agent…a person who consumes ghee daily will have all aging changes very late and that too in decreased rate….It is good when applied to face along with pure Tumeric Powder. It brings brightness to the face. But should not be used by persons who have oily skin.
16. Action on preventing hair fall and premature greying
Ghee also helps in strengthening the hair roots, thus preventing the excess hair fall….Ghee also prevents and reduces the pre-mature greying of hairs….Indukantham Ghritam, Amrutaprasham Ghritam, Ajamamsa Ghritam, Kalyanakam Ghritam etc can be used according to the condition.
17. Action for making the respiratory system healthy
Ghee especially acts on the respiratory system and prevents the chances of lung disorders like asthma and other diseases. Indukantham Ghritam, Maha Tiktakam Ghritam, Amrutha Prasham Ghritam, Kalyanakam Ghritam etccan be done based on the condition of the patient.
Many people come to us and say that we have taken medicated ghees for many months but there has not been any result….
Ghee should be only taken after the digestive process of our body is good and our Kapha in the body has been decreased….if ghee is taken in this condition, it will get digested well and will act like a Nectar or Amrut.
In Contrast…..
If ghee is taken during the acute infections or when there is high temperature or when there is no or less appetite with increased Kapha, it will not get digested and will act like a poison…..Either there will be aggravation of the condition or there will not be any affect on the system…..
This has been very well mentioned in Ayurveda….
All the medicines prescribed above should be taken only after an expert medical advice from an Ayurvedic Doctor.
As seen in the link below.…/eat-ghee-and-be-free-ayurveda-a…

परोपकाराय फलन्ति वृक्षा: परोपकाराय वहन्ति नद्यः।

परोपकाराय दुहन्ति गावः परोपकाराय इदं शरीरम्।


h.gifa.gifr.gifi.gifh.gifa.gifr.gifa.gifn.gifk.gif ( hari krishnamurthy K. HARIHARAN)"

” When people hurt you Over and Over think of them as Sand paper.
They Scratch & hurt you, but in the end you are polished and they are finished. ”
"Keep away from people who try to belittle your ambitions. Small people always do that, but the really great ones make you feel that you too, can become great."- Mark Twain.
யாம் பெற்ற இன்பம் பெருக வையகம்

visit my blog
follow me @twitter lokakshema_hari



read the article below. Indian politicians and Government can learn from this. Hope our so called intellectuals learn some thing from this returning awards and medals are just show off .

Canadian Mayor’s reply to Muslims against pork.

Pork will continue to be served in Canadian schools.

Muslim parents demanded the abolition of pork in all the school canteens of a Montreal suburb. The mayor of the Montreal suburb of Dorval, has refused, and the town clerk sent a note to all parents to explain why…
“Muslims must understand that they have to adapt to Canada and Quebec, its customs, its traditions, its way of life, because that’s where they chose to immigrate.

“They must understand that they have to integrate and learn to live in Quebec.
“They must understand that it is for them to change their lifestyle, not the Canadians who so generously welcomed them.
“They must understand that Canadians are neither racist nor xenophobic, they accepted many immigrants before Muslims (whereas the reverse is not true, in that Muslim states do not accept non-Muslim immigrants).
“That no more than other nations, Canadians are not willing to give up their identity, their culture.
“And if Canada is a land of welcome, it’s not the Mayor of Dorval who welcomes foreigners, but the Canadian-Quebecois people as a whole.
“Finally, they must understand that in Canada (Quebec) with its Judeo-Christian roots, Christmas trees, churches and religious festivals, religion must remain in the private domain.

The municipality of Dorval was right to refuse any concessions to Islam and Sharia.
“For Muslims who disagree with secularism and do not feel comfortable in Canada, there are 57 beautiful Muslim countries in the world, most of them under-populated and ready to receive them with open halal arms in accordance with Sharia.
“If you left your country for Canada, and not for other Muslim countries, it is because you have considered that life is better in Canada than elsewhere.
“Ask yourself the question, just once, “Why is it better here in Canada than where you come from?”

“A canteen with pork is part of the answer.”
Share this story, to promote tolerance in the world. This is what should be adopted in all countries..

the ‘Miniature Wunderland’

Two German Brothers have put this TRAIN SET together.

This is the world’s biggest train set.
Covers 1,150 square meters / 12,380 square feet…
Features almost six miles of track and is still not complete…

Twin brothers Frederick and Gerrit Braun, 41, began work on the ‘Miniature Wunderland’ in 2000.

The set covers six regions including America , Switzerland , Scandinavia , Germany , and the Austrian Alps.

The American section features giant models of the Rocky Mountains, Everglades , Grand-Canyon etc…

…and Mount Rushmore.

The Swiss section has a mini-Matterhorn.

The Scandinavian part has a 4ft long passenger ship floating in a ‘fjord’.

It is expected to be finished in 2014, when the train set would cover more than 1,800 square meters / (19,376 sq ft) and feature almost 13 miles of track, by which time detailed models of parts of France, Italy and the UK would have been added…

It comprises 700 trains with more than 10,000 carriages and wagons.

The longest train is 46ft long.

The scenery includes 900 signals, 2,800 buildings, 4,000 cars – many with illuminated headlights.. .

…and 160,000 individually designed figures.

Thousands of kilograms of steel and wood was used to construct the scenery…

The 250,000 lights are rigged up to a system that mimics night and day by automatically turning them on and off.

The whole system is controlled from a massive high-tech nerve centre.

In total the set has taken 500,000 hours and more than 8 million euro to put together, the vast majority of which has come from ticket sales.

Gerrit said: "Our idea was to build a world that men, women, and children can be equally astonished and amazed in."

Frederik added: "Whether gambling in Las Vegas, hiking in the Alps or paddling in Norwegian fjords – in Wunderland everything is possible."This 4-minute video is worth watching for this amazing stuff.


परोपकाराय फलन्ति वृक्षा: परोपकाराय वहन्ति नद्यः।

परोपकाराय दुहन्ति गावः परोपकाराय इदं शरीरम्।


h.gifa.gifr.gifi.gifh.gifa.gifr.gifa.gifn.gifk.gif ( hari krishnamurthy K. HARIHARAN)"

” When people hurt you Over and Over think of them as Sand paper.
They Scratch & hurt you, but in the end you are polished and they are finished. ”
"Keep away from people who try to belittle your ambitions. Small people always do that, but the really great ones make you feel that you too, can become great."- Mark Twain.
யாம் பெற்ற இன்பம் பெருக வையகம்

visit my blog
follow me @twitter lokakshema_hari


The Golden Rules Of Life

The Golden Rules Of Life

We’re not born with a manual on how to live life, which forces us to learn lessons the hard way. Life can be hard, complicated, and confusing. You’ll never encounter two situations that are exactly the same, but we have to figure out the right way to react. That being said, these few rules can help you handle life and make smart decisions. You might say they’re the Golden Rules for Life.


Don’t have the time to hit the gym? Then stair training is something you might enjoy.

Don’t have the time to hit the gym? Then stair training is something you might enjoy.

Stairs are often neglected and remembered only during emergencies and smoke breaks. If you do not have the time to hit the gym then working out with the help of stairs is a great idea as it’s guaranteed to tone and tighten you lower body. Not to forget, it’s a great form of cardiovascular exercise. But there are some dos and don’ts for stair training and with the following tips we help you optimise it so you don’t injure yourself.

Anaerobic fitness

If you experience tiredness and shortness of breath within 2 to 3 minutes stair exercise, then start slowly and pace up gradually. Stair training will improve your anaerobic fitness, and improve your aerobic fitness. Stair exercises will help you increase your cardiovascular stamina and will also tone your lower body.

Cardio training

Staircase exercise is a great out of gym cardio training. You can also incorporate stair exercise in your interval training and circuit training routines.

Core training

It also strengthens the muscles around the lower back and the abdomen. If you are a beginner then start slowly as your core muscles needs to be in shape to help you balance and prevent you from falling on the stairs.

Here’s how to perform stair case workout

1. Push ups

Your own body weight helps you build your upper body.

2. Squats

It is a great way to build leg muscles and boost your stamina.

3. Step ups

Take a step with your right leg and land on your heel. Step down and continue the same for the left foot.

4. Triceps Dips

Sit on the bottom step and place your hand on the second last step. Now slowly push your body upwards with your hands, lifting yourself up. Keep your elbow at 90 degree when you are propped up.

5. Lunges

Lunges can help build your lower body since your legs need to be sexy for your summer look. Stand on the bottom step and extend your left foot far as possible and bend the knee. Repeat it with the other foot.

Stair workout for weight loss

According to Livestrong, you can lose weight if you try the stair workout for 60-90 minutes for five days. A person can burn 1,225 calories in a 90 minute workout.

Go slow to burn more calories with stair workout

According to this study, if you climb stairs slowly you will burn far more calories than doing it at a fast speed.


परोपकाराय फलन्ति वृक्षा: परोपकाराय वहन्ति नद्यः।

परोपकाराय दुहन्ति गावः परोपकाराय इदं शरीरम्।


h.gifa.gifr.gifi.gifh.gifa.gifr.gifa.gifn.gifk.gif ( hari krishnamurthy K. HARIHARAN)"

” When people hurt you Over and Over think of them as Sand paper.
They Scratch & hurt you, but in the end you are polished and they are finished. ”
"Keep away from people who try to belittle your ambitions. Small people always do that, but the really great ones make you feel that you too, can become great."- Mark Twain.
யாம் பெற்ற இன்பம் பெருக வையகம்

visit my blog
follow me @twitter lokakshema_hari


How Jewelers Cheat Customers

Gold Jewelry Scam in India; Be Very Careful,
How Jewelers Cheat Customers
During my childhood days, one of my dad’s friends was a Jeweler.
Click here to join World Malayali Club

Whenever we used to go for Jewelry purchase, I used to pity on him as i used to think that how this poor chap earn his living. He used to sell gold at market rate i.e. same rate at which he has bought. Now I pity on my thought process as the same poor chap is now richest person of town.

In my opinion, Jewelry purchase is the only domain where females don’t bargain at all and women can be cheated easily. I have closely observed purchase cycle and found out many loopholes in entire chain.
It’s very high margin business and customer can be easily fooled to the extent of 35%-40% of total sale value (Which is clean profit margin for jeweler). In my opinion, its not cheating but a fraud in broad daylight. Let’s discuss these points in details.
1. Making Charges: The biggest culprit among all. Jewelers can charge making charges up to 40% of sale value. The sale and purchase of Jewelry is a mind game. The Jewelers play with the mind of the customers especially females. This is the smartest trick of any trade. If you have observed closely then most of the salesmen try to convince accompanying female member specially in real estate and jewelry purchase. Once they gauge the mind then price is being quoted. You will never find price mentioned on any of jewels unit. Instead of price, some code is being mentioned so jewelry price is not standardized. Some time back, I visited one of the reputed Jewelers with pan India presence. He quoted price of necklace as 1 Lac Rs. when I asked him price breakup, he became uncomfortable and told me that no one ask for breakup. He was trying to show that as if I am some idiot who has come for jewelry purchase for the 1st time. When i insisted, he gave break up as 70k is value of gold and 30k is making charges. He pitched that making charges are just 30% of this beautiful necklace but way to look at it is that for 70k asset you are paying 30k making charges i.e. approx 43%. Now you can image the extent of cheating.
2. Gold Purity: The purity of Gold is measured in carat. 24 Carat is purest form of Gold available but you cannot make any jewelry from 24 Carat Gold. 24 Carat Gold can be held only in the form of gold coin or gold brick. 18 Carat Gold means that it contains 18 part of Gold and 6 part of another metal i.e. 75% purity. Purest form of jewellery is 22 Carat. The Hallmark gold contain Gold Purity seal but to value conscious customers, Jeweler pitch low carat gold and charge high.
Reason for this is customer has particular budget in mind and jeweler try to fit customer’s requirement in customers budget with low carat gold. In this bargain, he cheat customer on Gold Purity. In small towns, still the Jeweler’s word is final on Gold purity. They sell 18 Carat gold and charge for 22 carat gold. The oral guarantee of Jeweler in small towns is biggest guarantee for customer.
3. You are Paying Gold Rate for Ordinary Stones: Any piece of jewelry is incomplete without colorful stones. When you are buying this jewelry piece then jeweler weigh the entire piece and charge @ Gold Price but have you thought that you are paying the price of Gold for ordinary stones costing few hundred bucks embedded in jewelry.
If you go for exchange of same piece then jeweler will deduct the weight of stones as impurity from total value. Assuming these stones weigh 10% of total weight then at the time of purchase, you are paying 10% extra and at the time of sale, you will get 10% less value. It’s a double loss for customer.
4. Wastage: Normally Jewelers charge 5%-7% of total gold weight as wastage during making. It is different from making charges and it implies the qty of gold wasted during making. Trust me not even a single gram gold is wasted during making as Gold can be melted and used again.
5. Jewelry Cleaning: This is complementary service from Jewelers and as customer we thank Jeweler that he is such a nice human being that he is cleaning jewelry for FREE….Friends, there are no free lunches in this world. For cleaning gold jewelry, the jeweler put the jewelry in one solution which is basically acid. Whenever gold is put in this acid then gold particles are dissolved in this acid. If you weigh the jewelry before and after cleaning then you will
observe the difference of a gram or few fraction of same. So if jeweler is cleaning 100 pieces in a month then he can easily extract 60-70 gram gold from acid solution which will cost approx 2 Lac today.
6. Converting Gold Coins to Jewelry: Many people invest in form of Gold Coins from bank or jeweler. If you are selling Gold Coins back to jeweler from whom you bought the same then you will get complete value. But if u are selling or converting Gold Coins purchased from bank to jeweler then no one will buy at market rate. Despite being of 24 carat purity gold coins of banks are accepted @ 20% to 25% discount by Jewelers. Gold coins of other Jeweller’s are accepted at 5%-10% discount. Its a heavy loss for customer and nothing less then cheating.

7. Under Valuation of Gold Jewelry: If you buy any gold jewelry worth 1 Lac today then i can bet and give it in writing that no other jeweler will value the same more then 95k at same gold rate same day.
Jewelers tend to undervalue the jewelry purchased from other Jeweler.
I hope that this article will be useful for readers to make informed and correct decision while buying Gold jewelry. You cannot avoid 100% cheating but can minimize the extent of loss by questioning the
jeweler regarding pricing.

10 Awesome Features in Excel 2013

Helen BradleyHelen Bradley | @helenbradley

Microsoft’s updated spreadsheet tool isn’t getting a lot of new, whiz-bang features, but it is becoming more functional. That’s something both new and experienced users will enjoy—especially a new approach to an old problem that used to require a cumbersome workaround. Complex tasks become easier to perform, thanks to tools such as Recommended Charts and Recommended PivotTables tools. Other changes place choices closer to your data, and use big-business brawn to crunch data right into Excel.

To help you get up to speed, read on for 10 new features that make your work easier in the new Excel. Want to know more about the new Office suite? You’ll find our full review of Office 2013 here, as well 10 killer features in the new Word 2013 here.

1. Start screen sets the scene

Excel’s new Start Screen helps you get to work more quickly. Along its left edge are the most recently used worksheets, any of which can be pinned to your Recent list so they will always be visible. Here, too, you can click Open Other Workbooks to access your files from a disk or the cloud. The Start Screen’s top-right corner also shows the SkyDrive (or SharePoint) account you are currently connected to.

A range of templates appears here to help you quick start a project. These can also be pinned, or you can use the search feature to look online for other templates. A list of suggested searches can help you get started.

New users will appreciate the template choices, and existing users will likee the Recent file list and quick access to existing files. Although the Start Screen can be disabled, I find it useful enough to stick with it.

The Open tab has links to recently accessed files and locations.

2. Enjoy a new Backstage View

The Backstage View, introduced in Office 2010, is accessible from the File menu. In Excel this has been revamped to show exactly what you’re doing so you can choose the appropriate task.

The Open tab now gives you access to recently accessed workbooks, making it a combination of the Open and Recent tabs from Excel 2010. You can pin worksheets to this list or click Computer to access recently accessed locations (any of which you can pin permanently here, too). There’s also access to your SkyDrive account, and the option to set up additional SkyDrive or SharePoint accounts.

Want to split first and last names into two columns? Look to the new Flash Fill feature.

3. Make Flash Fill magic

The most whiz-bang new feature is the Flash Fill tool. Its predictive data entry can detect patterns and extract and enter data that follows a recognizable pattern. It solves some common problems that currently require cumbersome workarounds to achieve.

One such problem is extracting a person’s first name from a column of full names. In a blank column adjacent to the one that contains full names, you simply type the first name and then click theHome tab, and select Fill, Flash Fill. The first names of everyone in the list will be entered into that that column immediately. You can use the same process to extract last names, to join first and last names, to extract months, days or years from dates and even extract values from cells. While you could have always done this with formulas, now Flash Fill ensures anyone can do it very quickly and easily.

Take the guess work out of which chart to choose to best display your data.

4. Simplify choices with Recommended Charts

This falls somewhere between a whiz-bang new feature and something that makes working in Excel more intuitive. Recommended Charts shows only a subset of chart types that are appropriate to the data you’ve selected. It will help inexperienced users create charts that help explain the data and don’t confuse the viewer.

To use the tool, select the data that you want to chart, click the Insert tab and selectRecommended Charts. A dialog appears with a range of charts to choose from—click each in turn to see how your data will look plotted on that chart. Select the desired option and click OK, and the chart is created automatically.

Change the look of your chart by selecting options from the pop-up menu.

5. Chart tools get smarter

In previous versions of Excel, when a chart is selected, the Chart Tools tab revealed three additional tabs: Design, Layout, and Format. The interface is simpler in Excel 2013, with only the Design and Format tabs to choose from.

In addition, a set of icons appears outside the top right edge of a chart when it is selected. Click any of these buttons—Chart Elements, Chart Styles or Chart Filters—to reveal additional chart formatting options. Click Chart Elements to add or remove elements, such as axis titles and legends; click Chart Styles to change the style and color of your chart; or click Chart Filtersto view filtered data using a live preview.

Quick Analysis offers formatting, totals and charts for analyzing your data.

6. Quickly analyze your data

The new Quick Analysis tool can help both new and experienced users find options for working with selected data. To use it, select the data to analyze, and the Quick Analysis icon appears in the bottom-right corner of the selected data.

Click that icon, and a dialog appears showing a range of tools for analyzing the data, such as Formatting, Charts, Totals, Tables and Sparklines. Click any option, and a series of selectable choices appear; preview those choices by mousing over them. Next, click the option you like to apply it to your data. This feature speeds up the process of formatting, charting and writing formulas.

PivotTables just became ridiculously simple to create.

7. Answer questions instantly with Pivot Tables

Pivot Tables are a powerful tool for analyzing and answering questions about your data, but they’re not easy for new users to create. For the first time, though, if you can click a mouse key, then you can create a meaningful Pivot Table, thanks to the new Recommended PivotTables. To use it, select your data, including headings, and choose Insert, Recommended PivotTables. A dialog appears showing a series of PivotTables with explanations of what they show. All you need do is to select the table that shows what you want to see, click OK,and the PivotTable is automatically drawn for you.

Excel 2013 now integrates Power View for beefy analysis and reporting.

8. Make quick reports with Power View

The Power View add-in, available for previous versions of Excel, is now integrated inside Excel 2013. Power View is typically used for analyzing large quantities of data brought in from external data sources—just the sort of tool that big business might use.

Incorporated within Excel, it’s now accessible to anyone. To see it at work, select your data and choose Insert, Power View. The first time you use it, the feature installs automatically. Then a Power View sheet will be added to your workbook, and the analysis report will be created.

You can add a title and then filter the data and organize it to display the way you like. The Power View tab on the Ribbon toolbar displays report format options, such as Theme and text formats, as well View options for Field List and Filters Area panels that you can use to filter and sort your data.

Try to work on a worksheet that someone else is editing? You’ll be warned that it’s locked. You can view and download it, but can’t change it.

9. Share files and work with other people

Working with other people on shared files in real time is a double-edged sword. While it’s useful to do this, you will face problems when two people try to change the same item at the same time. In Excel 2013 you can share and work collaboratively on files with others via SkyDrive using the Excel WebApp, and multiple people can work on the same file at the same time. However, you cannot open a worksheet from SkyDrive in Excel 2013 on your local machine if someone else is currently working in the same worksheet. This protects the worksheet against conflicting changes.

Instead, if one person is editing an Excel file that’s stored online, others with permission can view and download it, but they cannot change the original, whichis locked until the person working with it is finished.

Like other applications in the Office 2013 suite, Excel 2013 saves files by default to the cloud. You can open, view, and edit Excel files online in a browser using the Excel WebApp without having Excel 2013 on the local hard drive.

Share your cloud-stored worksheets with friends on Facebook, Twitter, or LinkedIn.

10. Share work to your social networks

Here’s a handy way to share a to-do list, an event planning worksheet, or whatever spreadsheet you desire with your social network. You can now share Excel workbooks with Facebook and more from within Excel 2013 itself. To see the Post to Social Networks option, the best way to save the file first to SkyDrive.

If you haven’t saved your file to SkyDrive, then choose File, Share, and click Invite People. You’ll be stepped through the process of saving the file to the Cloud so that Save As options later appear automatically. Once this is done, you are returned to the Share panel where the Post to Social Networks option now appears. Here you can select any social network that you have linked to your Office 2013 account. You can select whether viewers can view or edit your shared worksheet, and you can include a message, and then post it for review.

Helen Bradley is a business and lifestyle writer, blogger, photographer; Photoshop and Lightroom professional; and an expat Australian.

परोपकाराय फलन्ति वृक्षा: परोपकाराय वहन्ति नद्यः।

परोपकाराय दुहन्ति गावः परोपकाराय इदं शरीरम्।


h.gifa.gifr.gifi.gifh.gifa.gifr.gifa.gifn.gifk.gif ( hari krishnamurthy K. HARIHARAN)"

” When people hurt you Over and Over think of them as Sand paper.
They Scratch & hurt you, but in the end you are polished and they are finished. ”
"Keep away from people who try to belittle your ambitions. Small people always do that, but the really great ones make you feel that you too, can become great."- Mark Twain.
யாம் பெற்ற இன்பம் பெருக வையகம்

visit my blog
follow me @twitter lokakshema_hari