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

Presentation of 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 …

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/