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/

Remove Duplicates

The tool "Remove Duplicates" It is very easy in Excel to extract all unique values from a list of data using the tool Remove Duplicates. This tool exists in any version of Excel. Since the Excel 2007 version, the menu is directly accessible from the ribbon. But for versions prior to Excel 2003, the tool is …

Continue reading »

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

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/

Copy Paste

The major advantage of using a spreadsheet is to copy data or formulas to save time and secure its calculations. We will present some techniques to copy data in this page but there are also other methods (mouse, Paste Special ...). Presentation Copy / paste is a simple manipulation. Select the cell you want to …

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/

Inspect a formula with F9

In Excel, there is some amazing shortcuts and F9 is one of them Let's say you have a complex formula with a lot of VLOOKUP, INDEX, MATCH, Reference all over your workbook. And you have a mistake Not easy to find where is the mistake. Except if you use the shortcut F9 😏 When do …

Continue reading »

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