In today’s increasingly competitive business environment (made even more challenging due to COVID-19), securing a job offer has become extremely difficult. The pandemic has caused the loss of many jobs at all levels, further fueling competition. The key in a crowded field of interviewees is to differentiate yourself from others. One great way is to tout your skills, a critical factor for most employers. In many roles, one of the most important skillsets is the Microsoft Office Suite, specifically Microsoft Excel. Proficiency with this software can be critical to navigating the interview process and securing a job offer.
Questions they might ask
Interviewers could ask you about functionality in Excel. This might include experience using specific functions and/or formulas such as: how the $ symbols are used across data sets in Excel? What is VLOOKUP? What does a pivot table do? Be ready with short, accurate answers to help you stand out among most prospective employers.
A simple explanation for each is as follows. The $ symbol is used to lock absolute references in place, which is important for certain types of calculations. VLOOKUP is a function that allows you to search for specific data points across large sets to draw specific insights. A pivot table is an essential tool to summarize, aggregate, reorganize, sort, group, count, average, or compute segments of data sourced from a much larger dataset. All of these topics are covered in MST’s Excel curriculum.
Excel knowledge, specifically around formulas, functions and terms is important to gaining a valuable advantage in the interview process. Whether you are learning about this material for the first time or have a base understanding and would benefit from a refresher, there are many resources at your disposal. You could easily watch videos on YouTube. However, most are taught by techies so they may not be easily understood by all viewers. Many learners fare better with live classes rather than pre-recorded lectures. It allows them to ask questions directly and interact in real time with a teacher. An effective teaching methodology and compelling instructor can make all the difference. Whatever path works for you, choose it sooner than later. It may just help you get the edge for that next job.
(Guest post by Jordan Barry, former MST intern)