FREE EXCEL FILE DOWNLOAD: https://jopaexcel.com/dataanalysislkxvti7iue0

In this Excel video tutorial, we will learn how to perform data analysis in Excel from a raw database, transform, clean and edit this report, perform analysis using functions and formulas, build charts and then put everything together with the final result and conclusion and transform our entire analysis into a report.

This free Excel tutorial can give you an idea of what data analysis is and how a professional data analyst works on a daily basis. Perhaps we can also say that it is a BI business intelligence analysis.

We will use several formulas in Excel, several important functions in Excel, such as sum formula, sumif formula, countif formula, averageif formula in Excel. We will also make several important charts graphs in Excel such as column chart, donut chart or pie chart and also a card to show a value. It's as if we were creating a dashboard in Excel, but to assemble our report and for data analysis.

SUM, Another function and formula that we will use in the Excel spreadsheet is the sum. We can add items, values, cells, ranges in Excel in different ways. We can use the plus sign or the sum function for this. We can also select items individually, select values, numbers, individually and separate them by plus or semicolon or we can select, in the sum function, the entire range at once, that is, select several cells from one time to add a value from these cells.

COUNTIF, The COUNTIF function can help me, as it can count values that appear more than once in a list, it can count repetitions, it counts how many times a certain value has already appeared in the spreadsheet. It is one of the most important formulas in Excel, one of the most important functions, which can help us a lot in everyday life, in the job market, in an Excel job interview or even when carrying out analyses.

sumif, The sumif formula in Excel helps us to add up not everything but only what meets a criterion, this way we can carry out analyzes in Excel through one of the most important functions of all, which is the sumif function in Excel.

AVERAGEIF, the averageif function in Excel, returns the arithmetic mean of all cells in a range that met a given criteria.

#JopaExcel #Dashboard #Excel