Blog Archive

Humor: The Cyclist

A Cyclist - is such a disaster for the economy:

1. S/He doesn't buy a car and does not take a car loan.
2. Does not buy vehicle insurance.
3. Does not buy fuel.
4. Does not use the services of repair shops and car washes.
5. Does not use paid parking.
6. Does not become obese.
7. Yes, and well, dammit! Healthy people are not needed for the economy. They do not buy drugs. They do not go to private doctors. They do not increase the country's GDP!
On the contrary, every new McDonald's outlet creates 30 jobs: 10 Dentists, 10 Cardiologists and 10 Weight Loss Experts.

You are welcome to Ponder!!
 

Excel Basics: Creating Charts and Conditional Formatting

A picture is worth of thousand words; a chart is worth of thousand sets of data. In this tutorial, we are going to learn how we can use charts in Excel to visualize our data.

What is a chart?

A chart is a visual representative of data in both columns and rows. Charts are usually used to analyse trends and patterns in data sets. Let's say you have been recording the sales figures in Excel for the past three years. Using charts, you can easily tell which year had the most sales and which year had the least. You can also use charts to compare set targets against actual achievements.
We will use the following data for this tutorial.
Note: we will be using Excel 2013. If you have a lower version, then some of the more advanced features may not be available to you.
Item 2012 2013 2014 2015
Desktop Computers 20 12 13 12
Laptops 34 45 40 39
Monitors 12 10 17 15
Printers 78 13 90 14

Types of charts

Different scenarios require different types of charts. Towards this end, Excel provides a number of chart types that you can work with. The type of chart that you choose depends on the type of data that you want to visualize. To help simplify things for the users, Excel 2013 and above has an option that analyses your data and makes a recommendation of the chart type that you should use.
The following table shows some of the most commonly used charts and when you should consider using them.
S/N CHART TYPE WHEN SHOULD I USE IT?
EXAMPLE
1 Pie Chart When you want to quantify items and show them as percentages.
Visualizing data using charts in Excel
2 Bar Chart When you want to compare values across a few categories. The values run horizontally
Visualizing data using charts in Excel
3 Colum chart When you want to compare values across a few categories. The values run vertically
Visualizing data using charts in Excel
4 Line chart When you want to visualize trends over a period of time i.e. months, days, years, etc.
Visualizing data using charts in Excel
5 Combo Chart When you want to highlight different types of information
Visualizing data using charts in Excel

The importance of charts

  • Allows you to visualize data graphically
  • It's easier to analyse trends and patterns in the charts
  • Easy to interpret compared to data in cells

Step by step example of creating charts in Excel

In this tutorial, we are going to create a simple column chart that will display the sold quantities against the sales year.
  • Open Excel
  • Enter the data from the sample data table above
  • Your workbook should now look as follows
Visualizing data using charts in Excel
To get the desired chart you have to follow the following steps
Visualizing data using charts in Excel
  • Select the data you want to represent in graph
  • Click on INSERT tab from the ribbon
  • Click on the Column chart drop down button
  • Select the chart type you want
You should be able to see the following chart
Visualizing data using charts in Excel

 

 

Tutorial Exercise

When you select the chart, the ribbon activates the following tab
Visualizing data using charts in Excel
Try to apply the different chart styles, and other options presented in your chart.

Conditional Formatting

As the name suggests, conditional formatting refers to formatting that is only applied when the specified condition is true. Let's say we want to easily fetch the sales figures greater than 30. We can use conditional formatting to highlight all the sales figures that are greater than 30.
Highlight all the sales figures as shown below
Visualizing data using charts in Excel
Click on Conditional Formatting drop-down menu on the HOME tab
Visualizing data using charts in Excel
You will get the following dialogue window when you click on Greater Than…
Visualizing data using charts in Excel
The final result should look as follows
Visualizing data using charts in Excel
If you want to remove the conditional formatting,
  • Click on conditional formatting button
  • Select clear rules
  • Select clear rules from the entire sheet

Summary

Charts are a powerful way of graphically visualizing your data. Excel has many types of charts that you can use depending on your needs.
Conditional formatting is also another power formatting feature of Excel that helps us easily see the data that meets a specified condition
Source: Guru99

Beautiful Manners

 

A person of wisdom and spirituality has very beautiful manners that have grown from genuine respect and love for the whole of humanity.
Manners in this sense have nothing to do with culture or education; it is simply a question of humility.
When we are at the receiving end of such manners, we feel that some deeper part of us has been honoured. In fact none of use deserves anything less.

