Data Analyst Excel: Understanding Study Tips and Formulas – Data Analyst Excel is an option if you do data analysis in addition to using other statistical tools. Excel is a number processing application that makes data processing easier to make it more accurate. Excel can also perform statistical calculations by providing functions that support this work.

Microsoft Excel is also one of the software that data analysts must master because the data is in the form of numbers and can be processed more simply and conclusions can be answered using a number of existing formulas. If you are a data analyst or are heading towards a career as a data analyst, it is very important to know and understand Excel formulas.

Understanding Data Analyst

Data Analyst Excel: Understanding Study Tips and Formulas

A data analyst is someone who interprets data into useful information. Usually, the data analyst profession is needed by companies and currently, there are many vacancies available. The data that has been analyzed will later be used to support the development of products made by a company.

Data analysis is also classified as a profession that is quite promising because data is one of the main keys to a company’s progress. Data obtained from data researchers cannot be used immediately but needs to be interpreted first by a data analyst.

Tips for Learning Data Analyst for Beginners

Tips for learning data analysis with Excel for beginners that you must pay attention to are:

Learn Basic Calculations

The way to learn how to calculate in Excel is to learn the whole concept first. Generally, in Excel calculating numbers and also processing data has another term, namely the use of “function”. This function can also be said to be an Excel formula to get the desired number.

How to create a function in Excel is quite easy, namely by clicking the box in Excel and typing the equals symbol (=), for example, =3+5, and then entering to get the result. You can also use other symbols according to your needs to perform basic calculations, such as (+) for addition operations, (-) for subtraction operations, (*) for multiplication operations, and (:) for division operations.

Understanding Autosums

Autosum is one of the advantages of Excel, which has the function to perform calculations quickly, without knowing the formula or formula. For example, you want to add up the number 5 in 10 cells descending in 1 column. You can select mor block all cells and click Formulas, then select Autosum.

All cells are added up automatically and quickly. Using Autosum is quite helpful if the number of numbers to be calculated is very large. Apart from the Autosum formula, you can use SUM for addition, Average to find the average value, Count Number to get the number of cells selected, Max to find the largest value, and Min to find the smallest value.

Understand Conditional Formatting

Conditional Formatting is a function that is commonly used to obtain data and has an attractive and interactive appearance. This function is used to change cells automatically if they meet the conditions or criteria.

Cell format also includes font (size, type, and color), size, cell border, and cell background color. The way to use it is to select the data you want to change select the (Conditional Formatting” option in the menu bar and select the format you want. There are several Conditional Formatting criteria
available, such as marking all selected cells according to their values, marking only cells that contain certain values, marking cells that correspond to the lowest and highest values , and others.

Create a table

Creating tables is also part of how to learn Excel data analysis for beginners that needs to be done. Using tables can make data organized easily and just writing numbers in Excel is not enough, because you need to format them in table form.

The way to create a table in Excel is to first block the available table data, click the Tables menu, and then click Tables. For data that already uses table format, you can create a table according to your wishes.

Understand Shortcuts

The final data analyst learning tip for beginners is to understand shortcuts in Excel. There are several shortcuts that you can use to make work easier and faster.

Examples of shortcuts you can try when using Excel are:

CTRL + V, to paste the information contained in the cell.
CTRL + C, to copy the information contained in the cell.
CTRL + 9, to hide previously selected rows.
CTRL + Z, to go back to one step previously.
CTRL + 0, to hide previously selected columns.
CTRL + O, to open a previously created file.
CTRL + N, to create a new file again.

So, those are some tips for learning Excel data analysis that you need to understand well.

Excel Formulas Often Used by Data Analysts

The following are several Excel formulas for data analysts that are often
used, including:


SUM is an example of an Excel formula that a data analyst must know. The SUM formula can be used to add numbers or data in Excel. Other forms, you can also use to add up more forms, such as rows and columns that you choose and an example is looking for total sales income data.


Count is an Excel formula used to obtain the number of cells that have been selected. The Excel Count formula can be calculated even if the amount of data is quite large. A count formula that can be used to calculate data filled in in cells and is in the form of numbers only.


Average is an Excel formula used to find the average value of numbers in your data. The formula used corresponds to the row or column you select in the existing Excel data.


Vlookup is an Excel formula that is used to look for a value in the table you are working on and comes from another table. This formula can be used to retrieve data from other tables accurately and practically. This can help you if you need to analyze quite a lot of data.


Hlookup is an Excel formula that is used to find data in the first row of an Excel table and look for values in cells in the same column in the table. This formula is very commonly used for data analysts in Excel.


SUMIF is an Excel formula that is used to add up data according to the criteria you have specified. Usually, you will give the command to sum or SUM a value, but with certain criteria or IF.


Max is an Excel formula used to find the highest value in data. This formula can help those of you who have a lot of data.


Min is an Excel formula used to find the lowest value or the inverse of Max.

So, that’s an explanation of Excel data analysis, learning tips, and Excel formulas that a data analyst needs to learn well.

This is the main advertisement. Click to view for 20 seconds.

Rate this post