Sunday, 27 December 2015

[HM:258276] 10 Excel Data Entry Tips for Extreme Productivity

Excel is an amazing tool with fascinating capabilities to analyze data (be it using formulas, charts or dashboards). The ease with which data can be entered and stored in Excel makes it a compelling choice.

In this blog post, I have listed 10 useful Excel Data Entry tips that will make you more efficient and save a lot of time.

#1 Use Excel Data Entry Form

Excel Data Entry form enables you to add records in an existing data set. It gives a pop-up form that can be filled by the user. It is especially convenient when the data set has many columns and would require you to scroll right and left again and again as you key in data points.

Data Form feature is not already available in Excel ribbon. We first need to make it available by adding it to the Quick Access toolbar.

Adding Excel Data Entry Form to Quick Access Toolbar

Go to Quick Access Toolbar, right-click and select Customize quick Access Toolbar
In the Excel Options Dialogue box, Select All Commands and Go to Form. Select Form and press Add. This will add the Data Forms Icon to the Quick Access Toolbar.

Using Excel Data Entry Form

Select any cell in the data range and click on the Data Form icon from the Quick Access Toolbar.
In the Pop-up Data form, all the column titles are listed vertically. Fill the data to the adjacent text box for each heading.
Once you have entered the data, press Enter
Click on New to add new record

Using Excel Data Entry form, you can also navigate through the existing data (row by row), or find data by specifying the criteria (try this by clicking on the criteria button)

#2 Quickly Enter Numbers with Fixed Decimal Numbers

If you are in a situation where you have to manually enter data in excel that also has a decimal part to it, this trick could be mighty useful. For example, suppose you have to enter marks for students in percentage with up to 2 decimal points. You can enable a feature where you just type the numbers without bothering about hitting the dot key every time. To enable this:

Go To File –> Options
In the Excel Options Dialogue box select Advanced
In Advanced Options, check the option "Automatically Insert a decimal point"
Specify the number of decimals you want (for example 2 in this case)

Now, whenever you enter any number, excel automatically places last 2 digits after the decimal. So 1 becomes .01, 10 becomes 0.1, 100 becomes 1, 2467 becomes 24.67 and so on..

Excel Data Entry - Add Decimal Automatically

Once you are done with data entry, simply switch it off by un-checking the same option.

#3 Automatically Add Ordinal to Numbers

Yes, you can use a combination of excel functions (such as VALUE, RIGHT, IF, OR) to add ordinals ('st' in 1st, 'nd' in 2nd, and so on..).

Here is the formula:

=A1&IF(OR(VALUE(RIGHT(A1,2))={11,12,13}),"th",IF(OR(VALUE(RIGHT(A1))={1,2,3}),CHOOSE(RIGHT(A1),"st","nd","rd"),"th"))

#4 Fill Down Using Control + D

This is a nifty Excel Data Entry trick. If you have to copy the above cell, just press Control + D. It copies the content as well as the formatting. If there is a formula in the above cell, the formula is copied (with adjusted references).

This works for more than one cell as well. So if you want to copy the entire row above, select the current row and press Control + D.

If you select more than one cell/cells, than the cell above selection is copied in all the cells.

#5 Quickly Enter Date/Time in Excel Cells

Do not remember the current date? Don't worry, just press Control + ; (semi-colon Key) and it will enter the current date in the cell.

Similarly, you can enter current time by using the shortcut Control + Shift + : (colon key)

Remember, these are absolute values, and won't change if the date or time changes. If you want to have dynamic date and time value that changes whenever you opne the workbook or when there is a re-calculaiton, use TODAY and NOW functions.

#6 Control + Enter to Fill Entire Selection with Content in Active Cell

When you select multiple cells in Excel, one of the cells with light shade (as compared with the remaining selected cells) is the active cell. If you enter something in the active cell when the selection is made and press Control + Enter, the value is inserted in all the selected cells.

This holds true for formulas as well. If you enter formula in active cell and press Control + Enter, all the cells will get that formulas (with adjusted references).

#7 Alt + Down Arrow to Get a List of All Unique Values in that column

