top of page
Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Excel_MiniProject
*I cleaned data from an Excel worksheet involves the process of identifying and correcting any errors or inconsistencies in the data to ensure that it is accurate and reliable for analysis.
*Conditioning Formatting- used rule Age=D2:D10>30, Salary= K12:K20>50000 & Salary G2:G11>50000
*Formula- Max/Min/IF-IFS/Len/LeftRight/DatetoText/TRIM/Substitute/SUM-SumIF/COUNT-COUNTIF/Concatenate/Days-NetworkDays
*Pivot Table was used to show a sum of revenue to each countries in years
*XLOOKUP was used to look up for email based on the data on the right side Column A-Question & B('C' as well)-Answer
bottom of page