# 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 …

## How to use the contain of cells in Excel?

In Excel, it’s very easy to use the contain of cells. You just have to call the reference of a cell to reuse its value in as data or in a formula. What is the reference of a cell? In Excel, a cell is often called by its references. In other word, the intersection of a …

## Function LEN

Presentation of the LEN function The LEN function returns the number of characters in a cell (LEN for length 😉) =LEN(string) And that’s all? 🤔🤨😲 Yes that’s all! But it is a very useful function for the tests or in conditional formatting 😉 Remarks If you have a string with coma, point, dash, space, … the LEN …

## Function DATE – YEAR – MONTH – DAY

Presentation of DAY, MONTH, YEAR The Functions YEAR, MONTH and DAY are very simple to understand. They extract each part of a date. DAY extracts the day of a date MONTH extracts the day of a date YEAR extracts the day of a date Individually, these functions do not interesting but used with the DATE function, they are …

## 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 …

## 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 …

## 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 …

## 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 …

## 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 …

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 …