-
Project 1 – Codename ‘Deep Below’: A User-Friendly Voyage through Excel, Power Query, and Power BI
Ahoy there, fellow data sailors! Recommended song for this project: “Sleeping in the cold below?” Not us, not today. We’re about to set sail on an adventure as exciting as any sea shanty, with a treasure more valuable than gold doubloons: data. Yes, my brave companions, today we embark on a journey that spans the… Read more
-
Heart in the Machine: Emotion, Empathy, and Their Unforeseen Role in Automation
I can neither confirm nor deny that I may have botched the scheduled publication time of today’s post on VBA… But in the spirit of consistency, I still wanted to get something fresh out for anyone who may be reading in the evenings after work. In the spirit of full disclosure, I am the type… Read more
-
VBA for Excel: Unleashing the Power of Automation
Hello, and welcome back! Today, we’re venturing into the magical realm of Excel automation with a look at Visual Basic for Applications (VBA), the programming language that turns Excel from a simple spreadsheet application into an automation powerhouse. Quick note here – I typically use VBA in this setting, as it just fits better with… Read more
-
Excel Beyond Excel: The Power of Power Query
Today’s businesses thrive on data. Data is being produced at an unprecedented rate and comes in almost too many different formats, from different sources, and with varying levels of quality. As a result, extracting useful information from this sea of data can sometimes feel like looking for a needle in a haystack. This is where… Read more
-
Pivot Tables: Your Personal Data Cruncher
Data. In our modern world, it’s everywhere. With the increase of digitized information, we have access to more data points than ever before. And Excel is one of the most popular tools for dealing with this data. But as any data analyst can tell you, large datasets can be a double-edged sword. Yes, they hold… Read more
-
A Step Deeper into Excel: Mastering Lookups and Logical Functions
Hola, data enthusiasts! Ready to venture deeper into the world of Excel lookup and logic functions, and take a look at why they’re some of the most commonly used tools in the business? We’re taking a journey today through the landscape of Logical and Lookup functions. While logical functions allow us to have some control… Read more
Abstract Foundations 