Tag Archive: Top 10

Articles sur le thème : Top 10

Basic calculation

Excel allows you to do all kinds of calculations and respect mathematical rules. We will see how to perform simple calculations (addition, subtraction, multiplication, division) and also how to perform operations that use several different operators without making any mistakes 😉 The = sign In Excel, all the calculations or formulas start with the = …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/basic-calculation/

Fill Series

The fill handle is very useful to copy formulas as you know but also, you can fill series of number or date. Look at the following tutorials to see what you can do. Fill series of numbers When you have to create a list of number, it is not necessary to create a formula or to …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/fill-series/

Absolute Relative References

The cell reference is the code that identify a cell: A1, B3, C15, … BJ375. But in Excel, it’s not just reference, we have absolute, relative and mixed references (but what-is-this-stuff 😲🤔🤨) It is very important to understand this concept because very often in a spreadsheet, you have important data that must be used in your formulas: …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/absolute-relative/

Best excel shortcuts

Discover the best Excel shortcuts for the pro. Have a look at all this amazing tips and tricks about the Excel shortcuts 😃👍😉 Copy / Paste on large range of cells The following video will show you the technique to make a copy / paste over 5000 rows without using the mouse in less than …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/best-excel-shortcuts/

Copy Paste

Copy Paste is the most common action when you start to Excel. Benefits of the action Copy Paste With Excel, you can copy any cell or any range of cell 1. Select the cell you want to copy and click on the following icon “Copy” in the Home tab.     2. Just after you …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/copy-paste/

Calculation without equal

Secretary problem 😉 I always wonder why there is a calculator close to a computer. It’s totally ridiculous especially if you have Excel on your computer 😉 But a secretary told me one day “I’m fed up to start a formula with =” Excel option In fact, there is a way to do calculation without …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/calculation-without-equal/

Remove Duplicates

The tool Remove Duplicates Since Excel 2007 In these versions, the tool Remove duplicates is in the tab Data.     To extraction without duplicates, you have to follow this 2 steps Select the column where want to remove the duplicates Click on the tool Remove Duplicates In the next dialog box, indicate if the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/remove-duplicates/

Examples of Paste Special (all options)

There are situations where a standard copy-paste destroys the presentation of your worksheet. To avoid that it’s better to use the Paste Special. Principle of paste special Once the “copy” has been activated, you can display a specific dialog box that offers a wide range of collages. To enable this option, you must click on the arrow …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/examples-of-paste-special-all-options/

Inspect a formula with F9

In Excel, you can scan a part of your formula with the shortcut F9 When use the shortcut F9? Let’s say you have a complex formula with a lot of VLOOKUP, INDEX, MATCH, Reference all over your workbook. The result is not correct and you need to find the reason To split your formula in …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/inspect-a-formula-with-f9/

Move and Copy worksheets quickly

In Excel, there is a lot of tips and tricks to move or copy a worksheets. Here is some examples Move sheets in a workbook To move a worksheet inside a workbook, you just have to Select the worksheet you want to move by a click Hold and drag your mouse Release the button of the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/move-and-copy-worksheets-quickly/