Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
a. Formatting the data: Open the dataset in Excel. Select the data range that you want to format. Apply borders, adjust font size, and align the content as desired using the formatting options in the Excel toolbar. b. Summary of Product Sales: Use the SUM, AVERAGE, STDEV, VAR, MAX, and MIN functions to calculate the respective…
Vikrant kaushik
updated on 09 Jul 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 Vikrant kaushik (2)
Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Below is the VBA code to create Pivot Charts for the mentioned questions and some additional tasks. Please insert this code into the VBA editor of your Excel workbook: vbaCopy code Sub CreateDashboard() ' Clear existing Pivot Tables and Charts (if any) On Error Resume Next ThisWorkbook.Sheets("Dashboard").PivotTables.Delete…
01 Aug 2023 10:17 AM IST
Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
a. Formatting the data: Open the dataset in Excel. Select the data range that you want to format. Apply borders, adjust font size, and align the content as desired using the formatting options in the Excel toolbar. b. Summary of Product Sales: Use the SUM, AVERAGE, STDEV, VAR, MAX, and MIN functions to calculate the respective…
09 Jul 2023 08:02 AM IST