Tag: Automation
-
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…
-
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…
-
Supercharging Your Workflow: The Perks of Process Automation
Imagine if you could get more hours in your day. Sound good? Well, with a little work and time invested up front, that’s pretty much what process automation can do for you. By using tools like Excel Macros, Power Automate, VBScripting, and Python, you can hand over repetitive tasks to your computer, freeing up your…
Abstract Foundations 