Excel Genius

I am going through some old data in a GL account without a lot of background and a fairly large list of transactions. Is there anyway excel can “help me” figure out which of these transactions sum to ...

My husband started a little business. I want to begin spreadsheets to keep track of customers, jobs, invoices, expenses, and income. I started a couple but I'm sure there is a better way since they ar...

What is something you do in Excel that you think will save you time, but ends up taking wayyy longer than expected?

VLookup not working, getting N/A even though serial number value exists on lookup table, which is in a different workbook. Already did text-to-columns on all serial numbers on both workbooks and both ...

Excel now with regular expressions! I rarely use them in code, dreading playing around with something to get the parsing just right. As for why it is included, why not!? https://hackaday.com/2024/05/2...

How do you input this in excel? Mean: 875 Std Dev: 55 What is the probability if the mean is 910? Im using =norm.dist() formula and getting 73%. Is this correct?

What is your favorite Excel shortcut?

What is the worst feature of Excel?

What makes you choose Microsoft Excel over Google Sheets?

Today I learned that Microsoft has an official link for shortcuts in excel:

A huge thank you to you all for helping me achieve this major milestone. If it weren’t for you all, I wouldn’t have earned this badge

I have a pivot table based on a set of sales data. Values are summed correctly for the order (freight, tax, fees, etc). I need to add a column or calculated field on the pivot for quantity. I want qua...

Having some trouble with vlookups and pivot tables. I haven't used them in a few years and I'm very rusty, but seems like most companies want that experience now. Help with this is much appreciated. T...

What processes/ reports can typically be automated using excel? I’m in FP&A and there is a lot of manual/ tedious work and looking to automate some stuff.

Trying to use Ctrl + [ in current excel to trace formula dependents (and F5 to return back to where I was) but for some reason it’s taking me to some random tab. Never had an issue using this before. ...

I'm being pressured to switch to Google Sheets for collaboration, but my heart belongs to Excel. Is it worth resisting, or should I just embrace the change? What are the pros and cons you've experienc...

How do I get rid of this STUPID menu bar that pops up every time I open excel? Was messing around with settings and somehow this became permanent…tried googling and everything to get it off and no luc...

I have 100+ forms that I need to combine data from into a master sheet. For example, a question on the form says “what is your favorite food” and the respondent would type in their food into cell B2. ...

Does anyone have a good way to share a power pivot report with a Mac user? I’ve tried using excel online with sharepoint but the performance is abysmal and the query is not supported, so updates are m...

A big debate in the office: tabs at the bottom vs. tabs at the top of a workbook? This feels like it could escalate into a full-blown war. Is there a clear winner here?