Member-only story
Excel for Data Analysis : What to Learn
Excel is more important than Python in Data Analysis. Yes! you read that right. Most of the Data Analysts use Excel in their work life than Python.
Microsoft Excel is a very powerful tool in data analysis, widely used by professionals in various industries. If you are looking forward to using Excel for data analysis, here are the features and skills you should learn:
1. Basic Excel Functions
— Learn basic functions like SUM, AVERAGE, COUNT, and ROUND. Learn how to use formulas to do quick calculations.
2. Data Cleaning
- Learn to remove duplicates, deal with missing data, and clean messy datasets.
- Learn Text-to-Columns and Find & Replace.
3. Sorting and Filtering
- Learn how to sort data in ascending/descending order
- Use filters to drill down into specific data points
4. Conditional Formatting
- Highlight important data using rules and color scales
- Create visual cues for trends or anomalies
