Category Archive: Beginner

Add days without the weekend

Common error when adding days When you build a schedule for your team, you mustn't include the weekend in your result. So you can't write a formula like this =B2+C2 Look at the first results! 🧐🧐🧐 Even if the first result looks correct, it isn't. The result is Monday but it should be Wednesday. If …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/add-days-without-weekend/

Use the value of a cell in Excel

In Excel, it's very easy to use the value of a cell. You just have to call the reference of a cell. What is the reference of a cell? In Excel, a cell is often called by its references. In other word, the intersection of a row and a column, like A1, B5, D8,...     …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/use-the-value-of-a-cell-in-excel/

Paste Special

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/paste-special/

Function LEN

Presentation of the LEN function The LEN function returns the number of characters in a cell. It's simple 😉 =LEN(string) And that's all? 🤔🤨😲 Yes that's all! But this function is very usefull for the tests or for the conditional formatting Remarks If you have a string with coma, point, dash, space, ... the LEN function counts every …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/function-len/

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/

NOW & TODAY

The functions TODAY and NOW are two extremely important functions. They allow you to create dynamic workbooks using the system date on your computer. We will use these functions to create workbooks such as Automatic calendar Worker timesheet Follow-up of supplier payments Delivery delays ... Presentation of the functions To view the current day, use …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/now-today/

Excel on your mobile for free

Using Excel from a mobile seems to be a bit of a joke, but after using it, it is easy to get caught in the game. Of course, we will never create great worksheets as we can do with Excel desktop, but to open its files from any location (street, subway, bus) is very interesting. This …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/excel-on-your-mobile-for-free/

Title with date in Excel

Function TEXT converts any number into text and keep the specific number format. Presentation of the function TEXT TEXT function converts any number data into a text format according the parameters you give to the function. TEXT function has two parameters the number the format to apply Problem to solve Let's take an example with …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/title-with-date-excel/

Date format

It's important to understand how Date and Time are managed in Excel to custom their format. What is a date in Excel? Display number and not a Date. It's normal😉 In Excel, it is possible that a cell doesn't display a date as you expect but a number such as 42370. For a lot of …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/date-format/

Excel for free

Excel for Free! It was the dream for all and now it's real 🙂 For years, the only way to use for free microsoft Excel was to download it and use a "hack" serial key. Very risky technique especially in accordance with the law. Now, this "technique" is difficult to use because the new version of …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/excel-for-free/

Older posts «