I recently transitioned to a new role. I went from doing system work to a system analyst for financial systems. Let me say it is a whole new world. Think accounting, but with data tables. Nevertheless, I found the transition relatively easy, in part because of the experience I gained in my previous jobs. During that time, my most commonly used tool was Excel.
Now, Excel and I have a bit of a love-hate relationship. It’s been my go-to tool for years, helping me make sense of endless rows of data. Just when I thought I had seen it all, Microsoft decided to keep things interesting by adding some new functions that are surprisingly useful for data analysis. I’m talking about LET, FILTER, and RANDARRAY.
Ever look at a formula you wrote and wonder what you were even trying to do? Yeah, me too. That’s where LET comes in. It’s like giving your formula a set of instructions before it gets down to business. You can define variables within the formula itself, making it cleaner and way more readable.
For example, instead of typing the same calculation five times, you can define it once with LET and use it multiple times. It’s a game-changer when you’re trying to create formulas that don’t look like ancient hieroglyphs. Plus, it’s faster because Excel only calculates the expression once.
You know that feeling when you’re looking at a massive dataset and just want to see the entries that actually matter? FILTER is your new best friend. It allows you to select specific rows that meet your criteria, all while preserving your data integrity. Think of it as a sieve that only lets through the data you need.
It’s like the good old IF function but on steroids. Need a list of all transactions over $1,000? Done. Want to filter out outdated records without creating a whole new worksheet? No problem. Once you get the hang of it, you’ll wonder how you ever managed without it.
Sometimes you just need a random number. Sometimes you need a whole random list. That’s where RANDARRAY comes in. Instead of hitting F9 until you’re blue in the face, you can now generate an entire array of random numbers in one go. You specify the number of rows and columns, the minimum and maximum values, and whether you want integers or decimals.
I know, at first glance, it might seem a little niche. However, consider testing formulas or generating sample datasets for analysis—it’s convenient. Plus, it’s a lot of fun when you’re bored and want to create some chaos in a spreadsheet.
These new functions might not seem revolutionary at first, but they’re powerful tools that make Excel feel a little more modern and a lot more efficient. If you haven’t tried them yet, give them a shot.
Please let me know if you would like more tips or examples on how to utilize these functions effectively. Below will be a list of content creators I recommend to help you take your Excel skills to the next level.
No posts
Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.