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...
News and Tips
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]