
Master data filtering techniques to explore and analyze records by city and premium amount, apply multi-criteria filters, clear selections, and identify ABC entity transactions from descriptions.
Create and compare multi-level data visualizations using stack charts, line charts, pie charts, and scatter charts to analyze department skill distributions, trends, and correlations.
Student will get understanding of five very useful techniques in excel and their practical applications from real life examples.
These techniques are:
1. Sorting
2. Filtering
3. Absolute referencing and by cell name
4. Data Visualization using various Excel charts
5. Data analysis using Pivot Table
After going through this course, the student will get broader understanding of these techniques to boost up their excel task productivity.