This video on Data Analytics in Excel will help you will understand the various crucial functions available in Excel, such as vlookup,hlookup, sumif/s, counif/s, iferror and others. You will learn how to sort and filter data in Excel. Then, we’ll focus on conditional formatting and data validation. Moving further, you will get an idea of how to create pivot tables and pivot charts in Excel. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as regression, sampling, descriptive statistics and much more. Let’s begin.

• 00:00:00 Basic of excel
• 00:04:20 Lookup & functions
• 01:37:58 Conditional formating
• 01:54:30 Data validation
• 02:36:30 Sorting and filtering
• 03:23:55 Data analysis using toolpak

#data-analysis #excel