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: Find and replace

Excel: Find and Replace – made simple

Microsoft’s favourite spreadsheet software offers a plethora of useful features and tools. Among the most important commands are “Find” and “Replace.” We’ll show you how they work step-by-step. In addition, this article offers tips and tricks to search for unknown values using placeholders.

Conditional formatting in Excel

Excel: conditional formatting – what is it?

Excel’s conditional formatting is a useful feature to visually distinguish and analyse your data. This type of Excel formatting allows you to emphasise cells according to certain conditions. Conditions are predefined using specified values or formulas. But how does it work? And how is conditional formatting applied in Excel?

IF OR function in Excel

How to use the IF OR function in Excel

Using a combination of the IF function and the OR function, you can perform specific evaluations in Excel in which you can define multiple conditions in the same function. Therefore, the return value will be “TRUE” if either one of the conditions is met. We will explain when and how to use the IF OR formula in Excel using simple examples.

EXCEL IF AND formula

IF AND in Excel: Everything you need to know

If you want to evaluate your data with regard to multiple criteria, the combination of the Excel functions IF and AND may be of use to you. Based on whether the conditions you defined are met or not, Excel will return a result of your choosing. Keep reading to find out how and when to use Excel’s IF AND formula.

Excel not equal sign

Excel: The “not equal to” operator explained

Excel is the perfect tool for evaluating large sets of data in tables and precisely defining conditions. Excel’s logical operators are particularly useful in this connection. In this article, you’ll learn how the Excel “not equal to” sign works and how it can be used with functions like IF.

FIND function in Excel

The Excel FIND function

The FIND function in EXCEL is an effective tool. It allows you to find specific strings within a cell, regardless of how much information it contains. FIND is especially useful in combination with other functions. What tasks can the function help you with? And what is the syntactical structure?

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.


Own your online success
IONOS takes care of your online challenges
Create your website with the perfect domain and the UK's fastest hosting!