bowl image

Excel Genius

Discussions, Useful Tips, Resources, Macros, More

231.6K members
  1. AVG

    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.

    1
  2. Manager

    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 th...

    read more
    3
  3. Senior Associate

    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 anyon...

    read more
    2
  4. Associate

    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, form...

    read more
    5
  5. works at Deloitte
    First time poster

    For those of you that are trying to get more consistent with using shortcuts, checkout https://excelshortcutcoach.com

    8
  6. works at PwC

    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...

    read more
    3
  7. works at CohnReznick

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

    4
  8. works at TaxCentric

    Anyone using tryshortcut.ai its quite something!

    6
  9. Business Analyst

    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.

    10
  10. Business Analyst

    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. 😂😂

    10
  11. Business Analyst

    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?

    9
  12. works at Boston Consulting Group

    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 separator...

    read more
    3
  13. Business Analyst
    image attached to post
    15
  14. Senior Sales Manager

    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.

    4
  15. Business Analyst

    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...

    read more
    8
  16. Business Analyst

    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 pro...

    read more
    6
  17. Business Analyst

    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 ...

    read more
    4
  18. Business Analyst

    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...

    read more
    4
  19. Business Analyst

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

    3
  20. Business Analyst

    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...

    read more
    11