Excel

Excel Pivot Tables
Pivot tables: using Excel to its fullest
  • Web analytics

Excel pivot tables can considerably ease the evaluation of data. Data analysis can be especially time-consuming and tedious with complex numerical series, but with Excel pivot, this doesn’t have to be the case. Simply place your data in the right context and filter the essential information in just a few clicks. The pivot table allows you to create expressive diagrams in no time. Find out all you...

Pivot tables: using Excel to its fullest
Excel SUMPRODUCT function
Excel: What can you do with the SUMPRODUCT function?
  • Online sales

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.

Excel: What can you do with the SUMPRODUCT function?
Removing Excel Duplicates
Deleting Duplicates in Excel: How it Works
  • Online sales

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.

Deleting Duplicates in Excel: How it Works
Showing Duplicates in Excel
Identifying Duplicates in Excel
  • Online sales

There are several reasons why you may want to find duplicates in Excel – to filter out errors or analyze double entries. Excel can automatically display these duplicates to you. Thanks to color highlighting, you can instantly see which entries appear more than once in your tables. And the feature is easy to use: We’ll explain how it works.

Identifying Duplicates in Excel
How to wrap text in Excel
Wrapping text in Excel: How to display the contents of your Excel cells on multiple lines
  • Online sales

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.

Wrapping text in Excel: How to display the contents of your Excel cells on multiple lines
Freezing Excel Rows
Freezing Rows and Columns in Excel: A Guide
  • Online sales

The bigger an Excel table is, the harder it is to maintain an overview. The problem is that cells like the header bar become hidden without the use of special formatting. The following article shows you how to freeze certain Excel columns and rows so they stay visible when scrolling.

Freezing Rows and Columns in Excel: A Guide
VLOOKUP in Excel
Faster with Excel: the VLOOKUP function explained
  • Online sales

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,...

Faster with Excel: the VLOOKUP function explained
COUNTIF in Excel
Practical functions in Excel: COUNTIF explained
  • Web analytics

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...

Practical functions in Excel: COUNTIF explained
Excel: LOOKUP Function
Excel: How to use the LOOKUP function
  • Online sales

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: How to use the LOOKUP function
Excel: TEXT function
Excel Text: using the TEXT function to convert numbers into individually formatted text
  • Online sales

The Excel TEXT function converts any number into a text string. The best part is that you can format the number as text in almost any way you like (e.g. as a decimal number, fraction, currency or by adding user-defined text before, between or after). Learn how to make the most of the Excel TEXT function using the format codes.

Excel Text: using the TEXT function to convert numbers into individually formatted text