https://flavorsrecipes.blogspot.com/?m=1 be more attractive

mardi 30 août 2016

How to Find Duplicates in Excel

When working with a Microsoft Excel spreadsheet with lots of data, you'll probably encounter duplicate entries. Microsoft Excel's Conditional Formatting feature shows you exactly where duplicates are, while the Remove Duplicates feature will delete them for you. Viewing and deleting duplicates ensures that your data and presentation are as accurate as possible.

EditSteps

EditUsing Conditional Formatting

  1. Open your original file. The first thing you'll need to do is select all data you wish to examine for duplicates.
    Find Duplicates in Excel Step 1 Version 7.jpg
  2. Click the cell in the upper left-hand corner of your data group. This begins the selecting process.
    Find Duplicates in Excel Step 2 Version 7.jpg
  3. Hold down the key and click the final cell. Note that the final cell should be in the lower right-hand corner of your data group. This will select all of your data.
    Find Duplicates in Excel Step 3 Version 7.jpg
    • You can do this in any order (e.g., click the lower right-hand box first, then highlight from there).
  4. Click on "Conditional Formatting." It can be found in the "Home" tab/ribbon of the toolbar (in many cases, under the "Styles" section).[1] Clicking it will prompt a drop-down menu.
    Find Duplicates in Excel Step 5 Version 7.jpg
  5. Select "Highlight Cells Rules," then "Duplicate Values." Make sure your data is still highlighted when you do this. This will open a window with customization options in another drop-down menu.[2]
    Find Duplicates in Excel Step 6 Version 7.jpg
  6. Select "Duplicate Values" from the drop-down menu.
    Find Duplicates in Excel Step 7 Version 6.jpg
    • If you instead wish to display all unique values, you can select "Unique" instead.
  7. Choose your highlight color. The highlight color will designate duplicates. The default is light red with dark red text.[3]
    Find Duplicates in Excel Step 8 Version 7.jpg
  8. Click "OK" to view your results.
    Find Duplicates in Excel Step 9 Version 7.jpg
  9. Select a duplicate's box and press to delete it. You won't want to delete these values if each piece of data represents something (e.g., a survey).
    Find Duplicates in Excel Step 10 Version 7.jpg
    • Once you delete a one-time duplicate, its partner value will lose its highlight.
  10. Click on "Conditional Formatting" again. Whether you deleted your duplicates or not, you should remove the highlight formatting before exiting the document.
    Find Duplicates in Excel Step 11 Version 7.jpg
  11. Select "Clear Rules," then "Clear Rules from Entire Sheet" to clear formatting. This will remove the highlighting around any duplicates you didn't delete.[4]
    Find Duplicates in Excel Step 12 Version 7.jpg
    • If you have multiple sections of your spreadsheet formatted, you can select a specific area and click "Clear Rules from Selected Cells" to remove their highlighting.
  12. Save your document's changes. If you're satisfied with your revisions, you have successfully found and deleted duplicates in Excel!
    Find Duplicates in Excel Step 13 Version 6.jpg

EditUsing Excel's Remove Duplicates Feature

  1. Open your original file. The first thing you'll need to do is select all data you wish to examine for duplicates.
    Find Duplicates in Excel Step 14 Version 6.jpg
  2. Click the cell in the upper left-hand corner of your data group. This begins the selecting process.
    Find Duplicates in Excel Step 15 Version 6.jpg
  3. Hold down the key and click the final cell. The final cell is in the lower right-hand corner of your data group. This will select all of your data.
    Find Duplicates in Excel Step 16 Version 6.jpg
    • You can do this in any order (e.g., click the lower right-hand box first, then highlight from there).
  4. Click on the "Data" tab in the top section of the screen.
    Find Duplicates in Excel Step 17 Version 6.jpg
  5. Find the "Data Tools" section of the toolbar. This section includes tools to manipulate your selected data, including the "Remove Duplicates" feature.
    Find Duplicates in Excel Step 18 Version 6.jpg
  6. Click "Remove Duplicates." This will bring up a customization window.
    Find Duplicates in Excel Step 19 Version 6.jpg
  7. Click "Select All." This will verify all of your columns have been selected.[5]
    Find Duplicates in Excel Step 20 Version 6.jpg
  8. Check any columns you wish to use this tool on. The default setting has all columns checked.
    Find Duplicates in Excel Step 21 Version 6.jpg
  9. Click the "My data has headers" option, if applicable. This will prompt the program to label the first entry in each column as a header, leaving them out of the deletion process.
    Find Duplicates in Excel Step 22 Version 5.jpg
  10. Click "OK" to remove duplicates. When you are satisfied with your options, click "OK". This will automatically remove any duplicate values from your selection.
    Find Duplicates in Excel Step 23 Version 5.jpg
    • If the program tells you that there aren't any duplicates--especially if you know there are--try placing a check next to individual columns in the "Remove Duplicates" window. Scanning each column one at a time will resolve any errors here.
  11. Save your document's changes. If you're satisfied with your revisions, you have successfully deleted duplicates in Excel!
    Find Duplicates in Excel Step 24 Version 5.jpg

