Excel Genius

Hey everyone! I love being part of this bowl. I often see easy questions and loveeee helping out, but I always add in my reco of trying ChatGPT too because it’s incredibly useful. Here are some ways I leverage it, and I’d love to hear your ideas too!

1. Formula Help… more

I need a really good project plan spreadsheet that provides a gantt chart for all the task items, anyone know a website that provides free templates?

Could I get some help with creating a custom Excel sheet?

I have to track the number of hours people are working but within the hours worked, 50% has to be in a certain location.

Hello guys,
I have excel assignment tomorrow for my Business Analyst role at Massachusetts Bay Transportation Authority. Can anyone help me with this that how the test will be and what they are going t… more

Is there any way to make a pivot table auto-update when you add data to the sheet it's using? The only way I seem to be able to add the new rows is by deleting and recreating...there's gotta b… more

How can I tell the filter formula to look data after a blank row while looking down a whole column?

I do not want to have the set a range, I want it to look down the whole column and bring the data after the first blank row. … more

I don’t have anything to share rn, but I need 11 likes to DM someone on here. Any help is appreciated! 🙏

Please has anyone had to use Power Automate to create flows on Excel?

I’m trying to create a workflow that sends an email when items are created on excel. Any ideas?

I’ve been stuck on an excel issue and I can’t seem to get it sorted out, tried YouTube, google, etc. I’m trying to run a PV calc on excel but I keep getting a different answer than my financial calcu… more

I’m having an issue where my excel workbooks are almost doubling in size. I have a master workbook that produces consolidated company reports (12 tabs) and 12 more tabs that populate based off a selec… more

What are some good resources for making dynamic dashboards in Excel? Or would PowerBI be the way to go? I'm looking at a small dataset so I figured Excel could work just fine.

Anyone affected by the IT bowl? Excel is down for the whole company here.

Can someone refer me to a sql bowl?

What are some unique applications of conditional formatting y'all have tried? I made a pretty cool checklist that updated according to the task's completion percentage.

Does anyone know how to make a FILTER formula that would bring any data from a column if the first 3 letters match “abc” or the first 4 letters match “abcd”?

It seems like you cant use the LEFT formul… more

What is your favorite excel add in?

What do you guys use excel for in your personal life? Besides budgeting because, duh.

When are we going to see GenAI for Excel? I'm done with these formulas lol.

Any way to collapse the content of several cells into the top cell in a selected range?

I'm converting PPT tables to Excel, but any table cell with multiple lines gets copied over as multiple excel… more

How do y’all return a deduped list? I either paste special and remove duplicates, or use a combination of UNIQUE and FILTER.

Client had provided an updated data dump PnL for 100+ assets with the quarters of each year going in descending order. I have built my working sheet in ascending order. Instead of redoing a new worksh… more

What’s the most complex formula or function you’ve ever created in Excel?

Quick question: our GM makes 4% of NI. Net income changes once his commission is posted. I had an algebraic formula to calculate early in my career. I now calc by reducing NI by incremental perce… more

Does anyone know how to consolidate data from several Excel files, please?

Can anyone help me with margins when printing in excel? No matter how hard I try or what I look up, I can’t seem to get rid of white space on the left and bottom when I’m printing.

I’ve tried putting e… more

A committed and seasoned professional specializing in Administrative & Executive support for 7+ years. I regularly provide Management, Coordination, Administration, and Events and Conference servi… more