No smilies, no avatars, no flashing gifs. Just discuss the issues of the day, from last night's telly via football to science or philosophy.
Started by HelenDamnation on 20-Nov-2015 17:25:17
What is your favourite Excel thing?

Everyone seems to know different ways of doing things in Excel. What are the ones you like? I'm very keen on Text to Columns and the copy/paste thing where you can turn a column in one sheet into a row in another.

Previous
|
Next
|
Top
|
Bottom
hailesaladdie - 20 Nov 2015 17:27:12 (#1 of 159)

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19
)-7,30)*14%,)*7-6

Pentecost - 20 Nov 2015 17:28:13 (#2 of 159)

Insert Subtotals.

HelenDamnation - 20 Nov 2015 17:29:45 (#3 of 159)

Showoff, Hailes. Or fantasist.

hailesaladdie - 20 Nov 2015 17:32:41 (#4 of 159)

Or Googler. I do like it, though (calculates the date of Easter for a given year in cell A1).

turbodante - 20 Nov 2015 21:54:13 (#5 of 159)

Alt, D, F , A


This is the shortcut to advanced filter. From here you can filter a list by unique values.

HelenDamnation - 20 Nov 2015 21:54:58 (#6 of 159)

Oooohhh....

RunnyBabbit - 20 Nov 2015 22:04:14 (#7 of 159)

Random number generator. Great for doing World Cup sweepstakes and stuff.

<pseudorandom number generator, acksherly>

dreams99 - 20 Nov 2015 22:05:49 (#8 of 159)

Data tables.

Pentecost - 20 Nov 2015 22:08:01 (#9 of 159)

pseudorandom number

If you can't tell a random number from an apparently random number, then what's the difference?

Pentecost - 20 Nov 2015 22:10:31 (#10 of 159)

This question, by the way, probably isn't for an excel thread.

tasselhoff - 21 Nov 2015 08:56:40 (#11 of 159)

It depends. On my passphrase generator, I replaced the PHP rand() function with openssl_random_pseudo_bytes(). The problem with rand() is that it's not as unpredictable as we'd like. Whereas openssl_random_pseudo_bytes() uses /dev/urandom and is "computationally secure" enough. Here is why urandom is more than good enough http://www.2uo.de/myths-about-urandom/

tasselhoff - 21 Nov 2015 08:59:42 (#12 of 159)

As a general rule, /dev/urandom should be used for everything except long-lived GPG/SSL/SSH keys (where/dev/random should be used).

TRaney - 21 Nov 2015 09:14:06 (#13 of 159)

I liked the queries in Excel 2. I hate pivot tables.

Lemongrab - 21 Nov 2015 09:19:46 (#14 of 159)

I love nested IFs!

Gotout - 21 Nov 2015 09:22:05 (#15 of 159)

I just wonder how I can get through life, never having had to use Excel?

tasselhoff - 21 Nov 2015 09:33:24 (#16 of 159)

I hate Excel, because users can do what they want with it. And this generally entails headaches for IT down the line.

TRaney - 21 Nov 2015 09:33:58 (#17 of 159)

IT hate our freedoms!

tasselhoff - 21 Nov 2015 09:35:29 (#18 of 159)

Go on, be my guest. Just don't come crying to us when it all goes wrong.

kvelertak - 21 Nov 2015 10:16:47 (#19 of 159)

Excel is proof of the existence of magic. Lookup tables being a case in point.

See also batch files for creating filelists and named folders.

supadjg - 21 Nov 2015 10:28:35 (#20 of 159)

Pivot Tables have kept me in a job for the past 15 years. Great way to sort through transactional data.

Previous
|
Next
|
Top
|
Bottom
Check Subscriptions
|
Home » IT & Computers