Vikrant kaushik
NA
Skills Acquired at Skill-Lync :
Introduction
2 Projects
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
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
1 Course Certificates
Academic Qualification
M.Tech
Birla Institute Of Technology And Science–Pilani (BITS–Pilani)
03 Jan 2022 - 06 May 2024
B.Tech
om sai institute of technology and science
15 Nov 2011 - 09 Mar 2015
12th
M M Inter College
10 May 2010 - 06 Jun 2011
10th
janta higher secondary school
05 May 2008 - 06 Jul 2009
Here are the courses that I have enrolled
Similar Profiles
Ladder of success cannot be climbed with hands in pocket.
The Future in Motion
Give more than what you get you will get more than what you gave
Avid learner