Excel Genius

HELP! Excel gurus, is there a way to allow filtering but turn off sorting on a worksheet?

Whenever a big project wraps up, I take a few minutes to add a “lessons learned” tab to the spreadsheet. Looking back, it’s become a surprisingly helpful tradition for tracking what worked and what to… more

Some of the best team moments have happened over a shared Excel sheet—late nights, snack breaks, and collective relief when we finally finished the budget.
Do you have any memorable stories of teamwork… more

Early in my career, I was nervous every time I opened a big Excel file. Now, it’s one of the tools that makes me feel most in control at work.

I recently built a dynamic drop-down where the choices update automatically based on another field, using the INDIRECT and UNIQUE functions. Super useful for forms and making data entry foolproof.
Anyo… more

I’m a big fan of Power Query for cleaning up messy datasets—removing duplicates, splitting columns, and even combining multiple files in a folder with just a few clicks.
What’s the most complex cleanup… more

I’m joining a CPG start-up as their first finance hire. I rarely built 3 statement models and budget models from scratch. I’ve been learning from YouTube. Does anyone know where else I could learn or … more

A while back, a teammate asked if I could help them with a tricky Excel formula. We ended up sitting together for half an hour, going over SUMIFS, conditional formatting, and some keyboard shortcuts.
B… more

Growing up, my family used an Excel spreadsheet to manage bills and plan out big purchases. Now, I do the same—and I’ve even added conditional formatting to spot overspending!

I once found an old Excel file from my first year on the job—a real trip down memory lane. The formatting was questionable, the formulas messy, but seeing how far I’ve come was surprisingly motivating

True story: I once nested so many IFs and ANDs in a single cell, even I couldn’t remember how it worked a week later. Had to draw it out on paper just to untangle the logic! hahaha

On stressful days, I secretly enjoy cleaning up a messy dataset—removing duplicates, fixing typos, and getting it all to line up. Weirdly therapeutic!
Does anyone else find spreadsheet cleaning oddly s… more

Some people think you need to be a math whiz to use Excel, but honestly, logic and curiosity go a long way.

If Excel granted you one wish—any feature, any magic button—what would it be? Mine: automatic, one-click data clean-up for messy imports.

my Excel pet peeve is when people leave endless blank rows in a file.
What’s your biggest spreadsheet annoyance? Let’s vent together!

Not a very analytical person tbh, but a lot of roles require advanced excel and dashboard visualization/reporting skills. Are there any free courses that can take me from beginner to advanced quickly (not sure if this … more

How often do folks here use boolean logic with sum product to move information around? Wondering what are the common use cases for modelling/data analysis, or if it's worth getting familiar?

Last week I used Excel to help a friend plan a wedding—guest lists, meal preferences, the whole nine yards. I have to say, I'm pretty satisfied with the final product!

I can’t be the only one who double-saves every five minutes, just in case. Old habits die hard!
Do you have any quirky spreadsheet superstitions or habits? :)

Is it just me, or does every big project end up with a dozen tabs labeled “final_v2”, “final_final”, and “USE_THIS_ONE”?
How do you organize your Excel files so you know what’s what? Any naming hacks?

I use Excel for more than work—like tracking travel budgets and even my gym progress.
Does anyone else use Excel for non-work stuff?

If you could invent any feature for Excel, what would it be? I’d love an “undo last sort” button for those moments I panic after accidentally reordering everything

Hot take: Merging cells is the pineapple-on-pizza debate of Excel. Some swear by it, others say it ruins everything. -_-

Every Monday, I start by color-coding my spreadsheet tabs—it’s my weird way of getting into the zone. Does anyone else have little rituals or habits that make working in Excel feel a bit more… fun?

CV says "advanced Excel": SUMIFS, pivots, and charts.

Excel test in the interview and so many candidates could not even do a SUMIFS (1 man not even able to do so using the formula help window...)
more

Does anyone have a good workout excel template?

Has anyone developed a dynamic dashboard where users can select multiple criteria from dropdowns (not just one), and the underlying data, charts, and even conditional formatting update in real time without relyin… more

There’s nothing quite like whipping out a quick formula during a meeting and hearing someone say, “Wait, how did you do that?” 😁😁

Worth picking up power query? Have a couple of days on bench and thinking of taking up a course. Any folks here find value add in PQ?

My brother and I created a slightly above beginner Excel course designed for accounting/finance professionals. We focus on building Excel intuition, mastering hotkeys, and functions.

We’re looking for a few people to test drive the course, give us h… more

Ok…. I’ll admit it: I once spent 30 minutes hunting for a #DIV/0! error… only to realize I forgot to drag down the formula.
Excel keeps you humble.

Anyone else have a classic spreadsheet slip-up

There’s nothing quite like getting a massive spreadsheet to finally balance out after hours of head-scratching.
Small win? Maybe. Satisfying? Absolutely.

What’s your favorite “tiny win” moment in Excel

Turning raw data into a clear chart can change how a team thinks about a problem.
What’s your go-to chart for making numbers easy to understand in Excel?

Bar chart, pie chart, scatter plot—or something … more

Excel teaches you to think step-by-step.
It’s less about math and more about logic, structure, and creativity.

What has Excel helped you solve that surprised even you?

Odd question

Would you rather give up VLOOKUP or Conditional Formatting forever?

Tough call, I know. One helps you find meaning, the other helps you make it pop 😂😂

How do we go from data to decision faster using Excel?
How can we make formulas more understandable, and dashboards more actionable?

Would love to hear what others are exploring!

Playful & Punchy
Got Grit & Giggles?
Brainy. Bold. Ready to shake things up?
We’re cooking up something epic and need save minds who love fast rides and big wins. If you live for that “aha!” mome… more

Bold & Energetic: Smart. Ambitious. Impact-oriented. Sound like you?
We’re building something big and looking for talented minds to help drive it forward. If you’re passionate, fast-moving, and wan… more

Just wanted to share a fun Excel moment as part of the Excel Genius Bowl! Last year, I spent way too long trying to figure out why my VLOOKUP formula wasn’t working—only to realize my lookup column ha… more