Being called for a job interview is good news for who is out of market, isn’t it? As competition only grows in times of crisis, including professional qualification courses in the curriculum makes all the difference at the time of selection.

Among the most highly rated qualifications among recruiters are Excel courses. Nowadays, possessing advanced knowledge in Excel tricks can enable you to be among the first candidates selected in a selection process.

However, one must be honest. After all, when called to the next steps in the process, you should be prepared to demonstrate what you know. It is not enough just to express a good resourcefulness during the interview, one must be prepared to answer theoretical questions and solve practical exercises involving the software most used by companies.

So, if you have a job interview in sight, pay attention to these Excel tricks that can help you ...

 

What is in the selection processes?

 

Unless you are running for a very specific job, the usual thing is to ask candidates to prove a knowledge of Excel between basic and intermediate. Here are the most requested Excel tricks in selective processes:

 

1. Data storage and manipulation

 

Excel is ideal for storing and analyzing a large volume of information. In addition to creating a database, show that you know how to use formulas to relate them to each other, generating richer and more relevant results for decision-making.

 

2. Formulas and Functions

 

Learning how to create mathematical formulas to get results fast is one of the main tricks of Excel for doing well in selective processes. Generally, selections require some calculations like SUM, SUMIF, IF, MEDIAN, VLOOKUP, COUNT, COUNTA, COUNTIF.

 

3. Drawing up charts

 

Creating, reading and interpreting charts is a key skill among the Excel tricks you need. In addition to collecting data, know how to organize them and define the best graphical representation for each situation.

 

4. Creating Macros

 

Creating macros consists of setting up and saving standard routines that can be triggered again - and faster - on any worksheet. That is, they are like routines that perform preprogrammed tasks. Macros apply simple actions to complex actions, so they can be relevant in any job - that is, a great Excel trick to be presented in a selection process.