Category: Beginner

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

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. The function COUNTIF do that easily 😃 Don’t use the filters 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 …

Continue reading

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

Excel for free

Excel for Free! It’s possible with a Microsoft account and an Internet connection. How to get Excel for free? With the Cloud technology, it is easier to use Office applications from a browser (Internet Explorer, Firefox, Chrome, …) rather than install it on your computer. To work with Excel online, you can go on www.office.com …

Continue reading

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

Change the language of Microsoft Office

Change the language of Office 2016, 2019 and Office 365

You can easily change the language of your Office applications. If the language you want is not installed, you can download it from office.com

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/