EditTips

  • You can also identify duplicate values by installing a third-party add-in utility. Some of these utilities enhance Excel's conditional formatting feature to enable you to use multiple colors to identify duplicate values.
  • Deleting your duplicates comes in handy when reviewing attendance lists, address directories, or similar documents.

EditWarnings

  • Always save your work when you're done!

EditRelated wikiHows

EditSources and Citations


Cite error: <ref> tags exist, but no <references/> tag was found




source How to of the Day http://ift.tt/1kp0vuC

How to Reduce Your Carbohydrate Intake

People may choose to reduce carbohydrate intake for a number of reasons. Those who suffer from type 2 diabetes should strive to balance the need for taking in enough carbohydrates to produce energy while limiting carbohydrate consumption to regulate blood sugar levels. Still others seek to control carbohydrate intake as a way of following a balanced diet that includes healthier foods. Whatever the reason, several strategies can be used to make sure the carbohydrate reduction produces the desired results without leading to a loss of essential nutrients.

EditSteps

EditReducing Your Carb Intake

  1. Learn what foods include carbohydrates. Carbohydrates come in multiple varieties, but when it comes to diet, most people are concerned with processed (simple) versus naturally occurring (complex) carbs. You will find naturally occurring carbs in grains, fruits, vegetables, milk, nuts, seeds, and legumes.[1] These complex carbohydrates resist digestion more than simple, refined carbohydrates such as those found in flour and sugar.[2]
    Reduce Your Carbohydrate Intake Step 1 Version 2.jpg
    • Sources of simple carbohydrates include white breads and pasta, cake, candy, cookies, and sugar-sweetened beverages.[3]
    • Generally speaking, complex carbs are better because their sources additionally include vitamins, minerals, protein, and other nutritional value, whereas simple carbs do not. The fiber content in complex carbohydrates also alleviates some of the negative impact on blood sugar.
  2. Avoid or minimize processed grains. White bread, white rice, and flour provide relatively little nutritional value and increase the amount of simple carbohydrates in your daily diet. For fiber intake, stick with small amounts of whole grains. These will cause fewer fluctuations in blood glucose levels as well.[4]
    Reduce Your Carbohydrate Intake Step 2 Version 2.jpg
  3. Avoid sugar and sweets. Desserts, pastries, sugary beverages, and other confectionery treats may taste wonderful, but they tend to provide little in the way of nutrition, and they increase the amount of carbohydrates in your diet significantly. Opt for servings of fruits or frozen fruit desserts that are made with no extra sugar if you feel the need for a treat.
    Reduce Your Carbohydrate Intake Step 3 Version 2.jpg
    • When something does call for a sweetener, use alternative sweeteners if possible.
  4. Watch the starch. While you do want to eat more vegetables, limit your intake of white potatoes, corn, and other starchy foods. A five-ounce russet baked potato has 30 grams of carbs, for instance.[5]
    Reduce Your Carbohydrate Intake Step 4 Version 2.jpg
    • Substitute with other root vegetables that contain fewer carbohydrates, and increase the amount of dark green vegetables that you consume at each meal. They tend to have few if any carbs while providing the benefit of a lot of nutrients.
    • Other starchy, high-carb vegetables include beets, peas, parsnips, sweet potatoes, and some winter squashes.[6]
  5. Select meat, fish, and poultry. Many low-carb diets replace the missing carb calories with high-protein calories. Many red meats have very little in the way of carbohydrates and offer the benefit of plenty of protein. Fish and poultry are also good options that provide nutrients and are filling, which will help to satisfy your body's craving for more carbs.
    Reduce Your Carbohydrate Intake Step 5 Version 2.jpg
  6. Broil and bake instead of frying. When preparing meats and vegetables, avoid battering and frying those foods. The flour used for the coating contains plenty of extra carbohydrates that your body does not need. To add flavor, use plenty of herbs and spices while broiling, and use an egg batter/crushed bran flakes combination to bake chicken and fish and enjoy a crispy coating.
    Reduce Your Carbohydrate Intake Step 6 Version 2.jpg
  7. Limit portions. Learn the difference between a sliver and a wedge of cake or pie, and get an idea of how much is actually in a single serving. Limiting portions will make it easier to enjoy more of the foods you like without taking in a lot of carbs. It can also be beneficial to weigh foods prior to cooking. For instance, it can help to weight out 4-6 oz of raw chicken before cooking to ensure the proper portion size is being consumed.
    Reduce Your Carbohydrate Intake Step 7 Version 2.jpg

