Tech Tip: How to Tidy up Copied Data in Excel

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

IT Managed Services for Financial Services

Over the last four decades, technology has significantly impacted how Financial Services operate. In the past, Financial Services businesses, such as IFAs and accountants, had to track financial data manually. Today, they can use software to automate many of these...

Time to move your business to the cloud?

Still relying on office computers? It’s time to move your business to the cloud. A few years ago, running your business using data and apps stored on office computers—or a dusty server in the cupboard—might have worked. But times have changed. With remote teams and...

Tech Tip: How to Follow Sites in SharePoint

Hello, Happy New Year and welcome to today's Tuesday Two Minute Tech Tip which is about how to find the data you want to access in SharePoint and OneDrive. If you are working with files in Teams and on SharePoint sites, you might wonder why you do not see the sites...

Why the Cloud is not backup

Cloud computing has revolutionised the way businesses work. Companies that utilise the cloud will have coped the best with COVID-19 imposed restrictions. Whether forced to by circumstance or not, businesses are moving from the traditional server in the office to...

Cybercrime is always evolving. Your training should be too

Cybercrime is an ever-evolving threat, and it's crucial to adapt and stay ahead. The increasing recognition of the value of cybersecurity awareness training among businesses is a positive trend. However, moving away from the "one-and-done" mindset is vital....

Make sure your cloud server is protected from this

Using a cloud server to drive your business’s technology is a smart idea. The benefits are huge. You can use as little or as much storage as you need, without having to worry about limitations or huge bills. Perfect for growing businesses. Your team can access any...