Excel

The Excel HLOOKUP function explained in simple terms

The HLOOKUP function in Excel is a useful feature for anyone who wants to look for specific values in a table. This requires all the compared values to be located in the same row (i.e. horizontally arranged). You can save a lot of time by using the HLOOKUP function, especially when dealing with large data sets, as our HLOOKUP example will illustrate.

Excel: How to use the LOOKUP function

Do you have a huge table where you can no longer keep track of all the entries? In Excel, you can use LOOKUP to quickly find related values. For instance, the function can serve as a mini search engine within your spreadsheet. Enter a search term and Excel will seek out the associated value for you. Here, we’ll show you what the syntax of the function looks like.

Excel SEARCH: tips for using the Excel SEARCH function

The SEARCH function in Excel gives you the ability to quickly perform complex analyses of large data sets, clean up your data, and stay on top of your documents. When used correctly, the Excel SEARCH function is a highly effective tool. In this overview, you’ll learn more about how to use this convenient feature.

Excel tables: How to perfectly format your data

Excel is a powerful tool for formatting, analyzing and presenting your data. Excel lets you create tables that perfectly organize groups of data and provide useful features like sorting and filtering functions, for example. In this tutorial, you’ll learn how to create Excel tables and tailor them to your individual needs.

Excel: Calculate the Sum of a Group of Numbers

The Microsoft Excel program is a convenient and easy way to collect and archive data. In addition, mathematical formulas can be solved using the software. For example, you can use the Excel SUM function to add the values of specific cells or entire ranges of cells without having to use a calculator.

Creating an Excel drop-down list

If you regularly use spreadsheet programs to process large datasets, you will welcome anything that helps. This is where drop-down lists in Excel come in. These allow you to conveniently add content with just one click so you don’t have to type the same thing again and again. We show you how to insert a drop-down in Excel.

Excel: track changes

Imagine you’re preparing an Excel spreadsheet that several colleagues will be collaborating on at the same time. You can monitor whether all collaborators made an entry by tracking changes in Excel. This way, you’ll be able to keep an overview of who wrote what. In this article we’ll show you how it’s done.

Wrapping text in Excel: How to display the contents of your Excel cells on multiple lines

Excel cells often contain only a few numerical values or short text. But when you’re dealing with lengthy contents, the Microsoft application often hides a portion of the information. You can prevent this by wrapping text, which Excel allows you to do in two different ways. In this article, you’ll learn everything you need to know about this feature.

Inserting Excel into Word

Want to learn how to insert an Excel table into Word and aren’t sure how to proceed? We’ll explain how to insert an Excel file into Word. The easiest way is to use the copy and paste commands. But if you want to edit the data later, it’s better to link the Excel spreadsheet in Word. You can do this quickly and easily with our simple step-by-step guide.

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.

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