EditUsing Strategies to Help Maintain a Lower Carb Intake

  1. Calculate the number of carbs you want to eat. The Dietary Guidelines for Americans recommend that carbohydrates make up 45-65% of your daily caloric intake for a standard diet.[7] Based on a 2,000-calorie/day diet, this means approximately 900-1,300 calories each day from carbs.[8]
    Reduce Your Carbohydrate Intake Step 8.jpg
    • Lower carb diets typically mean reducing carbs to between 240-520 calories each day, which equates to 60-130 grams of carbohydrates.[9]
  2. Consult your doctor or dietitian. Before making any big changes to your diet, consult your doctor or a dietitian regarding the safest way for you to do so. Current blood work results, existing kidney conditions, and other factors can all contribute to the healthiest way for you to cut back on carbs.[10]
    Reduce Your Carbohydrate Intake Step 9.jpg
  3. Check labels. Once you know your target for carbohydrates, remember to check labels for the food you buy. Try to balance options in order to adequately reduce carbs to your desired amount.
    Reduce Your Carbohydrate Intake Step 10.jpg
    • In addition to grams of carbs and calories from carbs, you may also see carbs listed as “servings.” Each serving of carbs is equivalent to 15 grams of carbs. However, you won’t see fractions or decimals of servings, so each serving isn’t exact. Typically, if a food has 8-22 grams of carbohydrates, then it will be listed as one serving.[11]
  4. Use the glycemic index. This helpful guide makes it possible to determine how many carbohydrates are found in a number of different foods both raw and processed. The index provides a per serving count of carbohydrates, making the process of carbohydrate counting much easier. Using the index allows you to plan for a healthy amount of carbs at each meal while avoiding the chance of taking in too many carbohydrates at a single setting.[12]
    Reduce Your Carbohydrate Intake Step 11.jpg
  5. Consider dietary changes you can maintain. You’re better off skipping fad diets that you can stick with only for a month or two before burning out on them. Many high-protein, low-carb diets can simply feel too restricting for long-term adoption. Instead, make changes in your diet that you will have an easier time maintaining.[13]
    Reduce Your Carbohydrate Intake Step 12.jpg
  6. Stay aware of potential complications. The additional fat from many high-protein sources can lead to additional problems when cutting carbs, such as higher cholesterol, which in turn raises the risks of heart disease.[14] High long-term carbohydrate restrictions can also lead to vitamin or mineral deficiencies, bone loss, and gastrointestinal disturbances.[15]
    Reduce Your Carbohydrate Intake Step 13.jpg
    • Severely limiting carbohydrates (anything less than 20 grams each day) may also lead to a body process called ketosis.[16] This is when your body does not have enough sugar (glucose) to produce energy, and your body begins breaking down stored fat to operate.[17] Side effects can include nausea, headache, and physical and mental fatigue.[18]

EditTips

  • For additional help in meal planning, ask your doctor for a referral to a trained dietitian. The dietitian can design a diet plan that not only helps to control your carbohydrate intake but also balances the need for other nutrients and minimizes the chances of taking in too much fat and cholesterol.
  • Remember that diabetics do not need to restrict carbohydrates as much as they need to be consistent with them. The spikes of high blood sugar followed by drops in blood sugar are what causes problems. Carbohydrate consistency along with pairing carbohydrates with proteins and fats will help to maintain proper blood sugar levels. Always test your blood glucose levels at two-hour and one-hour intervals after a meal to get some idea of how certain foods impact your blood sugar, and then plan meals accordingly.

