How to Do Data Analysis in Excel From Scratch to Reporting with Modern Charts and Functions
25,178 views
About :
🟢 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 video lesson Excel, let's learn how to do data analysis in Excel from a raw database, transform, clean and edit this report, do analysis using functions and formulas, build graphs and then put everything together with the final result and conclusion and transform it into a whole report this is our analysis. 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 various formulas in Excel, various important functions in Excel such as sum formula, sum formula, count formula, mediase formula in Excel. We will also make several important 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 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 pluses or semicolons or we can select, in the sum function, the entire range at once, that is, select several cells at once. 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. SOMASE, The somase 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 sumase function in Excel. AVERAGEIF, the averageif function in Excel, returns the arithmetic mean of all cells in a range that satisfy a given criteria. #ExcelenteJoão #Excel #Dashboard
759,647 views 3 days ago
110,636 views 1 day ago
861,371 views 3 days ago
707,716 views 3 days ago
861,371 views 3 days ago
Google AdSense
336 x 280
336 x 280
Up Next
KAKA BASS - Aulas de Baixo
38,231 views
3 years ago
3 years ago
KAKA BASS - Aulas de Baixo
117,547 views
5 years ago
5 years ago
Fabio Aposan
86,306 views
4 years ago
4 years ago
KAKA BASS - Aulas de Baixo
26,672 views
4 years ago
4 years ago
Giane Rangel
519,712 views
3 years ago
3 years ago
KAKA BASS - Aulas de Baixo
11,665 views
3 years ago
3 years ago
David Julio
3,597 views
1 year ago
1 year ago
KAKA BASS - Aulas de Baixo
25,592 views
5 years ago
5 years ago
KAKA BASS - Aulas de Baixo
43,835 views
5 years ago
5 years ago
JADEMIR MACHADO by POWER BASS
9,953 views
3 years ago
3 years ago
Diego Diesel
6,340,610 views
12 years ago
12 years ago
ToqueMaisBaixo by DUVALLE
166,268 views
5 years ago
5 years ago
KAKA BASS - Aulas de Baixo
3,254 views
1 year ago
1 year ago
Túlio de Melo - Curso de Baixo
101,309 views
4 years ago
4 years ago
Google AdSense
336 x 280
336 x 280