Tag: save time
-
Unpacking Procedural Thinking & Pattern Recognition for the Modern Business Maverick
Recommended Listening: Ever found yourself stuck in a maze of spreadsheets, tangled in a web of processes, or running into walls in a labyrinth of strategic decisions? Fear not, dear reader, for the solutions to these modern business challenges might just lie in the toolbox of a programmer. That’s right, thinking like a coder isn’t…
-
Mastering the Game: Pattern Recognition and Process Mining in Your Automation Strategy
While our modern lives may not require us to track animals or predict weather changes, our brains continue to seek patterns in the environment, and not just in the physical world but also in the sphere of our daily tasks.
-
A Flexible Macro For Automating Report Export and Distribution
In today’s digital age, a significant amount of our time at work is spent processing and communicating data. For many of us, this often involves updating reports with new information and sending regular updates via email. The process can be time-consuming and repetitive, especially if we’re manually copying tables into emails or exporting and attaching…
-
Project 2 – Codename: ‘Whirlwind’: Twirling Through Excel to Conjure an Automated Data Storm
Recommended Song for this breezy project: Buckle up, data enthusiasts! Today, we’re going on a whirlwind adventure. We’re stepping away from the safe haven of our data centers and stepping right into… the heart of a tornado! Oh, no need to look so terrified – we’re not really going to put you in the path…
-
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…
-
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…
-
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…
-
Spelling It Out: Mastering Text Functions in Excel
Have you ever received a messy spreadsheet with names in ALL CAPS, or addresses all jumbled together in one cell, or perhaps product codes with extra spaces? That’s where Excel’s text functions come in. They’re the unsung heroes of data cleaning, helping you whip that wayward text into shape and save tons of manual (and…
-
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…
-
Power Query: Tell me you’re decent with Excel without telling me you’re decent with Excel.
Hello again, data enthusiasts! It’s time to get our hands dirty with some serious data crunching as we delve deeper into the powerful world of Power Query. In our last article, we touched on the basic features of Power Query. Now, let’s kick things up a notch and explore some commonly used options that can…
Abstract Foundations 