Excel Genius

What specific resources do you recommend to learn pivot tables well? Any specific YouTube videos, or anything else?

How can I get better with my excel skills? Is there a course which gives you exercises to actually Lea by doing instead of watching?

What's your go-to Excel shortcut that saves you time? Let's create a collective list of shortcuts to boost everyone's productivity. Share your favorites!

I’m trying to check numeric values in a column and classify them. For example, if it’s within 0-10, group 1. 10-20, group 2. I have four such groups. I’ve been using a vlookup but I get a ref error. M… more

Are kids in K-12 grades learning how to use Excel at all?

Quickest way to learn excel when you haven’t used it in years, looking to start at beginner level and learn from there. Is there a YouTube? Or a website that people recommend? Thanks!

Downsides to using Excel Online?

Trying to use excel to double check future dates for scheduling orders and looking for input on best formula to use. I want to make sure that if the future date falls on a weekend, the return date is … more

I have an excel test coming up for manager role, any idea what the test might consist of?

We’re nearing 200k fishes in this bowl, yet I only see a couple of real excel questions per week. What’s up with that?! Where y’all at with those questions? Give us excel geniuses a chance to prove ou… more

I have a daily report i disburse with a date at the top that is manually updated each day. I am trying to make it a formula so I can’t forget to update it before disbursing, I can do the =today()-1 to… more

Are there any excel celebrities that you look at and say “I want to be that good”?

Why do employers request extensive Excel skills but then never have you use them?

I have never been more motivated to get an excel coach. I want to compete in competitive excel! 😂

How do I get rid of that stupid pop up that doesn’t let me copy/paste? I have to hit ctrl+c 10 times before it actually works

Knock, knock.

Who’s there?

Column.

Column who?

Column A, because you never notice B until you’re done with A

Anyone have any interesting or fun macros they want to share? I like to do as much as I can without writing any VBA, but I bet there’s a ton of people in this bowl that have no idea what’s even possib… more

Just told Excel I needed space. It responded with 'Did you mean: Spacebar?' 😑

Good morning, fishes. Here at Walmart, you might say we’re a pretty big company with lots of disparate, non-homogenous data sources. Importing and processing data through excel to a useful format can be a massive pain and is… more

Recommendations on a budget template to track finances.

How did you get started with excel? Was it for a class, a work assignment, personal interest? The first time I remember using excel was for an analytical chemistry class. We were doing linear regressi… more

Would you ever consider hiring an “excel tutor” to help you design a solution, revise a formula, double check your work, etc? Are there too many free videos and AI assistants out there to make this a … more

What are the best excel courses or webinars (free) that one can utilize to improve or learn new things?

Hey Excel Team,
I have a pivot table with 6 groupings for salary ranges by count of ID and displayed as % of grand total. Does anyone know how I can group the row grand total %? I’m trying to show the… more

Anyone have any experience working with total duration numbers for training and leveraging that data in PowerBI?
I have a report that has the time an associate spends in a course and I cannot figure out how … more

Hello, I am wondering if anyone has any experience with using Microsoft Access? I know some bare bones functionality but am trying to create an FMLA & Leave tracker / database and having a hard ti… more

Please help! Noob here trying to bootstrap a solution.

In a table of multiple columns, need to add values in Column A, based on criteria in Column B using SUMIFs and Xlookup

=SUMIFS(XLOOKUP(J14,E12:E187… more

HELP, I need to create an expense report - I know exactly what is needed and how the design should look.
however, I'm basic intermediate when it comes to formulas. if someone could please assist m… more

Hi all, did anyone managed a huge data set with contact list? I'm looking for a convenient template, that can be automated or implemented from excel into other data system

when creating a cover letter, or any document ,how do you create a link to insert to link to your resume?

What do you primarily use excel for? My primary use is building probabilistic decision models. Risk analysis, business value forecasts, project prioritization. Improving decisions under uncertainty is… more

Has anyone tried out the python editor in excel yet? I’ve done a couple of things, but it seems a bit quirky still.

What is your favorite new or recently discovered formula? One that I’ve been using a lot recently is MAKEARRAY. I’ve found it to be incredibly versatile in making dynamic worksheet features that were … more

Do you follow any YT creators etc who are excel content oriented?