This one can save some time that you might otherwise waste in typing. Suppose you are entering data in a column with activity status (To be Done, Completed). Instead of typing the status again and again, you just need to type it in a couple of cells, and then you can use the keyboard shortcut Alt + Down arrow. It gives you the list all the unique entries, and you can quickly select from the list.

Excel Data Entry - Alt Down Arrow

If you want to select from pre-specified options, create a drop down list using data validation.

#8 Quickly Sift through Multiple Worksheet Tabs in a Workbook

This one saves tons of time. Simply use the keyboard shortcut Control + Page Up/Page Down to navigate through multiple worksheet tabs in a workbook.

#9 Enter Long Text by Using Abbreviations

If you have to enter long names or keywords again and again in your worksheet, this trick would come in handy.

For example, you may want that whenever you type ABC, Excel should automatically replace it with ABC Technology Corporation Limited. Something as shown below:

Excel Complete Abbreviations - Excel Data Entry

This feature can be enabled using the autocorrect options. Read how to enable it.

#10 Enter Data in Non-Contiguous Ranges

Suppose you have a template as shown below, and you have to enter data in all the cells highlighted in red, in the order specified by the arrows.

Here is a quick way to do this:

Select all the cells where you need to enter the data (press control and then select one by one).
- Start with the second cell in your sequence of data entry (start with D3). Select the first cell B3 (where data entry begins) at last.
Once selected, go to Name Box (which is on the left of the formula bar).
Type any name without spaces.
That's It!! Select the Named Range by clicking the Name Box drop down. Now start entering your data and use Enter/Tab to jump to the next cell.

Related Excel Productivity Tips:

http://trumpexcel.com/2014/08/excel-data-entry-tips/

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/

https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[HM:258275] What is SPIN Selling Technique

Why Questions Matter in Selling – A Synopsis of SPIN Selling

Posted by Richard Young on February 11, 2014 in Sales Strategies | 46,486 Views

SPIN Selling by Neil Rackman is a hugely influential book that argues the importance of asking the right questions in the sales conversation.

10 Second Summary

Customers will only be motivated to buy something if they identify there's a need. And because there are times when prospects are not even aware there's a problem, the questions you ask are key. This book describes a powerful sales process that reveals four types of questions that when asked in sequence, will significantly increase the likelihood of a lead translating into a sale.

Key Reason You Should Read SPIN Selling

Lots of businesses struggle to close enough deals because their selling strategy and sales techniques are not customer-centric. Instead of understanding the buyer, and presenting a solution from a buyer's perspective, too much emphasis is placed on the features and detail of the product/service that's being sold and the credentials of the business itself.
SPIN Selling describes a sales tool that will enable sales teams to instantly become more customer-centric by revealing the questions that need to be asked to build rapport, credibility and pave the way for a sale.

Rapid Fire Overview of Key Sales Lessons Discussed

SPIN Selling is an acronym of four different types of sales questions that can take a disinterested prospect to someone who's motivated to buy. These questions are:

SITUATION questions
PROBLEM questions
IMPLICATION questions
NEED-PAYOFF questions

The SPIN Selling process was developed following the careful observation of 35,000 sales calls carried out by experienced, professional sales experts. From the observations, it became clear that the quality of questions asked by a salesperson were key to whether or not a sale was closed. For example, the right questions could speed up the process, whereas the wrong questions could stall it or even halt it completely.

The resulting SPIN Selling process and sales techniques laid out a sequence of questioning types, designed to build the rapport and understanding needed to increase closure rates.

Let's look at these four question types in turn:

#1: Situation Questions

Situation questions form the starting point for your conversation.

By asking situation type questions, sales reps can develop an understanding of context. In turn, this background information can be used to guide the conversation in an appropriate way.

The key to succeeding with situation questions is to do research IN ADVANCE of the conversation, so you can avoid boring prospects with questions where the answers are common knowledge.

Examples:

How do you currently manage your customer's contact details?
How do you keep track of what's happening in your sales pipeline?
How do you maintain an overview of how your individual sales reps are performing?

