Excel Genius

Who should get more credit, the person with the vision or the person with the ability to actually execute the vision? I feel like it should be at least equal, but lately I've been getting the shor… more

My coworker keeps asking me the most basic excel questions and I'm kinda tired of spending time in my day teaching them things they should already know. Would it be rude to send them some self-hel… more

Will anything better than Excel ever come, or is this the peak of humanity?

I've got a huge json file that I'd like to convert to excel. What's the cleanest way to do this? Do I need to run some Python?

How important is an internship for an accounting job/Degree? I work full time and go to school full time and I keep hearing that I HAVE to start applying soon? I don’t know if it’s even possible for m… more

Hi, I’m trying to bring in data that is in the middle of my data set but the issue is my data might change from day to day and entity to entity. Let’s say tomorrow or for another entity the data might be between row 199 and … more

Does anyone have a link to an Excel Assessment test?

Where can I get some fancy Excel gantt chart templates?

I am currently staying in Lusaka, Zambia.
Why is it that we cannot be engaged for Remote job in USA or other Countries,while staying in Lusaka Zambia?

I am able to do debt recovery and debt collection?

Anyone ever tried to convert a Google sheet with complex formulas into an Excel file? Is there a way to do this automatically without having to recreate everything?

There isn't a job in the world I can possibly want more than my old one.

Hopefully this will be useful to someone...today I tried to work out how to select specific cells on Sheet1, which after clicking the macro copies the equivalent rows on Sheet2 (only the data from col… more

I'm going to have to use Google Sheets for a client. It's my first time. Is it pretty much the same as Excel or am I going to face a steep learning curve?

When is it better to keep a file as csv as opposed to xlsx? I usually always convert but I've been wondering lately if there's any advantage to a csv file, particularly if I'm not making c… more

As of now, GPT is far from being as reliable or stable as people might think. When using GPT for Excel data analysis, you often run into strange errors. Large models still have a lot of accuracy issue… more

In early 2024, my company had a round of layoffs, and the business line I was responsible for got cut. I decided to leave on my own. With the economy the way it is, job security feels like it’s disappearing… more

I would really love to get some peoples' opinions on forecasting revenue in Excel (GROWTH/TREND/FORECAST/Moving Average/etc) and the circumstances when one option may be better than another?

This experience letter serves to confirm that I Hina held the position of Montessori teacher at different schools from May 1998 to November 2023. Throughout this period, I exhibited exemplary pedagogical skills and a profound comm… more

What’s the funnest or weirdest thing you’ve ever used Excel for outside of work, and did it actually work out the way you planned? I've been working on a fantasy football tracker with Excel, compl… more

I suck at Excel, so pls be gentle. I'm working on a document that has two worksheets (W1 and W2).

W1 will have a list of products and labor roles and respective prices for each.

My boss wants it so that when … more

Any MS Teams experts out there? Can't find a bowl for this. A client sent us a Teams meeting. I forwarded it to a 3rd party and all looked fine. He got an email with no information. I see organize… more

Can I make formulas auto-update as I add/update data in my spreadsheet? Right now, the only way I can make it update is by clicking into the cell and pressing enter.

Is there a way to format cells when using modern formulas such as 'unique' or 'sort'?
How you do you do it?
Also, I read about the 'pivotby' formula but can't seem to be able… more

What are some things you all do to handle really large datasets in Excel, and make them more manageable? I've got one I can barely open without my whole computer crashing.

Can someone please help me with my excel test 😭

Hello everyone,
I am very good at Excel and advanced Excel (Macro/ Power Query). I used to teach Excel to professionals in my country as a side hustle. I have now moved to Canada and I am thinking of starting it here as well… more