Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
applied times new roman as font, gave all borders, and gave left most alignment. solved (b) & (c) in the existing sheet "sales_data" at location AD4, AJ4. created ABC tab and added data formatting tools. solved (e) & (h) in two different sheets namely (E) & (H). solved (f) & (j) using conditional formatting.…
MSHIVA SHARAN
updated on 29 Jan 2023
Project Details
Leave a comment
Thanks for choosing to leave a comment. Please keep in mind that all the comments are moderated as per our comment policy, and your email will not be published for privacy reasons. Please leave a personal & meaningful conversation.
Other comments...
Be the first to add a comment
Read more Projects by MSHIVA SHARAN (8)
Project 2 - EDA on Vehicle Insurance Customer Data
completed
19 Jul 2023 05:56 PM IST
Project 1 - English Dictionary App & Library Book Management System
completed
19 Jul 2023 07:54 AM IST
Project 2
(5)imported "College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ" into excel and gave the sheet name as the table name. (12) created "project" named procedure and executed the question. (13)imported the views "College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ"…
28 Apr 2023 09:45 AM IST
Project 1
answers: 1) Created a new scheme named as "ecommerce". 2)Imported the "users_data.csv" using the instructions given.
14 Apr 2023 03:52 AM IST
Project 2 - Gender Bias in Science and Technical field
completed the challenge and replicated upto the extent.
25 Mar 2023 11:56 AM IST
Project 1 - Analyzing the Education trends in Tamilnadu
Added an image and added title: "Women in STEM fields" as floating and kept it on the image.
24 Mar 2023 11:18 AM IST
Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
First part i have created charts for all the mentioned contions such as "Gender Ratio of Applicants, Car Owner/ Non-Owner Ratio, House Owner/ Non-Owner Ratio, Client Income Type, Client’s Level of Education, Client’s Housing Type, Client’s Family Status, Client’s Occupation Type" and kept it in…
17 Feb 2023 10:41 AM IST
Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
applied times new roman as font, gave all borders, and gave left most alignment. solved (b) & (c) in the existing sheet "sales_data" at location AD4, AJ4. created ABC tab and added data formatting tools. solved (e) & (h) in two different sheets namely (E) & (H). solved (f) & (j) using conditional formatting.…
29 Jan 2023 09:38 AM IST