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 3 – Assignment Conditional Formatting
Download the dataset above and answer the following questions
1. Create a calculated column using the structured formula method to calculate the sales
2. Use conditional formatting to highlight sales that are above $5000
3. Use data bar to show the vales of quantity without displaying the values in the column. NB: Don’t sort or filter before adding conditional formatting.
Click below, select all three answers from where you have saved them, upload them and then submit