Remove whitespaces in Excel using the TRIM function.

Replace ugly Excel errors returned by a formula with something more appropriate and pleasing to the eye.

Transpose and paste a vertical column of data horizontally into a row

Edit a hyperlink in Outlook 2016

insert an emoji or symbol into your application

Add Sparklines to Excel tables to show trends in the data

Use the RANDBETWEEN function in Excel to randomly generate numbers between a specified upper and lower threshold.

Don't waste time manually editing queries to move the date period on one month. This blog explains how to use DATEADD to dynamically shift the dates on one month on each refresh

Import text files into Excel and use the Text to Columns wizard to separate the data into columns