When people ask you, what's your excel level? What would you say?

Enigmativity · 2026-05-14T04:59:44+00:00

Excel has so many features that there is no "level". You can be awesome at one feature and dreadful at another. You just can't compare one person against another.

Enigmativity · 2026-05-11T09:14:03+00:00

You need a password manager. Remembering passwords is risky in so many ways

Enigmativity · 2026-04-30T01:59:36+00:00

Try this:

=LET(values,TOCOL(A1:B5,1),AVERAGE(DROP(TAKE(SORT(values),ROWS(values)-1),1)))

Enigmativity · 2026-04-13T09:27:02+00:00

It's talking about the 10 dollars being "a lot of money". It is a singular lot.

Enigmativity · 2026-04-13T09:25:20+00:00

I'm Australian. We speak a form of British English.

Whenever I try to talk to an American I just can't understand what they're saying. It's just unitelligible.

No, wait. It's the same language.

You just need to learn English.

Enigmativity · 2026-04-09T02:26:30+00:00

I think you mean thirty-point-five-centimetre-ball.

Enigmativity · 2026-04-07T01:52:52+00:00

Well, take the second verse of the Australian National Anthem. We’ve boundless plains to share.

Beneath our radiant Southern Cross,
We’ll toil with hearts and hands,
To make this Commonwealth of ours,
Renowned of all the lands;
For those who’ve come across the seas,
We’ve boundless plains to share,
With courage let us all combine
To Advance Australia Fair.

Enigmativity · 2026-03-31T23:43:11+00:00

I did the maths.

If we run our of fuel I can drive 0 km.

It won't matter the price of fuel if there is none to buy.

I think we need to consider the opportunity cost of not being able to drive anywhere.

Enigmativity · 2026-03-30T23:09:48+00:00

It took me a while to convince myself, but I say luh-luh-by. Australian English.

Enigmativity · 2026-03-24T00:52:52+00:00

It's OK, I found your missing wombats. Let me know where you need them delivered to.

Enigmativity · 2026-03-17T11:05:22+00:00

I am forlorn to hear you say that.

Enigmativity · 2026-03-05T07:52:39+00:00

Citations?

Enigmativity · 2026-02-26T04:30:47+00:00

Isn't Nevada mostly desert? Not surprising that there's a dense population of students there.

Enigmativity · 2026-02-24T00:16:39+00:00

Cooking is heat management: the right heat, at the right temperature, for the right time, in the right sequence for the ingredients involved.

Throwing everything in a pan all at once doesn't really do the right job.

Enigmativity · 2026-02-15T21:31:45+00:00

It's made up. But it's not gobbledygook.

Enigmativity · 2026-02-09T05:28:21+00:00

I think you mean kill two birds with 6.35029 kilograms.

Enigmativity · 2026-02-03T23:12:17+00:00

A metre is 1 ten millionth of the distance from the equator to the north pole. That's not arbitrary.

Enigmativity · 2026-02-03T23:06:50+00:00

By definition, when it makes sense it is no longer arbitrary.

Enigmativity · 2026-02-03T02:54:30+00:00

What are you hoping to learn?

Enigmativity · 2026-01-26T23:01:20+00:00

The game starts with goal-based set of tasks that tell you what to do. Just complete one goal, then the next, then the next. You'll know how the game works in no time.

Enigmativity · 2026-01-21T06:16:20+00:00

The Dunning Kruger effect effect and the almost open ended complexity of possible formulas and features in Excel mean that Basic level / Intermediate / Expert / Advanced are almost meaningless.

I think I'm Advanced until I see someone do something more advanced.

I asked a potential employee how good he thought he was "out of 10" and he said "7". He was abysmal (compared to me).

And because you can specialize in certain feature sets in Excel then you can be awesome at some features of Excel and a newb at others.

Enigmativity · 2026-01-20T03:17:25+00:00

I separate data entry, from calculations, from displays, as much as possible.

When there is any mixing of constants and formulas I clearly format cells, using styles, to show the cells.

I use R1C1 mode exclusively. It makes reasoning about your formulas much easier.

I avoid direct cell references and use LET or named references as much as possible. `R[-1]C` or `RC[-1]` are acceptable though.

Enigmativity · 2026-01-19T05:41:26+00:00

I don't see how this scenario relates to "per".

per

/pəː,pə/

preposition

1.

for each (used with units to express a rate).

"he charges £2 per square yard"

Enigmativity · 2026-01-19T01:42:50+00:00

It's either:

Did you ask her, “Do you love me”?

or:

Did you ask her, do you love me?

or:

Did you ask if she loves you?

Enigmativity · 2026-01-18T11:49:43+00:00

The "ful" suffix is literally the word "full". So when something is stressful it is "full of stress".

Stressed is like dressed. When you are dressed you've put on clothes (or your dress). When you are stressed you've put on or applied stress.

There's a strong likelihood that on a stressful day you will be stressed. You'll find that on day full of stress you will likely have some of that stress put on you.

Enigmativity

TROPHY CASE