Don't Copy / Paste Data In Excel! Use These 5 Alternatives Instead ...
Does copy / pasting data around Excel drive you crazy? You wouldn’t be the only one! In fact, the number one reason we are called in to help organisations is … they are doing too much copy / pasting data around Excel.
WATCH THE VIDEO HERE
It just feels so repetitive. But, it’s not just the tedium of undertaking the same manual task time and again … it’s the risk associated with it. Copy / pasting (partly because it feels so onerous) comes with risk: you could copy the wrong data, paste to the wrong cell, accidentally copy filtered day … the possibilities are endless. So, it’s frustrating … and risky!
Though Excel does provide options to avoid copy / pasting, it seems the majority of professionals aren’t aware of them, and still fewer use them on a regular basis.
In this video, I share my top 5 alternatives to copy / pasting in Excel. From quick, formula-based solutions to Excel’s sophisticated data management tools and even a VBA-based option, I’ll talk you through what’s available, so you can choose the best option for you. Where things get technical, I direct you to follow-up resources, taught from beginner level, where you can learn more. As usual, an Excel download file is available – so make sure you download it and work along with me.
So, are you ready to say goodbye to endless copy / pasting of data around Excel? Remember to let me know how you get on in the comments – I’m very happy to answer your questions there.
WATCH NEXT
Excel Filter Formula (BEGINNER TUTORIAL)
Excel Power Query For Beginners
Transfer Data From One Sheet To Another With Excel VBA (BEGINNER TO PRO!)
Set Up Your PC For Excel VBA (VBA ABSOLUTE BEGINNER TUTORIAL)
Why You Shouldn't Fragment Datasets In Excel
Excel Office Script For Beginners
How To Structure An Excel File
Beginner Guide To Excel’s Dynamic Array Formulae