#2: Problem Questions

If you can get a customer to acknowledge there's a problem that needs to be fixed, they're far more likely to give you the attention you need to close a deal.

Problem questions achieve just that, by probing to discover what's causing your prospect pain.

In addition, problem questions are highly effective at encouraging a prospect to identify an issue that's been overlooked.

Examples:

Was the amount of training you needed to get up and running with your CRM ever a problem?
Do you find it's expensive adding new users to your CRM?
What's the biggest problem you're facing so far when managing your sales pipeline?

#3: Implication Questions

The purpose of this third set of questions is to make the customer eager for a solution to the problem(s) they've just identified.

Smart, implication questions will make the customer identify (for themselves) the effect, consequences and impact of that problem going unchecked. In short, in order to encourage a prospect to consider your solution in any seriousness, they need to have a firm grasp on how serious the problem is.

Examples:

If leads don't get inputted onto your CRM system, what's the impact on your sales outlook?
If training on your CRM is costly and time-consuming, what does that mean for new reps when they start?
If you can't accurately see your performance to date, how much response time do you have to implement a fix if you anticipate your sales are falling short of target?

#4: Need-payoff Questions

The final stage of SPIN Selling, is to encourage a prospect to consider how valuable a solution to the problem they've identified, would be. The secret to getting results with need-payoff questions is to ensure the buyer specifies the benefits themselves. So encourage them to visualise and imagine what would be different with that problem gone. That way, your customer will be able to place a value on what you have to offer.

The beauty of these questions is that if you get them right, your customer will tell you how your product will help.

Need-payoff questions need to evoke positive emotions. After all, it feels good to know that a pressing problem can finally be solved. In addition, aim to reduce objections to an eventual purchase, as well as encouraging the customer to start to think about committing to the solution you have on offer.

Examples:

Why is being able to have a big picture overview of your sales pipeline important to you?
If you could cut the amount of time spent training new staff on your CRM, what impact would that have?
If you could see at a glance which opportunities you have in your pipeline, how would that help you achieve your sales targets?

Suggestions as to How You Can Apply These Insights to Your Sales Techniques

The beauty of SPIN Selling is that it's a highly practical (and proven) sales Enablement tool that's easy to implement.

An easy way to get started is to brainstorm a list of questions for each of the stages that would be relevant to your business – and then explore these with prospects during your next call.

How much thought and preparation do you give to the questions you ask during your sales discussions? Could your technique improve by structuring your pitches into these four distinct stages? Please share your thoughts below.

Source: http://blog.pipelinersales.com

Thursday, 24 December 2015

[HM:258274] Do You Have a Manager’s Mindset?

Julie Long, a senior developer at a software company, was identified by her manager as a high performer. When she was asked to coordinate a team of three junior developers on a project, Julie was excited about the opportunity to finally move into a management role.

However she quickly became frustrated. Things that were simple and easy for her were not getting done in a timely way by her team. After just a few weeks in her new role, as she reviewed the code her team members had written, she found herself seriously considering scrapping their contributions and writing it all herself. She knew that if she worked a few extra hours, she could likely match the output of all three of her direct reports.

This scenario is all too common when an individual is asked to make the leap from expert to manager. It's especially common when someone is asked to lead a team of their recent peers. But jumping into the weeds and trying to do everything, even if it works initially, is not a sustainable strategy. Ultimately a manager needs to focus on becoming a successful teacher and mentor in order to help their people develop and grow, and to increase the overall capacity of the team.

But this requires a dramatic change in mindset, and it's this process that is so difficult for many of the recently promoted. Because coaching and coordinating others is not how you spent your days as an individual contributor, it can be hard to discard old habits. Start by tracking the improvement of your direct reports from where they are rather than comparing their output and capabilities to your own. If you assess people individually, their talents will emerge—and their progress will become a measure of your own success.

Here are some other things to keep in mind as you work on shifting your mind-set. Some of these suggestions may seem obvious, but the fundamentals have a way of flying out the window when new responsibilities pile up and the pressure's on

Take the Long View