Today's Inspiration: Character Counts !


Your Age
Does not define your Maturity
Your Experience
Does not define your Wisdom
Your Grades
Does not define your intellect
But
Your Character
Defines your real Personality…

Relationship Tip: Understand your friends and foes

Someone agreeing with you is not always your friend, And someone opposing you is not always your enemy.Many relationships fail because people spend too much time pointing out each other’s mistakes instead of appreciating each other’s uniqueness

Our Qualities are like Ice



 
God has amazing principles of abundance. Any normal human being can get exposed to such principles by exerting positive efforts with pure intention into the right perspective. Extensive scholarly studies conclude that the root level principle of abundance and spirituality is to love and serve the creatures of God. His creatures are not limited to Humans only. A bird in your window, the cat in your house, the stray dogs and every single breathing thing, including trees is creature of God. God multiplies His blessings when someone loves His creatures.

Spirituality is usually taken as a complex, not-easy-to-understand thing whereas in my opinion you are already a spiritual person: 

1- when you do things purely for the sake of God, without any greed.
2- when you serve His creatures without any expectation (money, respect or any other benefit) .
3- when you have a big heart to offer your services whenever and wherever required, no matter big or small.
4- when you want to add value into someone's life.
5- when you want to resolve someone's unhappy situation.

On the contrary, some of us are self-centered people, not concerned about others feelings and needs. We should understand that all the God-given blessings and qualities we have, are ​like ice. While the ice is melting (as the age factor), the coolness of ice should not be limited to ourselves instead our ice should cool down someone's 'hot jug'.
​Our qualities and blessings should be beneficial to other creatures of God.​
​ ​
When we distribute what we have, God multiplies His blessings and adds more! When we surprise others, God surprises us. Needless to mention that God's surprises are far beyond the level of our comprehensions.

The crux of this article is to make a concrete commitment to ourselves to spread small happiness from today and start the great journey towards an awesome blessed life!


Things to do:
I will put genuine efforts in the following domains:
1- serving my family, relatives and friends with the best intention.
​2- adding value to the lives of orphans, widows and poor.
3- expanding my horizon to serve the society with time, money and efforts.
4- Encouraging my fellow beings and bring them to the journey of spiritualism. 
 


 
 
 
 
 

The Cost of Envy


When a colleague outperforms you, a friend has a bustling social life, or when someone has a seemingly perfect relationship, it is easy to turn to resentment.1 Most of the time, we don't admit to these feelings, but the green-eyed monster lurks beneath the surface.
Whether or not we'd like to admit it, we've all felt jealous of someone else in the past.
Competitive and jealous feelings are an adaptive strategy. Humans are naturally inclined to compare to others because it was essential to outperform others in order to survive.2
While it seems natural to become envious or resentful of others, the feeling does more harm than good.

Envy Costs Your Entire Mind

Envy interferes with people's ability to think and act. Instead of working on attaining a high level of success, it focuses a person's energy on what they lack.3 An envious person is blind to their own progress since their only aim is to have what someone else already has. Without benchmarks for their progress, envious individuals quickly lose their motivation altogether.
Those who worry about the final outcomes that others experience don't think about the journey that their competitors had to take to reach that level of success.4 Envious people are blind to their own strengths, and they're unable to see the weaknesses of rivals.
If you spend your whole life envying others because you think they are more efficient, more easily promoted, or better at solving problems, you'll never become better. A person who wastes time worrying about others' successes will not be able to see his or her own potential. Even when the envious person succeeds, he or she will likely still be so focused on the other person that there is little cause for celebration. The vicious cycle continues, and the envious individual never feels satisfied.
The reality is that there will always be someone smarter, better, or stronger. Enviousness condemns people to lead lives in which they constantly hope to have more. The green-eyed monster can never be satisfied. Intrinsic motivation for success yields better outcomes than resentment of others' accomplishments.

Cut the Chord and Stop Depending on Envy

I understand that even the most altruistic and optimistic among us may be tempted to envy others from time to time. When I face envy, I revisit my purpose and desire to succeed. I find motivation through grounding myself in my vision.
When I first started Lifehack, it was a struggle. This was during a time when the web was becoming exponentially popular each day, and lots of new companies were popping up everywhere to fill in the space.  During that time I heard about a startup close by that quickly grew to fill a huge office. Their building had four floors, a fancy layout, a big canteen, and a rec room with a pool and a dartboard. Almost immediately I thought, "Wow! That sounds cool. I wish I could have those things too. It must be nice." I was impressed, but started to have that uncomfortable feeling comparing myself to this suddenly successful startup.
 
