News and Tips

Approve documents with SharePoint and Flow

It's now super easy to  get documents approved by utilising the built in Approval Flow in SharePoint. Watch this whort video to see how. [embedyt] https://www.youtube.com/watch?v=VJ6dj63kBWQ[/embedyt]

Teams Meetings

Meetings scheduled through Teams let you share content, record the meeting and make the meeting more accessible, you can join from anywhere that you can connect to the internet. Watch this short video to see how to schdeule Teams Meeting. [embedyt]...

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]