Category: Beginner

Title with date in Excel

The TEXT function changes the format of the numbers in a string

The TEXT function is very useful when you have to create a string which mixed text and number or date. You can customize each part of your date

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

Function COUNTIF

COUNTIF

A basic task with Excel is to count the number of rows for a specific criteria. Solution with the filter Most of the Excel users, use the filter to count the rows. But this solution is really not convenient when you have to repeat this action for many values. The solution is to use COUNTIF …

Continue reading

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

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/

Change the language of Microsoft Office

In many companies, Excel is often in English. But for a lot of people, it’s not easy to work with the Excel functions in English. But no panic, you can easily change the language of Office but the method depends of your version of Office. Presentation In function of your function of Office, the way …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/change-the-language-of-microsoft-office/

Quick Analysis

Quick Analysis

Permanent link to this article: https://www.excel-exercise.com/quick-analysis/

Conditional Formatting – Data Bars and Icons

The conditional formatting allows you to add Data Bars and the icons in your cells is function of the result of rules. The Data bars When you insert a conditional formatting Data Bar, everybody will approve your document. It’s an instant success. 👍😎😊 The method to insert Data Bar in your cells is very simple. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/data-bars-and-icons/

Conditional Formatting – Highlight Top Bottom values

Highest / Lowest value It’s quite easy with the conditional formatting to highlight the highest and lowest value of your series. Select the range of cells where you have your data Select the menu Conditionnal Formating > Top/Bottom rules > Top 10 items         In the dialog box, replace 10 by 1 …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/top-bottom/

What is a conditional formatting

Many Excel users are not familiar with the conditional formatting tool. But, it is the essential tool for automatically changing the color of a cell according to its value. Never change the color manually Many of you change the color of the cells manually using the formatting bar. Of course, to change the color of …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/what-is-a-conditional-formatting/

Remove spaces in Excel with TRIM

The TRIM function This function is very useful for cleaning all the spaces before and after a string. When you import data, it is strongly recommended to use two following functions to “clean” the blank characters in your cells. The function is very simply to use. There is only one argument, your text to clean …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/remove-spaces-in-excel-with-trim/

Copy Paste

Copy Paste is the most common action when you start to work with Excel. Benefits of the action Copy Paste With Excel, you can copy any cell or any range of cell Select the cell you want to copy and click on the following icon “Copy” in the Home tab. Just after you see an …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/copy-paste/