What did I learn today: Power Query Preview Hyperlink

What a brilliant feature, which was lying right in front of me for months, but I did not notice it. In Power Query Preview dialog, every field name has a hyperlink. NOTICE THAT. Click on a column name to bring that column into view.
Now you never need to struggle with horizontal scrolling in complex data sets.

This is a GIF animation. Some colors are smudged due to GIF limitations.

Power Query Hyperlink

Have you noticed the hyperlinks which appear in formula syntax tooltip in Excel?
Find out what that does and you will be amazed. Read this article for details.

How to create templates for common replies in Outlook

Very simple. Reply as usual. But do not click SEND button. Look at the mail and remove things which will change every time you respond. For example, the recipient address should be removed. But if every reply needs a CC to your boss, keep that email id.

Once the response is generic enough, choose
File – Save As – Outlook Template (.OFT). Specify a name and save it. Reusable attachments can also be kept as a part of the template. For example, FAQ documents, Product Brochures, User Manuals, etc.

Now next time you need to use similar response – there is no need to retype the message. Choose File – New Items – More Items – Choose Form

SNAGHTML3c76c37

From the drop down in the Forms Dialog choose User Templates in File System and select the template you saved earlier. Fill in the additional information and Send. Simple and Effective.

If you realize that the forms which you are using are beneficial to more people in the organization, contact your IT team. They can put the forms in the central forms library for everyone to use.

***