📞 01223 214177 ✉️ karen@roem.co.uk
A couple of years ago I wrote a tip recommending not to ignore Clippy in disguise.
Speaking of Clippy, during last Thursday's training session one of my course participants wrote in the chat that she was 4 when Clippy was around. Talk about Throwback Thursday! But I digress ... don't ignore Clippy in disguise.
At the time I told you Clippy was replaced by tiny "smart tags" that most people seem to ignore. I shared my favourite three (Paste Options, Auto Fill Options and Insert Options) and today I want to add another overlooked an underused button that pops up occasionally ... Quick Analysis.
It does what it says on the tin ... it quickly analyses your data. It's a super-fast way to see the various tools and apply conditional formatting, create PivotTables, add totals, show sparklines - and much more!
Here's how:
So if you don't know exactly what tool to use, check out the various options. It even gives ideas about PivotTables (under its Tables tab).
Related tips
Last and this week's CleverClogsTipTime on LinkedIn
PS In case you were wondering why there wasn’t a tip last week… I was prepping and running a tailored PowerPoint training session (yep, the Throwback Thursday one).
PPS Thanks for reading my tips – even as far as the PPS ;) That said, “they” often say that the PS is guaranteed to be read. I never accepted ads or sponsorship for my tips, but if you want to help keep this going, hire me to do a 15-minute curiosity coffee or lunch and learn session for your team, book one of my courses or webinars or simply drop me a line to say hi. It really makes a difference to know you think the tips are useful.
*
Unless stated otherwise this tip is written for Microsoft 365 desktop apps and Windows 10 users, but might also be useful in Office 2010, 2013 and 2016.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.