Tag Archives: easy 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.

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

5 Easy Steps to Make Your Excel Charts Look Professional

Posted on by
Reply

Why do Excel charts usually look so ugly? Ok, they look a lot better in newer versions of Excel than they did before, but you still need to make a few changes if you want them to look good enough for a presentation.

These are the 5 things you can do to make your Excel chart look professional:

READ MORE

Use a shortcut to switch between tabs in Excel

Posted on by
Reply

If you work with Excel all the time, you are probably pretty tired of switching between the tabs using the mouse. To make your life easier, learn this Excel keyboard shortcut:

  • Ctrl + PageUp
  • Ctrl + PageDown

EasyExcel_9_1


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

Create a Search Box in Excel without VBA

Posted on by
13

Is it possible to create a search box in Excel, without using VBA?

Yes, and it’s easy!

We will use Conditional Formatting to highlight the fields that match the search string. For example, if you look at the table below, we want to highlight row 8, 11, 15 and 25 if we search for “RG”, because “RG” is part of the product name in those rows.

READ MORE