Interview Questions
Barksdale Control Products
Excel Analyst Intern

What experience do you have completing high level excel analysis?
In the Business Valuation project, my team was tasked with determining the intrinsic value of a company using financial data. I was responsible for data visualization, where I used Excel functions like Insert Charts and trendlines to illustrate key financial trends and assess the company’s performance. Additionally, I led the creation of a dynamic financial model to estimate the company’s value and determine a fair price based on projected cash flows and valuation multiples.
In a Creditworthiness Evaluation report, I worked with a dataset of 1,000 borrowers, analyzing their spending behavior. In this task, I mostly use Pivot Table to analyse different characteristics of borrowers. Moreover, visualize the boxplot and distribution to determine the outliers of the borrowers.
Barksdale Control Products
Excel Analyst Intern

What do you know about out Barksdale product line ( So in summary someone who know FLOW, PRESSURE, TEMPERATURE & LEVEL instrumentation)?
Barkdale specializes in a wide range of products, around 500 products family that monitor the flow, pressure, temperature, and level, which are essential for automation and safety systems in various industries such as transportation and industrial.
Examples of products include pressure switches, transducers, level sensors, temperature controls, and valves.
From what I understand:
Pressure instrumentation, like transducers, is important to prevent equipment damage.
Flow measurement is to ensure the efficiency and the flow of fluid, basically fluid control.
Temperature control is to ensure that the temperature is at the desired level. It is essential even in small restaurants and bakeries.
Lastly, the level sensor is to prevent the shortage and overflow of the fluid in tanks, for example.
Barksdale Control Products
Excel Analyst Intern

Can you provide an example of a report you created using Excel?
https://drive.google.com/file/d/16qPR2JmAKk-H9-gg_1hOQHD5nZXwbc8z/view?usp=sharing
These are two examples where I applied Excel to explore and visualise data effectively: Business Valuation Report: My team was tasked with evaluating a company's value. I was responsible for creating the data visualisations to support our conclusions, using Excel to present key financial insights clearly and professionally. Creditworthiness Evaluation Report: I worked with a dataset of 1,000 borrowers to identify patterns in their spending behaviour. While Excel was used for initial exploration and visualization, I also utilized R for advanced data manipulation due to the dataset's size. These experiences demonstrate my ability to leverage Excel—and complement it with tools like R—for analytical tasks, visual reporting, and business insights.
I am really excited about the position and really hope that my professional skills can be applied in the real business world environment like Barksdale Control Products.