One Minute to Excel #4 – Copy Anything

Mouse and keyboard combined

Copying is a common task in Excel. This technique applies to most things in Excel form cells and range to charts, images and sheets.

It also works in Word and PowerPoint.

Have you used the mouse and keyboard together? It is time to start.

Let’s go.

One Minute to Excel #3 – Filling in the blanks

No blank looks

Imported data often has missing entries you need to populate.

You can use Power Query, but that duplicates the table.

This technique works on the existing table and is quick and easy to apply once mastered.

Start the clock!

One Minute to Excel #2 – Identify Duplicates

Short, sharp video tips

In the previous video I removed duplicates, in this video we identify duplicates using Conditional Formatting.

I identify the duplicates twice in a minute in this video.

The clock is ticking.

Aikido instructor George Leonard on mastery:
​”How long will it take me to master Aikido?” a prospective student asks.
“How long do you expect to live?” is the only respectable response.

From James Clear newsletter.

(I think you can replace (Ctrl + H) Aikido with Excel.)

James Clear

One Minute to Excel #1 – Remove Duplicates

Working against the clock

I have started a new series of short videos showcasing Excel’s features that work in less than a minute.

There is a countdown to see if I can do it.

In this first one I remove duplicates in less than a minute.