Master Data Analysis on Excel in Just 10 Minutes is a comprehensive guide to quickly and easily analyzing data using Microsoft Excel. It covers topics such as creating tables, summarizing data, sorting and filtering data, applying formulas and functions, working with charts and graphs, combining datasets from multiple sources, using advanced features like pivot tables & macros etc.
This video will teach you all the fundamentals of data analysis in just 10 minutes. First, we’ll go over how to transform or clean up a raw set of data on Excel. This will include using features like the trim formula, data types, removing duplicates, and more. Then, we’ll look at descriptive statistics using the data analysis feature on Excel. This will give us important numbers like the average, min, max, quartiles etc. We’ll also create a box and whisker chart for analysing outliers. Third, we’ll analyze the data using pivot tables. Finally, we’ll create a small report using conditional formatting, xlookups, sumifs and more.
DOWNLOAD Free Excel file for this video:
Design emails people love to get.
YouTube · Kenji Explains · 2 hours ago
3 key moments in this video
YouTube · Excel in a Minute · Dec 16, 2021
6 key moments in this video