5 Excel Functions that will make you a data wizard
August 18, 2017
Excel has a lot of features and functionalities that make it a very competitive business intelligence tool.
One thing that makes Excel stand out is its wide variety of Excel functions (while I must admit I am also pretty impressed with what Google Sheets has to offer in terms of functions).
There are close to 450 functions in Excel and there seems to be one for everything.
Now don’t worry about not knowing all these functions. You are never going to need more than a handful of these. And most of these function are well covered online and you can find many useful online Excel training to make you proficient in it.
Here are my favorite five Excel functions that would help anyone working with data in Excel.
#1 IF Function
If is a basic formula that checks for a condition and returns a specified value when it’s met. For example, suppose you have a long list of numbers and you have to check whether it is greater than 50 or not.
You can easily do this using the IF function. Here is the syntax:
=IF(A1>50, “Yes”, “No”)
Here A1 has the value and the function checks whether the value is greater than 50 or not. If it is, then it returns Yes, else it returns No.
The power of IF function lies in the fact that you can use multiple IF functions within the IF function itself. This is called nested IFs.
#2 VLOOKUP Function
VLOOKUP function is highly popular Excel function that helps you look through an entire column and fetch the matching value from the specified column.
The V in the VOOKUP stands for vertical as it goes down the vertical column and looks for the specified value. There is also the HLOOKUP function, but VLOOKUP is the one you should focus on, to begin with.
#3 SUMIF Function
There is a basic SUM function in Excel that would simply add all the numbers in the specified range. SUMIF takes it a step further allows the user to add the values based on a certain condition.
For example, if you want to add all the sales value for a sales rep named Paul, then you can do that by specifying it as the condition.
#4 MIN/MAX Functions
MIN/MAX functions – as the name suggests – would find the maximum or the minimum value from a given range. These are really helpful when you want to find out the outliers in your data set.
#5 COUNTIF Function
COUNTIF is similar to SUMIF. It counts the values in a given range when the specified condition is met. For example, if I want to find out how many times did Paul made a sale, I can specify the condition to be Paul and then count the total number of occurrences.
These are my top five Excel functions. It’s something that I use on a daily basis. This is no way enough to get the work done and sooner or later you will have to learn some other awesome functions as well, however, this should be a good starting point if you’re a beginner in Excel.
7 Skills That Can Land You a High Paying Jobs
August 17, 2017
Everyone wants to climb up a few rungs of the career ladder and earn a bit more money. But it can be difficult to know what exactly employers are looking for in order to land you that highly paid job of your dreams.
I have been working in a 9 to 5 job (happily I must add) and in this article, I am listing the skills that I believe are important in helping you land a high paying job.
Now the list is definitely not exhaustive, but in my experience, these are useful skills whether you work in the sales department or in a zoo.
Communication is one of the most important skills that employers are looking for.
Now communication takes a whole new shape when you aspire to enter the corporate world. There are written and unwritten rules you need to know and abide by.
In a higher paid job you will need to be able to communicate with your peers, with those that you manage, and with those above you in order to make sure that each and every part of the business is running smoothly.
Communication can be face to face, via phone, emails or conference calls/chats. Often, you will get a limited time to put forward your point, and the skill to structure your communication make or break the deal.
We live our lives on the internet and on our phones and produce more data than you can shake a stick at.
This can leave businesses struggling to cope with and analyse the vast amount of data they’re left with. If you have a head for understanding complicated data, then you can expect to earn more and get higher paid jobs, as analytical skills are useful in all areas of business. If you can track, build, and analyse data then make sure that you advertise this to your potential employers, because it is a valuable skill in many areas of a company, and data specialists are highly sought after.
If you can track, build, and analyse data then make sure that you advertise this to your potential employers, because it is a valuable skill in many areas of a company, and data specialists are highly sought after.
Presentation skills are one of the most important skills that employers are looking for, as presentation skills show confidence and a comfortability of public speaking. Presentation skills mean that you can present to clients and potential clients in a way that will convince them to work with the business, but you can also hold yourself in a respectful manner, and this is highly revered by potential employers who want to bring in more business.
Presentation skills mean that you can present to clients and potential clients in a way that will convince them to work with the business.
An important skill here is to work with PowerPoint. It amazes me how this single software has completely changed the way businesses work. We are all so used to PowerPoint that it has become synonymous to presentations in the corporate world.
4. Project Management
Project management skills allow you to show that you can take on larger projects, plan them, and manage your time properly in order to get the job finished in time, and finished to a high standard.
Project management opens up doors to a huge range of managerial roles, as it shows employers your ability to organise and manage yourself in order to fulfil the requirements of a project properly to satisfy clients and bosses.
5. Technical Skills
If you can get your head around new technology then you have a major advantage over a lot of people who are competing for the job that you want.
For example, if the new world demands node JS and you’re stuck with PHP, you may struggle to get hired in the new world. My point here is that you should be proficient in the technology in your space.
Your employer will value technical skills that are applicable to the job, but will also favour those who can grow and develop with new technology as it emerges. This gives the businesses an edge on the competition if they can get their business onto the newest technology as fast as possible, so make sure to mention any technological skills or qualifications that you possess to really impress potential employers.
One good thing about technical skills is their diversity so as long as your prospective employer can spot any such skills in you, the job you are interviewing for will be as good as yours.
Multitasking is another ability that is held in very high esteem by any potential employer, especially for bigger and higher paid jobs.
These jobs typically have a lot of responsibilities attached to them, and if you want to succeed you need to be able to do several things at once and keep on top of it all.
If you can show employers that you have had to organise several jobs at the same time then you are much more likely to gain the higher job roles.
7. Teaching and Mentoring
Companies love people who can teach and transfer their skills to other members of the work team.
If you can teach others about the skills that you possess then you are much more valuable to a potential employer, as employers love to develop their workforce in order to create a more productive team of staff by using their own workforce, rather than external companies to teach new skills.
The current job market is constantly changing, and it is never easy to know what exactly employers are looking for in order to tick all of the boxes that potential employers are looking for. We hope that this list has helped you to better understand the key areas that employers are looking for a candidate to fill, as this will make it much more likely for you to win the job of your dreams.