[Closed] Obscure Excel Feature of the Day.

care to elaborate or do you mean screenshot?

It's quite handy for presentation tools or scenario testing if your outputs are remote from your inputs.

One of the few tools I miss in google sheets.

Useful for gathering Metrics together for a single management KPI "summary" as well.

[b]Distribute Vertically[/b] & [b]Align Left[/b] are little known tools which can save huge amounts of time for users unaware of their existence

Allows you to create a live view to other parts of your workbook, just add it to the quick access toolbar from the all commands list.

A Stoner says its v hand when running scenarios

I quite liked the 3D game they hid in Excel 2000....

I'll let Rob Hilton explain the "Double unary", but it's well handy 😉

Makes Sumproduct a good friend

Ctrl+shift+: boom there is the time

Ctrl+: time and date.

@ joshvegas

Anyway to get that to work when creating the filename ?

You can do that in VBA.

A quick Google later:
https://www.extendoffice.com/documents/excel/2268-excel-add-date-to-filename.html

Cheers Cougar VBA will have to do

A bit of swopping around and that's pefect

Analysis pack- Histograms.

I love histograms.

I love histograms.

Stoner - Member
I'll let Rob Hilton explain the "Double unary", but it's well handy

unary + unary = binary

I think that's how it works 😀

I seem to renember using the camera tool to fudge dynamic chart titles in an old version where it couldn't otherwise be done.

If you're ever stuck in a mire of vlookups slowing things done horribly this is a trick that'll make the average user think you're some kind of magician*

https://fastexcel.wordpress.com/2012/03/29/vlookup-tricks-why-2-vlookups-are-better-than-1-vlookup/

*Massive geek

*likes*

And I shall assume Google sheets does the same binary pass under VLOOKUP. But worth checking.