7 Excel Hacks That Will Make Your Life Easier

7 Excel Hacks That Will Make Your Life EasierA whopping 67% of middle-skill jobs require experience in Excel. Just because you hate numbers and the thought of spreadsheets make you nauseous doesnt mean you cant add this valuable skill to your resume with confidence. Here are a few tricks to make you an Excel wizard.1. ChartsThese are not just for the know-it-all in grade school. Charts are a great way to make your data visual, and a great way to impress the bigwigs. Once youve entered your data, simply click Insert ChartChart schriftart and youre on your way.2. Conditional FormattingThe possibilities here are endless. Want to show off profit margins? Or efficiency? Simply click HomeConditional FormattingAdd and make your magic. Low numbers (say those below 70%) or profits under 3% could be set to automatically highlight in red, while excellent numbers could be highlighted in green.3. Quick AnalysisHave a smaller data set? You can skip to the fancy chart and table stage by using this tool. Just highlight your data and click on the icon in the bottom right corner of your highlight field to open the Quick Analysis menu.4. AutofillWhy enter the same thing in every row when you can have Excel do it for you? Just schrift in the datum you need repeated, then click and drag the lower right-hand corner of the cell all the way down the column.5. Power ViewHave a larger data set? Power View can collate and make sense of your data for you, generating visual, interactive reports for you to present directly to the boss. Just click InsertReports and start exploring.6. Pivot TablesThey sound really fancy, but theyre super useful. You dont have to write a single formula, but you can summarize all of your data into impressive and informative tables and lists. Just click InsertPivotTable, select your data range, use the drop-down menu to select your fields, then make your table7. VLOOKUPIf youre working in a database with multiple sheets and tabs, VLOOKUP is a great way to bring them all together and pull coherent information from the entire data set. Under the Formula menu, select VLOOKUP and enter the cell that contains your reference, then the range of cells to pull from, the column number, and either true or false.These few tricks are mobilfunktelefon for everyone, but will make you stand out among your colleagueseven if youre bad at numbers.Once you have these done, step up your game and learn these 7 advanced Excel Tricks. It might even get you a raise or promotion.7 Excel Tricks Thatll Make Your Life a Lot Easier (Especially if Youre Not a Numbers Person)

10 Toxic People You Should Avoid Like The Plague At Work