EditWarnings

  • This article offers certain dietary information, but it should not be considered medical advice, especially for altering a diet to manage type 2 diabetes. Always consult your doctor before making decisions regarding your management of any disease or condition.
  • Reducing your carbohydrate intake may reduce muscular flexibility and lead to anxiety attacks or panic attacks if you have a back problem.

EditRelated wikiHows

EditSources and Citations


Cite error: <ref> tags exist, but no <references/> tag was found




source How to of the Day http://ift.tt/1Z0a1ZQ

lundi 29 août 2016

How to Measure Your Inseam

Inseam measurements are required for choosing and tailoring accurate clothing sizes, and may also be necessary for picking the right bicycle. Measure your inseam by extending a soft tape measure from the bottom of your crotch area, down the inside of your leg, and to the bottom of your inner foot. You can also measure your inseam by using a soft tape measure to measure the length of the inner seam (running from the crotch to the hem) of your pants.

EditSteps

EditUsing a Pair of Pants to Find Your Inseam

  1. Fold your pants. Choose a pair of pants that fit you perfectly; they aren't too long or too short, and are just tight enough to be comfortable. You will be measuring the inseam on the pants, so make sure they truly fit you. Fold them in half vertically, so that you can only see a single leg.

  2. Smooth them out. Lay them out on an ironing board or the floor. Smooth them out so there aren't any wrinkles or bumps, and the fold is evenly lined up.

  3. Place the start of the measuring tape at the bottom intersection of the crotch. This is the spot on the inside of the leg where one pants leg meets the other. [1]
  4. Stretch the tape down the pants until you reach the bottom of the inside of one leg, where it touches the ground.

  5. Make note of your measurement. The measurement in inches (or centimeters) from the crotch of the pants to the hem is your inseam length.

EditMeasuring Your Inseam With the Help of a Friend

  1. Strip down to the bare necessities. Remove your pants or put on a pair of tight fitting workout pants. Measuring with your regular clothes on is likely to leave you with an inaccurate number.
    Measure Your Inseam Step 8.jpg
  2. Ask a friend to assist you in getting a measurement.
    Measure Your Inseam Step 9.jpg
  3. Stand up straight. Your inseam will be too short if you slouch during the measuring process. Back against a wall to make sure you are keeping good posture.
    Measure Your Inseam Step 10.jpg
  4. Grab a clipboard. Slide a clipboard or very thin hardcover book between your legs. Put it has high as you can, just under the pubic bone. If you are a male, move accessory tissue out of the way so that you can get a true measurement. Make sure the edge of the clipboard is flat against the wall.
    Add a Pen Holder to a Clipboard Step 8.jpg
  5. Make your measurement. While you stand up straight, have your friend place the measuring tape at the top of the clipboard, near your thigh and crotch area.
    Measure Your Inseam Step 11.jpg
  6. Make your measurement. Extend the tape down to where it reaches the floor on the inside of your foot. The length in inches (or centimeters) on the tape is the length of your inseam.[2]
    Measure Your Inseam Step 12.jpg

EditVideo

EditTips

  • Keep in mind that the ideal inseam length will change depending upon the garment or the use. For example, for pants that you plan to wear with boots or high heels, the inseam may need to be 1 or 2 inches (2.5 to 5cm) longer, so that it doesn't touch the ground. An inseam on a pair of shorts will be much shorter than an inseam on a pair of jeans.

EditRelated wikiHows

EditSources and Citations


Cite error: <ref> tags exist, but no <references/> tag was found




source How to of the Day http://ift.tt/2cacbc1

How to Get Used to Working With the Public if You Are Shy

Being shy or introverted can be difficult, especially in a work environment. If your job requires you to provide presentations, attend events, or speak at conferences for your industry, it can be stressful. You will have to interact with co-workers, or speak to other industry professionals, clients, and the public. It can seem overwhelming to someone who is shy, but you can break it down to making a good first impression, perfecting your public speaking, and managing your shyness and anxiety. Addressing these factors will help improve your social interactions, and decrease shyness in the workplace.

EditSteps