I could have allowed this feeling to fester, but instead I turned inward to remember what was important to me. I reminded myself that I am most interested in creating an environment that boosts productivity. Anything that doesn't increase productivity is superfluous, and could actually create distractions.
 
Then, I thought about the goals of my work. I want to create a product that has a positive influence on others. It doesn't matter whether my office space seems cool. What is truly important is how the work that we do in these offices can change lives.
 
My team doesn't need all those bells and whistles to create a fun work environment. My team members are fun and creative all on their own. If I spent all my time worrying about how big their offices were, I'd be upset with myself for not being able to offer them what that other startup has. I'd be too busy worrying about my feelings of guilt to push my mission forward.

When I focus on my aspirations and work to improve myself, it brings me closer to achieving my mission. Knowing what I really want is the best motivation, and it wards off envy better than vain attempts to have what everyone else has. There's just no reason for me to envy what others have because those things don't align with my vision for this company.
 
Freeing myself from the control of envy has liberated me from unrealistic and counter-productive desires. I can see the progress I've made as well as the areas in which I'd like to grow, and I allow my work to stand on its own merit instead of constantly comparing it to the work of others.
 
Not only is freeing oneself of envy critical for staying focused on what is important, it also makes life much more pleasant. Being able to applaud another person's success without having a negative reaction has led to more opportunities and partnerships than if that success had created an adversarial relationship.
When you start to covet the success of others, realign yourself with your vision, and recognize that we are all on a journey to become the greatest versions of ourselves.
 

Wisdom: Understanding Life

To understand life better, you have to go to 3 locations :

1. Hospital
2. Prison
3. Cemetery


🏥 At the Hospital, you will understand that nothing is more beautiful than HEALTH.
🔐 In the Prison, you'll see that FREEDOM is the most precious thing.
💐 At the Cemetery, you will realize that life is worth nothing. The ground that we walk today will be our roof tomorrow.


The truth is that we all come with *nothing* and we will go with *nothing* ... Let us, therefore, remain humble and be grateful to God at all times for everything.

Great Professional Tips for Your Office & Business


 
ü        Keep track of what you do; someone is sure to ask.
ü        Be comfortable around senior managers, or learn to fake it.
ü        Never bring your boss a problem without some solution.
ü        You are getting paid to think, not to whine.
ü        Long hours don't mean anything; results count, not effort.
ü        Write down ideas; they get lost, like good pens.
ü        Always arrive at work 30 minutes before your boss.
ü        Help other people network for jobs. You never know when your turn will come.
ü        Don't take days off sick unless you are.
ü        Assume no one can / will keep a secret.
ü        Know when you do your best morning, night, under pressure, relaxed; schedule and prioritize your work accordingly.
ü        Treat everyone who works in the organization with respect and dignity, whether it be the cleaner or the managing director. Don't ever be patronizing.
ü        Never appear stressed in front of a client, a customer or your boss. Take a deep breath and ask yourself: In the course of human events, how important is this?
ü        If you get the entrepreneurial urge, visit someone who has his own business. It may cure you.
ü        Acknowledging someone else's contribution will repay you doubly.
ü        Career planning is an oxymoron. The most exciting opportunities tend to be unplanned.
ü        Always choose to do what you'll remember ten years from now.
ü        The size of your office is not as important as the size of your pay cheque.
ü        Understand what finished work looks like and deliver your work only when it is finished.
ü        The person who spends all of his or her time is not hard-working; he or she is boring.
ü        Know how to write business letters including thank-you notes as well as proposals.
ü        Never confuse a memo with reality. Most memos from the top are political fantasy.
ü        Eliminate guilt. Don't fiddle expenses, taxes or benefits, and don't cheat colleagues.
ü        Reorganizations mean that someone will lose his or her job. Get on the committee that will make the recommendations.
ü        Job security does not exist.
ü        Always have an answer to the question, What would I do if I lost my job tomorrow
ü        Avoid working at weekends. Work longer during the week if you have to. 
ü        The most successful people in business are interesting.
ü        Sometimes you'll be on a winning streak and everything will click; take maximum advantage. When the opposite is true, hold steady and wait it out.
ü        Never in your life say, Its not my job
ü        Be loyal to your career, your interests and yourself.
ü        Understand the skills and abilities that set you apart. Use them whenever you have an opportunity.
ü        People remember the end of the project. As they say in boxing, Always finish stronger than you start.