Welcome To Divex Training
INTRODUCTION TO DATA ANALYSIS
MODULE 1 - INTRODUCTION TO EXCEL
MODULE 2 - BASIC EXCEL FUNCTIONS
MODULE 3 - EXCEL TABLE AND CONDITIONAL FORMATTING
MODULE 4 - DATA SORTING AND FILTERING TECHNIQUES
MODULE 5 - PIVOT TABLE AND DATA VISUALIZATION
MODULE 6 - POWER QUERY FOR DATA CLEANING
MODULE 7 - EFFECTIVE DATA VISUALISATION AND DASHBOARDING
MODULE 8 - EFFECTIVE DATA VISUALISATION AND DASHBOARDING 2
MENTORSHIP
Excel 5 -Assignment – Module 5
- Create a pivot table showing the monthly sales and visualize your result using a line chart
- Create a pivot table showing the products by sales and visualize your result using a bar chart
- Create a pivot table showing the average unit price of products in each segment. Visualize your result using a bar chart.
- Create a pivot table showing the percentage share of sales by country. Visualize your result using a donut chart.