EditMaking a Good First Impression

  1. Smile more. When you smile, it presents you to the world in a very non-threatening and helpful way.[1] People will respond much more positively to a person who is smiling than someone who is not.[2] Additionally, smiling helps you act confident through your body language even if you are not particularly feeling it.[3]
    Get Used to Working With the Public if You Are Shy Step 1 Version 2.jpg
    • Smiling will not only help you make a good first impression, but will also help decrease stress hormones helping you feel a little more at ease.[4]
  2. Address your personal appearance. Unfortunately people make snap judgments in about one-tenth of a second based on your appearance.[5] Knowing this occurs can actually help you prepare better. To make a good first impression and set yourself at ease, work towards creating the image of the person you want others to see. Knowing you are putting out a professional appearance may give you a confidence boost as well.
    Get Used to Working With the Public if You Are Shy Step 2 Version 2.jpg
    • Make sure your clothes are professional and appropriate for the occasion or situation you will be in.
    • Wear something that you feel comfortable and attractive in to increase your confidence. Remembering to work within the appropriate dress guidelines for that type of occasion.
    • See to it that you are well groomed, showered, and deodorized. Pay attention to your fingernails, hair, and the use of perfume or cologne.[6]
    • Make sure your clothes are clean, neat, and well kept. This means to make sure there are no stains, wrinkles, or holes in your clothing.
  3. Make eye contact. When speaking to a customer or co-worker, eye contact is essential to help maintain a good rapport between you and evoke positive reactions from them.[7] Eye contact shows interest, respect, and intelligence, and helps avoid the perception that you are rude, shy, or introverted. Not making eye contact can additionally make you appear distracted or nervous.
    Get Used to Working With the Public if You Are Shy Step 3 Version 2.jpg
    • Focus on making eye contact especially when someone else is speaking to you, or when you would like to connect with your audience during presentations.
  4. Have a good handshake. The handshake is so commonplace in the working world that we often forget how impactful it can be on a first impression. Try to develop a handshake that is firm and confident.[8] Make eye contact if you can, rather than looking at your hands to illustrate directness and confidence.[9] As silly as it may sound, find a friend and practice handshakes to get comfortable with the process and help you gain confidence in your handshake. According to Etiquette International a good handshake has the following qualities:
    Get Used to Working With the Public if You Are Shy Step 4 Version 2.jpg
    • Keep your fingers together and thumb up as you enter into the handshake.
    • Your grasp should be firm but not too hard.
    • The handshake should last about 3 seconds including eye contact.
    • Release the handshake even if the introduction continues.
  5. Maintain a professional attitude. It can be easy to become flustered or babble when you are shy or nervous in a work situation. Try to be as relaxed and pleasant as you can in the work environment. The more calm and relaxed you are the more your body will respond and help you to actually be calm. Be careful however, not to take your relaxed state too far. Try to avoid:
    Get Used to Working With the Public if You Are Shy Step 5 Version 2.jpg
    • Being overly loud or boisterous.
    • Engaging in unprofessional conversation topics or office gossip.
    • Telling inappropriate jokes at work.
    • Interrupting or dominating any conversations.
  6. Let the other individual take the lead in the conversation. Know when to talk and when to let the other person talk. It may help ease some shyness or anxiety to know that, in general, it is a good practice to let other individuals speak first. Maybe they have a question for you that can direct the conversation, or if not, ask them a question about themselves or their job so they can still have the floor first.[10] This will help take the pressure of making conversation off of you.
    Get Used to Working With the Public if You Are Shy Step 6.jpg

