How to Do Data Analysis in Excel | From Scratch to Reporting with Modern Charts and Functions
🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel...
🔵 DOWNLOAD SPREADSHEET: https://excelentejoao.com.br/wp-conte...
In this Excel video lesson, we will learn how to perform data analysis in Excel from a raw database, transform, clean and edit this report, perform analyses through functions and formulas, build graphs and then combine everything with the final result and conclusion and transform all of our 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 identity analysis.
We will use several formulas in Excel, several important functions in Excel, such as the sum formula, the sumif formula, the countif formula, and the average formula in Excel. We will also create several important graphs in Excel, such as a column chart, a donut chart, or a pie chart, as well as a card to show a value. It is as if we were creating a dashboard in Excel, but to assemble our report and analyze data.
SUM, Another function and formula that we will use in the Excel spreadsheet is the sum. We can add items, values, cells, and 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 by semicolons, or we can select the entire range at once in the sum function, that is, select several cells at once to add up a value from these cells.
COUNTIF, The countif function can help me, because 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 our daily lives, in the job market, in an Excel job interview or even to perform analyses.
SUMIF, The sumif formula in Excel helps us to add not everything but only that which meets a criterion, in this way we can perform analyses 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 meet a certain criterion.
#ExcelenteJoão #Excel #Dashboard