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

# How to Refer to a Column in a Spill Range

### INDEX rules

A spill range is the result of a dynamic array formula. At the moment that requires the subscription version of Excel.

# 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!

# Handling Formula-Based Blanks

### The N function to the rescue

It is common to display a blank cell using the IF function and “”. A problem can arise when you want to use that IF formula in a calculation. Here is an easy way to cope.

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

# Single formula for a Column

### It can done

In Excel your goal should be to have a single formula in a table column that can be copied down the whole column.

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.

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

James Clear
| | Posted in Quotes

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

# XLOOKUP Doesn’t Always Spill

### But it can

The new XLOOKUP function has the ability to spill when you select multiple columns to extract. Even when you do, it doesn’t always spill across.