Excel Genius

Am I crazy and or inept or is power query absolutely horrible? It locks down the entire excel instance while open, uses not one but two Microsoft proprietary “coding” languages, the built in ETL tool… more

I have a GenAl work problem. I have a bunch of large unique data sets coming in through an API. I need to be able to send the data to someone, potentially through a GPT, which will allow the user to a… more

Has anyone been using the ChatGPT Add In for Excel?

What have you used out for?
Anything that’s been working well for you?
Is it worth learning?
Any tips using the ai formulas?
What’s your fave ai.____ for… more

What are the best resources for learning excel? I'm not great at it, but my promotion definitely requires me to be better.

Anyone know how to quickly remove page break lines? It seems like I can turn them on for every instance of excel with one button but turning them off is tedious

"Just a quick update to this spreadsheet" are the most dangerous words in the English language.

Is there a formula that sums cells based on if they are highlighted? I’m tracking when material gets delivered and I highlight each delivered quantity as it completes. In a separate cell, can I do a f… more

Hello All, I am currently working on a spreadsheet that will paste data from specified fields within a pdf document. For example, I am interested in using VBA to extract specific data (such as name, … more

Office debate: Gridlines or no gridlines? This is serious business.

Anyone know of/have the alt + F12 macro that brings up all tabs in a searchable format instead of right click and scrolling or something similar?

Q: what's the excel addin called that has a built in hierarchy analyzer? I.e. To analyze span of control etc. Can't seem to find it on Google

Interviewing for a new job that sounds heavily Excel-based. Any red flags I should ask about to avoid another soul-crushing spreadsheet grind?

Sometimes I watch those insanely fast Excel competition videos and have a full-on existential crisis about my own skills. Anyone else?

I'm new on the team and inherited some of the ugliest spreadsheets I've ever seen. I've been trying to decipher them all day. Is it rude to ask the previous person to walk me through them … more

Any lead to Job related to data analysis or any would be of great value. I believe I am good with Excel or can learn very fast. I am in high need of JOB. Preferred location Charlotte, North Carolina but not limit… more

Best source to learn excel shortcuts?

Starting business school in the fall and my personal computer is a Mac. How can I download windows for Mac? Is it worth it?

Best free resources for learning the ins and outs of Excel?

My PivotTable is acting WEIRD. The same data keeps showing up under multiple categories and the groupings make no sense. What am I doing wrong?

Does anyone know the Microsoft Access version of Excel’s Control + Shift + [Arrow]? I have 550,000 rows to delete and I cannot figure out how to select them all to do so - other than just scrolling 🥵

Is there an unspoken rule about how many different fonts you can use in a single spreadsheet? (It's one, right?)

Is Python really taking over the MS-Excel space?

Any recommendations for excel classes or helpful courses I can take to round out my excel knowledge? Tired of bothering the ladies in accounting every time I need to make something.

Favorite way to use Excel that is complete overkill for the task or project?

What's the easiest way to remove all text from number ?

Ok excel geniuses, help me Obi Wan Kenobi you're my only hope. I hate charts and graphs, it's my one Excel kryptonite.

I've taken classes and can follow the sample file exercises OK but when I try wit… more

I have a pivot table with categories and subcategories in my Rows. I'm trying to do a top 10 breakdown for the subcategories. Usually not an easy issue. Problem being is that some of the subcatego… more

Help please!

How can I create a sign up sheet through excel that has the following :

Calendar with drop down of the day(s) they would like to select in each day in the calendar
Different drop downs for each team … more

Is Analyst basic Excel? If u know excel would u be able to do Analyst?

I would like to monitor my stock portfolio automatically.
I read it's possible using Google sheets + Google finance, but it doesn't have all the ETFs.
Does anyone know about an alternative always using Google s… more

I read that you can create QR codes in Excel. Does anyone have experience doing this? I'm looking for a quick guide or reference to help. TY!

Does anyone know of any website where you can get a part-time job doing programming/data analytics/Excel? Interested to earn some money but also to develop these skills

Does anyone know offhand which web hosting sites are the easiest to integrate with Excel?

Why is the date format never what I need it to be? 😫