While individual contributors keep their heads down and focus on getting work done, managers needs to be looking further ahead. Good managers spend much of their time anticipating challenges, negotiating political situations, and creating a road map that pulls together what each team member is working on independently. You also need to think beyond what will happen in the ideal scenario and plan for contingencies.
Seeing the bigger picture involves doing two things well.

First, you should have a solid understanding of the needs and goals of your department, as well as the entire organization. This clarity about the ecosystem in which your team operates will help you anticipate your manager's expectations. Second, you need to understand the capabilities of the individuals on your team. Recognizing your team's capacity will give you the ability to better forecast when your team will be stretched or when it will experience bottlenecks, and to set expectations accordingly.

Ask More Questions

When one of your team members is struggling, it can be tempting to just hand out answers (or do the work yourself, like Julie). After all, you probably know what needs to be done, and quickly providing the solution will get you back to your own work faster. But if you get into the habit of being the answer dispenser, you don't give people the chance to figure it out for themselves.
Asking questions ca

n be a great way to help a team member work through a problem. Have them describe what's frustrating – put it up on a whiteboard if you can – and then talk through all the angles. In many cases a solution will become obvious just through the act of describing the problem. But if it doesn't, your questions can be instrumental in helping your employee look at the obstacle in a new way or uncover alternative possibilities.

Focus on What and When

As an individual contributor, you were rewarded for perfecting the "how" of getting your work done. You might have great ideas about what makes you more productive and allows you to do your best work. But what works for you might not work for others, and further, others might come up with new ideas or techniques that you haven't considered. It's always best when setting goals with your team to focus on what the deliverables are, and when they need to be complete, but to leave the details of how that gets done up to each person.
The exception, of course, is when someone asks for help, or if you observe a team member struggling. At that point you can look at how they are going about the task. But even in these cases you should approach the situation with an open mind, and not simply dictate what should be done.
Another reason to focus on the goals and not the process is to avoid micromanaging. No one enjoys having their manager hang over their shoulder and tell them how to do their job. It's a quick way to frustrate your team, and it won't make the work go any faster.

Trust Your Gut

Stepping into a new role can throw you off balance. You are working hard to learn new ways of thinking and behaving and it can make you feel like you're wrong a lot of the time. But your instincts are still valuable. If you feel like a project is going off the rails, don't wait until it's too late to respond. You may be figuring out how to be a good leader, but your sense of whether the work is being done and done right is likely on target—especially if it's work that you've done yourself in the past.
Many new managers delay confronting a team member who is missing deadlines or struggling in some way because they doubt their instincts or aren't sure how to address the problem productively. But rather than waiting until the situation grows worse, sit down and have a conversation. Make sure you're aware of how people are doing, and check in with them regularly. When you feel like something is off, it probably is.

Be Patient

