Open Source

Excel: ROUND Function
  • Online sales

Excel allows you to perform complex computations. However, you may often want to simplify the results, either by rounding up or down. In Excel, you can round using a function, saving time and effort. You can use the ROUND function directly and in its simple form, or build it into complex formulas. So, how do you use it correctly?

Removing Excel Duplicates
  • 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.

Set up your own Debian FTP server with ProFTPD
  • Configuration

FTP servers are suitable solutions if you want to make files available for download or offer multiple users a platform for storing and accessing data. The practical server-client technology also plays an important role in the maintenance of web presences. This tutorial explains how to install and set up your own Debian FTP server.

Apache Lucene
  • Configuration

Who wouldn’t want to build their own search engine that’s adapted precisely to their requirements? Apache Lucene makes this possible. The open source project can be precisely adjusted and also works extremely quickly, which is why even large companies such as Twitter rely on Lucene. In our Lucene tutorial, we show you how to use the full-featured text search. But first the question: What is...

Webinars: Advantages, features, and possible uses
  • Online sales

The internet and World Wide Web have brought humanity closer together – it has never been easier to share information, experiences, and memories than it is today. More and more often, the web also serves as a platform for further education. So-called webinars - i.e. online seminars – are replacing classic face-to-face lectures. Companies and teachers now communicate knowledge online instead of in...

Skype alternatives
  • Social media

For millions of people around the world, video chats and conferences are an essential part of daily life – for both work and leisure. When it comes to video telephony software and applications, Skype is one of the pack leaders. In fact, many people are unaware that there’s a considerable number of good alternatives to Skype on the market. Some of these programs even boast extra features that can’t...

Markdown editors
  • Web development

How can you easily format texts for use online and offline? This becomes a piece of cake when you use the markup language Markdown and an editor. With these editors for Linux, Windows and Mac as well as the online editors, you can create Markdown documents and convert them into HTML pages. But what are the best Markdown editors?

Excel: INDIRECT Function
  • Online sales

In Excel, we almost always work with cell references. Rather than entering values into formulas individually, we pull them from the cells of tables. The INDIRECT Excel function enables you to even obtain references from other cells. This can be helpful when working with multiple worksheets or when creating complex formulas, for example. We explain how to use INDIRECT in Excel.

Free Microsoft Excel alternatives
  • Online sales

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.

Creating an online store with WordPress
  • CMS

In order to successfully sell products in the age of mobile internet and digital offers, having a well-functioning online store is a necessity. But how can you create your own online store without resorting to expensive help? With WordPress and WooCommerce, you can quickly and easily set up your own web store. We will show you how to do it with this step by step WooCommerce tutorial.