EditSpeaking to the Public

  1. Practice relaxation exercises to help you be calm and at ease. It may be difficult due to anxiety you are feeling about speaking to the public, but if you feel on edge others will sense that and feel it too.[11] There are not many people out there that enjoy public speaking, so take comfort in the fact that everyone in the audience understands it is an anxiety inducing situation. Address your stress and fear and its ability to hinder you in presenting yourself as a strong and confident person. If you need help relaxing, try some breathing or relaxation exercises.
    Get Used to Working With the Public if You Are Shy Step 7.jpg
    • Sit or stand somewhere with few distractions. Breath in through your nose for a count of four, hold your breath for a count of seven, and slowly release the breath out through your mouth for a count of eight.[12]
    • Count your breaths as you exhale. Breathe slowly and count up to five breaths. Repeat a few times, while trying to draw your breath from the bottom of your lungs instead of your shoulders.[13]
    • Change the shy or anxious thoughts and actively shift your focus onto others and off of yourself. Instead of thinking, “I am so nervous. How can I be less anxious?” try and think “How can I make everyone else more comfortable?”
  2. Pretend you are extroverted. Strangely enough, pretending you are not shy is effective.[14] You may end up convincing everyone else and maybe yourself, too! Many introverted individuals use this technique in order to be able to adapt to stressful work situations. Some ways you can accomplish this include:
    Get Used to Working With the Public if You Are Shy Step 8.jpg
    • If you work with or know someone with a charismatic friendly personality that you admire, pretend you are them. Take what you know about their attitude and style and act the part. Working next to others with outgoing personalities can be contagious just like smiling. Use this to your advantage.
    • Walk into a room and say “Hi” to everyone with a lot of energy and smiling. They will get the impression that you are outgoing, friendly, and approachable. The more you act like an outgoing person, the easier it will be to become on in these work situations.
  3. Identify your fears. You may be shy, introverted, or you may have anxiety about social situations or speaking to the public that are making it difficult for you to work. Identify if you have any particular fears about working with the public or public speaking. For example, maybe you are afraid you will make a mistake in an important presentation or conference.
    Get Used to Working With the Public if You Are Shy Step 9.jpg
    • Know that you will make mistakes, because everyone does. Those mistakes, however, are all teachable moments and ways you can improve your work.[15] Remember that it is often not mistakes that define us, but rather how we respond to them.
  4. Work with smaller groups or individuals. Working or speaking with a larger group of individuals has the tendency to make the work more complicated and can increase your stress. You may have anxiety over public speaking or with just speaking in any public situation.[16] A way to cope with this is to adjust the size of the group you are speaking with; reducing it down to a smaller group or just addressing an individual.
    Get Used to Working With the Public if You Are Shy Step 10.jpg
    • Break the larger group into a smaller, more manageable group. Separating into smaller groups allows you to focus more on fewer individuals and makes conversations easier.
    • Address one person in the group. If a client or a member of the public asks you a question, focus your attention on them and no one else in the group. This will show that person you are putting extra attention into their question, as well as help you focus and reduce your anxiety.
  5. Be aware of or change how you speak. The tone of your voice and the way that you speak conveys a great deal to the individuals listening. One study determined that men with a lower tone to their voice were considered more dominant, and women who alternated the pitch of their voice were perceived to be more trustworthy.[17] Additionally, if you speak clearly and calmly, studies show that you will be taken more seriously.[18]
    Get Used to Working With the Public if You Are Shy Step 11.jpg
    • Practice speaking at home or record yourself to see how you sound and adjust your speech accordingly.
  6. Be yourself. The problem many people face with social interactions in the workplace (or interactions with the public) is a lack of confidence. Remind yourself you were hired for this job for a reason, because you are good at it. Be yourself and bring your unique perspective and ideas to projects you are working on or individuals you are working with.
    Get Used to Working With the Public if You Are Shy Step 12.jpg
    • Additionally, allowing your personality to come out a little in presentations or at conferences makes it more interesting and engaging for the audience. It will also help you connect with your audience. Perhaps they will see something they can identify with in what you say.
  7. Prepare thoroughly for your tasks, events, or presentations. If you are speaking publicly, chances are you are already an expert on the topic. Still, it may help your feelings of shyness or anxiety to make sure you are well prepared for your presentation.
    Get Used to Working With the Public if You Are Shy Step 13.jpg
    • Make sure to research your topic, prepare your notes or your presentation and rehearse what you are going to say. It is also helpful to give your presentation in front of family and friends first. The more confident you feel, the more confidence you will show to others.

