Published On Mar 18, 2024
Excel Dataset Link: https://docs.google.com/spreadsheets/...
In this video, you'll learn the essentials of data analysis broken down into data cleaning, data analysis, and data visualization.
In the data cleaning section, we'll use Power Query to clean up a raw set of data. This will include changing formats, merging columns, and trimming spaces.
Then, in the analysis phase, we'll answer some questions about our data using pivot tables. Finally, in the visualization phase, we'll use conditional formatting, box plots, and scatter plots to visualize the data.
Data Analysis Tutorial:    • Learn Data Analysis on Excel in Just ... Â
How to do Data Entry work in Excel:    • How to do Data Entry Work in Excel Us... Â
Pivot Table Tutorial:    • Excel Pivot Table Explained Under 10 ... Â
#excel #dataanalysis #dataanlyst #excelfordataanalysis