Luckily, we don’t use the roman numerals much today, so this post is just for fun! Converting an Arabic number (normal number) into a Roman numeral is one of the easiest things you can do in Excel, but converting back from Roman to Arabic is equally difficult. Let’s have a look:
If you want to convert a normal number into a classic Roman numeral, there is a built-in function in Excel: ROMAN
In a previous post we learned how to make an Excel drop-down menu in 3 minutes. In this post I will show a very easy way to make a drop-down list in Excel that changes depending on what you have chosen in another cell. It’s easy, and it only takes five minutes!
It is absolutely critical that the data table is set up correctly: The main category (the countries in this example) should be in one column, and the sub-categories (the cities) in the other columns, with the countries repeated as headings.
READ MOREIf you want to see where your Excel file is located on the computer or the server, you can display the file path in the Quick Access Toolbar. With the file path displayed here, you can also copy and paste it into an e-mail and send it to a colleague (provided they have access to the same server). A great way to avoid sending attachments!
You only have to do this once – if you add something to the Quick Access Toolbar, it will be displayed in every Excel document on the same computer.
READ MOREEven if you have never used Microsoft Excel before, it only takes 5 minutes to learn how to make a simple report. Once you have done the exercise below, you will be able to create your own sales reports, commission reports, or household budget.
In this post we will create a sales report in 5 steps. You will be amazed by how easy it is!
Let’s get started!
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:
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.
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