Excel

Removing Excel Duplicates

Deleting Duplicates in Excel: How it Works

The Microsoft program Excel makes storing and processing data a piece of cake. But the more entries are added to a table, the greater the chance that some values are duplicated in the process. Excel offers a function for removing duplicates to solve this problem with ease. This allows you to delete redundant double entries with just a few clicks.

Editing an Excel drop-down list

Editing an Excel drop-down list

Drop-down lists allow you to configure tables in Excel in a way that is more professional, easier and less prone to errors. However, like anything else in day-to-day work, drop-down menus also have to be changed now and again. For this reason, we are going to explain how to edit Excel drop-down lists so you can adapt their content and appearance and add useful information for other users.

Excel shortcuts

30 Excel shortcuts to speed up your work

Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.

Excel DATEDIF function

Excel: The DATEDIF function explained

Microsoft Excel has many functions that help you produce calculations, statistics, and tables. Some of these functions do not even make it into the official list in the software. DATEDIF is one of those hidden functions that can help you calculate periods of time. The result can be shown in days, months or years. We’ll explain how it works.

Excel: opening XLSX files

Opening XLSX files with Excel

The XLSX format has been the standard format for Microsoft Excel files for some time now. Microsoft replaced the old XLS format with a new file extension back in 2007. Since then, all workbooks in the popular spreadsheet program have been saved as XLSX files. Here, you will learn how to open these files and how to use them in older versions of Excel.

XLSX to XLS

Converting XLSX to XLS quickly and easily

How do you convert XLSX to XLS? Sometimes an Excel spreadsheet is sent to you in the wrong file format. The easiest way to allow you to work with the information is by converting it into the correct format. You can either convert XLSX to XLS directly in Excel or use an external converter.

COUNTIF in Excel

Practical functions in Excel: COUNTIF explained

What is COUNTIF? With Excel, Microsoft provides a helpful spreadsheet program. The application combines numerous functions – most of which many users are unaware of. It therefore makes all the more sense to learn more about it and use the program for more than just creating tables. The COUNTIF function helps you create statistics, for example. We explain clearly how to use COUNTIF correctly in...

VLOOKUP in Excel

Faster with Excel: the VLOOKUP function explained

It can often be incredibly time-consuming to search for a specific entry in an Excel table by hand, which is where VLOOKUP comes into play. This practical function allows you to find the exact value for a specific search criterion. The VLOOKUP function is indispensable for managing price lists, members directories, and inventory catalogues. To ensure you can benefit from this practical function,...

Excel SUMPRODUCT function

Excel: What can you do with the SUMPRODUCT function?

Besides its clear tables and informative diagrams, Excel impresses in its ability to perform complex calculations automatically. Microsoft’s spreadsheet software offers many different tools to help you do just that. For example, you can use Excel’s SUMPRODUCT function to add and multiply values in a single step. We’ll explain how it works.


Wait! We’ve got something for you!
Have a look at our great prices for different domain extensions.


Enter the web address of your choice in the search bar to check its availability.
.club
$1/1st year
then $15/year
.com
$1/1st year
then $15/year
.info
$1.60/1st year
then $20/year
.org
$1/1st year
then $25/year