News and Tips

Excel Datedif

Datedif lets you calculate the difference between dates and display the result in whole Years, Months or Days.  It is particularly useful for tracking years of service, warranty terms, reporting cycles and age. Datedif is not found in Excel's function list you just...

Translate documents with Word

Translating a document from one language to another is straightforward using Word. Watch this short video to see how. [embedyt] https://www.youtube.com/watch?v=QLO_lYZkw8Y[/embedyt]

Use Flow to turn @mentions in emails into Tasks

Flow lets you automate all sorts of tasks and processes in Office 365. Watch this short video to see how we use Flow to automatically take an email where we are @mentioned and add it as a task in the To do app. [embedyt]...

Visualise regional data in Excel with a Bing Map

If you have facts and figures that include cities and regions you can visualise this by using the Bing Maps option in Excel. Watch this short video to see how. [embedyt] https://www.youtube.com/watch?v=q7WKRLLzbhA[/embedyt]

Keep colleagues informed as you post comments in Word

Comments now let you use @mentions. This allows you to identify who needs to action a comment and emails them at the same time. Watch this short video to see how. [embedyt] https://www.youtube.com/watch?v=S3hh_apxZKg[/embedyt]

Highlight Duplicates in Excel

Duplicate values can be difficult to spot. Watch this video to see how to make them stand out. [embedyt] https://www.youtube.com/watch?v=6Bb_ysutzrg[/embedyt]

Add a Formula to a Table in Word

Excel is the ultimate tool for formulas, however you can also add formulas to Word documents. Watch this video to see how. [embedyt] https://www.youtube.com/watch?v=dg5FSZQL6fE[/embedyt]

Pin websites to view later

When you come across a website that you'd normally favourite try the Pin feature instead. Pin lets you keep key websites open while keeping tabs down to a minimum. Watch this short video to see how. [embedyt] https://www.youtube.com/watch?v=w4vLDe22VCo[/embedyt]...

Add key web pages to your Taskbar

Important websites can get lost when you favourite them. With Edge and Windows 10 you can add web pages to your taskbar so you have an icon for them instead. Watch this short video to see how. [embedyt] https://www.youtube.com/watch?v=EKY-Z_WhlOc[/embedyt]