Excel Genius

Hi All,
Not super skilled at excel, but I'm looking for a way to pull the time difference between two columns that have date/time for a process start/finish point.
The purpose would be to calculate how long the… more

I've just started teaching myself VBA code for some forms I'm creating in Excel. For the pros in the bowl, how'd you learn and what are some of your favorite use cases?

I know this should be easy but I haven't had luck figuring this out online. I have a pivot table, in the rows I have Group name, in the values I have count of another column that marks tasks compl… more

hey guys, qq for my excel geniuses: i have an excel that heavily relies on another tab of data for a variety of automated calculations and analyses. If I need to update that tab of data or others, wha… more

I've noticed the last few days that Excel charts are acting differently. It is lumping columns together so that I can't choose individual columns to work with. Have any of you noticed this? … more

There are times when I copy something then try to paste it and it doesn’t paste. This happens when I usually delete something in between the two commands, but I notice it happens quite often other tim… more

What will get you farther as a data analyst - knowing Excel or knowing Python? I've seen both utilized pretty impressively.

I might expose myself as a non-genius but I've got to ask, what is ever the point of making a table in Excel. I find it annoying and useless.

What is wrong with this formula =if(>=threshold1,b2*yellow_high,=if(c2>=Threshold2,B2*yellow_low,”no action”))

Is there a capability in Excel that can create a new spreadsheet providing sums across the groupings and rows of a different sheet?

Anyone running compensation model in excel for couple hundred employees and expect 100% accuracy?

I'm building an Excel template for meal planning. Anyone else done that and willing to share tips? I want it to be as fancy as possible!

If I haven’t spent part of my day in Excel, did I even work? Why is it that unless I've been in a spreadsheet I feel completely unproductive lol.

If your manager sets up 2 excel spreadsheets to sync up in Sharepoint, and it takes more than 10+ minutes to save the file, what are your thoughts?

Is there any way to save a filter in excel? If not, can we start a petition to make this a thing, this would save me sooo much time.

How long did it take everyone here to learn excel? Also, what's the best way to truly learn how to properly use all of the functions?

Do you prefer Excel on Windows vs macOS? I use an hp laptop at work but theres constant problems with the laptop and software. IT doubled the memory capacity and it’s still experiencing little issues … more

Anyone ever had Excel stop performing functions due to a full memory? I've tried closing some files out, it's still not letting me edit :') oh happy day.

It's like some days VLOOKUP just doesn't want to work! I couldn't get it to pull the data, clicked in a bajillion times and then it just randomly starts working. I swear Excel gets an atti… more

Is there a job where I can just make new excel sheets or work in excel. I feel like this is my calling.

Really interested in learning more about Copilot for Excel and how it can be used for data cleaning and analysis? Any suggestions for courses/training?

How much of your job is looking at spreadsheets? Mine is about 70% at least.

Say I am done learning excel and I am pretty good at handling the basis. Which areas of specialization can i pivot to that will most likely be excel/google dependent?

P.S: I want a type of specializat… more

I'm trying to calculate the time between two activities.

The format in the cell is 01 02:52:12 representing day, hour, minute, second.

Is there a formating or easy step I can do so I can make the … more