FREE FILE TO DOWNLOAD: https://jopaexcel.com/jobinterviewtest_ls5lukb0i8

In this Excel video tutorial, we will learn how to solve an Excel test for a job interview. Through this questions, we gonna see how to use functions in Excel, how to use formulas in Excel, how to create a chart in Excel, how to make pivot table in Excel.

If you are studying how to pass a job interview, or if you are interested in taking a basic Excel course for job interviews, this video can help you a lot. It presents the most important Excel formulas for the job market, functions to save time in everyday life and how to solve an Excel test in a job interview.

With practical, everyday examples, we will solve several Excel challenges that appeared in an Excel test for a job interview.

From a report extracted from a company system database, we will need to adjust the information in the table to be able to solve the challenges.

In the first question, we need to build a column chart in Excel step by step from scratch, where the largest column is highlighted with green and the smallest column highlighted with red or the largest value is highlighted in green and the smallest value is highlighted in red We then need to create this dynamic and interactive chart in Excel column or bar chart.

In the second question, we need to use three functions in Excel three important formulas in Excel sum formula average formula vlookup formula or sum function average function and search function. This way, we will learn in practice step by step how to do sum in Excel, how to do average in Excel and how to look for a value in Excel, how to use the procv function.

In the third question, we will need to create a pivot table in Excel or as it is known as a pivot table. The pivot table in Excel is an excellent tool to help us filter and segment the information we have in a database. From an Excel table we can adjust and reorganize the information in the pivot table to be able to carry out accurate analyzes with the data we have .

0:00 - Subscribe to the Channel!
0:20 - Like the Video!
0:40 - Question 01
4:44 - Question 02
11:03 - Question 03

#JopaExcel #Dashboard #Excel