-
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
-
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 Read more
-
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 Read more
-
Making Data Pop with Conditional Formatting: For when there’s…. not… a chart for that.
Ever stared at a spreadsheet full of numbers, struggling to make sense of it all? Don’t sweat it; we’ve all been there, and sometimes the summarization provided by a chart just doesn’t work. Enter Excel’s conditional formatting, a feature that can turn that number jungle into a beautiful, comprehensible garden. We’ll be focusing on Excel Read more
-
Charts, Graphs, and Plots, oh my! Choosing the right visualization for the story you want to tell.
Data visualization is an art and a science, combining aesthetic design with statistical accuracy to tell the most compelling story of your data. Whether you’re tracking quarterly sales, forecasting weather patterns, or just trying to make sense of your monthly budget, the right chart or graph can make all the difference. So, let’s delve into Read more
Abstract Foundations 