I’m interviewing for a pricing analyst role and I’d love some tips on what they ask in both the Excel practical and interview. Any advice would be great. Thanks.

I’m a finance guy who’s had too many awkward talks with bosses over KPI/Total errors in my reports (probably missed a promotion or 2 because of it).

Felt exposed given how important numbers are in the job, so I built an iOS a… more

Help! What are some good automation/AI tools that integrate with Excel?

New client requires every chart to be in native Excel. I'm used to having our Analytics team make Tableau dashboards. Can anyone recommend a tool (we… more

Excel power users wanted 📊
There’s a short-term, remote AI training project with a top-tier research lab looking for advanced Excel users. Work involves realistic spreadsheet tasks (PivotTables, formulas, charts, Automate/Re… more

What is the best AI to use for updating VBA? I’m not familiar with VBA, so I’ve been using ChatGPT 5.2 Thinking to help me update some old macros, but the response time and results have been disappoin… more

How many transitioned from excel experts to experts in other tools? what tools you learned were the most impactful and useful?

Not sure if this is nerdy or genius, but I track my workouts in Excel. Sets, reps, progress graphs… it’s oddly motivating to see my own “dashboard” of gains.

True story: I once deleted a column I desperately needed and only realized after saving. Cue the heart-stopping panic. Luckily, version history saved me. 😂😂

I love Excel but man… when a file takes forever to open, I start questioning all my life choices. Has anyone figured out a good way to keep files lean when they get huge?

Why is Power Query so terrible at converting an image (of a table of numbers)!?

Even high resolution images don't seem to make much difference. Decimal points are missed, the thousand comma separat… more

I know with the RANK function it will provide the same ranking to duplicated numbers. How could you bypass that? I’ve tried using IF and it breaks.

It’s funny—Excel is just cells and formulas, but the impact is always about people. A cleaner report means less stress for a teammate. An automated tracker means more time back for someone’s day.

Has E… more

The more I work in Excel, the more I see it as a storytelling tool. Behind every chart or dataset is a story waiting to be told—sometimes about performance, sometimes about people, sometimes about progress.… more

Looking at old spreadsheets sometimes feels like time travel—I can see past projects, old budgets, and even how my skills have grown. Some of those formulas make me cringe, but they also remind me of progress.more

If my last workbook could talk, it would probably say: “Stop overcomplicating me with all these nested IFs!” It made me laugh to imagine my spreadsheets having personalities.

If Excel could talk back t… more

Hey have anyone ever had an Excel mistake that ended up teaching you something valuable?

Not long ago, I showed a coworker a shortcut in Excel that cut their task time in half. Seeing their excitement reminded me how small tips can make a big difference. Sometimes the best part of knowing Excel isn’t… more

If you had to describe your Excel style—are you the minimalist (clean sheets, few formulas), or the architect (complex formulas, hidden sheets, dashboards)?

Which type are you, and why?

The first time I discovered PivotTables, I remember thinking, “Where has this been all my life?” It completely changed how I look at data. 😀

What was your biggest “aha” moment in Excel where something… more

When I build reports, I always struggle between including all the details and keeping it simple enough for people to actually use. Sometimes I feel like I either overwhelm my audience or leave out something… more

I love building dashboards in Excel, but sometimes I get stuck making them both functional and simple enough for others to use. Too many buttons and drop-downs can overwhelm people.
What’s your approac… more

I’ll admit—sometimes I spend too much time making a spreadsheet look “just right.” But when different people format things differently, it quickly turns messy again.
How do you balance clean formatting… more

My coworker is working with datasets so large that scrolling and filtering feels like an endless task. I know there are smarter ways to handle big data, but it’s easy to fall back on manual steps.

What… more

Sometimes I’ll double-check a spreadsheet that looks fine, only to realize there’s a hidden error buried in a formula or a reference to the wrong tab. It makes me wonder how often things slip through unnoticed.more

One of my dashboards is full of long, nested formulas, and troubleshooting them is becoming a nightmare. I’ve started breaking them into helper columns, but it’s still hard to maintain.
What’s your str… more

Anyone have an experience creating a scorecard in excel? End goal is to have a red amber green status tie to a main group which is comprised of statuses of the sub groups. Appreciate any suggestions t… more

Lately I’ve been dealing with an Excel file that’s gotten so large it takes forever to open and save. I’ve tried reducing formatting and moving some data into separate sheets, but it’s still slow.

Has … more

For a charity event, I used Excel to track volunteers, shifts, and supply lists. It wasn’t about calculations—it was about keeping everyone organized and on the same page. It reminded me how flexible Excel can be… more

Not long ago, I realized I was spending way too much time manually updating status trackers. Learning how to link data across sheets and automate calculations with formulas was a total game changer for my w… more

Working with a teammate on an Excel dashboard taught me the value of asking questions and sharing tips. I learned shortcuts I never would have discovered on my own, and we finished the project faster than e… more

I’m using VLookup to compare two lists and for some reason it does not return any values. Instead I just see the formula. No error pops up either. The same formula/logic works on other sheets. What co… more

Last week, I spent hours troubleshooting a stubborn formula—only to realize I’d made a tiny typo. It was frustrating at the time, but finally getting it to work felt like a huge victory. It’s those little moments… more

When I started my career, opening a complex Excel workbook used to make me break out in a sweat. These days, I actually look forward to diving into large datasets and tackling tricky formulas. It’s funny how the … more

Merged cells in shared workbooks drive me up the wall—why do people do this to us?!
What’s your biggest Excel pet peeve? Get it off your chest!

Unpopular opinion: VLOOKUP is overrated—once you try XLOOKUP, there’s no going back!

Some of my best Excel tips have come from team chats, friends, and even internet forums.
Who taught you your most valuable Excel trick?

Ever had an Excel file crash on you right before a big deadline? I’ve definitely learned the importance of autosave the hard way!
What’s your wildest Excel save-or-crash story? How did you recover?