I've gained tons of Excel knowledge this year like XLOOKUP, CONCAT,SUMIF,IFS,Pivot tables,etc....

I have practiced a lot and for some reason I feel behind still. I'm like " no way this is too easy. That's it? That's the complicated Excel stuff ppl talk about?"

I don't have a job yet, so I don't know how Excel looks like on the job.

Did I underestimate Excel?

Is it easy or is there something I'm missing?

I hope you get my point, because English isn't my first language.

There are quite the few SUM and AVG etc. formulas e.g. SUM and AVG but also SUBTOTAL and AGGREGATE and possibly more I don't know of.

I only learned about AGGREGATE a couple weeks ago and I love how it combines different functions and filter possibilities in one. SUBTOTAL does alot of it too, but I think AGGREGATE has more flexibility.

But I do use SUM still alot for the quick sums.

What formulas do you usually use?

I've created a heat map using one of the preset conditional formatting gradients and I need to include a key (?) like the gradient with the numbers in the top right of this image, however I can't seem to figure out how to do that...help?

I have a bunch of numbers, e.g. 46, 55, 89, 92, 95, 101, 104, 112, etc. Is there a way I can make a column graphs where each column shows the count for a specific range, e.g. a count of all the values which fall between 40-49, 50-59, and so on?

Trying to put together a formula and running into a bit of difficulty. I'm comparing a Target Date for completion of a task (cell J2) to the Actual Date that task was completed (cell K2) to determine how many days past the Target Date the task was done. In many cases in my data set, the Actual Date is blank as the task has not yet been completed. In some cases the Target Date is in the past and in some cases it's in the future.

So I need a formula that can handle 3 scenarios:

1. If a date is recorded in cell K2, calculate the days between K2 and J2.
2. If K2 is blank and the date in J2 is in the past, calculate the days between J2 and Today's date.
3. If K2 is blank and the date in J2 is in the future, return a result of 0.

Any help would be greatly appreciated!

If you have a column of full names, type the first name of the first person in the next column, then press Ctrl+E. Excel fills the rest by copying your pattern. Do the same in another column for last names. It works for pulling out parts of emails, codes and dates too. Just check a few rows afterward, since names with middle initials can trip it up.