Category: Beginner

Date Format in Excel

What is a date in Excel? In Excel, you can display the same date in many different ways just by changing the date format. Dates are whole numbers Usually when you insert a date in a cell it is displayed in the format dd/mm/yyyy. Now if you change the cell’s format to Standard, the cell …

Continue reading

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

Move and Copy worksheets quickly

In Excel, there are a lot of tips and tricks to move or copy a worksheet. Here are some examples: Move sheets in a workbook To move a worksheet within a workbook, you just have to: Click on the tab of the worksheet you want to move Hold and drag your mouse Release the mouse button …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/move-and-copy-worksheets-quickly/

Add Days Excluding the Weekend

Common error when adding days When you build a schedule for your team, you ususally don’t include the weekend. 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 you add …

Continue reading

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

Use the Cell Value in your Calculation

In Excel, it’s very easy to use the value of a cell in your calculation. You just have to call the cell reference. What is the cell reference? In Excel, a cell is often called by it’s reference. In other words, the intersection of a row and a column, like A1, B5, D8,…   Reusing the …

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 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 paste options. To select Paste Special, just click on the arrow under …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/examples-of-paste-special-all-options/

Function LEN – Test a String Length

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 useful for logical tests or for conditional formatting Remarks If you have a string containing a comma, point, dash, space, etc. the LEN function counts every …

Continue reading

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

Remove Duplicates

The tool Remove Duplicates In these versions, the tool Remove duplicates is in the tab Data. To extraction without duplicates, you follow these 2 steps: Select the column you want to remove duplicates in Click on the tool Remove Duplicates In the next dialog box, indicate if the first row of your selection is the …

Continue reading

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

Split Time and Date

If you have in a cell a time and a date (like the use of the function NOW) it’s easy to split them in 2 different cells. Split the date Let’s start from the following document where you have in column A data with date and time We want to split The date in column …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/split-time-and-date/

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 2 functions extremely important. 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/