Tech Tip: How to Tidy up Copied Data in Excel • Blisstech Solutions

This Tuesday Two Minute Tech-tip shows you how to tidy up data in Excel spreadsheets.

Do you have data in a messy format and need to change it so it is organised?

Have you ever received data in Excel or in a text file or Word document and wanted to change it from rows to columns, or vice versa?

Maybe you have done this manually in the past, which can take a lot of time!

This tip will save you a lot of time by explaining:

👉 How to tidy up a messy spreadsheet into something neat and organised.
👉 How to move data from rows into columns.
👉 How to split data from one cell into separate columns.

These tips will help you to:

💥 Save time by avoiding manual data entry.
💥 Quickly manipulate data in Excel using some neat tricks.

Check out the video to learn more and subscribe to our YouTube channel https://www.youtube.com/channel/UCr8R-LSAjMvvuF65EtwSRag

Thanks for watching.

← The tax relief few businesses know about What are the benefits of outsourcing IT support? →

Don’t walk the plank with pirated software

A huge number of small and medium-sized businesses would consider using pirated software to try and save money. Don’t do it.

Are your employees reporting security issues fast enough… or even at all?

The faster your employees report a potential cyber security issue, the less damage is done to your business. But how can you encourage quick reporting? Here we share some solid ideas.

Tech Tip: How to create a scheduling poll using Outlook

Welcome to a new Tuesday tech tip video where we will be exploring how to create a scheduling poll using Outlook. You know what it's like when you are trying to get everyone together for a meeting. Trying to find a time that suits everyone can be a real pain! There...

Get a FREE IT RISC Assessment (and that’s not a typo!)

Most small businesses don't have the time or resources to perform in-depth IT assessments on their own. This can be a major problem, as failing to keep your technology up to date can lead to reliability and security issues down the road. Therefore, Blisstech Solutions...

Tech Tip: Using Microsoft Teams Keyboard Shortcuts

Microsoft Teams is a great productivity tool. It has many features that can help you be more productive and speed up repetitive tasks. One way to be even more productive with Microsoft Teams is to use the shortcut keys. The shortcut keys can help you quickly access...

Tech Tip: How to search for files in Window and Microsoft 365

Welcome to a new Tuesday tech tip video where we will show you how to find your files using the powerful search features of Windows and Microsoft 365. Even if you are very organised with filing your data, sometimes, you just cannot find the file that you are looking...

Secure your data under lock and key

Your business's data is invaluable. Without it, you wouldn’t have much of a business, would you? So that data must be kept safe… and one of the best ways to do that is to encrypt it. That way, even if a cybercriminal gets their hands on it, your data is worthless to...

Young employees have different attitudes to cyber crime

If you employ anyone aged between 16 and 19, you need to pay special attention to the cyber security training you’re giving your team.

1 in 4 people struggle with password overload. Here’s the answer

1 in 4 people struggle with password managment. Here’s the answer

Struggling from password overload? You’re not alone, and it’s putting your business at risk of data theft. Good news: There’s a very simple solution and we’ll tell you all about it.

Is your email signature putting your business at risk?

When was the last time you gave any thought to your email signature? It’s just there to provide your contact details and maybe boost your branding, right? But have you ever considered exactly how much information you’re giving away? It’s enough to allow someone else...

More Content