10 Toxic People You Should Avoid Like The Plague At Work Toxic people defy logic. Some are blissfully unaware of the negative impact that they have on those around them, and others seem to derive satisfaction from creating chaos and pushing other peoples buttons.As important as it is to learn how to deal with different kinds of people, truly toxic people will never be worth your time and energy and they take a lot of each. Toxic people create unnecessary complexity, strife, and, worst of all, stress.People inspire you, or they drain you plattl them wisely. Hans F. HansenRecent research from Friedrich Schiller University in Germany shows just how serious toxic people are. They found that exposure to stimuli that cause strong negative emotions the same kind of exposure you get when dealing with toxic people caused subjects brains to have a massive stress response.Whether its negativity, cruelty, the victim syndrome, or just plain craziness, toxic people drive your brain into a str essed-out state that should be avoided at all costs.Studies have long shown that stress can have a lasting, negative impact on the brain. Exposure to even a few days of stress compromises the effectiveness of neurons in the hippocampus, an important brain area responsible for reasoning and memory. Weeks of stress cause reversible damage to brain cells, and months of stress can permanently destroy them. Toxic people dont just make you miserable theyre really hard on your brain.The ability to manage your emotions and remain calm under pressure has a direct link to your performance.TalentSmarthas conducted research with more than a million people, and weve found that 90% of top performers are skilled at managing their emotions in times of stress in order to remain calm and in control. One of their greatest gifts is the ability to identify toxic people and keep them at bay.Its often said that youre the product of the five people you spend the fruchtwein time with. If you allow even one of those five people to be toxic, youll soon find out how capable he or she is of holding you back.You cant hope to distance yourself from toxic people until you first know who they are. The trick is to separate those who are annoying or simply difficult from those who are truly toxic. What follows are ten types of toxic drainers that you should stay away from at all costs so that you dont become one yourself.1. The gossipGreat minds discuss ideas, average ones discuss events, and small minds discuss people. Eleanor RooseveltGossipers derive pleasure from other peoples misfortunes. It might be fun to peer into somebody elses partieal or professional faux pas at first, but over time, it gets tiring, makes you feel gross, and hurts other people.There are too many positives out there and too much to learn from interesting people to waste your time talking about the misfortune of others.2. The temperamentalSome people have absolutely no control over their emotions. They will lash out at you and project their feelings onto you, all the while thinking that youre the one causing their malaise. Temperamental people are tough to dump from your life because their lack of control over their emotions makes you feel bad for them.When push comes to shove though, temperamental people will use you as their emotional toilet and should be avoided at all costs.3. The VictimVictims are tough to identify because you initially empathize with their problems. But as time passes, you begin to realize that their time of need isall the time. Victims actively push away any personal responsibility by making every speed bump they encounter into an uncrossable mountain. They dont see tough times as opportunities to learn and grow from instead, they see them as an out.Theres an old saying Pain is inevitable but suffering is optional. It perfectly captures the toxicity of the victim, who chooses to suffer every time.4. The self-absorbedSelf-absorbed people bring you down through the impassi onate distance they maintain from other people. You can usually tell when youre hanging around self-absorbed people because you start to feel completely alone.This happens because as far as theyre concerned, theres no point in having a real connection between them and anyone else. Youre merely a tool used to build their self-esteem.5. The enviousTo envious people, the grass is always greener somewhere else. Even when something great happens to envious people, they dont derive any satisfaction from it. This is because they measure their fortune against the worlds when they should be deriving their satisfaction from within.And lets face it, theresalwayssomeone out there whos doing better if you look hard enough. Spending too much time around envious people is dangerous because they teach you to trivialize your own accomplishments.6. The manipulatorManipulators suck time and energy out of your life under the faade of friendship. They can be tricky to deal with because they treat you li ke a friend. They know what you like, what makes you happy, and what you think is funny, but the difference is that they use this information as part of a hidden agenda.Manipulators always want something from you, and if you look back on your relationships with them, its all take, take, take, with little or no giving. Theyll do anything to win you over just so they can work you over.7. The dementorIn J. K. Rowlings Harry Potter series, Dementors are evil creatures that suck peoples souls out of their bodies, leaving them merely as shells of humans. Whenever a Dementor enters the room, it goes dark, people get cold, and they begin to recall their worst memories. Rowling said that she developed the concept for Dementors based on highly negative peoplethe kind of people who have the ability to walk into a room and instantly suck the life out of it.Dementors suck the life out of the room by imposing their negativity and pessimism upon everyone they encounter. Their viewpoints are always glass half empty, and they can inject fear and concern into even the most benign situations. A Notre Dame University study found that students assigned to roommates who thought negatively were far more likely to develop negative thinking and even depression themselves.8. The twistedThere are certain toxic people who have bad intentions, deriving deep satisfaction from the pain and misery of others. They are either out to hurt you, to make you feel bad, or to get something from you otherwise, they have no interest in you. The only good thing about this type is that you can spot their intentions quickly, which makes it that much faster to get them out of your life.9. The judgmentalJudgmental people are quick to tell you exactly what is and isnt cool. They have a way of taking the thing youre most passionate about and making you feel terrible about it.Instead of appreciating and learning from people who are different from them, judgmental people look down on others. Judgmental people stifle your desire to be a passionate, expressive person, so youre best off cutting them out and being yourself.10. The arrogantArrogant people are a waste of your time because they see everything you do as a personal challenge. Arrogance is false confidence, and it always masks major insecurities. A University of Akron study found that arrogance is correlated with a slew of problems in the workplace.Arrogant people tend to be lower performers, more disagreeable, and have more cognitive problems than the average person.How to protect yourself once you spot emToxic people drive you crazy because their behavior is so irrational. Make no mistake about it their behavior truly goes against reason, so why do you allow yourself to respond to them emotionally and get sucked into the mixtur?The more irrational and off-base someone is, the easier it should be for you to remove yourself from their traps. Quit trying to beat them at their own game. Distance yourself from them emotionally, and approach your interactions with them like theyre a science project (or youre their shrink if you prefer that analogy). You dont need to respond to the emotional chaos only the facts.Maintaining an emotional distance requires awareness. You cant stop someone from pushing your buttons if you dont recognize when its happening. Sometimes youll find yourself in situations where youll need to regroup and choose the best way forward. This is fine, and you shouldnt be afraid to buy yourself some time to do so.Most people feel as though because they work or live with someone, they have no way to control the chaos. This couldnt be further from the truth. Once youve identified a toxic person, youll begin to find their behavior more predictable and easier to understand. This will equip you to think rationally about when and where you have to put up with them and when and where you dont.You can establish boundaries, but youll have to do so consciously and proactively. If you let things happen n aturally, youre bound to find yourself constantly embroiled in difficult conversations. If you set boundaries and decide when and where youll engage a difficult person, you can control much of the chaos. The only trick is to stick to your guns and keep boundaries in place when the person tries to cross them, which they will.--This article originally appeared on TheLadders.com.