Excel

Excel: LOOKUP Function

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: SUM Function

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.

SUMIF in Excel

The Excel: SUMIF function explained

Get more out of Excel: SUMIF makes it easier to work with balance sheets and analyses. Add only the values you need – completely automatically. From simple calculations to complex formulas, it’s all possible with the SUMIF function in Excel. How do you use the function? And what does the syntax look like?

Excel Pivot Tables

Pivot tables: using Excel to its fullest

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

SEO add-ins for Excel - easily connecting data

SEO add-ins for Excel: optimizing and editing all in one

SEO data is the bedrock for any successful online marketing venture. The calculating power of Excel is a boon to data analysts when it comes to processing metrics and analysis data. But how can these large quantities of data gathered from SEO tools be directly processed in Excel? SEO plugins for Excel offer a very practical possibility here. We present the most useful extensions here.

Free Microsoft Excel alternatives

Microsoft excel alternatives: 5 premium free-of-charge applications

For many companies, spreadsheets are a part of day-to-day business: whether to compare costs, create diagrams, or plan financing and revenue streams, most tend to gravitate towards Microsoft Excel for their calculations. But is there any way around having to pay for this expensive product? We’ll show you 5 of the best alternatives to Microsoft Excel here.

Excel macros: The useful scripts

Excel macros: How to optimize your work process with the popular spreadsheet programs

Excel, the spreadsheet software from Microsoft, has been one of the most popular solutions for years when it comes to handling the ever-increasing flow of data. Simple, well-structured tables, meaningful diagrams, or complete budgets can easily be created. For daily office life, many companies can hardly imagine functioning without the Office application. But the more complex the project is, the...

Excel if-then statements

Excel if-then: how the IF function works

Excel’s if-then statement is one of its most helpful formulas. In many situations, you can create a logical comparison: if A is true, then B, otherwise C. To use this useful if-then formula in Excel, you first need to understand how it works and precisely how to use it. For example, which syntax rules does the IF function follow, and how can you extend the formula?

Freezing Excel Rows

Freezing Rows and Columns in Excel: A Guide

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.

Showing Duplicates in Excel

Identifying Duplicates in Excel

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.


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