Excel macros: How to optimise your work process with the popular spreadsheet programmes

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 more tedious working with the Windows programme can become — unless you make use of the powerful Excel macro function, that is. [...]  

Graphic file formats: the most important storage formats for images online

Whether you own an online store, run a corporate website, or write a blog, none of your web projects won’t be successful without photos or graphics. Images create visual stimuli that can enhance the content of your text and appeal to your visitors. However, it is crucial not only to find suitable graphical elements - but also to choose the appropriate graphic file format. The format needs to meet requirements such as picture quality as well as matching the website’s level of performance. [...]  

User experience design – for the perfect user experience

User experience design is becoming more and more important among web designers and software developers: a good user experience (UX) is now the goal as well as the standard for serious websites and software. But what exactly is UX design? It is often difficult to define due to the many related terms, such as user interface (UI). Read everything you need to know about user experience design and get inspired by our best practice examples. [...]  

MPLS: What’s behind the network technology

Speed and reliability play an important role for data transfer in networks. They reflect the quality of the connection, which is why providers do everything they can to guarantee the agreed services. A method primarily used in virtual private networks is the so-called multiprotocol label switching (MPLS). [...]  

SSL stripping: Basics and protection options

Data transmission via SSL/TLS is one of the most effective means to give a web project more security. Even before packets are sent, powerful algorithms ensure the encryption of the information. If third parties capture the data on the transmission path, the true content remains hidden from them. However, it becomes problematic if attackers are active with their tools before the encryption process has even begun. This is the case with so called SSL stripping. [...]  

The right configuration to secure your server

If you operate or rent your own server, it is your responsibility to protect it against failures and external access. You can immediately begin to set the foundation for this when configuring the server, if you have the necessary administrative rights. The correct settings can work wonders, especially with encrypted remote connections via SSH protocol, and greatly increase security. [...]  

HTTPoxy: Threatening the security of CGI applications

Fifteen years after the discovery of the security flaw HTTPoxy, it’s still an issue with CGI applications. The reason for this is the fact that the Common Gateway Interface standard provides the use of environment variables to process HTTP requests. These can include header contents that modify the original proxy configuration, allowing hackers to redirect data packets to a completely foreign server. [...]  

White Paper – A document used for advertising with facts

How do you write a white paper? And what actually is white paper marketing? The term white paper can often create confusion as it is not clearly defined. This article gives you an overview of what types of white paper documents there are, as well as useful tips on how to create a white paper. [...]  

Affinity marketing: Advertising through reference groups

What is affinity marketing? This form of online marketing is relevant to all of us, whether we want it to be or not. The techniques of affinity-based advertising are particularly successful in e-commerce. This article defines the term affinity marketing, and provides information about the methods and relevance of this marketing technique. [...]  

Recommendation systems in e-commerce

Admittedly, automated systems also make mistakes, but overall, it’s quite impressive that online shops can suggest products that users like. By streaming movies and series, the respective platforms are able to 'learn' the users’ tastes and then generate playlists automatically. This isn’t a coincidence, but rather the ability of modern recommendation systems. [...]