Shifting your mind-set from the day-to-day responsibilities of an individual contributor to the broader view of a manager and leader takes time. Don't expect these skills to evolve overnight, and don't be discouraged if you have some setbacks as you try to strike a balance between getting things done and coaching your team. Most of us aren't natural-born managers. The mind-set of a manager can be learned and honed with practice.
When times get tough (as they're bound to do) or you're feeling overwhelmed by your new role, pause and ask yourself:

Am I seeing my direct reports' strengths and weaknesses clearly, or comparing them to mine?
Am I taking the long view, anticipating capabilities, challenges, and expectations?
Am I asking questions more often than dispensing answers?
Am I setting clear deadlines and deliverables, but leaving the "how" up to my team?
Am I second-guessing my instincts? (Don't.)
Am I being patient with my own development as a manager?

Katy Tynan is an expert on the future of work. She is the author of the new book Free Agent: The Independent Professional's Guide to Self-Employment Success, from Productivity Press. Katy is a consultant and a founding partner of MindBridge Partners. Follow her on Twitter @KatyTynan.

hbr.org

Junaid Tahir
www.DailyTenMinutes.com

Wednesday, 23 December 2015

[HM:258273] 5 Steps to Develop Your Personality

Description: Change your understanding of the world with our easy tips

Photo: meandnaika / carianoff

Everything is changing, growing and developing. It means that our society also requires some changes. People are willing to do whatever they want and live how they want. Read our five self development tips and apply them in our own life to make it better.

Tip#1 Accept yourself

It is completely up to you to decide when it is time to change your life. Gather all your strength and do it tomorrow, take personal responsibility for all your acts. There is nobody who can do it instead of you. Your decisions today determine your future life.

Tip#2 Visualization is the best

One of the best ways to make your dreams come true is to make a picture of them inside your head. You can even find some similar photos in Internet and print them. Put photos in some place, where you can see them every day. They will help you to focus and visualize your goals.

Tip#3 Learn from errors

Learning from the errors is the best way to get success. Of course it is much better to learn from others mistakes, but in real life we all prefer to experience everything on a first hand. No matter whether it is a good thing or bad.

Tip#4 Challenge yourself

Only fool knows everything. It is an old, but very true to life proverb. Make yourself to learn something new every day. Find something interesting in your old, typical things and stuff.

Tip#5 Think positively

You mind should be full of positive thoughts and ideas. Let your surrounding inspire you to act. It will leave no room for negative thoughts. Only in this case you will succeed in your aims and commitments.

Follow these five simple steps and you will be able to change your life. To balance your inner and outer world, you can visit fifthave and become a perfection.

[HM:258272] Creating Positive Energy In the Home

A home that pulses with positive energy is a joy to live in. But what are the tricks to designing a space that attracts good vibes and repels negativity? Here are some easy and simple steps you can take that accentuate the positive at home.

Design details

Rooms that have flow, natural light and space are more likely to buzz with positive energy. If your home is cluttered, edit some of the stuff you don't need from your life. This goes for furnishings as well as clothing and other possessions – if you haven't used it in a year, do you really need to keep it? Rooms overflowing with furniture stifle positivity, so select your favorite essentials, then donate the rest to a good cause. Removing clutter is one of the chief principles of the ancient art of feng shui. Discarding excess material possessions and clutter is believed to allow positive energy to circulate more freely about the home, encouraging peace and serenity within.

Happy colors

Mood and ambience is hugely influenced by the colors we choose in our home décor. Dark, heavily pigmented paint shades suck the light from a room, shrinking the dimensions and giving a somber mood. To invite positive influences, choose colors that reflect the light, warm shades that lift the atmosphere and reference the natural world. Soft yellow and orange tones, merged with greens and creams that have a luminous quality, will all add fizz and freshness to rooms.

The power of light

Sunshine boosts positive energy levels, making you feel happier. Direct natural light into your home and improve your sense of well being in a subtle but measurable way. Light and airy rooms feel more spacious, are uplifting and inspiring to spend time in, and they also stimulate us into action and movement, rather than sedentary behavior. Design rooms in such a way that light has easy access from outside, keeping window treatments to a minimum and making sure trees and bushes do not block out the sun. Installing elegant and streamlined interior shutters for greater control makes a noticeable difference, because you can manage the natural light levels throughout the day, according to mood.

To further lift light levels, carefully placed mirrors can be used to reflect it back into the room, doubling up the energy levels. Light up dark corners and alcoves with mirrors and lamps, and fit a crystal chandelier for extra sparkle and movement.

Natural appeal

Feng shui fans recommend jade plants and interior water fountains to add positive power to the domestic interior. Just as good are freshly cut blooms placed so that their perfume and quiet beauty can dissipate into the atmosphere. Alternatively, spread the scents of frankincense and cinnamon essential oils, which neutralize negative energies, or rose and orange oils, which are aligned to love and joy in particular. Add several drops into a spritzer containing water, and with a few sprays, the mood of a room is transformed.

A house with positive energy levels directly impacts the occupants and how they feel. Banish dark moods and replace them with outward looking, positive thinking that works on every level. A great place to start making changes is in your close environment, so take a fresh look at your home and start taking some positive, energizing steps.

Friday, 18 December 2015

Re: [HM:258269] Re: WhatsApp group

Pls. add me

My number is 00966548493880

Regards,

Imran Ahmed

Sent from my iPhone

On 16-Oct-2015, at 7:50 pm, Mohan Bisht <mohan.it88@gmail.com> wrote:

Bhai pls add me my no. Is 9716646322 pls pls

On Oct 9, 2015 5:02 PM, "h h. bhate" <hh.bhate@licindia.com> wrote:
9890003633
________________________________________
From: hyd-masti@googlegroups.com [hyd-masti@googlegroups.com] On Behalf Of naveed shaikh [nvdshaikh306@gmail.com]
Sent: Friday, October 09, 2015 12:47 PM
To: hyd-masti@googlegroups.com
Subject: Re: [HM:258147] Re: WhatsApp group

Send your number to me so that i can easily add u guys.

Wapp +91 7385904171

Thank you.
Naveed shaikh

GRAPHICSDesigner
The Creative Design

Operation Department
Khandesh central Mall
Nehru Chowk Jalgaon,
Cell : 91 7385904171
Web: www.cetl.in<http://www.cetl.in>

On Wed, Oct 7, 2015 at 11:34 PM, Siddiqullah Shekib <siddiqullahshkb6@gmail.com<mailto:siddiqullahshkb6@gmail.com>> wrote:
Please add me too
0092-315-508-6188
Thanks

On Wed, Oct 7, 2015 at 11:43 AM, Naresh Kumar <nareshgampala@gmail.com<mailto:nareshgampala@gmail.com>> wrote:
Please add me to whats app group...
My Number: 9989063885

On Tue, Oct 6, 2015 at 5:55 PM, Syed Qutubuddin ASadi
<contact@syedqutubuddin.in<mailto:contact@syedqutubuddin.in>> wrote:
> Please add me to whats app group...
> My Number: 9700784465
>
>
> On 10/6/2015 12:31 PM, Mohan Bisht wrote:
>
> Please admin ji,, Add me my no. has been change my new no. is 9716646322<tel:9716646322>
> ppls pls pls pls pls
>
> On Fri, Aug 21, 2015 at 9:39 PM, Muzammil Hussain <mh13367@gmail.com<mailto:mh13367@gmail.com>> wrote:
>>
>> Dear admin ji Pls. Add my No. 7303089232(Muzammil hussain)
>>
>> On 7 Jul 2015 12:46, "Musthaq" <musthaq.mus@gmail.com<mailto:musthaq.mus@gmail.com>> wrote:
>>>
>>> Mohamed fazahim - Your mobile number is wrong
>>>
>>> On Tue, Jul 7, 2015 at 12:29 PM, Mohamed Fazahim <fazahim293@gmail.com<mailto:fazahim293@gmail.com>>
>>> wrote:
>>>>
>>>> Please add me also +94777330293<tel:%2B94777330293>
>>>>
>>>> On 23 May 2015 23:10, "Sree" <snookala786@gmail.com<mailto:snookala786@gmail.com>> wrote:
>>>>>
>>>>> Add my number +91-8886980789<tel:%2B91-8886980789> to WhatsApp group. Thanks Sree
>>>>>
>>>>>
>>>>> On Tuesday, May 5, 2015 at 5:46:02 PM UTC+5:30, Manimaran Chellam
>>>>> wrote:
>>>>>>
>>>>>> Add my number also in WhatsApp group. My no is +919894259846<tel:%2B919894259846>.
>>>>>>
>>>>>> Regards,
>>>>>> C.Manimaran
>>>>>> Madurai - 625104.
>>>>>
>>>>> --
>>>>> --
>>>>> We are also on Face Book, Click on Like to jois us
>>>>> FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
>>>>> FB Group: https://www.facebook.com/groups/hydmasti/
>>>>>
>>>>> https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
>>>>>
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "Hyderabad Masti" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti%2Bunsubscribe@googlegroups.com>.
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>> --
>>>> --
>>>> We are also on Face Book, Click on Like to jois us
>>>> FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
>>>> FB Group: https://www.facebook.com/groups/hydmasti/
>>>>
>>>> https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
>>>>
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Hyderabad Masti" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti%2Bunsubscribe@googlegroups.com>.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>> --
>>> --
>>> We are also on Face Book, Click on Like to jois us
>>> FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
>>> FB Group: https://www.facebook.com/groups/hydmasti/
>>>
>>> https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
>>>
>>> ---
>>> You received this message because you are subscribed to the Google Groups
>>> "Hyderabad Masti" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an
>>> email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti%2Bunsubscribe@googlegroups.com>.
>>> For more options, visit https://groups.google.com/d/optout.
>>
>> --
>> --
>> We are also on Face Book, Click on Like to jois us
>> FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
>> FB Group: https://www.facebook.com/groups/hydmasti/
>>
>> https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "Hyderabad Masti" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti%2Bunsubscribe@googlegroups.com>.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> --
> We are also on Face Book, Click on Like to jois us
> FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
> FB Group: https://www.facebook.com/groups/hydmasti/
>
> https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
>
> ---
> You received this message because you are subscribed to the Google Groups
> "Hyderabad Masti" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti%2Bunsubscribe@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> --
> We are also on Face Book, Click on Like to jois us
> FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
> FB Group: https://www.facebook.com/groups/hydmasti/
>
> https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
>
> ---
> You received this message because you are subscribed to the Google Groups
> "Hyderabad Masti" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti%2Bunsubscribe@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/

https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti%2Bunsubscribe@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
Yours In Diplomacy,

Siddiqullah Shekib

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/

https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti+unsubscribe@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/

https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com<mailto:hyd-masti+unsubscribe@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
"The information contained in this electronic message and any attachments to this message are intended for exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at LIC OF INDIA or co_mailadmin@licindia.com immediately and
destroy all copies of this message and any attachments. The views expressed in this E-mail message / Attachments, are those of the individual sender."

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/

https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/

https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ

---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Wednesday, 16 December 2015

[HM:258268] Technology: What is Virtual Private Network

A virtual private network (VPN) is a technology that creates an encrypted connection over a less secure network. The benefit of using a VPN is that it ensures the appropriate level of security to the connected systems when the underlying network infrastructure alone cannot provide it. The justification for using a VPN instead of a private network usually boils down to cost and feasibility: It is either not feasible to have a private network (e.g., for a traveling sales rep) or it is too costly to do so. The most common types of VPNs are remote-access VPNs and site-to-site VPNs.

A remote-access VPN uses a public telecommunication infrastructure like the Internet to provide remote users secure access to their organization's network. A VPN client on the remote user's computer or mobile device connects to a VPN gateway on the organization's network, which typically requires the device to authenticate its identity, then creates a network link back to the device that allows it to reach internal network resources (e.g., file servers, printers, intranets) as though it was on that network locally. A remote-access VPN usually relies on either IPsec or SSL to secure the connection, although SSL VPNs are often focused on supplying secure access to a single application rather than to the whole internal network. Some VPNs provide Layer 2 access to the target network; these require a tunneling protocol like PPTP or L2TP running across the base IPsec connection.

A site-to-site VPN uses a gateway device to connect the entire network in one location to the network in another, usually a small branch connecting to a data center. End-node devices in the remote location do not need VPN clients because the gateway handles the connection. Most site-to-site VPNs connecting over the Internet use IPsec. It is also common to use carrier MPLS clouds rather than the public Internet as the transport for site VPNs. Here, too, it is possible to have either Layer 3 connectivity (MPLS IP VPN) or Layer 2 (Virtual Private LAN Service, or VPLS) running across the base transport.

VPNs can also be defined between specific computers, typically servers in separate data centers, when security requirements for their exchanges exceed what the enterprise network can deliver. Increasingly, enterprises also use VPNs in either remote-access mode or site-to-site mode to connect (or connect to) resources in a public infrastructure as a service environment. Newer hybrid-access scenarios put the VPN gateway itself in the cloud, with a secure link from the cloud service provider into the internal network.

Source: searchenterprisewan

Junaid Tahir
www.DailyTenMinutes.com