Includes 10 Simple Excel Techniques That Make You Work Faster

👉 1. See the statistical summary from the Status Bar at the lower right.

Sometimes we want to add numbers, count numbers, or take arithmetic averages quickly (without calculating them), we don't have to write the formula down, just drag Select and cover the data you want, and look at the Status Bar on the lower right, and it shows a lot of data.

Tips: We can choose what the Status Bar summarizes by right-clicking the Status Bar below and ticking what you want, such as Average, Count, Numerical Count, Maximum, Minimum, Sum.

👉 2. Learn to use Keyboard shortcuts.

Using key shortcuts really helps us to work faster (and looks really cool!), especially which ones we use often to remember.

For me, for example,

Ctrl + C: Copy

Ctrl + X: Cut

Ctrl + V: Paste

Ctrl + Z: Undo

Alt + =: Auto Sum

F2: Enter Edit Mode

F3: Paste Name (Preowned Name)

F4: Lock Cell (in Edit Mode) / Repeat Repeat

F5: Drag the Cell Reference in Formula Bar and press F5 and enter to select that Cell / Range.

F9: Convert Formula to Value (in Edit Mode) / Recalculate

👉 3. Use the Quick Access Toolbar.

In addition to the standard Ribbon, we can add the commands we often use to the Quick Access Toolbar in the top left corner, as well as enter commands that are not in the regular Ribbon, and most importantly, can be combined with the shortcut key Alt + 1, Alt + 2....

👉 4. Use Defined Name in the formula reference.

Naming a Cell or Range has many advantages, such as

- It's easier to read the formula because it can be used as a meaningful word.

- Easy to manage. Reference editing time can be solved in one name Manager. Suitable for frequent references to frequently cited fields or ranges where items may be added later, such as Reference Table.

- It is more convenient to refer to the reference VBA to Defined Name because when we insert a Cell, the reference in the VBA does not advance like the reference in the normal Sheet. This will not be a problem if we use Defined Name instead.

- Do not press Ctrl + Shift + Enter when using Array Formula

How to give Cell or Range a Definished Name

1. Select the Cell or Range you want to name.

2. Go to the Name Box on the left of the formula box.

3. Type the desired name and press Enter.

To manage the name, go to Ribbon Formula = > Name Manager (or press Ctrl + F3).

👉 5.Create Custom List to help Auto Fill / Sort

Maybe we want Excel to be able to Auto Fill data for us automatically, such as A-Z or A-H, but believe it or not, Excel can't do it because it doesn't know these lists (it doesn't really understand why it just doesn't know...)

But don't be afraid. We can teach Excel to know our customized list. To make it Autofill and Sort according to the list we defined as (choose in Sort Option what to Sort Order).

How to Create Custom List

Go to Excel Option = > Popular = > Edit Custom List

Then you can enter the desired word in the List entries box (separate words with Enter) or Import from the existing range (but it must be a value Text, not a formula).

For example, this A-Z I made from the formula = CHAR (65), = CHAR (66) and so on.

The way to do this is to create numbers in a column, like A1, A2...

And then write = CHAR (A1) in the column next to it, and then Copy drags down...

Then Paste to Value again.

👉 6.Learn More Function

Excel has a lot of functions, some of which are designed to work very easily if we know how to use them.

But on the other hand, if we don't know that there is a Function like that, we may do unnecessary work...

What I often find is that maybe we want to multiply each of the results, but multiply them a lot of times... some people don't know the PRODUCT function, they multiply them normally, but if they know this function, they can drag the whole bar, for example.

This is just one function, and let's think about how many unnecessary things we can do! (For example, a function similar to this has another SUMPRODUCT to multiply each of the ranks and add them together)

So if you start to feel strange, try Google to find out if someone has the same problem as us and find a simple solution.

👉 7. Use Picture Link to detect the impact at the destination channel.

When you want to check the impact on filling in one box (especially distant ones), you can use Picture Link to help (available from Excel 2007 and up) by

Give the Copy Range the destination you want to see the results.

Paste near the source box. Select = > Paste = > As Picture = > Paste Picture Link

Condensing / expanding / moving images as convenient

Let's change the source value to see the effect at the destination.

👉 8. Use Paste Column Widths instead of sitting, adjust the width of the column itself.

I've seen some of you sit and arrange the width of the columns in Excel to be the original, some of whom are very respectable in a lot of effort! But I would say it's not necessary when we can copy even the width of the columns.

How to

Select the original cell or range to copy the column width.

Press copy

Select the destination box

Paste Special Press = > Column Widths

👉 9.Lock Format Painter so that Paint the destination in multiple cycles.

I think many of you have used Format Painter, but I'm not sure if you want to copy the format from one channel to a paste to a destination, many non-adjacent channels, what do friends do?

If you don't know the technique, you can choose the original channel... and press the Format Painter button 1 t... and then press the destination box 1 t... and then start again, go to the original channel again, painter again, destination again... and so on... which is a waste of time!!

A better way is

Select the original channel

Double-click the Format Painter button (the button will be selected and held, unlike the normal press, only one time)

Choose the destination as many times as you want.

To quit Paint, come back and press the Format Painter button again.

👉 10.Work in Excel and then use Copy to Paste as Link elsewhere.

When data is tabulated, computed, or graphed, I recommend using Excel and then Copy as a Link to MS Word or PowerPoint.

How to Copy to Paste to Link:

Copy table or graph data in Excel

Open MS Word or PowerPoint that is the destination program.

Paste = > Paste Special = > Select Paste Link

.

If anyone likes good techniques and knowledge like this, don't forget to follow me so you don't miss new content.

# programmer # Programmer # Developer # Self development # Trending # IT should know # Share IT Trick # Includes IT matters # Excel # Work life review