|
|
Post by scubar on Jul 2, 2020 10:33:37 GMT
Is total Warhammer 1 worth the ten pounds it is on Steam at the moment? Yes, along with Total Warhammer 2, and as much DLC as your wallet can take. |
|
|
|
Post by Melvazord on Jul 2, 2020 10:36:54 GMT
New excel is garbage compared to old excel. Now its all about making things look pretty for corporate types and all the functionality is hidden.
Uh I mean...go sports?
|
|
|
|
Post by Sheep2 on Jul 2, 2020 10:37:07 GMT
You want to impress someone?
Change the ink and background colour and make the spreadsheet add things up
Red ink on yellow never fails* to impress.
Real people do not care about VLOOKUP.
Advanced functions are strictly for nerds
* may fail
|
|
|
|
Post by amipal on Jul 2, 2020 10:39:55 GMT
I've got the day off today. So while the boy is at nursery for the morning, I'm sat in front of the telly, playing through the big box of Amiga CD32 games that arrived yesterday.
Gunship 2000 has been the one I've spent the most time on though. Primary and secondary objectives achieved! Now heading home.
|
|
|
|
Post by Shenguin on Jul 2, 2020 11:12:19 GMT
If
Sumif
Vlookup
Countif
Mid
|
|
|
|
Post by Tuffers on Jul 2, 2020 11:12:56 GMT
I love Excel. I spend a large part of the working week using it. First thing to do when creating any new workbook, or opening an older one that might not be correct as it was last used by a deviant, is to select 'All Borders'.
Anyone who doesn't do this is sick in the head.
|
|
|
|
Post by Ozymandias Kane on Jul 2, 2020 11:14:05 GMT
Top 5 Excel functions 1) Sum 2) Coloured ink/background 3) Undo 4) Redo 5) Sort VLOOKUP is the best function. Formulas and tracing them, Name Manager - also HLOOKUP |
|
|
|
Post by Sheep2 on Jul 2, 2020 11:21:01 GMT
Anyone who doesn't have undo as one of their favourite functions is a dangerous idiot. With a spreadsheet full of horrible errors. |
|
|
|
Post by tenthenemy on Jul 2, 2020 11:24:17 GMT
Of course I love Excel. How else would I keep track of all those Animal Crossing items?
Spending more time on making your spreadsheet look pretty than actually entering data? Yes, please.
|
|
|
|
Post by RollingEscargot on Jul 2, 2020 11:34:09 GMT
Will nobody think of the pencil and paper manufacturers?
|
|
|
|
Post by Chumbles on Jul 2, 2020 11:38:32 GMT
I now realise why I don't cook more often... err... my stick blender's cheapo batteries have rotted so I have to use the big boy (now called The Exploderiser (c) MrTiddles ) later. My stomach is very interested in my creation and my nose is going nuts... so the peptic ulcer has had to be pacified with loadsa milk. Vertigo is damned dangerous when you're cooking so it's taken an hour to get to this stage... I now have to wait while it cools so I can blend it, decant the soup into the blue storage containers etc. so not a quick jobbie |
|
|
|
Post by Chumbles on Jul 2, 2020 11:39:51 GMT
Will nobody think of the pencil and paper manufacturers? I do, I draw maps... |
|
|
|
Post by Faceless on Jul 2, 2020 11:42:48 GMT
No love for 'concatenate'?
Monsters.
|
|
|
|
Post by tenthenemy on Jul 2, 2020 12:04:07 GMT
Will nobody think of the pencil and paper manufacturers? It was worse when the bottom fell out of the clay tablet and stylus market. |
|
|
|
Post by Melvazord on Jul 2, 2020 12:05:39 GMT
I now realise why I don't cook more often... err... my stick blender's cheapo batteries have rotted so I have to use the big boy (now called The Exploderiser (c) MrTiddles ) later. My stomach is very interested in my creation and my nose is going nuts... so the peptic ulcer has had to be pacified with loadsa milk. Vertigo is damned dangerous when you're cooking so it's taken an hour to get to this stage... I now have to wait while it cools so I can blend it, decant the soup into the blue storage containers etc. so not a quick jobbie Why does it look like this picture was taken by someone who is peering through the window of a house that is not theirs? Oh...OH. |
|
|
|
Post by Chumbles on Jul 2, 2020 12:11:20 GMT
Excel 2000 was bestie - I now use 2007... 1) Undo... without this I would be sectioned... 2) Autosum 3) Corner dragging a numbered list so it autopopulates* 4) Conditional calculation 5) Conditional formatting so bad things are red and good things are green... My biggest weakness? I can't master pivot tables... *greatly tempted to say autocopulates - which it does in a way |
|
|
|
Post by Sheep2 on Jul 2, 2020 12:29:39 GMT
Classic Anne Larsen.
|
|
|
|
Post by tenthenemy on Jul 2, 2020 12:30:13 GMT
Excellent taste in bread bins and coffee machines, Chumbles. By which I mean to say I've got the same in my kitchen. |
|
|
|
Post by Sheep2 on Jul 2, 2020 12:32:04 GMT
Also Melvazord returned just after the police broke into encrochat.
Coincidence?
|
|
|
|
Post by crankcaller on Jul 2, 2020 12:33:19 GMT
A bunch of Nerds liking spreadsheets. Who'd of thunk it...
I too fail at Pivot Tables.
|
|
|
|
Post by Sheep2 on Jul 2, 2020 12:33:37 GMT
|
|
|
|
Post by RollingEscargot on Jul 2, 2020 12:46:44 GMT
1) Download
2) Enable editing
3) Save as
4) Peer quizzically for a couple of minutes
5) Delete
|
|
|
|
Post by scubar on Jul 2, 2020 12:46:53 GMT
I love a good pivot table.
I’ve never mastered vlookup, but I’ve never really needed to.
|
|
|
|
Post by Shenguin on Jul 2, 2020 12:53:12 GMT
No love for 'concatenate'? Monsters. I considered it, but I rarely use it, as rather than typing =concatenate... in, it's easier just to use the & symbol to replicate the function, which gives me a philosophical dilemma about whether I'm actually using the concatenate function, or an unnamed function with the same properties as concatenate. |
|
|
|
Post by Destry on Jul 2, 2020 12:57:33 GMT
|
|
