From Basic to V-H Lookup and Pivot
Data Entry Training with Microsoft Excel by Karier.Mu (Prakerja)
On 9 and 10 March 2024, I completed the Data Entry training with Microsoft Excel through the Pre-Employment program. The experience was amazing and provided deep insight into how Excel can be a powerful tool in data management and analysis.
One of the most important things I learned was the basic ability to use Excel to perform data entry efficiently. From understanding the interface to knowing how to format cells and columns, each step was clearly explained, ensuring that participants could start working with Excel with confidence.
The training also took me through a series of math functions, text data manipulation, and date functions in Excel. From simple addition to the use of complex statistical formulas, I now feel better equipped to handle different types of data appropriately.
One of the other highlight points was learning about logical formulas and lookup functions in Excel. This allows me to perform more sophisticated data analysis, with the ability to find patterns and relationships that may be hidden in the dataset.
However, the training was not only about Excel technicalities. I also learned the importance of data visualization using charts in Excel. This not only made the report more visually appealing, but also helped me to more easily understand and present the findings from the data I was working with.
The importance of using shortcuts in Excel was also highlighted. I learned how to save time and increase productivity by utilizing the right key combinations for common tasks. In addition, the training provided opportunities to plan and manage data report analysis with Excel.
With a better understanding of how to formulate relevant questions and interpret analysis results, I feel more confident in making data-driven decisions.
More importantly, the training taught me the importance of resilience and adaptiveness in the face of challenges in operating Excel. From small mistakes to bigger obstacles, this training strengthened my ability to stay calm and find solutions in the midst of difficulties.
Overall, the Data Entry with Microsoft Excel training has taken me through an inspiring and profound journey. I not only have stronger technical skills, but also a more resilient mental attitude to face the ever-changing world of data analysis.
I am very grateful for this opportunity and can’t wait to apply everything I have learned in my career going forward.
Thank you for reading my article :D
Links to assignments and projects I’ve worked on:
Assignments for Day 1 and 2:
Day1:
https://docs.google.com/spreadsheets/d/1D58lPGCqoU2IvXVqxEJwgjiahlR2V3YS/edit?usp=sharing&ouid=117533164033891869458&rtpof=true&sd=true
Day2:
https://docs.google.com/spreadsheets/d/1eiAHHr5Odkxd2pFNavD9tqrz-IAFaxZd/edit?usp=sharing&ouid=117533164033891869458&rtpof=true&sd=true