News and Tips

Excel – Leading Zeroes

Have you ever entered a phone number that starts with a zero or a code that start with zeros into Excel. If you have the zeros usually disappear. Watch this short video to see how you can keep those leading zeroes. https://youtu.be/5RQ_cTqWA9M  

Excel – Drop Down Lists

Excel has lots of smarts for us to use. Here is one that will help you make it easier to control and input data. Watch this short video to see how. https://youtu.be/501wcDso-SY  

OneNote – Capture Text from Pictures, Scans and PDFs

Need to capture text from photos, scans or PDFs. The full version of OneNote makes it easy with its built in character recognition tool. Watch this short video to see how it is done. https://youtu.be/aDmBEKVLeP4  

Outlook – Forms Add In / Quick Poll

Outlook has allowed you to poll people since the 90’s using the Voting Buttons. However through various iterations of Outlook they've got lost. With Office 365 you have the Forms Add In for Outlook that lets you create user friendly polls easily. Watch this short...

Teams Switches

Shortcuts are a great way to work faster. Teams utilises a shortcut feature called switches. Switches are activated from the Search box by typing the / Watch this short video to see our top five switches. [embedyt] https://www.youtube.com/watch?v=xRnArWGdtAI[/embedyt]...

Teams – Share Screens

Ever tried to describe what is going on with your computer to someone over the phone. It can be frustrating. If you have Teams there is no need to keep getting frustrated, use the Share option from a Chat, Call or Meeting. It even works on most mobile devices as well....

Word – Block Authors

Co- Authoring in Word makes it quick and easy for multiple parties to work on a document and get the job done. However what if you want to stop your fellow co-authors from editing certain paragraphs? You can block them. They can still edit other parts of the document...

Archive Teams in Teams

Some Teams have a life cycle e.g. Projects, Recruitment etc. Once these are finished you don't want further content to to be added to them or changes being made. At this point you'll want to archive the Team. Watch this short video to see how....

Convert Function in Excel

You can do all sorts of unit conversions using Google these days. However what if you need these to be recorded and want them to be smarter. This is where you use Excel's Convert function. Watch this short video to see how. https://youtu.be/wAkcANIdMyg