Microsoft 365

Microsoft Excel vs. Coronavirus: Why investing in the right resource is critical

Microsoft Excel is usually the go-to tool for creating spreadsheets and performing calculations with restricted data sets. For that kind of work, it’s invaluable. But should it ever be used as a database?

As we have all seen play out in real-time this week, catastrophic results can ensue when you fail to invest properly in the correct resources for projects.

What happened to the coronavirus test and trace data:

This week, almost 16,000 cases of coronavirus in England went unreported because of a glitch caused by an Excel spreadsheet. According to Tech Radar, PHE was unable to keep track of the thousands of results, due to outdated software.

Although the maximum number of rows per Excel file is more than one million, it seems the system stored each test result in a new column instead. This has a maximum of approximately 16,000 per file. This is thought to have been down to the use of older versions of Excel, which store fewer columns in its .xls files than newer versions with their .xlsx format.

Why Microsoft Excel was the wrong resource:

Multiple IT experts have been scratching their heads over the UK Central Government’s decision to use Excel for such a sensitive task.

Paul Norris, Senior Systems Engineer at TripWire, says Excel is useful for small tasks but not for handling large quantities of data:

Desktop tools such as Excel should not be used for large datasets, and investment should be made into technology that can securely process large datasets to ensure data integrity and accurate results.

Another massive issue? Data security. Excel software, while simple to use and collaborate on, is not appropriate for providing significant data security. Multiple users were never incorporated into the desktop interface. This means that files are easily corrupted by simultaneous use, which can also cause performance issues. If several users do have access, multiple versions could be updated and stored independently, causing confusion over which version is the latest.

A cautionary tale for all businesses: Invest in proper resources

If this week should do anything for business owners and project managers, it should serve as an important reminder about the necessity of using and investing in the right software for the right project.

While using a cheaper option may seem like a savvy decision at the time, it can result in disastrous consequences – particularly when the software or project involves sensitive client data.

Make sure you have a trusted IT Specialist on hand to help with this. Whether you have an internal IT Department or you outsource, get a trusted advisor to guide you to the correct solutions that fit your business needs.

WebMicrosoft Excel vs. Coronavirus: Why investing in the right resource is critical

Coronavirus return to work checklist: IT Support and Telecoms

Coronavirus Return to Work Guidance: 

Is your IT Support & Business Telecoms equipped for the ‘New Normal’?

Find out how to embrace and optimize the new normal with our IT Support & Telecoms “Coronavirus return to work checklist”.

There is no doubt that 2020 has been a demanding year. Your employees were tasked with adapting almost instantly to remote workplaces, only to now be asked to transition back when they’ve just about settled in. These constant changes are difficult, but there are ways to help. Your business should no be longer reacting to Covid-19, but be strategising for it. As a business, you need to look at the business communications solution you quickly put in place and decipher whether it was the right solution for your company.

You need to be asking where your pain points have been and if the current ways of working are sustainable long-term.

See the return to work checklist

WebCoronavirus return to work checklist: IT Support and Telecoms

Microsoft 365: 7 Tricks to make you more productive

Mastering the latest Microsoft 365 (formerly Office 365) productivity tips and uncovering new Microsoft Office 365 hacks are a really useful way to, firstly, get the most out of your Office 365 experience – but more importantly, to work smarter and be as productive as possible when working from home.

Here are 7 tips and tricks to use when using Microsoft 365 for work:

Learn Microsoft 365 as you work:

1. Make use of ‘Tell Me’

Are you feeling like a Microsoft 365 newbie? Then you need to use Tell Me – a text field where you can enter words and phrases about what you want to do next, and quickly get to features you want to use or actions you want to perform.

When editing a document, spreadsheet or presentation in Office Online, you can access Tell me by tapping the light bulb to the right of the tabs as seen in the image below:

Collaborate effectively:

2. Co-authoring in documents

One of the best features in Microsoft 365 online, is the ability to collaborate and edit documents with your colleagues – no matter where you are.

By saving your files to OneDrive or SharePoint, you can instantly share them with your co-workers and track their changes as you work toward a finished project or document. Work together on contracts and Excel Workbooks from the comfort of your home office. Find out more about how you do this here:

3. Attach files with Sharepoint

Rather than going through the laborious process of attaching files via e-mail, use the Share+ function in Sharepoint to add a shareable link to your emails). This saves valuable space in your inbox and shaves minutes off a task – giving you more time for other responsibilities.

4. Create groups

Creating Office 365 Groups allows you to maintain communication with specific departments and colleagues in your business, using the parameters you set. Once you create a group, you can share a calendar between members, exchange files, and of course, conveniently chat.

Continue signing agreements & contracts:

5. DocuSign

Did you know that you can get any document in Word or Outlook signed without bothering with a print-and-scan process? DocuSign allows you to Sign, send, and manage documents anywhere on any device, and they are also secure and legally compliant.

Save valuable inbox space:

6. Scheduling assistant for meetings

Instead of emailing back and forth for half an hour to find a convenient meeting time, take advantage of Microsoft Scheduling Assistant. When you’re sharing your calendars, you can use Scheduling Assistant to come up with a time to get together.

How to do this: Create an event on your calendar and add the people you want to invite. Then, use the Scheduling Assistant time picker to drag and drop to a time on the calendar that turns green. That means everyone’s available. Done!

Teamwork over the internet:

7. Mention someone to get their attention

One of the things that people really miss working from home is not being able to pop over to someone’s desk to get their attention, or when we’re working in the office alongside someone, we can say “Hey, John!”

To help with this, use Outlook’s @ mentions. If you @John in an email message, the recipient will see they’ve been called into the conversation and are expected to pay attention or respond. Not only this but when other people @ mention you, the inbox displays the relevant sentences around your @ mention directly in your message excerpt. This feature lets you know at a glance what you need to heed.

These tips will help you adapt to being as productive as possible whilst working from home. Do you have any Microsoft 365 tips and tricks? Let us know!

WebMicrosoft 365: 7 Tricks to make you more productive