EditManaging Your Shyness and Anxiety

  1. Remind yourself that you’re fine just the way you are. Being introverted or shy tends to come with a great deal of negative connotations in our society. You may feel shame or sadness in regards to your experience, or even question why you are the way you are.[19] Remind yourself being introverted is more of a personality trait that has its own set of strengths. The only thing to address is if your shyness is causing you to struggle with work. If that's the case, find a few ways to manage it in that setting.
    Get Used to Working With the Public if You Are Shy Step 14.jpg
    • Try to understand and remind yourself that anxiety and shyness in the workplace are completely normal occurrences. Many people have the same feelings you do if their job entails a public focus.
    • Allow yourself time to adjust to being in the public eye more often. If you’re used to spending a lot of time on your own or find speaking in front of others a challenge or draining, remind yourself that you can learn how to work with the public over time. It’s just a matter of practicing the set of skills you will need to perform your job.
    • Practicing new skills can be a bit nerve wracking, but it can also be exciting and fun. It’s okay to feel uncomfortable at first, because it’s new to you. This is the learning process. However, as you take small steps and see small improvements every day, it can be fun too.
    • Avoid putting yourself down. Everyone has to practice new skills in order to do them well.
    • Find resources dedicated to introverted individuals such as "On Being an Introvert at Big Conferences" by Aaron B. Hockley or "Plight of the Introvert" on Wordpress to help you understand you are not alone.
  2. Define the difference between introversion, shyness, and social anxiety for yourself. Once you define the differences, decide where you fall and what you identify with the most. Placing a name on it gives you power to change it, own it, or overcome it. Acknowledge any fears you have and make a defined and realistic plan to work on changing them .[20]
    Get Used to Working With the Public if You Are Shy Step 15.jpg
    • Shyness. People who are shy tend to feel awkward in certain social situations, so they might avoid them now and then. However, shyness does not usually overtake your life. You can work on overcoming shyness by doing things you would not normally do, such as smiling at a stranger or introducing yourself to a new coworker.
    • Introversion. People who are introverted have a set of qualities that causes them to prefer being alone to spending time with people. Introverts may still be social and present themselves with confidence, but they might need more time to recharge after a lots of social time. If you are introverted, then you can learn how to balance your social time with enough alone time to recharge.
    • Social Phobia. Social phobia is a mental illness that causes some people to completely avoid social situations and it can have severe effects on one’s quality of life. If you think you might have social phobia, then you may want to see a therapist to get help.
  3. Make calculated efforts to get involved at work. Getting to know your coworkers may make it easier to work with the public if you are shy. The support that you get from your coworkers may help you to feel more confident in different social settings. It's hard to jump into social or more casual situations at work, but try to get involved as much as you feel comfortable with. Generally, the more comfortable you feel with your co-workers or clients, the less shy or anxious you may feel the next time you interact with them. Take it slow and try the following:
    Get Used to Working With the Public if You Are Shy Step 16.jpg
    • Show up to the team building exercises.
    • Go out to happy hour with your co-workers.
    • Try to be helpful not only to customers, but also to fellow co-workers.
    • Spark short casual conversations with clients, coworkers, or the public based on observations. If someone is displaying sports memorabilia ask, “Hey, are you a Yankees fan? Me too! Did you see the game the other day?”
  4. Address the energy expenditure. All of the interaction and working to change your experience for the better can have a drain on an introvert.[21] You are working hard to improve your career, just make sure you are taking care of yourself as well. Be prepared and have a recovery plan for yourself if you know a certain day or event is going to be particularly draining.
    Get Used to Working With the Public if You Are Shy Step 17.jpg
    • Practice telling yourself positive mantras or affirmations at the end of the day such as, “I faced my fears,” “I am proud of what I accomplished today,” or “Now I will take care of myself.” [22]
    • Create blocks of quiet, uninterrupted time so that you can recharge yourself throughout the day or at the end of the day.
    • Conserve your energy beforehand. If you are speaking at a conference or going to a crowded event avoid going to lunch with your coworkers beforehand or mingling with other conference attendees. Take some quiet time just for you if you know you'll have to push a lot of effort out soon.
  5. Give it time. The more time you spend interacting with strangers or interacting with the public, the more you'll get used to it.[23] Practice the techniques that work for you, and be proud of yourself for working with your fears and accomplishing your goals. Keep at it. You will find that you'll become more comfortable working with strangers and with interacting with the public in general.
    Get Used to Working With the Public if You Are Shy Step 18.jpg

EditRelated wikiHows

EditSources and Citations


Cite error: <ref> tags exist, but no <references/> tag was found




source How to of the Day http://ift.tt/2buGUBP

https://warriorplus.com/o2/a/x8g6yk/0

How to Clean Your Room

Plus, tips to help you stay motivated and make it fun Cleaning your room can feel like an overwhelming task, but it’s likely a quicker and...

https://warriorplus.com/o2/a/x8g6yk/0