Tag Archives: Excel

Convert numbers to Thai text with the BAHTTEXT function (?)

Posted on by
8

Everybody knows that you can do amazing things with Excel, but who would imagine a function like BAHTTEXT? According to Microsoft, this function “Converts a number to Thai text and adds a suffix of Baht.” There are no functions that convert numbers to text in any other language, so why Microsoft chose to develop this function remains a mystery. I’m guessing that one of the developers did it to impress someone who speaks Thai…

Sadly, I don’t speak a word of Thai, so in order to determine whether or not the BAHTTEXT function is good enough to impress anyone, I checked the results in Google Translate. This is what I got:

READ MORE

Remove Duplicates in Excel

Posted on by
Reply

How can you remove duplicates from a list in Excel?

Easy! Excel has a built-in feature for this. Just select one of the cells in the list and click on Remove Duplicates on the Data ribbon.

EasyExcel_31_1_Remove Duplicates in Excel

EasyExcel_31_2_Remove Duplicates in Excel

Voilà, the duplicates are gone:

For more advanced ways to handle duplicates (and triplicates, quadruplicates etc.), take a look at this article: How to Find Duplicates and Triplicates in Excel

More Easy Tricks:


Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

Use Excel to Count Words

Posted on by
Reply

In Word you can easily count the words simply by clicking “Word Count” from the Review ribbon. But what if you have your text in Excel? There is no built-in word count function in Excel, so we have to find another way.

In a previous post I showed how to count characters in a text string using the LEN function. We will use the same function, with a twist, to do a word count.

READ MORE

How to Create a Dynamic Chart in Excel

Posted on by
Reply

In many situations you collect data every day (sales figures, stock prices etc.) for weeks, months and years, while all you want to show in the chart is the last week or two. I’ve seen many people spending a lot of time updating the chart manually every day, so here I will show you how you can make a dynamic chart that always shows the last 7 days. Of course, you can use the same technique for any number of days, weeks or months.

READ MORE

Today’s Shortcut: Insert New Worksheet in Excel

Posted on by
2

If you want to create a new worksheet in an Excel workbook, you can use the mouse and click next to the rightmost existing sheet. But why not use a shortcut instead?

Alt + Shift + F1

EasyExcel_27_Shortcut_Alt+Shift+F1


Other Shortcuts:

Download “Standard Keyboard” in Excel

How to protect cells in Excel

Posted on by
Reply

Why it’s important to protect cells in Excel

If you create an Excel report for someone, it is important that you somehow visualise which cells they are allowed to change, and which cells they should not touch. The common way to do this is to use a blue font for the assumptions, i.e. the values that can be changed.

Unfortunately, this is not always enough. Inevitably, someone will try to enter values into the calculation cells as well, and when they do, the whole report might be useless. We need to protect the cells from being tampered with, and the good news is that it takes less than a minute!

READ MORE