Category: Foundational
-
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…
-
Bridging the Gap: How Mastery in Excel Sets You Up for Success in Programming and Automation
This piece will be more reflective than our typical content, because it ties heavily into why I’m writing these posts in the first place. I was fortunate to have someone help me get started (though he still denies he did much; you know who you are) in the world of reporting and automation early in…
-
Data Organization Basics: Key Concepts in Data Management for Effective Modeling
Greetings, fellow data lovers! Today we’re stepping away from the nitty-gritty of Excel and diving into the broader realm of data management. Let’s explore the key concepts of finding, cleaning, and organizing data to streamline modeling, enhance performance, and future-proof your data systems. While most of the terms here come from the more technical side…
Abstract Foundations 