Excel Genius

Excel on a mac is infuriating. I'm pretty sure the 7th circle of hell is people forced to build complex Excel spreadsheets using a Mac. Pure torture.

My job is willing to pay for an Excel course, I'm looking for a really robust training that covers everything from formulas and functions to Macros and VBA. Anyone have any good suggestions?

I understand this is an Excel Genius group but I need help. I want to perfect my Excel skills. I am still a new learner, how do I do that please? Thanks

Hi all. I'm looking for some career advice. I'm an Excel geek and spend my days using Power Query, Power Pivot and VBA to simplify and automate processes. My current role does not have many interesting pr… more

I need to improve my skills. Can anyone recommend . I need intermediate upwards.

Fellow needs 🤓, what's the best way to convert a folder full of .xls files into xlsx? Preferable if the solution can avoid VBA. Is Power Automate a possibility? Thanks!

What are the best resources for learning to write VBA macros for Excel? I’ve watched so many videos that teach the basics and then it feels like it jumps to super complex…

Anyone know a way to divide a list of teams and titles into groups where each group should have a max of 5 titles from teams where possible? There are teams with only 1 title and others with more than… more

Hello,

Is it common to set complex commission calculations for couple hundreds of employees in excel?

Thanks for any feedback!

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 … more

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 the… more

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 … more

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?

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… more

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 apprec… more

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

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 e… more