Grace
Hello English speakers! Could you please help me correct my interview answers? Thanks in advance for your help! During my internship at JD Technology this summer, I taught myself Excel pivot tables and various Excel formulas, and successfully finished sales data statistics and analysis, as well as product order data splitting. During the internship, I was responsible for three main data-related tasks: the first part was to count daily sales data and track and analyze them, the second part was to sub-channel the weekly sales order totals, and the third part was to carry out the gross profit of main products and new products, and the measurement of promotion costs. At that time, after the department's agency handed over the work of sales data analysis to me, I found that since the previous way of data statistics required manual identification and was very inefficient, I wanted to improve the efficiency of data statistics by means of pivot tables and formulas. In this regard, I taught myself through online tutorials in my free time, and quickly mastered Excel's Vlookup and a variety of formula functions with the help of C language design and database principles and other programming foundations during my undergraduate studies, and mastered a variety of Excel shortcut keys in the period. Moreover, I applied the self-taught formulas to data statistics and splitting, and kept the data templates once to better hand over with the next interns. Finally, through the learning of Excel pivot tables and various formulas, I greatly improved the efficiency of the statistical and analytical part of the work I was responsible for, and did a good job of keeping and handing over the data templates to facilitate the handover of the next work.
Oct 3, 2021 3:52 PM
Corrections · 2
During my internship at JD Technology this summer, I taught myself Excel pivot tables and various Excel formulas, and successfully finished sales data statistics and analysis, as well as product order data splitting. During the internship, I was responsible for three main data-related tasks: the first part was to count daily sales data and track and analyze them, the second part was to sub-channel the weekly sales order totals, and the third part was to calculate the gross profit of both current main products and new products, and the measurement of promotion costs. At that time, after the department's agency handed over the work of sales data analysis to me, I found that since the previous way of data statistics required manual identification and was very inefficient, I wanted to improve the efficiency of data statistics by means of pivot tables and formulas. In this regard, I taught myself through online tutorials in my free time, and quickly mastered Excel's Vlookup and a variety of formula functions with the help of C language design and database principles and other programming foundations during my undergraduate studies, and mastered a variety of Excel shortcut keys in the period. Moreover, I applied the self-taught formulas to data statistics and splitting, and kept the data templates to better hand over to the next interns. Finally, through the learning of Excel pivot tables and various formulas, I greatly improved the efficiency of the statistical and analytical part of the work I was responsible for, and did a good job of keeping and handing over the data templates to facilitate the handover of the work.
This is pretty good, but I don't understand all of it!
October 3, 2021
Want to progress faster?
Join this learning community and try out free exercises!