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? →

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...

You might hold the secret to data security in your finger

Is your password keeping your data as safe as it could be? Maybe not. And there are new, safer alternatives to try. Here are all the details.

Tech Tip: How to Stay Cyber Safe at Christmas

CHRISTMAS SPECIAL!!! As we are on the countdown to Christmas, today's Tuesday Two Minute Tech Tip is on a (very tenuous) Christmas theme. As we all get ready for the big day we will be thinking of having a few days or even weeks off work and relaxing. Christmas is a...

Your need-to-know guide to cloud security

Cloud computing is no longer new technology, it is everywhere and has completely changed how we work. However, just because you are using someone else systems in the cloud, it does not imply that it is automatically secure. There is a saying in the cloud security...

Some bosses think their people do less when working from home

Microsoft has become the leader of productivity over many decades. Can you imagine doing your day to day work without their software? So it’s no surprise the tech giant recently conducted a major new survey into productivity in the workplace – and some of the results might surprise you. Researchers surveyed 20,000 people working for […]

The Microsoft New Commerce Experience (NCE) is on the way

Microsoft is introducing what it calls a New Commerce Experience (NCE) in 2022, with changes to licensing terms and pricing for Microsoft 365. This will mean fairly big, and potentially expensive, changes for business customers who have Microsoft 365 licences. The...

Tech Tip: How to create a transcript using Word

Welcome to another Blisstech Solutions Tuesday Tech Tip! Are you tired of rewinding and pausing video or audio content just to jot down notes? Say goodbye to that tedious process and hello to a more efficient solution. In this tech tip video, we'll show you how to...

Phishing – If you’re under pressure to take urgent action – stop and think

Phishing scams are one of the biggest security threats to your business right now and cybercriminals are always coming up with new phishing techniques. A massive 83% of organisations said they suffered successful attacks last year. And with just under a third of...

When did you last have a health check?

Book now for an IT check-up, to get in great shape for the journey ahead? You do it for yourself and your car – now do the same for your workplace tech

How To Secure Your Business When Remote Working

The global COVID-19 crisis means that more people are remote working than ever before. Businesses rushed to enable their employees to work from anywhere very quickly, which may include access to sensitive company data. In the rush to stay operational during the...

More Content