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 4 -Assignment – Sorting
- (a) Filter the data by country (Canada only) (b) Sort the filtered data by the quantity in descending order
- Sort the data in ascending order by first name and last name
- Create two slicers for country and product