Category: Beginner

Date format in Excel

In Excel, you can display the same date in many different ways just by changing the date format 01/01/2018 Jan 2018 Mon, 1 Jan 2018 … What is a date in Excel? Dates are whole numbers Usually, when you insert a date in a cell, you have this result Now, if you change the cell’s …

Continue reading

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

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/

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/

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/

Excel for free

Excel for Free! It was the dream for all and now it’s real with Excel Online without install Microsoft Office on your computer. How to get Excel for free? In fact, with the Cloud technology, it is easier to use Office applications from a browser (Internet Explorer, Firefox, Chrome, …) rather than install it on your …

Continue reading

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