Before Python, SQL & Power BI... There was Excel. 📊

Nelly Triza — Tue, 30 Jun 2026 16:53:13 +0000

Most people think data analysis starts with Python, SQL or fancy dashboards.

Mine started with an Excel spreadsheet.

At first, Excel looked like a grid full of endless cells. Then I realized something: every cell tells a story. Sales figures tell you what customers love. Expenses reveal where money quietly disappears. Employee records uncover performance trends. The data has always been speaking. Excel simply taught me how to listen.

As an accountant transitioning into data analytics, Excel became my first language. It taught me that data isn't just numbers on a screen. It's information waiting to answer business questions.

A few examples:

Human resource data helps answer the following:

Who are our top performers?
Which departments have the highest turnover?
What does our payroll look like?

Sales Data answers:

Which products sell the most?
Which region generates the highest revenue?
Are sales growing or declining?

Procurement data reveals the following:

Where are we spending the most?
Which suppliers offer the best value?
How can we reduce costs?

Finance data helps businesses understand:

Are we making a profit?
Is our cash flow healthy?
What's our financial position?

And it all begins with a few simple formulas.

SUM() totals your numbers.

AVERAGE() finds the mean.

MIN() identifies the lowest value.

MAX() finds the highest value.

COUNT() tells you how many records you have.

IF() helps you make decisions based on conditions.

SUMIF(), COUNTIF(), and AVERAGEIF() let you analyze data using specific criteria.

Simple? Yes.

Powerful? Absolutely.

Once you understand these building blocks, you'll discover tools like pivot tables, XLOOKUP, charts, conditional formatting and dashboards that transform thousands of rows into insights decision-makers can actually use.

I've learned that data analysis isn't about memorizing hundreds of formulas.

It's about asking better questions.

The formulas are simply the tools that help you find the answers.

This is the start of my Excel for Data Analysis series, where I'll share practical Excel skills using real business scenarios. Whether you're an aspiring data analyst, a student, or someone looking to sharpen your Excel skills, I hope you'll find something useful along the way.

Every expert once stared at a blank spreadsheet, wondering where to begin.

What's the one Excel function you use so often that your fingers type it before your brain catches up? Mine has to be XLOOKUP() and SUMIFS(). 😄

From Ledgers to Learning Models: Why I'm Starting a Data Science Journey

Nelly Triza — Sun, 28 Jun 2026 16:44:58 +0000

In the 21st century, standing still is the fastest way to fall behind. You either keep learning or you slowly become obsolete.

I'm an accountant by profession. Numbers have always been my language, whether they're in financial statements, tax returns or spreadsheets. But curiosity has a funny way of refusing to stay in its lane.

So, despite a full-time 9 to 5, I enrolled in a data science bootcamp.
Balancing work and learning hasn't been glamorous. It has meant late nights, early mornings, and more coffee than I'd like to admit. There are moments when concepts feel impossible and others when a single line of code finally works and suddenly everything feels worth it.

I'm under no illusion that this journey will be easy. But growth rarely is.

What excites me most is that data science sits at the intersection of logic, creativity, and problem-solving. As someone who has always loved numbers, it feels like a natural evolution rather than a complete career pivot. I'm not leaving accounting behind. I'm expanding what I can do with it.
Through this blog, I'll be sharing the wins, the setbacks, the projects and the lessons I learn along the way. If you're switching careers, learning while working full time, or simply curious about data science, I hope you'll find something here that resonates with you.

Here's to becoming a little better every day.

The girl with a dream of becoming a jack of all trades... while mastering a few along the way. 🌱📊💻

DEV Community: Nelly Triza

Before Python, SQL & Power BI... There was Excel. 📊

From Ledgers to Learning Models: Why I'm Starting a Data Science Journey