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 2 – Assignment
(a) Use excel function to get customers full name (first name and last name)
(b) Calculate total sales, total orders, average price, max unit price, and min unit price
(c) Calculate the total sales for each country
(d) Calculate average price of each product by country
(e) Use data validation to select a product and any lookup function to show the unit price of each product