Beyond the Spreadsheet: How My Lab Background Taught Me Marketing Strategy

blog beyond the speadsheet

Starting something new is always a humbling experience. Whether it is a new job or a career pivot, there is a specific feeling of being at “level zero.” Even if you bring a solid foundation of skills, there is always a new perspective to learn.

I recently experienced this shift while working on a data analysis project for an e-commerce brand called L’Acier. On paper, the task was familiar: use Excel to analyze performance data. But as I sat with thousands of rows of traffic and conversion metrics, I realized that my long history with Excel was only half the battle. The real challenge wasn’t “how” to use the tool—it was “how” to think like a marketer.


The Evolution of a Skill: From High School to the Lab

My journey with Excel started early. I attended a business-focused high school where certification was mandatory. At the time, I learned the mechanics: how to build a table, how to format a cell, and how to create a basic graph. But back then, I only learned “how to use” the software; I hadn’t yet learned how to actually read and analyze what the data was telling me.

The real transformation happened later, during my time in a bioscience technology program. I specifically chose a high-intensity, two-year “hands-on” college because I wanted to avoid the fluff of traditional three-year degrees. Our days were split between the lab and the classroom from 8:00 AM to 4:00 PM, with a constant focus on a practical curriculum and hands-on training.

In that environment, Excel became a necessary tool. We weren’t just practicing; we were entering raw data from experiments every day. This was where I moved from simply “using” Excel to performing actual data analysis. I learned that data is the key to obtaining and understanding results.


The Missing Link: The Stakeholder’s Perspective

When I transitioned into professional work, those analytical skills were my greatest asset. I could run a process, enter the results, and analyze the final outcome. However, I soon discovered a major difference between school and the professional world: the presence of a stakeholder.

In school, you submit a report with a conclusion, and that is the end of the transaction. In the workplace, my role often involved solving problems for others. Depending on the situation, this might mean optimizing a system, identifying the root cause of an issue, or making suggestions for improvement. The goal of the analysis wasn’t always the same; it depended on what the stakeholder needed.

Even with that background, I hit a wall during this recent marketing activity because I didn’t yet have a marketer’s perspective. When looking at L’Acier’s performance data, I had to ask myself: “Should I focus on improving the areas where performance is lower, or try to make the high-performing areas even better?”.

 

Learning to “Make the Stars Brighter”

Through this project and by comparing my work with the example insights, I found a common tendency in this industry: make the stars even brighter.

In a lab, you often focus on the outliers or the failures to figure out what went wrong. I learned that in marketing, the most valuable place to invest time and money is often where you are already seeing success. It’s about finding a high conversion rate—like the 14.62% I found on Tuesdays—and identifying it as a prime opportunity for growth. This was the “business logic” I gained through the activity.

 

Why My “Old” Skills Matter for My “New” Career

This experience reminded me that no skill is ever truly wasted. My years of entering experimental data into spreadsheets gave me the technical “muscle memory” needed to handle complex marketing sets without getting overwhelmed.

The technical side, using the Pivot Tables, the conditional formatting, and the COUNTA formulas, as examples from this project, has become second nature. But the ability to look at those results and translate them into a budget recommendation that solves a stakeholder’s problem? That is the new skill I am most excited to develop.

While the L’Acier project allowed me to apply my analytical mindset to the world of digital marketing, it also taught me that although the “what” (the data) is important, the “so what?” (the strategy) is where the real value lies.

 

 

Check out the full breakdown of my analysis and the specific budget recommendations I made for L’Acier in my latest case study: [Optimizing Ad Spend Case Study here]